Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which Tuning Method? System/Resource Tuning?

Re: Which Tuning Method? System/Resource Tuning?

From: Leeroy <leigh_at_deakin.edu.au>
Date: 7 Nov 2001 19:02:15 +1000
Message-ID: <01c16762$8a9103e0$48063acb@win95pc>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US