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
- 7034 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ammar takieddin
By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME
| Is This Answer Correct ? | 5 Yes | 0 No |
What is a user role in oracle?
How to get a list of all background sessions in the database?
Is primary key indexed by default in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is ordinary table in oracle?
Why we choose emp number as primarykey?
Why do we use bulk collect in oracle?
What to do if dba lost the system password?
Oracle General 
