RE: DML on dual?
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- Date: Thu, 12 Apr 2007 12:54:54 -0500
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@xxxxxxxxx]
Sent: Thursday, April 12, 2007 12:45 PM
To: Herring Dave - dherri
Cc: oracle-l@xxxxxxxxxxxxx
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
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.
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.
****************************************************************************
Other related posts:
