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
- 7074 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 is a lookup table in oracle?
What are the limitations of check constraint?
How to use group functions in the select clause using oracle?
How to add a new column to an existing table in oracle?
How to convert csv to table in oracle?
What do you understand by a database object?
How to speed up webrick?
Why oracle is used?
What is the usage of merge statement?
How to join two tables in a single query using oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How do I uninstall oracle 11g?
How to create id with auto_increment on oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
