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
- 7247 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 a data segment?
What is oracle join syntax?
What suggestions do you have to reduce the network traffic?
How to resolve the ORA-39133 error in Oracle?
How to add a new column to an existing table with a default value?
What is integrity and what is constraint??Explain with example
Can we convert a date to char in oracle and if so, what would be the syntax?
What is an oracle function?
How to use in conditions in oracle?
How to display row numbers with the records?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What are the various types of snapshots ?
State all possible different index configurations a table can possibly have?
What is a cursor in oracle?
What are the different types of partitions in oracle?
