- 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
SQL
These views provide information about the processing of all SQL statements in the instance:
- V$OBJECT_DEPENDENCY
Lists all objects that a package, procedure, or cursor in the SGA is depending upon. This view can be joined to the V$SQL and V$SESSION views to obtain a list of all objects being referenced by a user.
- V$OPEN_CURSOR
Lists all open cursors in the system.
- V$SORT_SEGMENT
Provides information about all sort segments in tablespaces specified as TEMPORARY.
- V$SORT_USAGE
Provides information about sort segments in all tablespaces.
- V$SQL
Provides information about all SQL statements in the shared SQL area.
- V$SQL_BIND_DATA
Provides information about the bind variables provided for each SQL statement.
- V$SQL_BIND_METADATA
Provides metadata about all bind variables used in SQL statements.
- V$SQL_CURSOR
Provides debugging information about every cursor in the shared SQL area.
- V$SQL_SHARED_MEMORY
Provides information about how memory is allocated for every cursor in the shared SQL area.
- V$SQLAREA
Provides information on all SQL statements in the shared SQL area.
- V$SQLTEXT
Provides the text of all SQL statements in the shared SQL area. All newline and tab information is replaced by spaces.
- V$SQLTEXT_WITH_NEWLINES
Provides the text of all SQL statements in the shared SQL area, but includes the original newline and tab characters.
-
No Comment