Another Database

[cravi]

Hi ALL

My oracle734 database (production) is running on NT4.0

I have a database(production) on server1

Now I have to create another database on the same server with different parameters.The old one also should exist.

PARAMETER OLD NEW

db_files 20 45

db_block_buffers 20000 25000

db_block_size 2k 4k

shared_pool_size 120mb 120mb


The RAM on server is :785,824 kb

Is it ok to create another database on the same server with this much of RAM.What other factors i have to consider?Please let me know.

Thanks
Ravi

[m_d_marian]

I think somebody said here that is ok to have a shared_pool_size <20% of the ram, now if you consider the second db, in the seem logic, <10% of server ram must be ok

[cravi]

could you please more explicit about this.Really i didn't get any idea from this.Is it ok to create another database with the RAM on server i specified.

Thanks
ravi

[m_d_marian]

my personal opinion is that 120Mo, for the two servers is the highest you can figure out for each db, so you ok.
You must pay attention to not outrun the real memory of the machine, so to avoid the disk swaping.

Anyways, you can issue:

Select bytes/1024/1024 from v$sgastat where POOL='FREE MEMORY';

If this value is consistently high over time, another area of SGA needs memory, you may want to decrease SHARED_POOL_SIZE.

[Edited by m_d_marian on 03-07-2001 at 12:57 PM]