how to tune oracle sql queries pls tell me step by step.
urgent pls
- 1 Answers
- 2553 Views
- I also Faced
- E-Mail Answers
Answer Posted / define
You can use pl/sql query profiler in dbForge Studio for Oracle. It helps to tune oracle sql performance very much.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
State all possible different index configurations a table can possibly have?
What is oracle thin client?
Is there an oracle sql query that aggregates multiple rows into one row?
Can we use bind variables in oracle stored procedure?
Where is the export dump file located?
What is a read write transaction in oracle?
Explain the use of indexes option in exp command.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the scope of a local variable?
What is ordinary table in oracle?
What do you understand by database schema and what does it hold?
what's query optimization and without use of IN AND Exist can we get another way data from query
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
 How to use an oracle sequence generator in a mapping?
