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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I could think of eviction from shared pool, like your guess, or the statement running with