Oracle Database - V$SQL

> Database > Oracle Database

1 - About

V$SQL 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 v$sqlarea).

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

Statistics displayed in V$SQL 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.

Advertising

3 - Documentation / Reference