COMMIT as a long running text

Hi,

    We support Big Client for Oracle HRMS (along with payroll) and lots of other customized applications depends on it.

    DB Version - 9.2.0.6
    IBM - AIX
    HRMS - latest version with family pack

    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.

    Any idea ..

--

Regards,
Tanmoy

• "Time is the coin of life. Only you can determine how it will be spent."

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 11 2006 - 22:27:11 CDT