 |
|
sqltune_category tips
Oracle Tips by Burleson |
Oracle 10g sqltune_category
Parameter type – String
Syntax – sqltune_category = category_name
Default value – DEFAULT
Modifiable – ALTER SESSION, ALTER SYSTEM
The sqltune_category parameter selectively
enables the SQL tuning base features for specific sessions. The
parameter value is an Oracle identifier string. For SQL Profiles,
the parameter sqltune_category specifies the category name used by
the optimizer to select a stored outline defined in the SQL tuning
base. Because the default value for sqltune_category is DEFAULT,
Oracle automatically applies SQL Profiles in that category. If you
specify another category with the sql_category parameter, then
Oracle uses SQL Profiles in that category until you reset the
parameter to another category name.
|
