RE: How to take sql*loader trace

That is why my advice was 10046 trace name context forever, level 8, not SQL_TRACE. With 10046, level 8 you can still get waits (tkprof in 9i understands them). You cannot Get explain plan because direct path doesn't use SQL to insert into the database. -- Mladen Gogala Oracle DBA

High availability and real time data warehosuing

Hi I was wundering if any of your shops are using High avaliability solutions . 1)Can you tell me how these solutions like datamirror are superior to oracle9i RAC ? 2)Has anybody implemented real time data warehousing solution ?If so what were the enabling technologies used like 1)Java

RE: OT : Learning curve

I second the recommendation to buy and read Tufte's books, whether you're the creator of graphic communication, or just the victim of it. When I was at Oracle management meetings, you could always tell the groups that were underperforming financially. They had the most complicated charts. Cary

RE: How to take sql*loader trace

Mladen Yes, when I saw your posting, I assumed that was what you were getting at. I'll have to remember this one if I have trouble with a SQL*Loader session. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003

Re: RE: quick suggestions for tuning ?

Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for your pointers and suggestions. I owe a lot to you Oracle Gurus. A novice DBA like me is ever grateful to this wonderful list. I love this list. Thanks once again. Jp. -- Please see the official ORACLE-L FAQ:

Re: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1

You could load the 7.1 exp on the 8.1 server and export then import on 7.1 server Rick |-+ | | Guido Konsolke | | | [EMAIL PROTECTED]| | | nkrupp.com

Take an Oracle 8.1 export file back to an Oracle 7.1 database.

Title: Take an Oracle 8.1 export file back to an Oracle 7.1 database. Hi all Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there

RE: UNDO Tablespace

The answer for this from our vendor is to increase the size of the UNDO based on their DBAs statement that UNDO is consumed rapidly because every query makes a physical copy of all tables and holds on to them for the retention period. Sherrie, In my considered opinion: Woohoohoohoo. That's a

RE: URGENT: Trying to duplicate database from cold backup - auxi

BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ:

RE: Limits on PL/SQL block?

-Original Message- From: Rudy Zung [mailto:[EMAIL PROTECTED] I'm seeing a PLS-00123 program too large error. Oracle's documentation says that the actual limit on the size of the block is dependant on the mix of statements in the PL/SQL block. Does anyone know how Oracle determines

RE: Record breaking query

Title: RE: Record breaking query I have seen the time for wait_events in 8.1 do funny things when the system date was changed by ntp. Oracle assumes that end time is after start time for each wait event, if this is not the case due to the system clock being changed, you get a BIG number.

tables and views

How to diiferentiate views and tables in all_tables and all_tab_columns . which column and what criteria can return only tables ?? -ak

RE: Hot Backup

Just use rman, it comes with your Oracle RDBMS and has a whole book of documentaion. Rut5h -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Oracle DBA Sent: Tuesday, August 12, 2003 9:29 AM To: Multiple recipients of list ORACLE-L Subject: Hot Backup

RE: Capacity Planning Methods?

OK, I'll post it. Salt to taste or toss it in the garbage. Note that this is just collecting data and doesn't make any recommendations or such. Comments and critiques welcome, except from Mladen... (running for cover) ;) And, of course, standard disclaimers apply! Rich Rich Jesse

RE: rman implementation

Sai - Several factors: - This was several years ago, so memory fades. - This was the sys admin's first go at NFS. - Got through the initial configuration issues, and the system was up and running. Then several months later I was trying to use the device for RMAN recovery. It would hang with

RE: Analytical Functions

Nope, Use them every day. Their standard issue, but require Enterprise edition in 8i. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 12, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi Can anyone tell me if the Analytical

Partitioning

I have worked with partitioning before but have yet encountered the following challenge - The table we are trying to partition is a large table with hundreds of millions of rows, which is ok. But it does not have a month column, although it has dates. I would like to partition by month because