1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Performance Tuning Simplified

Performance Tuning Simplified
Scenario 1

When module/application/report that has bad performance issue is known.

Steps


1. First of all we need to identify sql statements that perform very badly. To do this, start sql trace
SQL>alter session set sql_trace=true;


2. Then, re-run the module/application/report. This is performed so that the related sql statement can be captured.


3. Stop the sql tracing
SQL>alter session set sql_trace=false;

4. The trace should be created in admin/orcl/udump

5. The trace file is hard to be read by human. To translate this file into more human readable format, use TKPROF. Use sort=exeela to sort by elapsed execution time
root@localhost $ tkprof /mnt/disk2/u01/app/oracle/admin/orcl/udump/xxxxx.trc output_file.txt sort =exeela

6. Then, the output file will contain details explanation on the running sql statement including optimizer mode. Then from here, we can start to tuning the sql. On how to tuning the sql, I will write it later.

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy