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
- 7124 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
What do you mean by merge in oracle?
Explain do view contain data?
List the types of joins used in writing subqueries?
How to create an initialization parameter file?
Explain the use of file option in exp command.
Is the After report trigger fired if the report execution fails ?
What are the attributes of cursor?
Can group functions be used in the order by clause in oracle?
How to use "if" statements on multiple conditions?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to download oracle database 10g xe?
What is the data type of dual table?
What operating systems are supported by oracle database 10g xe?
What are the varoius components of physical database structure of oracle database?
How to shutdown your 10g xe server from command line?
