Database Reference
In-Depth Information
Source Code Depot
Table 1-2 lists this chapter's source files and their functionality.
Table 1-2.
Partially Documented Parameters Source Code Depot
File Name
Functionality
auto_pga_parameters.sql
Retrieves all the documented and undocumented
parameters that affect SQL work area sizing.
pga_aggregate_target_iterator.sql
This script varies
PGA_AGGREGATE_TARGET
between
10 MB and 32 GB and calls
auto_pga_parameters.sql
at each iteration.
row_factory.sql
Creates a pipelined table function that returns an
arbitrary number of rows.
sort_random_strings.sql
This script enables SQL*Plus
AUTOTRACE
and selects
rows from the test table
RANDOM_STRINGS
.
sql_workarea_active.pl
This Perl script monitors work areas by querying the
dynamic performance view
V$SQL_WORKAREA_ACTIVE
.
sql_workarea_active_hash.pl
This Perl script monitors work areas by querying the
dynamic performance view
V$SQL_WORKAREA_ACTIVE
.
The output includes SQL statement hash values.