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

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 Received on Fri Sep 02 2005 - 13:59:41 CDT