Re: 10g/AIX: Database Buffers problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 08 Jun 2004 22:48:22 +0200
Message-ID: <oe9cc0555pj8tckbs9nfk1p51066hje0o5@4ax.com>

On Tue, 8 Jun 2004 21:32:19 +0100, "Dave" <david.sharples3_at_ntlXworld.com> wrote:

>
>"Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote in message
>news:ca55ob$i14$1_at_ausnews.austin.ibm.com...
>>
>> Fellow Oracle Users:
>>
>>
>> I am running Oracle 10g Server on AIX 5.2
>>
>> When I try to start my instance, it comes with:
>>
>>
>> SQL*Plus: Release 10.1.0.2.0 - Production on Tue Jun 8 14:43:29 2004
>>
>> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>>
>> SQL> Connected to an idle instance.
>> SQL> ORACLE instance started.
>>
>> Total System Global Area 2550136832 bytes
>> Fixed Size 1328064 bytes
>> Variable Size 2523642944 bytes
>> Database Buffers 0 bytes
>> Redo Buffers 25165824 bytes
>> Database mounted.
>> Database opened.
>> SQL> Disconnected from Oracle Database 10g Release 10.1.0.2.0 - 64bit
>> Production
>>
>>
>> What parameter in my pfile should I set to allocate
>> Database_buffers?
>>
>>
>> Thanks in advance,
>>
>> A. Fuentes
>> 512-297-9937
>>
>>
>>
>db_cache_size or db_block_buffers
>

Note that db_block_buffers disables the dynamic SGA feature. You should use db_cache_size!

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jun 08 2004 - 15:48:22 CDT