Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which Tuning Method? System/Resource Tuning?
Looks a bit sus to me Vance. You've got zero physical reads for Machine B.
How can this be so if it has not already been run?
> > > >
> > > > NAME Machine A Machine B
> > > > ----------------------------------- --------- ---------
> > > > recursive cpu usage 1160 4
> > > > session logical reads 52592 306
> > > > CPU used when call started 1163 10
> > > > CPU used by this session 1163 10
> > > > session uga memory 212764 203800
> > > > session uga memory max 221036 212072
> > > > messages sent 2 1
> > > > session pga memory 577636 389408
> > > > session pga memory max 577636 389408
> > > > total file opens 2 0
> > > > db block gets 213 215
> > > > consistent gets 52379 91
> > > > physical reads 47939 0
> > > > change write time 0 1
> > > > redo synch time 6 2
> > > > free buffer requested 47941 1
> > > > dirty buffers inspected 1 0
> > > > free buffer inspected 1 0
> > > > prefetched blocks 22 0
> > > > redo entries 5 6
> > > > redo size 1568 1572
> > > > no work - consistent read gets 52346 58
> > > > table scan blocks gotten 123 51
> > > > table fetch by rowid 1120840 12
> > > > bytes sent via SQL*Net to client 2898 3600
> > > > bytes received via SQL*Net from client 11403 12506
> > > > cursor authentications 0 1
> > > > buffer is pinned count 2192418 2
> > > > buffer is not pinned count 49388 76
> > > >
Received on Wed Nov 07 2001 - 03:02:15 CST