HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Oracle AWR shows missing stats for SQL ID as top elapsed statement

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
elapsedtopstatementsqlstatsawrshowsformissingoracle

Problem

Why SQL ID has null number of executions and elapsed time / execution in AWR report. SQL ID is among top elapsed command on AWR but no details stats whoing time / execution. Would it be because shared pool got flushed or what else can cause this?

Solution

I could think of eviction from shared pool, like your guess, or the statement running with statistics_level=basic. The statistics_level can be dynamically set on a per-session basis.


Setting the STATISTICS_LEVEL parameter
to BASIC disables the collection of
many of the important statistics
required by Oracle Database features
and functionality, including:

*

  Automatic Workload Repository (AWR) Snapshots

Code Snippets

*

  Automatic Workload Repository (AWR) Snapshots

Context

StackExchange Database Administrators Q#1951, answer score: 3

Revisions (0)

No revisions yet.