Updating init ora


of BFiles (LOB) each session can open SESSIONS = int Max no.of user and system sessions SGA_MAX_SIZE =int bytes Initial SGA size = int bytes Target size of SGA SHADOW_CORE_DUMP = Include SGA in core file SHARED_MEMORY_ADDRESS = int SGA starting address (platform specific) SHARED_POOL_RESERVED_SIZE = int bytes Reserved area of shared pool SHARED_POOL_SIZE = int Size of shared pool SHARED_SERVERS = int Number of shared servers to start up (MTS) SHARED_SERVER_SESSIONS = int Max number of shared server sessions = server_clause utl_smtp server and port configuration parameter SORT_AREA_RETAINED_SIZE =int bytes [DEFERRED] UGA Memory to retain (Shared Server) SORT_AREA_SIZE = int bytes [DEFERRED] In-memory sort work area (Shared Server) SORT_MULTIBLOCK_READ_COUNT Obsolete in 9i SPFILE =spfile_name Parameter file =category Qualifier for applying hintsets SQL_VERSION =version Sql language version, for compatibility STANDBY_ARCHIVE_DEST = 'filespec' Standby database archivelog destination STANDBY_FILE_MANAGEMENT = Automate file mmanagement on standby DB STAR_TRANSFORMATION_ENABLED = STATISTICS_LEVEL = Collect Statistics = int bytes Size of the streams pool TAPE_ASYNCH_IO = Allow I/O requests to tape devices at the same time as CPU processing THREAD =int Redo thread to use (RAC) TIMED_OS_STATISTICS = int Gather OS statistics every x seconds TIMED_STATISTICS = Collect time statistics TIME_ZONE = '[ | -] hh:mm'| LOCAL | DBTIMEZONE | 'time_zone_region' TRACE_ENABLED = Trace execution path (Internal use only-Oracle support services) TRACEFILE_IDENTIFIER = "traceid" Trace file custom identifier = [DEFERRED] TRANSACTIONS = int Max.OPTIMIZER_INDEX_CACHING = int Percent to cache (favour nested loop joins & IN-list) OPTIMIZER_INDEX_COST_ADJ = int Adjust the cost of index vs FTS =path TRACE definition files: ORACLE_HOME/otrace/admin/fdf/ OS_AUTHENT_PREFIX = prefix Prefix for auto-logon accounts [string] OS_ROLES = Retrieve roles from the operating system PARALLEL_ADAPTIVE_MULTI_USER = Tune degree of parallelism PARALLEL_AUTOMATIC_TUNING = Automatic tuning PARALLEL_EXECUTION_MESSAGE_SIZE = int bytes Message buffer size PARALLEL_INSTANCE_GROUP = 'group' RAC: Limit instances used PARALLEL_MAX_SERVERS = int PARALLEL_MIN_PERCENT = int Min percent of threads required for parallel query PARALLEL_MIN_SERVERS = int PARALLEL_SERVER = [TRUE | FALSE] Startup in parallel server mode PARALLEL_SERVER_instances = int No.

These parameters, while changeable, should only be modified with the aid of an experienced DBA or Oracle Technical Support (called MOSC).

Initialization parameters for the Oracle Database have traditionally been stored in a text initialization parameter file.

There are a couple prepared statements and results sets open at the same time, but they are all closed eventually so I don't think it is a leak.

= Valid in 9i but dropped (or hidden) in 10g Bold = Static Parameter - change in Pfile/SPfile Normal= Dynamic Parameter - change in Pfile/SPfile/ALTER SYSTEM/SESSION PARAMETER DESCRIPTION ------------------------------ ---------------------------------------- ACTIVE_INSTANCE_COUNT = int Active instances in the cluster AQ_TM_PROCESSES = int Number of AQ Time Managers to start ARCHIVE_LAG_TARGET = int Max no.

For immediate, no matter what you use (spfile or init file ) parameter change takes effect immediately.isinstance_modifiable= true/false –this option is spesicif for RAC which has multiple instances for one database If you want to view value of the parameter briefly you can also use show parameter command which searches the entered string with wildcard on both ends NAME TYPE VALUE ———————————— ———– ——– buffer_pool_keep string buffer_pool_recycle string global_context_pool_size string java_pool_size big integer 0 large_pool_size big integer 0 olap_page_pool_size big integer 0 shared_pool_reserved_size big integer 7759462 shared_pool_size big integer 0 streams_pool_size big integer 0 elements of the command; scope =BOTH/SPFILE/MEMORY indicates the scope of the parameter setting.