Server Info

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 | 1 |  |  |  |  | number of AQ Time Managers to start
archive_lag_target | 0 |  |  |  |  | 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 | 1 |  |  |  |  | number of instances to use for sizing cluster db SGA structures
cluster_interconnects |  |  |  |  |  | interconnects for RAC use
commit_point_strength | 1 |  |  |  |  | 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 | 7 |  |  |  |  | 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 | 2 |  |  |  |  | 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 | 0 |  |  |  |  | Size of cache for 16K buffers
db_2k_cache_size | 0 |  |  |  |  | Size of cache for 2K buffers
db_32k_cache_size | 0 |  |  |  |  | Size of cache for 32K buffers
db_4k_cache_size | 0 |  |  |  |  | Size of cache for 4K buffers
db_8k_cache_size | 0 |  |  |  |  | Size of cache for 8K buffers
db_block_buffers | 0 |  |  |  |  | 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 | 0 |  |  |  |  | Size of KEEP buffer pool for standard block size buffers
db_name | oracle |  |  |  |  | database name specified in CREATE DATABASE
db_recycle_cache_size | 0 |  |  |  |  | Size of RECYCLE buffer pool for standard block size buffers
db_writer_processes | 1 |  |  |  |  | number of background database writer processes to start
dblink_encrypt_login | FALSE |  |  |  |  | enforce password for distributed login always be encrypted
dbwr_io_slaves | 0 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 0 |  |  |  |  | instance number
java_max_sessionspace_size | 0 |  |  |  |  | max allowed size in bytes of a Java sessionspace
java_pool_size | 33554432 |  |  |  |  | size in bytes of the Java pool
java_soft_sessionspace_limit | 0 |  |  |  |  | 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 | 0 |  |  |  |  | maximum number of non-system user sessions allowed
license_max_users | 0 |  |  |  |  | maximum number of named users that can be created in the databas
license_sessions_warning | 0 |  |  |  |  | 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 | 2 |  |  |  |  | maximum number of active ARCH processes
log_archive_min_succeed_dest | 1 |  |  |  |  | minimum number of archive destinations that must succeed
log_archive_start | FALSE |  |  |  |  | start archival process on SGA initialization
log_archive_trace | 0 |  |  |  |  | Establish archivelog operation tracing level
log_buffer | 524288 |  |  |  |  | redo circular buffer size
log_checkpoint_interval | 0 |  |  |  |  | # 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 | 1 |  |  |  |  | Number of log buffer strands
logmnr_max_persistent_sessions | 1 |  |  |  |  | maximum number of threads to mine
max_commit_propagation_delay | 700 |  |  |  |  | Max age of new snapshot in .01 seconds
max_dispatchers | 5 |  |  |  |  | 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 | 5 |  |  |  |  | max number of dispatchers
mts_max_servers | 20 |  |  |  |  | max number of shared servers
mts_multiple_listeners | FALSE |  |  |  |  | Are multiple listeners enabled?
mts_servers | 1 |  |  |  |  | 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 | 4 |  |  |  |  | max # open links per session
open_links_per_instance | 4 |  |  |  |  | max # open links per instance
optimizer_dynamic_sampling | 1 |  |  |  |  | optimizer dynamic sampling
optimizer_features_enable | 9.2.0 |  |  |  |  | optimizer plan compatibility parameter
optimizer_index_caching | 0 |  |  |  |  | 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 | 5 |  |  |  |  | maximum parallel query servers per instance
parallel_min_percent | 0 |  |  |  |  | minimum percent of threads required for parallel query
parallel_min_servers | 0 |  |  |  |  | minimum parallel query servers per instance
parallel_server | FALSE |  |  |  |  | if TRUE startup in parallel server mode
parallel_server_instances | 1 |  |  |  |  | number of instances to use for sizing OPS SGA structures
parallel_threads_per_cpu | 2 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 0 |  |  |  |  | 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 | 1 |  |  |  |  | number of shared servers to start up
sort_area_retained_size | 0 |  |  |  |  | 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 | 0 |  |  |  |  | Redo thread to mount
timed_os_statistics | 0 |  |  |  |  | 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 | 5 |  |  |  |  | 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)