Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.