In the previous module, we examined tuning using Oracle data structures including
- abstract data types,
- VARRAYs, and
- nested tables.
We will now turn our attention to tuning using the Oracle data dictionary.
During the time period of Oracle8i, Oracle provided a limited tool set for monitoring their database.
That has since changed
As a result, many third party monitoring tools have appeared. These include the Q product by Savant, DB-Vision by Platinum, Patrol by BMC, and a host of others.
However, Oracle does provide us with the tools to view the events within the active Oracle instance and create our own monitors and alert mechanisms.
The next lesson looks at the tools Oracle provides for viewing the performance of our database.
By the time you complete this module you should be able to:
As new features are added, it is expected that the data dictionary will be modified with each future release of Oracle.
This is not intended to be an exhaustive list of all the data dictionary views.
Those listed here are the most commonly accessed by user queries.