Re: small db initialisation parameters on Oracle10 R2

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 6 Mar 2006 14:02:53 -0400
Message-ID: <cd4305c10603061002v58c5d962w3d21aef2a18e5792@mail.gmail.com>

Hi Jhon, I copied it from my test database, hope be useful.

processes                                                             
         	100
timed_statistics                                                      
         	TRUE
shared_pool_size                                                      
         	0
large_pool_size                                                       
         	0
java_pool_size                                                        
         	0
spfile                                                                
         	E:\ORASERPG\INIT\SPINITSERPG.ORA
sga_target                                                            
         	402653184
control_files                                                         
         	E:\ORASERPG\CONTROLFILES\CTL_SERPG01.CTL,
E:\ORASERPG\CONTROLFILES\CTL_SERPG02.CTL,

D:\ORASERPG\CONTROLFILES\CTL_SERPG01.CTL, D:\ORASERPG\CONTROLFILES\CTL_SERPG02.CTL

db_block_size                                                         
         	8192
db_cache_size                                                         
         	0
db_keep_cache_size                                                    
         	83886080
db_recycle_cache_size                                                 
         	54525952
compatible                                                            
         	10.2.0.1.0
log_archive_format                                                    
         	ARC%S_%R.%T
log_buffer                                                            
         	7029248
log_checkpoint_interval                                               
         	0
log_checkpoint_timeout                                                
         	0
db_files                                                              
         	15
db_file_multiblock_read_count                                         
         	16
read_only_open_delayed                                                
         	FALSE
db_recovery_file_dest                                                 
         	D:\ORASERPGflash_recovery_area
db_recovery_file_dest_size                                            
         	94371840000
fast_start_mttr_target                                                
         	0
undo_management                                                       
         	AUTO
undo_tablespace                                                       
         	TBL_UNDO
undo_retention                                                        
         	56000
remote_login_passwordfile                                             
         	EXCLUSIVE
license_max_users                                                     
         	800
db_domain
instance_name                                                         
         	SERPG
dispatchers                                                           
         	(PROTOCOL=TCP) (SERVICE=SERPGXDB)
cursor_space_for_time                                                 
         	FALSE
session_cached_cursors                                                
         	1000
remote_dependencies_mode                                              
         	SIGNATURE
utl_file_dir                                                          
         	*
job_queue_processes                                                   
         	10
cursor_sharing                                                        
         	EXACT
audit_file_dest                                                       
         	E:\ORASERPG\AUDIT
background_dump_dest                                                  
         	E:\ORASERPG\TRACE\BACKGROUND
user_dump_dest                                                        
         	E:\ORASERPG\TRACE\USER
core_dump_dest                                                        
         	E:\ORASERPG\TRACE\CDUMP
session_max_open_files                                                
         	100
open_links                                                            
         	20
open_links_per_instance                                               
         	20
db_name                                                               
         	SERPG
open_cursors                                                          
         	800
optimizer_index_cost_adj                                              
         	10
optimizer_index_caching                                               
         	90
query_rewrite_enabled                                                 
         	TRUE
query_rewrite_integrity                                               
         	TRUSTED
pga_aggregate_target                                                  
         	157286400
workarea_size_policy                                                  
         	AUTO

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 06 2006 - 12:02:53 CST