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 run the anonymous block again?
what are the advantages of running a database in archive log mode?
How to use existing values in update statements using oracle?
What is the difference between a user and a schema in oracle?
How to define an oracle cursor variable?
What are a cluster and non-cluster index?
What is an oracle recycle bin?
How to export data with a field delimiter?
What is a Garbage Collection? and what is full recursive Garbage collection?
What do you understand by database schema and what does it hold?
What is a database table in oracle?
What is the difference between postgresql and oracle?
What are the types of trigger in oracle?
How can we view last record added to a table?
What is BBED in Oracle?