If you are using the BUFFER= parameter of the export, remove it and you will see much improvement!
Carol -----Original Message----- Sent: Monday, September 08, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Basic info: - RAC 9.2.0.2, - dual node Alhpa ES45 cluster, - CPU @ 1GHZ, very fast disk drives, - sys and system schemas ARE NOT analuzed. Full export (compress=n statistics=none) takes two hours. Very same database, but version 8.1.7 on older Alpha server, takes less than 30 minutes! Export file is about 1.5 GB large. NO user activites durring export, no system load except exp executable. I did tracing on export session (10046, level 12) and saw that queries against EXU9RLS, EXU9PCT and EXUTAB are taking a lots of time. When export comes to ".. exporting synonyms" it hangs. Eventually, after hour it is finished. Database works without any other problem. Oracle support (iTAR) was not very helpful. Any clue? I may copy and paste parts of tkprof output to clarify, if someone is interested. Thanks, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pena, Carol A INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
