| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DML on dual?
That's part of the problem. I don't know who is doing this, even after
trolling through V$SQL. All statements that reference DUAL are SELECTs.
I guess I could set 10046 system-wide for a short period, until I find a
.trc file with an event of row lock wait, but that seems to involve a
little too much brute force.
I could also check V$SEGSTAT every minute, checking for an increase in the appropriate segment event for DUAL, then when an increase is found scan V$SQL for a LAST_LOAD_TIME greater or equal to a minute ago. Maybe a little less brute force, but still seems to be a rather large hammer for such a small nail.
Dave
David C. Herring, DBA | A c x i o m Delivery Center Organization
630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com]
Sent: Thursday, April 12, 2007 12:45 PM
To: Herring Dave - dherri
Cc: oracle-l_at_freelists.org
Subject: Re: DML on dual?
David,
try to capture which session is doing this (looking into v$sql), and
then you'll have at least the program, ...
rgds
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 12 2007 - 12:54:54 CDT
 |
 |