Technical Notes
We're all on the same page!
Showing posts with label
performance
.
Show all posts
Showing posts with label
performance
.
Show all posts
Wednesday, 28 June 2017
plsql_optimize_level and plsql_code_type parameters
›
Purpose We are able to use plsql_optimize_level parameter for getting better execution performance on plsql codes. On the other way, pls...
Thursday, 4 May 2017
How to generate sql explain plan?
›
e.g. prepare example table: SQL> create table ep_employees as select * from employees observe costs values: SQL> explain plan ...
Wednesday, 12 April 2017
How to see TOP 10 SQL that consuming system resources highly?
›
e.g. select * from ( select * from v$sql order by DISK_READS desc ) where rownum < 11 options for order by: RUNTIME_MEM, EXEC...
›
Home
View web version