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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 15 Apr 2004 19:18:08 +0200
Message-ID: <ksgt70l7dmb2s629k1vforr7ji9e840r0u@4ax.com>


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
Received on Thu Apr 15 2004 - 12:18:08 CDT

Original text of this message

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