Database Reference
In-Depth Information
Source Code Depot
Table 25-4 lists this chapter's source files and their functionality.
Table 25-4. Statspack Source Code Depot
File Name
Functionality
gen_disable_sp_constr.sql
Generates a SQL script that disables all referential integrity
constraints in schema PERFSTAT
snap_by_cpu_util.sql
Lists snapshot intervals with high CPU usage
snap_by_db_time.sql
Lists snapshot intervals with high DB time
sp_sqltext.sql
PL/SQL pipelined table function for retrieval of syntactically
correct (i.e., no forced line breaks) SQL statements from the
Statspack repository
sp_sqltext_get.sql
SQL script that calls the pipelined table function SITE_SYS.
SP_SQLTEXT
sp_sqltext_join.sql
Retrieves statements which had an elapsed time of more than
one second per execution from a Statspack repository
sp_translate_hv.sql
Translates an Oracle10 g hash value from a SQL trace file to the
old hash value for use with Statspack and to the SQL identifier
( SQL_ID ) for use with AWR by querying STATS$SQL_PLAN_USAGE
sp_used_indexes.sql
Identifies used indexes in a schema; requires snapshot level 6
or higher
sp_valid_intervals.sql
View for retrieving valid snapshot intervals using the analytic
function LAG
sprepins_fix_10g.sql
Fix for incorrect session level reports in Oracle10 g (bug 5145816);
replaces the original file sprepins.sql
sprepins_fix_9i.sql
Fix for incorrect session level reports in Oracle9 i (bug 5145816);
replaces the original file sprepins.sql
sql_fulltext.sql
SQL*Plus script for retrieving a SQL statement identified by hash
value from V$SQL (requires at least Oracle10 g )
statspack_purge.sql
Snapshot purge PL/SQL procedure for Oracle9 i
 
Search WWH ::




Custom Search