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: Interpreting some alrt.log output

Re: Interpreting some alrt.log output

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 15 Apr 2004 19:21:47 GMT
Message-ID: <407ee0a0.2344894991@localhost>


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

Original text of this message

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