Tuesday, March 29, 2016

TKPROFF key words explanation in PLSQL Oracle

Column Value Meaning
PARSE Translates the SQL statement into an execution plan, including checks for proper security authorization and checks for the existence of tables, columns, and other referenced objects.
EXECUTE Actual execution of the statement by Oracle. For INSERTUPDATE, and DELETE statements, this modifies the data. For SELECTstatements, this identifies the selected rows.
FETCH Retrieves rows returned by a query. Fetches are only performed forSELECT statements.
COUNT Number of times a statement was parsed, executed, or fetched.
CPU Total CPU time in seconds for all parse, execute, or fetch calls for the statement. This value is zero (0) if TIMED_STATISTICS is not turned on.
ELAPSED Total elapsed time in seconds for all parse, execute, or fetch calls for the statement. This value is zero (0) if TIMED_STATISTICS is not turned on.
DISK Total number of data blocks physically read from the datafiles on disk for all parse, execute, or fetch calls.
QUERY Total number of buffers retrieved in consistent mode for all parse, execute, or fetch calls. Usually, buffers are retrieved in consistent mode for queries.
CURRENT Total number of buffers retrieved in current mode. Buffers are retrieved in current mode for statements such as INSERTUPDATE, andDELETE.
ROWS Total number of rows processed by the SQL statement. This total does not include rows processed by subqueries of the SQL statement.
Note: Query + Current = Logical Reads (total number of buffers accessed)

No comments:

Post a Comment