Re: COMMIT as a long running text

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 12 Oct 2006 07:16:58 -0400
Message-ID: <9177895d0610120416t3a07d218xe55655087d2f9a73@mail.gmail.com>

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_at_gmail.com> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 12 2006 - 06:16:58 CDT