Oracle Database - V$SQL

Card Puncher Data Processing

About

VSQL lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each child of the original SQL text entered (This parents must be seen in vsqlarea).

When a SQL statement ages out of the shared pool, it will no longer be in the VSQL view.

Statistics displayed in VSQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress.

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Adaptive Plan

Adaptive plan is an adaptive functionality. The Adaptive plan functionality enables the optimizer to: generate multiple predetermined subplans defer the subplan decision until execution time based...
Card Puncher Data Processing
Oracle Database - Explain Plan from Cursor Cache (DBMS_XPLAN.DISPLAY_CURSOR)

This DBMS_XPLAN.DISPLAY_CURSOR function display the execution plan of an already executed statement where the resulting cursor...
Oracle Database Sql Analytical
Oracle Database - SQL

215187.1SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly
Oracle Database Sga
Oracle Database - Session (Library|Cursor) Cache

The library cache is a part of the shared pool Private Sql Area Also known as: Session cursor cache. V contains the execution plan information for each child cursor loaded in the library...
Oracle Database Sga
Oracle Database - Shared sql area

The Shared sql area is an area in the library cache that contains: the cached SQL cursors the actual plan the parse tree for a SQL statement. Only one shared SQL area exists for a unique statement....
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN_STATISTICS

V provides execution statistics at the row source level for each child cursor. STATISTICS_LEVEL Join Column Equality Predicate Join...
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN

V contains the actual execution plan information for each child cursor loaded in the library cache. library cache Join Column Equality Predicate Join Table In order to add ADDRESS and HASH_VALUE...
Card Puncher Data Processing
Oracle Database - V$SQL_WORKAREA

V displays information work areas used by SQL cursors. The primary key for the view is WORKAREA_ADDRESS, the memory Address...
Oracle Database Sql Processing
SQL Engine - SQL Parser

The parser in an SQL engine parse a Sql statement. It's the first stage of SQL processing. This stage involves separating the pieces of a SQL statement into a SQL Tree where each node is a SQL token...



Share this page:
Follow us:
Task Runner