Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Author:Stelios Charalambides
Language: eng
Format: epub, pdf
ISBN: 9781430248095
Publisher: Apress


The first report roxtract_SNC2_locutus_11.2.0.1.0_dck1xz983xa8c_20121103_111855_main.html (in this example) is the roxtract main report. It is a trimmed down version of the SQLTXTRACT report, but nonetheless an amazingly useful HTML file. Let’s look at the top of this HTML file, as shown in Figure 9-4.

Figure 9-4 . The top of the HTML ROXTRACT report

As you can see, roxtract is weaker than the powerful XTRACT report. The number of sections it covers is reduced, but you still have the execution plans, table information and many other sections.

The other file supplied by roxtract is roxtract_SNC2_locutus_11.2.0.1.0_dck1xz983xa8c_20121103_111855_monitor.html. The HTML defaults to the Plan Statistics tab as shown in Figure 9-5.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.