Re: SQL Tuning

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 2 May 2016 20:02:32 -0400

On 05/02/2016 11:46 AM, Lothar Flatz wrote:

Hi Jonathan,

what also puzzles me is the CPU time. About the same number of buffer gets, but 10 times more CPU. Can't remember where I have seen that before.
I have. That can happen when the reads are performed using direct reads. The cause for CPU consumption is paging as the PGA expands.

--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2016