Re: Oracle AS 10g

Anyone know if this includes the new OEM 4.0 ? mvg/regards Jo Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 18:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle AS

NT - Win2K causes performance degradation..

Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased

Re: rebuilding indexes - sure to cause a ruckus

Thanks Raj, Unfortunately, in my rush to get the kids to school in time, I stuffed the formatting when my cut 'n' pasting got converted to plain text. Hope you found it all useful. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

I don't know why they favor MS AD. As a replacement for tnsname.ora the OID works very well. We didn't take it because the 3 developers know how to use the tnsnames.ora, the clients are all but 3 webbased for html, forms or reports. reports are partially created into files than can be

Re: leaf node 90-10 splits

Hi Tanel, I have no idea but if you currently have 9 entries in a leaf block and the 10th entry you're about insert causes this type of split, then 9 entries (the 90% currently in the existing leaf node) remain and the new entry (10%) goes into the new leaf node. A 90-10 (%) split. Possible

Antw: RE: PERL?

experienced the following things useful - on unix/bsd/linux - sqlplus / EOF connect sys as sysdba startup EOF things like that can be put into shell scripts - eg as startup scripts, for cron jobs doing e.g. reports into .pdf's to store on a webserver, perl's expect will most likely work

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

The interesting fact of course is that the beta program of 10g was announced in newsgroups AFTER it had closed for all intents and purposes to the general public... And quite frankly, Oracle could do a LOT WORSE than let customers like Mogens definitely join. Just a feeling, mind you. If Oracle

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

Amen... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I really do not intend to go with the flow. Fortunately, there are other databases and oracle's behavior is motivating me to start giving them serious considerations. -- Please see the official ORACLE-L FAQ:

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

Isn't that what Oracle has always done? I've got a funny feeling it's gonna start biting back really hard... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - guys decide to put out a limited production version? Prolonging the hype would not serve any useful purpose, except may

RE: NT - Win2K causes performance degradation..

Hi Mark, no thoughts specific to Oracle, but I'd recommend using the principle of change only one element at a time. I'd say they were unwise to upgrade to W2K, and at the same time change their Oracle parameters. If possible, I'd advise they set all their Oracle parameters back to their

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

Hmm, so you're telling me you want me to let Larry know your views on this? Not this bunny! :) The problem in putting out a limited production release is not so much in putting it out - that's dead easy. It's in the expectation that some form of support comes with it usually, and limited

Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax Connect

Re: rebuilding indexes - sure to cause a ruckus

Hi Yong, One thing I should have mentioned when I posted my epic is that it not only attempts to correct the numerous technical errors in the article but also attempts to answer the various questions the article raises but totally fails to address. What I find most astonishing about the article

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of

Re: rebuilding indexes - sure to cause a ruckus

Richard: I think that is the simple way of questioning other person's capacity. Remember this statment (borrowed from some one !!) If you are telling something is simple, you are questioning the other person's intelligence !!' KG -- Please see the official ORACLE-L FAQ:

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive

RE: A brief detour....;-)

So much printing ... no wonder we have a lot of dead trees now !!! wide grin Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

RE: rebuilding indexes - sure to cause a ruckus

Richard, I found it immensely useful, that's why I created the tinyurl and went to c.d.o.s and read the whole thread, from first to last post. (man those people need to learn to weed out old comments in the replies). This is what I love about this forum, it comes with huge amount of knowledge,

OT Re: Re: rebuilding indexes - sure to cause a ruckus

Hi Richard, I think, there are 2 candidates for an answer. 1life (nothing is more difficult) 2...love (ever tried to read your madam's thoughts?) ;-) Corrections welcome (as always). Cheers, Guido [EMAIL PROTECTED] 10.12.2003 11.39 Uhr (snip) If I can convince anyone who makes it

Re: rebuilding indexes - sure to cause a ruckus

Terse ? You haven't heard me terse until youhear me trying to get the kids to sleep at night. Don got it easy ;) - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 8:14 AM Subject: Re:

RE: Oracle AS 10g

OTN seems to say that it will be in the Database 10g, not in OAS 10g. I'm curious about the new OEM as well, given the chats on the list about it. I notice they posted Developer Server 10g, and a preview of Jdeveloper 10g this morning. Patrice. -Original Message- Sent: December 10,

RE: Oracle AS 10g

Here I am correcting myself again... The full-edition of OAS includes the OEM. Patrice. -Original Message- Sent: December 10, 2003 8:29 AM To: '[EMAIL PROTECTED]' OTN seems to say that it will be in the Database 10g, not in OAS 10g. I'm curious about the new OEM as well, given the

Re: rebuilding indexes - sure to cause a ruckus

Hi KG, O, you've got me thinking here !! I'm not too sure that I've really questioned anyone's intelligence. I've always measured someone's intelligence by: 1. How quickly the can learn and absorb new information 2. How much they know and appreciate the work of David Bowie A quick

Re: Oracle8i and oracle9i in the same machine

Oracle use the selected home as default. You can see you default home in: start-programs-oracle installation products-home selector. If you want to run scripts on the other home you need to add: set oracle_home=c:\oracle\ora92 (for example) at the start of your script. Yechiel AdarMehish

RE: Creating the Java System

Mark Mike, Thanks for the replies. They both were right on the mark. The full removal did the trick. thanks again Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Thomas, This error

tuning for throughput vs. tuning for response time

Has anyone else notice that these two can be somewhat different? In a high transaction system, I typiucal try to reduce LIOs when I write queries. For last 6-8 months, Ive been doing alot of ETL and nightly batch data loads. Ive found that there are times when I can improve response time by

RE: Documenting databases

-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09, 2003 7:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Documenting databases The internal stuff can be documented with OraSnap. Just google for it. It's free,

RE: rebuilding indexes - sure to cause a ruckus

Richard Foote scribbled on the wall in glitter crayon: BTW, does anyone know what a rocket scientist refers to when they say Hey, this is all quite easy, it sure ain't ? ? the only two i know use theoretical physics.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my

Re: Documenting databases

Alan, When I started working at my present job there was zip,nada,zilch.. for database documentation. I started with the basics of: describe every table. describe the table data source location and provider and method of loading the data into the table. describe who or how the data in the table

RE: A brief detour....;-)

Good morning all: Well some good news, especially for April Wells. I could not find the TSO/CLIST version of the workshop (we removed it from the class and replaced it with another complicated workshop from the Data Structures and PL/I Exercise handbook), however, I think I found the PL/I

RE: A brief detour....;-)

Apologies.. Carel-Jan -- There will allways be another 10 last bugs -- So much printing ... no wonder we have a lot of dead trees now !!! wide grin Raj Rajendra dot Jamadagni at nospamespn dot com All

RE: NT - Win2K causes performance degradation..

Mark, I have not done a MicroSlop upgrade, but I have in the past upped the SGA size and gotten when I really did not want, which was database performance degradation. You might ask them to check the pagefile size. If it's system maintained or too small funny things do happen. BTW:

Re: NT - Win2K causes performance degradation..

Mark, This is pure speculation, as you didn't provide any particulars. Upgrading to Win2k is not likely the culprit, or at least, I have experienced any kind of problem in moving a database from NT - Win2k. When they upgraded the memory, by just now much did they increase db_block_buffers? If

RE: Windows clustering???

Now you've got me going, Rich. After 15 years of VMS we're being forced to use UNIX (HP-UX 11i) just because the application we want to use doesn't run on VMS. (Developers needed to re-write the app for VMS. Marketing needed so the developers will be paid and the company will be profitable.)

RE: Re: Documenting databases

Alan, The IT departments of several sites, hitherto fairly independent, have all been brought under a single roof at one of my customers and as a result a lot of databases have fallen into the herd of databases we had to manage there. IMHO the key point to inventory is automation; if you

RE: Documenting databases

Alan - First the bad news. Obviously you can't automatically get all that information, but then you knew that. The good news. I think you'll find that information to be very valuable. I try to collect that myself. A spreadsheet or Access database is probably as good a way as any. If you have a

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

Title: Message Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE:

RE: NT - Win2K causes performance degradation..

Might also be they bumped shared_pool way up and they aren't using bind variables? -Original Message- When they upgraded the memory, by just now much did they increase db_block_buffers? If increased too much, they could be spending a lot of time waiting on latches, as there may

Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

How are you resolving your aliases on the unix box and on your client? Are you using onames for both (check your sqlnet.ora at both locations) or are you using local copies of tnsnames.ora? (or some other method).

Re: leaf node 90-10 splits

Hi, Tanel, Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang I wonder why does statistic leaf node 90-10 splits

RE: PERL?

Dan, If I were to use Expect.pm in Perl, I would program in Expect directly. If we can have one less layer of wrapping, why not? On the other hand, sqlplus is not an application that insists on terminal input as telnet does. So you can use a shell here document or coprocess to talk to it; Expect

RE: PERL?

Jared, Thanks for correcting me that shutdown is a sqlplus command. I wanted to make the point that piping strings to sqlplus can do more than Perl DBI can. (But Perl DBI has advantages in many cases) Yong Huang [EMAIL PROTECTED] wrote: All *SQL* commands will work work with the DBI.

Re: Documenting databases

I used to document database objects (including columns) with the COMMENT commands. I stopped doing that because I think it unnecessarily increases the size of data dictionary. It's just a little, though. Yong Huang Daniel Hanks wrote: How about in each database itself. COMMENT ON TABLE|COLUMN

RE: Oracle Data Guard

Hi, Guang, Look up SDU and TDU in Oracle documentation Network configuration. You set them in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to modify some procotol-specific parameters. In addition, in your client application, you can choose a sensible array fetch size,

char is going away?

Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please

RE: char is going away?

Gene Was another part of the rumor that Oracle was going to retire SQL standard compatibility? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that

RE: char is going away?

Gene, I remember Oracle saying that char was going away - about 6 years ago. That's when they created varchar and varchar2. Is this a new rumor? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 10, 2003 11:09 AM To: Multiple recipients of list

RE: char is going away?

Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

Re: char is going away?

Not as long as DB2 has it. Oracle needs to be compatible, in order for the people to convert. In addition to that, CHAR has some properties which VARCHAR2 does not. CHAR is fixed size, blank padded and oracle probably wouldn't want to break ancient mainframe COBOL programs, because people would

Re: char is going away?

Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG Someone told me that Oracle is planning to retire char GG variable and therefore they need to be replaced by GG varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical

RE: char is going away?

-Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG Someone told me that Oracle is planning to retire char GG variable and therefore they need to

24 x 7 x 365

Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve

RE: char is going away?

Jonathan My understanding is that VARCHAR2 is not even a SQL standard, and some databases don't handle VARCHAR very efficiently, so if you are trying to sell a product that can adapt to several databases besides Oracle, you might stick to CHAR. If your application is COBOL-based, using CHAR

RE: Documenting databases

Alan, That sounds like a good candidate for a simple database application written in PL/SQL. Create a schema and model your app. It shouldn't require too many tables. Since you have Oracle and non-oracle information to store, most of the Oracle information could be extracted from the data

RE: accounting software

Grace Take a look at Lawson Software -- http://www.lawson.com Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 9:34 PM To: Multiple recipients of list ORACLE-L can anyone recommend accounting software for mid-range

RE: 24 x 7 x 365

Well, first thing that needs to be noted is that 24 x 7 x 365 indicates uptime for 7 years, which always gives me a chuckle when people say it. Mind you, Ive been guilty of saying it too! J And probably the second thing that needs to be said is that no single product addresses true HA

RE: char is going away?

You mean you still need a DBA in 9i?!!? :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003

RE: Could not run export utility from cron job

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M Sent: Wednesday, December 10, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Subject: Could not run export utility from cron job I am able to run export utility from CLI

Re: leaf node 90-10 splits

On 9i: select * from v$statname where name like '%leaf%'; Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 07:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: leaf node 90-10 splits

Re: Documenting databases

Indeed, my todo list includes an item for automating RDA on several servers. The problem is, that RDA is rather difficult to automate, at least on Windoze. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 05:24 PM Please respond to ORACLE-L To:Multiple

Re: NT - Win2K causes performance degradation..

Mark, My guess is, that the new OS re-instated the file system caching. By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver(and domain controller, web server, print server, etc) until you tell it otherwise. This

Re: char is going away?

On 12/10/2003 12:44:26 PM, Jesse, Rich wrote: Did I mention that this application also RELIES on the OCI bug that allows a date column to contain a zero (as opposed to the zero-date) that can't be done thru normal SQL? That is, probably, because your application supports conversion to

Pipelined functions

Title: Pipelined functions I have a question related to pipelined functions ... I have a function which performs a task in a loop. I have piped messages at the beginning and end of the loop and expect them to appear as soon as they are piped. But there seems to be a difference of opinion

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

They will think differently after Mogens comes out with the Do you really need 10g presentation ;) -- Denny Koovakattu Quoting Nuno Souto [EMAIL PROTECTED]: The interesting fact of course is that the beta program of 10g was announced in newsgroups AFTER it had closed for all intents

long raw risk

Group, I have just been given a project / database where a vendor will implement a table with a LONG RAW field in it. Oracle manuals state clearly that this datatype is outdated and should be replaced by BLOB, I quoted the manuals to vendor-support, but they will not move on this. From the

RE: char is going away?

Dennis, According to my copy of 'A Guide To SQL Standard (Author: C. J. Date), 4th ed, pp292, section 19.4 CHARACTER(n) - fixed length string of exactly n characters (n 0) VARYING(n) - varying length string of up to n characters (n 0) So, I guess it is. Raj

RE: char is going away?

How's about applications written in ancient awful 4GLs like PowerHouse that do not handle variable length fields (aka columns) in their own files, and therefore do not directly support them in relational DBs either? Did I mention that this application also RELIES on the OCI bug that allows a date

Parentheses and joins

I looking for a good, simple example of when parentheses matter when writing a join query using the new, SQL92 join syntax. For example, I could write: SELECT * FROM county y JOIN city c ON y.county_id = c.county_id JOIN attraction a ON c.city_id = a.city_id; and I could use

Re[2]: char is going away?

DW If your application is COBOL-based, using CHAR DW simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DWMy understanding is that VARCHAR2 is not even a SQL standard The keyword

RE: Could not run export utility from cron job

Ken: When running from cron the user's .profile does not get executed. So your ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment. So on the line that you want to execute the export. Before the exp command add . ~/.profile (without the double quotes) exp user/password

RE: Re[2]: char is going away?

Oracle has varchar and varchar2 both ... tfm The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently,

Re: Could not run export utility from cron job

Simpson, Ken wrote: I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken How about adding the line: source path_to_your_profile/.(bash_)profile to the shell script that runs exp?

Re: Could not run export utility from cron job

How about setting it up to execute in 10 minutes? Testing things this minute isn't exactly the point with cron. On 12/10/2003 02:09:24 PM, Bricklen Anderson wrote: Simpson, Ken wrote: I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the

RE: 24 x 7 x 365

Title: RE: 24 x 7 x 365 As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-) Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]

Could not run export utility from cron job

Title: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp

Re:Re: two oracle pl/sql programmers needed (50k/yr)

In Austin, Texas -- Original Message Date: Tue, 09 Dec 2003 06:14:30 -0800 System Manager: Where are these positions located geographically? Me - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday,

Configuring Veritas Netbackup Question

I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a

Re: char is going away?

On 12/10/2003 11:34:36 AM, Jamadagni, Rajendra wrote: Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. Raj And it became reality. DBA jobs were outsourced. The only necessary people belong to the damagement. Oracle 10g will create the need for fewer IS

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

I think he's skipping that one to go direct to Do you really need Oracle? :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Denny Koovakattu

Re: 24 x 7 x 365

You mean 2004/02/31, the 31st of February? On 12/10/2003 02:19:34 PM, Whittle Jerome Contr NCI wrote: As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-) Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145

RE: Could not run export utility from cron job

Title: Could not run export utility from cron job You need to load user's .profile in your cronjob (to set ENVs), becuase the unix user who executes cronjob does not have it's profile loaded. HTH. Guang -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On

RE: Could not run export utility from cron job

Title: Could not run export utility from cron job Make sure that you source your environment variables in the script. At the least, set the $PATH variable to include the Oracle bin directory. Jobs executing from CRON do not automatically source the .profile when they kick off.

Re: char is going away?

Probably by Howard Dean and Bertie Gore. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 10:34 AM Not as long as DB2 has it. Oracle needs to be compatible, in order for the people to convert. In addition to that, CHAR

RE: long raw risk

The reason that vendors often use LONG RAW is that that datatype meets the ANSI SQL standard, while BLOB doesn't. That way, they can use the same DDL against most SQL databases. Sometimes you can modify the vendor's DDL before or during installation. Sometimes you can re-create a table right

rogue SYS connections

Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue connections as SYS from several remote databases. The os_user of the remote system is always oracle and there are several different remote hosts involved. I can't figure out how they are gaining access this way. Our

RE: Could not run export utility from cron job

have you _sourced_ your .profile? cron won't do it automatically for you. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

Re: 24 x 7 x 365

i was at an oracle group meeting and one of the RAC specialists at oracle was talking. he said that that kind of thing 'can' be done, but is incredibly expensive. you need redundancy and fail safes like crazy. any time you do an upgrade, bad things may happen. From: Tracy Rahmlow [EMAIL

Re: Configuring Veritas Netbackup Question

Dwayne, Doesn't the Veritas backup exec Oracle client perform a HOT backup of the database? If that is the case then the RMAN backup is performed differently that the hot backup. Read the script that the Oracle client uses to see what is happening. I may be off base with this version of backup

Re: Parentheses and joins

Jonathan, I didn't realize that parentheses would affect to optimizer to change the join order. A little experimentation shows that it can indeed be done. For anyone that wants to see it, the joins are below. I learn something every day around here. Jared select e.ename , e.empno ,

Re: rogue SYS connections

Suzy, Do you use RMAN to perform backups? Do you use a catalog with RMAN? Rman uses sys to perform the connections to the target database. Just a thought, Ron [EMAIL PROTECTED] 12/10/2003 3:09:33 PM Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue connections as

Re: Configuring Veritas Netbackup Question

You can get some better diagnostic information by doing the following on the client box: cd /usr/openv/netbackup/logs ./mkdirs.sh if the following directories were not created by the script, create them: /usr/openv/netbackup/logs/user_ops/dbext/oracle

Re: 24 x 7 x 365

Tracy, both OPS (8i) and RAC (9i)support independent node shutdown. Both support listener based load balancing so that incoming connections will be evenly spread on all nodes. That still doesn't give you the true 24 x 7 x 365 availability. For that, you need two replicated copies of the database,

Re: Configuring Veritas Netbackup Question

Brian, Netbackup does indeed have to be linked to Oracle. I performed this and it seemed to go well (no obvious error messages). -DC- Spears, Brian wrote: Dwayne Cox, Don't know if this is the same problem, but I did run into this and the there had to be a re-linking and a softlink set for

RE: Re[2]: char is going away?

Raj, Jonathan 1. I have heard rumors that in other databases the VARCHAR performance isn't good. In fact, some people that are converting from other databases to Oracle are pleasantly surprised that Oracle handles VARCHAR well. 2. I have been curious about Oracle's statement that you should use

RE: Configuring Veritas Netbackup Question

Dwayne Cox, Don't know if this is the same problem, but I did run into this and the there had to be a re-linking and a softlink set for a library if I remember correctly. Just an idea to check. I know this stuff is a bugger till you get it working. Brian -Original Message- Dwayne Cox

RE: rogue SYS connections

Thanks Ron. No, we use SQL-Backtrack instead of RMAN. However SQL-Backtrack does show a diff flavor of rogue connections of ###NOBODY. The remote database systems that are connecting to our database as SYS are not ones we support. What is common about these databases is they do have

RE: Re[2]: char is going away?

Yes, they keep saying that varchar may change in future releases, so use varchar2. Maybe they'll finally use it. But for what I don't know. -Original Message- Sent: Wednesday, December 10, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Raj, Jonathan 1. I have heard rumors that

Re: Windows clustering???

Maybe you all already know that, but HP is planning to support OpenVMS on their Itanium servers :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:14 PM I'm guessing they're not running Oracle on this VMS

Re: 24 x 7 x 365

Hi, Unfortunately I'm gonig to add the negative view, like several others have... True 24x7x365 (good pick-up Pete on the 7 year thing) will be limited by much more than database and operating system availability. We just did a major software upgrade last weekend and part of the upgrade

Re: leaf node 90-10 splits

Hi! SQL select * From v$sysstat where name like '%split%'; STATISTIC# NAME CLASS VALUE -- -- -- 195 leaf node splits 128612 196 leaf node 90-10 splits 128209 197

  1   2   >