- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Audit trail
These views (and some tables) provide information about the status of auditing and the actual audit trail. For further information, see Chapter 7.
- ALL_DEF_AUDIT_OPTS
Lists the default auditing options in effect for new objects.
- AUDIT_ACTIONS
Lists the audit codes and descriptions.
- DBA_AUDIT_EXISTS
Contains audit trail information generated by AUDIT EXISTS and AUDIT NOEXISTS.
- DBA_AUDIT_OBJECT
Contains audit trail information for object auditing.
- DBA_AUDIT_SESSION
Contains audit trail information for all connects and disconnects from the instance.
- DBA_AUDIT_STATEMENT
Contains audit trail information for all audited statements.
- DBA_AUDIT_TRAIL
Contains all audit trail information. The other DBA_AUDIT_ views are subsets of this view.
- DBA_OBJ_AUDIT_OPTS
Lists all object auditing options in effect.
- DBA_PRIV_AUDIT_OPTS
Lists all system privilege auditing options in effect.
- DBA_STMT_AUDIT_OPTS
Lists all statement auditing options in effect.
- STMT_AUDIT_OPTION_MAP
Lists the valid SQL statements that can be specified for statement auditing.
- SYSTEM_PRIVILEGE_MAP
Lists the valid system privileges that can be specified for system privilege auditing.
- TABLE_PRIVILEGE_MAP
Lists the valid object audit options that can be specified for schema object auditing.
-
No Comment