Table of Contents

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