Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!newshosting.com!nx02.iad01.newshosting.com!post01.iad01.newshosting.com!not-for-mail
From: andreyNSPAM@bookexchange.net (NetComrade)
Newsgroups: comp.databases.oracle.server
Subject: Re: Interpreting some alrt.log output
Date: Thu, 15 Apr 2004 19:21:47 GMT
Message-ID: <407ee0a0.2344894991@localhost>
References: <f40r70582idcsc88bl6p61ngfa34d70so8@4ax.com> <91884734.0404141514.3e7d10e9@posting.google.com> <uuvs709dpge6ubo60isaottkqs8fbjm8s3@4ax.com> <ksgt70l7dmb2s629k1vforr7ji9e840r0u@4ax.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Organization: Acecape, Inc.
Cache-Post-Path: nntp.acecape.com!unknown@p78-65.acedsl.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 34
X-Complaints-To: abuse@newshosting.com
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:259616

i believe Variable includes large_pool_size and some others.


On Thu, 15 Apr 2004 19:18:08 +0200, Sybrand Bakker
<gooiditweg@sybrandb.verwijderdit.demon.nl> wrote:

>On Thu, 15 Apr 2004 07:38:44 -0500, Ed Stevens <nospam@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