Properties

Version: 9.2.0.0.0 

Schemas

Schema
  RMAN 
Total: 1 schema(s)

Server Parameters

Name Value ISSYS_M Default SES_M SYS_M Description
O7_DICTIONARY_ACCESSIBILITY  FALSE          Version 7 Dictionary Accessibility Support 
active_instance_count            number of active instances in the cluster database 
aq_tm_processes          number of AQ Time Managers to start 
archive_lag_target          Maximum number of seconds of redos the standby could lose 
audit_sys_operations  FALSE          enable sys auditing 
audit_trail  NONE          enable system auditing 
background_core_dump  partial          Core Size for Background Processes 
background_dump_dest  E:\oracle\admin\oracle\bdump          Detached process dump directory 
backup_tape_io_slaves  FALSE          BACKUP Tape I/O slaves 
bitmap_merge_area_size  1048576          maximum memory allow for BITMAP MERGE 
blank_trimming  FALSE          blank trimming semantics parameter 
buffer_pool_keep            Number of database blocks/latches in keep buffer pool 
buffer_pool_recycle            Number of database blocks/latches in recycle buffer pool 
circuits  170          max number of circuits 
cluster_database  FALSE          if TRUE startup in cluster database mode 
cluster_database_instances          number of instances to use for sizing cluster db SGA structures 
cluster_interconnects            interconnects for RAC use 
commit_point_strength          Bias this node has toward not preparing in a two-phase commit 
compatible  9.2.0.0.0          Database will be completely compatible with this software versio 
control_file_record_keep_time          control file record keep time in days 
control_files  E:\oracle\oradata\oracle\CONTROL01.CTL, E:\oracle\oradata\oracle\CONTROL02.CTL, E:\oracle\oradata\oracle\CONTROL03.CTL          control file names list 
core_dump_dest  E:\oracle\admin\oracle\cdump          Core dump directory 
cpu_count          initial number of cpu's for this instance 
create_bitmap_area_size  8388608          size of create bitmap buffer for bitmap index 
cursor_sharing  EXACT          cursor sharing mode 
cursor_space_for_time  FALSE          use more memory in order to get faster execution 
db_16k_cache_size          Size of cache for 16K buffers 
db_2k_cache_size          Size of cache for 2K buffers 
db_32k_cache_size          Size of cache for 32K buffers 
db_4k_cache_size          Size of cache for 4K buffers 
db_8k_cache_size          Size of cache for 8K buffers 
db_block_buffers          Number of database blocks cached in memory 
db_block_checking  FALSE          data and index block checking 
db_block_checksum  TRUE          store checksum in db blocks and check during reads 
db_block_size  8192          Size of database block in bytes 
db_cache_advice  ON          Buffer cache sizing advisory 
db_cache_size  25165824          Size of DEFAULT buffer pool for standard block size buffers 
db_create_file_dest            default database location 
db_create_online_log_dest_1            online log/controlfile destination #1 
db_create_online_log_dest_2            online log/controlfile destination #2 
db_create_online_log_dest_3            online log/controlfile destination #3 
db_create_online_log_dest_4            online log/controlfile destination #4 
db_create_online_log_dest_5            online log/controlfile destination #5 
db_domain  apconsulting.zp.ua          directory part of global database name stored with CREATE DATABA 
db_file_multiblock_read_count  16          db block to be read each IO 
db_file_name_convert            datafile name convert patterns and strings for standby/clone db 
db_files  200          max allowable # db files 
db_keep_cache_size          Size of KEEP buffer pool for standard block size buffers 
db_name  oracle          database name specified in CREATE DATABASE 
db_recycle_cache_size          Size of RECYCLE buffer pool for standard block size buffers 
db_writer_processes          number of background database writer processes to start 
dblink_encrypt_login  FALSE          enforce password for distributed login always be encrypted 
dbwr_io_slaves          DBWR I/O slaves 
dg_broker_config_file1  %ORACLE_HOME%\DATABASE\DR1%ORACLE_SID%.DAT          data guard broker configuration file #1 
dg_broker_config_file2  %ORACLE_HOME%\DATABASE\DR2%ORACLE_SID%.DAT          data guard broker configuration file #2 
dg_broker_start  FALSE          start Data Guard broker framework (DMON process) 
disk_asynch_io  TRUE          Use asynch I/O for random access devices 
dispatchers  (PROTOCOL=TCP) (SERVICE=oracleXDB)          specifications of dispatchers 
distributed_lock_timeout  60          number of seconds a distributed transaction waits for a lock 
dml_locks  748          dml locks - one for each table modified in a transaction 
drs_start  FALSE          start DG Broker monitor (DMON process) 
enqueue_resources  968          resources for enqueues 
event            debug event control - default null string 
fal_client            FAL client 
fal_server            FAL server list 
fast_start_io_target          Upper bound on recovery reads 
fast_start_mttr_target  300          MTTR target of forward crash recovery in seconds 
fast_start_parallel_rollback  LOW          max number of parallel recovery slaves that may be used 
file_mapping  FALSE          enable file mapping 
filesystemio_options            IO operations on filesystem files 
fixed_date            fixed SYSDATE value 
gc_files_to_locks            mapping between file numbers and global cache locks (DFS) 
global_context_pool_size            Global Application Context Pool Size in Bytes 
global_names  FALSE          enforce that database links have same name as remote database 
hash_area_size  1048576          size of in-memory hash work area 
hash_join_enabled  TRUE          enable/disable hash join 
hi_shared_memory_address          SGA starting address (high order 32-bits on 64-bit platforms) 
hs_autoregister  TRUE          enable automatic server DD updates in HS agent self-registration 
ifile            include file in init.ora 
instance_groups            list of instance group names 
instance_name  oracle          instance name supported by the instance 
instance_number          instance number 
java_max_sessionspace_size          max allowed size in bytes of a Java sessionspace 
java_pool_size  33554432          size in bytes of the Java pool 
java_soft_sessionspace_limit          warning limit on size in bytes of a Java sessionspace 
job_queue_processes  10          number of job queue slave processes 
large_pool_size  8388608          size in bytes of the large allocation pool 
license_max_sessions          maximum number of non-system user sessions allowed 
license_max_users          maximum number of named users that can be created in the databas 
license_sessions_warning          warning level for number of non-system user sessions 
local_listener            local listener 
lock_name_space            lock name space used for generating lock names for standby/clone 
lock_sga  FALSE          Lock entire SGA in physical memory 
log_archive_dest            archival destination text string 
log_archive_dest_1            archival destination #1 text string 
log_archive_dest_10            archival destination #10 text string 
log_archive_dest_2            archival destination #2 text string 
log_archive_dest_3            archival destination #3 text string 
log_archive_dest_4            archival destination #4 text string 
log_archive_dest_5            archival destination #5 text string 
log_archive_dest_6            archival destination #6 text string 
log_archive_dest_7            archival destination #7 text string 
log_archive_dest_8            archival destination #8 text string 
log_archive_dest_9            archival destination #9 text string 
log_archive_dest_state_1  enable          archival destination #1 state text string 
log_archive_dest_state_10  enable          archival destination #10 state text string 
log_archive_dest_state_2  enable          archival destination #2 state text string 
log_archive_dest_state_3  enable          archival destination #3 state text string 
log_archive_dest_state_4  enable          archival destination #4 state text string 
log_archive_dest_state_5  enable          archival destination #5 state text string 
log_archive_dest_state_6  enable          archival destination #6 state text string 
log_archive_dest_state_7  enable          archival destination #7 state text string 
log_archive_dest_state_8  enable          archival destination #8 state text string 
log_archive_dest_state_9  enable          archival destination #9 state text string 
log_archive_duplex_dest            duplex archival destination text string 
log_archive_format  ARC%S.%T          archival destination format 
log_archive_max_processes          maximum number of active ARCH processes 
log_archive_min_succeed_dest          minimum number of archive destinations that must succeed 
log_archive_start  FALSE          start archival process on SGA initialization 
log_archive_trace          Establish archivelog operation tracing level 
log_buffer  524288          redo circular buffer size 
log_checkpoint_interval          # redo blocks checkpoint threshold 
log_checkpoint_timeout  1800          Maximum time interval between checkpoints in seconds 
log_checkpoints_to_alert  FALSE          log checkpoint begin/end to alert file 
log_file_name_convert            logfile name convert patterns and strings for standby/clone db 
log_parallelism          Number of log buffer strands 
logmnr_max_persistent_sessions          maximum number of threads to mine 
max_commit_propagation_delay  700          Max age of new snapshot in .01 seconds 
max_dispatchers          max number of dispatchers 
max_dump_file_size  UNLIMITED          Maximum size (blocks) of dump file 
max_enabled_roles  30          max number of roles a user can have enabled 
max_rollback_segments  37          max. number of rollback segments in SGA cache 
max_shared_servers  20          max number of shared servers 
mts_circuits  170          max number of circuits 
mts_dispatchers  (PROTOCOL=TCP) (SERVICE=oracleXDB)          specifications of dispatchers 
mts_listener_address            address(es) of network listener 
mts_max_dispatchers          max number of dispatchers 
mts_max_servers  20          max number of shared servers 
mts_multiple_listeners  FALSE          Are multiple listeners enabled? 
mts_servers          number of shared servers to start up 
mts_service  oracle          service supported by dispatchers 
mts_sessions  165          max number of shared server sessions 
object_cache_max_size_percent  10          percentage of maximum size over optimal of the user session's ob 
object_cache_optimal_size  102400          optimal size of the user session's object cache in bytes 
olap_page_pool_size  33554432          size of the olap page pool in bytes 
open_cursors  300          max # cursors per session 
open_links          max # open links per session 
open_links_per_instance          max # open links per instance 
optimizer_dynamic_sampling          optimizer dynamic sampling 
optimizer_features_enable  9.2.0          optimizer plan compatibility parameter 
optimizer_index_caching          optimizer percent index caching 
optimizer_index_cost_adj  100          optimizer index cost adjustment 
optimizer_max_permutations  2000          optimizer maximum join permutations per query block 
optimizer_mode  CHOOSE          optimizer mode 
oracle_trace_collection_name            Oracle TRACE default collection name 
oracle_trace_collection_path  %ORACLE_HOME%\OTRACE\ADMIN\CDF\          Oracle TRACE collection path 
oracle_trace_collection_size  5242880          Oracle TRACE collection file max. size 
oracle_trace_enable  FALSE          Oracle Trace enabled/disabled 
oracle_trace_facility_name  oracled          Oracle TRACE default facility name 
oracle_trace_facility_path  %ORACLE_HOME%\OTRACE\ADMIN\FDF\          Oracle TRACE facility path 
os_authent_prefix  OPS$          prefix for auto-logon accounts 
os_roles  FALSE          retrieve roles from the operating system 
parallel_adaptive_multi_user  FALSE          enable adaptive setting of degree for multiple user streams 
parallel_automatic_tuning  FALSE          enable intelligent defaults for parallel execution parameters 
parallel_execution_message_size  2148          message buffer size for parallel execution 
parallel_instance_group            instance group to use for all parallel operations 
parallel_max_servers          maximum parallel query servers per instance 
parallel_min_percent          minimum percent of threads required for parallel query 
parallel_min_servers          minimum parallel query servers per instance 
parallel_server  FALSE          if TRUE startup in parallel server mode 
parallel_server_instances          number of instances to use for sizing OPS SGA structures 
parallel_threads_per_cpu          number of parallel execution threads per CPU 
partition_view_enabled  FALSE          enable/disable partitioned views 
pga_aggregate_target  25165824          Target size for the aggregate PGA memory consumed by the instanc 
plsql_compiler_flags  INTERPRETED          PL/SQL compiler flags 
plsql_native_c_compiler            plsql native C compiler 
plsql_native_library_dir            plsql native library dir 
plsql_native_library_subdir_count          plsql native library number of subdirectories 
plsql_native_linker            plsql native linker 
plsql_native_make_file_name            plsql native compilation make file 
plsql_native_make_utility            plsql native compilation make utility 
plsql_v2_compatibility  FALSE          PL/SQL version 2.x compatibility flag 
pre_page_sga  FALSE          pre-page sga for process 
processes  150          user processes 
query_rewrite_enabled  FALSE          allow rewrite of queries using materialized views if enabled 
query_rewrite_integrity  enforced          perform rewrite using materialized views with desired integrity 
rdbms_server_dn            RDBMS's Distinguished Name 
read_only_open_delayed  FALSE          if TRUE delay opening of read only files until first access 
recovery_parallelism          number of server processes to use for parallel recovery 
remote_archive_enable  true          remote archival enable setting 
remote_dependencies_mode  TIMESTAMP          remote-procedure-call dependencies mode parameter 
remote_listener            remote listener 
remote_login_passwordfile  EXCLUSIVE          password file usage parameter 
remote_os_authent  FALSE          allow non-secure remote clients to use auto-logon accounts 
remote_os_roles  FALSE          allow non-secure remote clients to use os roles 
replication_dependency_tracking  TRUE          tracking dependency for Replication parallel propagation 
resource_limit  FALSE          master switch for resource limit 
resource_manager_plan            resource mgr top plan 
rollback_segments            undo segment list 
row_locking  always          row-locking 
serial_reuse  DISABLE          reuse the frame segments 
serializable  FALSE          serializable 
service_names  oracle.apconsulting.zp.ua          service names supported by the instance 
session_cached_cursors          number of cursors to save in the session cursor cache 
session_max_open_files  10          maximum number of open files allowed per session 
sessions  170          user and system sessions 
sga_max_size  135338868          max total SGA size 
shadow_core_dump  partial          Core Size for Shadow Processes 
shared_memory_address          SGA starting address (low order 32-bits on 64-bit platforms) 
shared_pool_reserved_size  2516582          size in bytes of reserved area of shared pool 
shared_pool_size  50331648          size in bytes of shared pool 
shared_server_sessions  165          max number of shared server sessions 
shared_servers          number of shared servers to start up 
sort_area_retained_size          size of in-memory sort work area retained between fetch calls 
sort_area_size  524288          size of in-memory sort work area 
spfile  %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA          server parameter file 
sql92_security  FALSE          require select privilege for searched update/delete 
sql_trace  FALSE          enable SQL trace 
sql_version  NATIVE          sql language version parameter for compatibility issues 
standby_archive_dest  %ORACLE_HOME%\RDBMS          standby database archivelog destination text string 
standby_file_management  MANUAL          if auto then files are created/dropped automatically on standby 
star_transformation_enabled  FALSE          enable the use of star transformation 
statistics_level  TYPICAL          statistics level 
tape_asynch_io  TRUE          Use asynch I/O requests for tape devices 
thread          Redo thread to mount 
timed_os_statistics          internal os statistic gathering interval in seconds 
timed_statistics  TRUE          maintain internal timing statistics 
trace_enabled  TRUE          enable KST tracing 
tracefile_identifier            trace file custom identifier 
transaction_auditing  TRUE          transaction auditing records generated in the redo log 
transactions  187          max. number of concurrent active transactions 
transactions_per_rollback_segment          number of active transactions per rollback segment 
undo_management  AUTO          instance runs in SMU mode if TRUE, else in RBU mode 
undo_retention  10800          undo retention in seconds 
undo_suppress_errors  FALSE          Suppress RBU errors in SMU mode 
undo_tablespace  UNDOTBS1          use/switch undo tablespace 
use_indirect_data_buffers  FALSE          Enable indirect data buffers (very large SGA on 32-bit platforms 
user_dump_dest  E:\oracle\admin\oracle\udump          User process dump directory 
utl_file_dir            utl_file accessible directories list 
workarea_size_policy  AUTO          policy used to size SQL working areas (MANUAL/AUTO)