Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interpreting some alrt.log output
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 DBAReceived on Thu Apr 15 2004 - 12:18:08 CDT