Over the years I have experimented with creating a custom performance tuning tool. Below are a couple screen shots of the program.
Part 2:
https://hoopercharles.wordpress.com/2009/12/13/toy-project-for-performance-tuning-2/
Over the years I have experimented with creating a custom performance tuning tool. Below are a couple screen shots of the program.
Part 2:
https://hoopercharles.wordpress.com/2009/12/13/toy-project-for-performance-tuning-2/
« 11.2.0.1 Statspack Report Contents SQL Grouping – Generating Comma Separated Lists »
********************
When the spacing of text in a comment section is important for readability (execution plans, PL/SQL blocks, SQL, SQL*Plus output, etc.) please use a <pre> tag before the code section and a </pre> tag after the code section:
<pre>
SQL> SELECT 2 SYSDATE TODAY 3 FROM 4 DUAL; TODAY --------- 01-MAR-12
</pre>
********************
When posting test case samples, it is much easier for people to reproduce the test case when the SQL*Plus line prefixes are not included - if possible, please remove those line prefixes. This:
SELECT SYSDATE TODAY FROM DUAL;
Is easier to execute in a test case script than this:
SQL> SELECT 2 SYSDATE TODAY 3 FROM 4 DUAL;
********************
Greater than and Less than signs in code sections are often interpretted as HTML formatting commands. Please replace these characters in the code sections with the HTML equivalents for these characters:
< < > >
Leave a Reply