Query capture

From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 07 Apr 2005 10:59:40 -0400

Hi,

I want to capture those queries on basis of following criteria.

1)SQLs that take more than 5 seconds
2)SQLs that take more than 10 seconds
3)SQLs that take more than 20 seconds

Can I do it without explain plan?
I want to set up script which will capture only those query which are taking 
more than 5,10,20 minutes to execute whether the table is small or large.
thanks


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

Follow-Ups:

Re: Query capture
From: John Clarke

Query capture

Other related posts: