Oracle Advanced Performance Tuning Scripts

Parameter Scripts

hidden_parameters.sql

This script lists all the hidden parameters, together with their descriptions and whether they can be modified. Note that to modify a hidden parameter with the ALTER SESSION or ALTER SYSTEM statements, it is necessary to enclose the parameter name in quotation marks. See the 8.1 version of the APT script tune_spin_count.sql for an example.

Warning: Setting hidden parameters changes the behavior of the Oracle server, and can damage databases. Do not set hidden parameters on production instances unless you have checked with Oracle Support.

Download script for: 7.3, 8.0 or 8.1

all_parameters.sql

This script reports the values of all parameters including the hidden parameters.

Download script for: 7.3, 8.0, 8.1

parameters.sql

This script reproduces the functionality of the SHOW PARAMETERS command but includes hidden parameters.

Download script for: 8.1

instance_variables.sql

This script shows the values of the instance variables from X$KVII, X$KVIT and X$KVIS.

Download script for: 7.3, 8.0 or 8.1

fixed_table_hwms.sql

This script is for release 7.3 only. It reports the high water mark usage of the fixed tables that are sized by an init.ora parameter. This is useful to avoid the two extremes of either running out of slots in these tables, or making them so large as to be wasteful. From release 8.0, this script is redundant, because V$RESOURCE_LIMIT provides the same information.

Download script for: 7.3


Ixora Pty Ltd.   All rights reserved.
12-Oct-2007 22:22
Search   Questions   Feedback   Up   Home