Oracle Utilities - Using Hidden
Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and
More
Other Things worth Discovering
The same approach used to discover new PL/SQL packages can be applied to
find other useful features in new versions of the database. The
following new Oracle features can be easily discovered:
• Instance Parameters – New instance parameters can easily be identified
with the following query:
select name
from v$parameter
minus
select name
from v$parameter@PRIOR_VERSION;
• Obsolete Parameters – Oracle provides a list of obsolete parameters
with each version of the database, beginning in 8.1.5.
select name
from v$obsolete_parameter
minus
select name
from v$obsolete_parameter@PRIOR_VERSION;
• V$ Views - New v$ and gv$ views are usually an indicator of new
functionality in the database. They are listed with the following query:
select view_name
from v$fixed_view_definition
minus
select view_name
from v$fixed_view_definition@PRIOR_VERSION;
• System Events – The new system events are also very interesting to
DBAs. Some of them offer new tuning features. They can be obtained from
the following query:
select name
from v$event_name
minus
select name
from v$event_name@PRIOR_VERSION;
The @PRIOR_VERSION contained in each query above represents a database
link to another version of Oracle. This designation can be used to find
any new characteristic of the database via an SQL statement.
The next section of this book will categorize the PL/SQL and binary
utilities according to the version of the database.
The above is an excerpt from Oracle Utilities - Using
Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof
and More by Rampant TechPress.
For more details on Oracle
utilities, see the book "Advanced
Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.
You can buy it direct from the publisher
for 30% off directly from
Rampant TechPress.
