-
how much time consumed
Hi All
We have a stored procedures which has a lot of inserts , updates & deletes & selects.
We want to actually know how much time is consumed by all the above DML's & selects.
What is the best & easy way to obtain such statistical info
Rgrds
-
Hi
Just wrap
l_start_time:=dbmsutility.get_time()
dml
l_end_time:=dbmsutility.get_time()-l_start_time
regards
Hrishy
-
or set time on in sql*plus and run it manually
-
Use DBMS_PROFILER.
This is a good PKG provided by Oracle.
Tamil
-
DBMS_PROFILER is the best tool to diagnose procedures.
If you are interested in tunning SQL in the proceure, the only thing missing in the suggestions is SQL_TRACE.
Don't forget to set timed_statistics also.
Both of those are session modifiable.
-
SQL_TRACE is the best way to find out how much cpu time & clock time each individual statement takes.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|