Author Description

Oracle DBAs are always trying to solve performance problems and obtain quick summary information from their Oracle databases by querying the Oracle data dictionary and the dynamic performance views. They are looking for information about schema objects (tables, views), database objects (rollback segments, users), and tuning information. This small booklet is a compendium of the most frequently used queries, arranged an easy to carry and use format. Table of contents: 1. The Data Dictionary and How It Works 2. Tuning Queries 3. Operational Queries 4. Database Structure Queries 5. Schema and Database Object Queries 6. Security 7. Multi-Threaded Server 8. Oracle Parallel Server and Parallel Execution