Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 7143 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain the use of Merge statement in oracle 11g
What are the ansi data types supported in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is ASM (Automatic Storage Management) in Oracle?
How to run create database statement?
How do I uninstall oracle client from windows?
How do I spool to a csv formatted file using sqlplus?
What is meant by recursive hints in oracle?
How to connect to a local oracle 10g xe server?
How can you merge two tables in oracle?
What is data type in oracle?
How do I call oracle stored procedures that take no parameters?
Is oracle a relational database?
How to get the Installed Oracle Version Information ?
Explain the difference between sql and oracle?
