Re: COMMIT as a long running text
- From: rjamya <rjamya@xxxxxxxxx>
- To: tanmoydc@xxxxxxxxx
- Date: Thu, 12 Oct 2006 07:16:58 -0400
what tool? what is the hash value of those statements? zero? if so
then some tools (e.g. Confio Ignite) treat them as " DDL or commit ",
but actually those could be dbms_jobs, in addition to commits.
Raj
On 10/11/06, Tanmoy <tanmoydc@xxxxxxxxx> wrote:
We have some monitoring tools like long running query for 2 hrs etc ,
One of our long running query alert was showing a customized application
having sql text COMMIT as running more than 2hrs.
We found out mutiple session sometimes having the same sql text.
considering considerable IO on server.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
