||Oracle Tips by Burleson
Oracle Instance Internals Scripts
complete. Lower values will take longer, but
consume fewer processing and I/O resources.
If the POWER clause of a rebalance operation is
not specified, then the default power will be the value of
The plsql_optimize_level parameter specifies the optimization level that will be used to
compile PL/SQL library units. The higher the setting of this
parameter, the more effort the compiler makes to optimize PL/SQL
Generally, setting this parameter to 2 pays off
in better execution performance. If, however, the compiler runs
slowly on a particular source module or if optimization does not
make sense for some reason (for example, during rapid turnaround
development), then setting this parameter to 1 will result in almost
as good a compilation with less use of compile-time resources.
The value of this parameter is stored
persistently with the library unit.
The plsql_warnings parameter enables or disables the reporting of warning messages by
the PL/SQL compiler, and specifies which warning messages to show as
The above is from the bestselling book
Mike Ault’s Oracle Internals Monitoring & Tuning Scripts.
It's only $49.95and you can download all the scripts immediately:
||Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized.