Technical Notes

We're all on the same page!

Showing posts with label tuning. Show all posts
Showing posts with label tuning. Show all posts
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, 4 January 2017

How to enable 'Diagnostic' and 'Tuning' diagnostic packs?

›
Check parameter SQL> SHOW PARAMETER control_management_pack_access Solid solution add this into initora file; *.control_management_...
›
Home
View web version
Powered by Blogger.