RE: To patch 'n pray or to keep looking for the root cause: tha t is the question

[Branimir Petrovic <BranimirP@xxxxxxxx>]

Hi Tom, long long ago, I tried and gave up on direct exports (can't 
remember any more exactly why, but there were odd problems with it). 

These servers of mine are smallish/crappish boxes with two ATA or 
SATA drives, therefore network traffic plays no role. Differences 
in time taken between "fast" and "not-so-fast" exports go to up to 
six times, and although I am in no hurry (nights here are long 
enough, especially during the winter), looking at oddity I can't 
explain kinda nags me.

Got off-list suggestion to try 9.2.0.4 patch or higher, so I
believe I'll go for it on one trial system. Will also have a
peak at v$session_event as Allan kindly suggested. 

Branimir



-----Original Message-----
From: Mercadante, Thomas F (LABOR)

Branimir,

Have you tried direct exports and logged any differences?  Obviously
this problem is either server based or Oracle based.

Direct exports would skip the SGA - thus eliminating any busy buffer
problems.

And also look for other events happening on the server.  Are your disk
mounted locally, or on a SAN?  This could be another cause for delay -
network problems interfering with SAN writes.

Tom
--
http://www.freelists.org/webpage/oracle-l

Other related posts:

RE: To patch 'n pray or to keep looking for the root cause: tha t is the question