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.
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: COMMIT as a long running text
- From: Laimutis Nedzinskas
- References:
- COMMIT as a long running text
- From: Tanmoy
Other related posts:
- » COMMIT as a long running text
- » Re: COMMIT as a long running text
- » RE: COMMIT as a long running text
- » Re: COMMIT as a long running text
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.
- RE: COMMIT as a long running text
- From: Laimutis Nedzinskas
- COMMIT as a long running text
- From: Tanmoy