Hi,
i've a database instance 11.2.0.4.
There are no user activities but EM 12c console show me CKPT that perform about 43% followed my MMON and PMON.
CKPT waits on control file sequential read and control file parallel read.
I've tried to gather sys stats and fixed objects stats but nothing....
These are top waits_
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 38 74.7
control file sequential read 21,762 8 0 16.1
control file parallel write 2,559 2 1 3.7
Looking dictionary stats (perfstat):
dc_histogram_data 30,639 24.3 0 5,686 1,491
dc_histogram_defs 172,090 31.3 0 23,987 3,135
Any Ideas?