In addition, there are two stand-alone scripts (with no SQLT dependencies) that you can use directly on any read-only database. They are sqlt/utl/roxtract.sql and sqlt/utl/roxecute.sql. They mimic SQLT XTRACT and XECUTE but in a smaller scale. Notice that you can also use these two stand-alone scripts safely on any production environment since they do not execute any DDL and they perform queries only (no inserts, updates or deletes). What do you get from them? You get the basics: execution plans; peeked binds; CBO statistics for Tables, Table Columns, Indexes and Index Columns; SQL Monitor Active report; 10053 trace; 10046 trace and TKPROF on roxecute.sql.
Author blog : http://carlos-sierra.net/2012/05/03/sqltxplain-sqlt-11-4-4-5-is-now-available/
Metalink(HTML) : https://supporthtml.oracle.com/epmos/faces/ui/km/DocContentDisplay.jspx?id=215187.1
Metalink(FLASH) : https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=215187.1
No comments:
Post a Comment