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.
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
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.
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]
Click Here to Expand Forum to Full Width