Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
REFRN23474

DBA_SQLTUNE_STATISTICS

DBA_SQLTUNE_STATISTICS displays statistics associated with all SQL statements in the database.

Related View

USER_SQLTUNE_STATISTICS displays statistics associated with the SQL statements owned by the current user.

Column Datatype NULL Description
TASK_ID NUMBER(38) NOT NULL Tuning task identifier
OBJECT_ID NUMBER(38) NOT NULL Advisor framework object identifier
PARSING_SCHEMA_ID NUMBER   Schema under which the SQL is parsed
MODULEFoot 1  VARCHAR2(48)   Last application module recorded for the SQL
ACTIONFootref 1 VARCHAR2(32)   Last application action recorded for the SQL
ELAPSED_TIME NUMBER   Elapsed time for the SQL statement
CPU_TIME NUMBER   CPU time for the SQL
BUFFER_GETS NUMBER   Number of buffer gets
DISK_READS NUMBER   Number of disk reads
DIRECT_WRITES NUMBER   Number of disk writes
ROWS_PROCESSED NUMBER   Number of rows processed by the SQL
FETCHES NUMBER   Number of fetches
EXECUTIONS NUMBER   Number of executions
END_OF_FETCH_COUNT NUMBER   End of fetch count
OPTIMIZER_COST NUMBER   Optimizer cost for the SQL
OPTIMIZER_ENV RAW(1000)   Optimizer environment
COMMAND_TYPE NUMBER   Command type

Footnote 1 The datatype of this column is VARCHAR2(64) starting with Oracle Database 11g Release 2 (11.2.0.2).

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF