| muzu |
Posted: Aug 21, 2007 02:07:53 AM |
Total Post: 37
Joined: Aug, 2007
|
Hi,
Can any one tell me important pre-requisites that should be checked and done before creating the database.
Also how to check and confirm the ram memmory space, before the database creation ? Is it necessary to shut down other instances running in the machine to release the ram memmory space. |
|
|
 Mohammed Taj |
| Posted: Aug 21, 2007 04:51:27 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
give me some details
1. Oracle Version
2. OS
3. Physical RAM
4. Expected DB size
5. OLTP or DSS
No, No need to shutdown all other instances
Which method your using for creation of database
1. Manually 2. DBCA 3. Response file
regards
Taj
|
|
|
|
|
| muzu |
| Posted: Aug 21, 2007 07:20:53 AM | |
|
Total Post: 37
Joined: Aug, 2007
|
Just creating the database manually in 10g version.
If we do not mention the shared_pool,java_pool initialization parameters in the pfile, will the default values for these will be allocated for the shared and java pool by the oracle server.
Also what is the basic difference between the SGA_MAX_SIZE and SGA_TARGET initialization parameters ? Is it always necessary to specify the SGA_TARGET parameter values.
|
|
|
|
|
| Mohammed Taj |
| Posted: Aug 21, 2007 08:12:43 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
SGA_MAX_SIZE is maximum size for sga. you can't over this limit.
SGA_TARGET is current size of sga
NOte: sga_target is equal or less than SGA_MAX_SIZE but it is not Greater than SGA_MAX_SIZE.
If you want to use automatic management of sga then specify SGA_TARGET parameter.
Regards
Taj
|
|
|
|
|
| dipali |
| Posted: Aug 21, 2007 10:42:25 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
SGA_TARGET is new parameter to oracle 10g..
It is not compulsory for you to set that parameter.
But in that case you have to set other memory sizing related parameters like that for shared pool, buffer pool, redo log buffer..
Instade, if you set SGA_TARGET, oracle will automatically size all these buffers for you...
|
|
|
|
|
| dipali |
| Posted: Aug 21, 2007 10:42:59 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
SGA_TARGET is new parameter to oracle 10g..
It is not compulsory for you to set that parameter.
But in that case you have to set other memory sizing related parameters like that for shared pool, buffer pool, redo log buffer..
Instade, if you set SGA_TARGET, oracle will automatically size all these buffers for you...
|
|
|
|
|
| dipali |
| Posted: Aug 21, 2007 10:43:25 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
SGA_TARGET is new parameter to oracle 10g..
It is not compulsory for you to set that parameter.
But in that case you have to set other memory sizing related parameters like that for shared pool, buffer pool, redo log buffer..
Instade, if you set SGA_TARGET, oracle will automatically size all these buffers for you...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
