Re: Missing DB time and enq:TM question;

From: Mladen Gogala <>
Date: Tue, 28 Nov 2017 23:00:36 -0500
Message-ID: <>

Statspack is not a precise measure. Statspack takes snapshots in 30 minutes intervals. You should not expect an exact time accounting from statspack. If you want an exact time accounting, you should trace the session. With statspack, you should know this:

But thoughts, the slave of life, and life, time's fool,. And time, that takes survey of all the world, must have a stop.

(Shakespeare, Henry IV)

On 11/28/2017 08:59 PM, Ashish Lunawat wrote:
>  In this statspack report the top 5 event accounts only for about 55%
> of the DB time. Any clue where is the remaining time gone?

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Wed Nov 29 2017 - 05:00:36 CET

Original text of this message