asked on

Estimate time to complete the query

I know we could find the cost of any query. but its not in time unit.
so anybody knows how can we find total time the query will require including "recoud count", "I/O" .etc.

By the way, this should be done using query or procedure. not using SQL*PLUS like explain plain or other stuff.
--> i should be able to query those values.

Please note that i have gather all system and objects statistics.

Metanil

SOLUTION

Ora_Techie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

sathyagiri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

tvdmit

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Metanil

ASKER

yes, I am currently using that view but it doesn't properly fulfill my requirement because query has already started.
Any other useful comments??

SOLUTION

NicksonKoh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

tvdmit

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Metanil

ASKER

:-D yes tvdmit it is somewhat connect to my previous questions.
I know and used CPU_PER_SESSION 3000 for 30 sec .. but we have to wait for 30 sec and 1000 call (in your cases).

i think i am getting good suggestions.. anymore left??

Metanil

SOLUTION