Re: internal password & init.ora

From: Nordine Vandezande <nordine.vandezande_at_virgajesse.be>
Date: Tue, 18 Aug 1998 12:38:00 +0200
Message-ID: <35D95988.EFAC0016@virgajesse.be>

Violin wrote:

> Hello,
> I have 2 questions,maybe someone can help me again!
> My database in Oracle7.3 on NT4.0(workgroup database!),
>
> Q2.How to expand SGA?
>
> How to change the db_block_size to 4096??
>

You can only set the block_size by database-creation, after that you cannot change this value.

> Then I try to expand db_block_buffers = 12800 (db_block_size=2048)
> startup nomount -> ORA-02941:error allocating SGA memory.
> How to measure the right value when it exceeds LARGE value?
>

Do you have enough memory? I know that on a unix-box there is a parameter 'shmmax' (shared memory) which has to be set. I've no experience with WinNT.

> Please give me some tips,Thank you so much!!
> Please Cc to : violin.hsiao_at_mail.pouchen.com.tw :)

Nordine Received on Tue Aug 18 1998 - 05:38:00 CDT