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
- 7141 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ammar takieddin
By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?
What are the ways tablespaces can be managed and how do they differ?
How to name query output columns in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is archive log in Oracle?
What is save point in oracle database?
Explain the use of file option in exp command.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a trigger and what are its types in oracle?
How to create a new user account in oracle?
Please explain oracle data types with examples?
How to delete an existing row from a table in oracle?
What is a table index?
Explain oracle 12c new features for developers?
