That's a useful bit of information. Thanks.
I've also come across a strange effect which
I had ascribed, without proof, to frequent truncating
of global temporary tables with 'on commit preserve'.
Sessions regularly, and for no apparent reason, and
nowhere near a commit suddenly spend a few seconds
(N x 1.03 to be precise) waiting for a 'log file sync'.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th
----- Original Message -----
From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
To: <mark.bobak@xxxxxxxxxxxxxxx>
Cc: <john.kanagaraj@xxxxxxx>; <oracle-l@xxxxxxxxxxxxx>;
<oradebug@xxxxxxxxxxxxx>
Sent: Monday, October 18, 2004 9:05 PM
Subject: Re: local write wait event
Mark:
Beware, GTT and Truncates do not go together.. Currently we do not
differntiate the GTT DDLs and Normal DDLs. Which means
the TRUNCATE on the temporary (Session) table locks the entire structure
(all-sessions-temp-tables) and all other sessions have
to wait for library cache/pin waits.
--
http://www.freelists.org/webpage/oracle-l
