installing a new instance correctly
I’m installing a new oracle instance with Database Configuration Assistant, but I’d like to know if I installed correctly.
My O.S. is windows 2003 server with 1 Gb Ram and Oracle 9.0.1 version.
May be max 15 user connecting simultaneity
I installed Oracle with this parameters:
Tamplate Name= DataWarehouse
Dedicated Server Mode
Shared pool=33554432 bytes
Java pool=33554432 mytes
Max n. of users=20
Percentage of physical memory(511mb) for oracle=70 (my machine has 1gb ram, must I increase this value here or is not important??)
Sort area size=1048576 bytes
In the init.ora SGA_MAX_SIZE=139232672
I CHOOSE TYPICAL INSTALL
How can I know if my database is installed correctly and which parameter I’d change?
does it start?
only you know who much memory you need for each part of the sga because you have properly sized it and you know what your application is going to do?
Also you say at the start 15 Users then say later 20 users
then you say this
Shared pool=183mb, whats it to be?
20mb for pga_aggregate_target seems a little mean as well
Was your Oracle Software Installation Successful ?
Did you create database after software installation ?
Last edited by SANJAY_G; 02-04-2004 at 07:03 AM.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Click Here to Expand Forum to Full Width