Re: Help on PO7 Performance

Hi Richard,

seems like the SGA on the PO7-computer is way to small

As SYSTEM, do a

select sum(value)/1024/1024 SGA_SIZE_MB from v$SGA

to get the memory which is used.

To increase the SGA, you can read the document

http://www.hoffmann-kiel.de/stdinst.html

Bye
Uli

> For demo purposes we have loaded an Oracle 7.3 Workgroup db into PO7.
>
> When I autotrace the same query across both systems the execution plan is
> exactly the same for both except a huge difference is visible in the
> statistics
>
> PO7
> ------
> 7 recursive calls
> 22792 consistent gets
> 10238 physical reads
>
> Oracle 7.3 (Workgroup)
> ---------------------------------
> 12370 consistent gets
> 0 physical reads
>
> (All other stats are indentical)
>
> Can anyone shed some light on improving this, or is it just a limitation
of
> PO7 ?
>
> Thanks
>
> Richard
>
> PS Pls also respond via email is possible.
>
>
>
Received on Tue Nov 09 1999 - 04:20:29 CST