Re: local write wait event

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_at_gmail.com> To: <mark.bobak_at_il.proquest.com> Cc: <john.kanagaraj_at_hds.com>; <oracle-l_at_freelists.org>; <oradebug_at_freelists.org> 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