Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interpreting some alrt.log output
i believe Variable includes large_pool_size and some others.
On Thu, 15 Apr 2004 19:18:08 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:
>On Thu, 15 Apr 2004 07:38:44 -0500, Ed Stevens <nospam_at_noway.nohow>
>wrote:
>
>>>How big is that SGA, anyways?
>>
>>SQL> select * from v$sga;
>>
>>NAME VALUE
>>-------------------- ----------
>>Fixed Size 730944
>>Variable Size 503316480
>>Database Buffers 335544320
>>Redo Buffers 811008
>>
>>
>>BTW, this db was setup via an app vendor supplied script.
>
>Which you can clearly see by the values listed.
>335M buffer cache, 500M shared pool.
>Yuck!!!
>
>
>--
>Sybrand Bakker, Senior Oracle DBA
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Thu Apr 15 2004 - 14:21:47 CDT