On reporting queries, there are too many “enq: KO – fast object checkpoint” wait event.
All reporting queries are doing full table scans concurrently. Oracle uses direct path reads instead of db file scattered reads. And direct path reads require a checkpoint
"_serial_direct_read"=NEVER Parameter Session Value Instance Value -------------------------------------------------- ------------------------------ ------------------------------ _serial_direct_read auto auto