We have one Package(which has many function/procedures, SQL
quires etc).
Now we need to check, which query or procedure is taking lot
of time in that Package. ?
How do we do it.
Answer Posted / bupesh
There are various ways to do this :
1) We can run individual objects (Procedures and Functions)
to get the timestamps and then work on the one with slow
performance.
2) We can also get the trace of the entire Package and
identify the slow objects.
3) We can use DBMS_APPLICATION_INFO to gather the
statistics at runtime using V$SESSION
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to create a table index?
How to see the table columns used in an index?
What is query image?
How to retrieve the count of updated rows?
How a database is related to tablespaces?
How to initialize variables with default values?
Is postgres faster than oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
how may join possible between (requisition with purchase order)
Explain oracle’s server parameter file.
How do you tell what your machine name is and what is its IP address?
How to define a record variable to store a table row?
What is where clause in oracle?
Explain constraining triggers.
How to select some rows from a table in oracle?