Parameter Files Oracle must read either an initialization parameter file or a server parameter file(SPFILE) to start an instance. These files contain list of initialization parameters and a value for each parameter. Server Parameter Files Initialization Parameter Files In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in the [...]
Archive for the ‘Initialization parameters’ Category
20 Aug
Recommended init parameters for Websphere Portal
Recommended init parameters for IBM Websphere Portal wspprd.__db_cache_size=587202560 wspprd.__java_pool_size=16777216 wspprd.__large_pool_size=16777216 wspprd.__shared_pool_size=939524096 wspprd.__streams_pool_size=33554432 *.compatible=’10.2.0.3.0′ *.db_block_size=8192 *.db_cache_size=524288000 *.db_domain=” *.db_file_multiblock_read_count=16 *.db_files=1024 *.db_recovery_file_dest=’/wspprd/oracle/product/10.2.0/flash_recovery_area’ *.db_recovery_file_dest_size=2147483648 *.job_queue_processes=10 *.open_cursors=1600 *.pga_aggregate_target=314572800 *.pre_page_sga=TRUE *.processes=600 *.sessions=665 *.sga_max_size=1610612736 *.sga_target=1610612736 *.shared_pool_size=536870912 *.db_writer_processes=20 *.sort_area_size=65536 *.cursor_space_for_time=TRUE *.session_cached_cursors=500 *.log_checkpoints_to_alert=TRUE *.log_checkpoint_interval=0 *.log_checkpoint_timeout=0 *.fast_start_mttr_target=3600 *.log_buffer=419430400 Related articles by Zemanta Creating Oracle Database for Websphere Portal (mohibalvi.wordpress.com)
14 Apr
OPEN CURSORS
Open cursors take up space in the shared pool, in the library cache. OPEN_CURSORS sets the maximum number of cursors each session can have open, per session. For example, if OPEN_CURSORS is set to 1000, then each session can have up to 1000 cursors open at one time. Monitoring open cursors v$open_cursor shows cached cursors, [...]
2 Apr
CONTROL FILE
The control file is a small binary file necessary for the database to start and operatesuccessfully. Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is in a valid state to use. A control file is updated continuously by [...]
28 Feb
PGA
Program Global Area (PGA) The Program Global Area or Process Global Area (PGA) is a memory region that contains data and control information for a single server process or a single background process. The PGA is allocated when a process is created and deallocated when the process is terminated. The total PGA memory allocated by [...]
