Oracle: Verificando os parametros do Banco: Difference between revisions
(New page: Para verificar os parâmetros faça o seguinte (no SQL Plus ou Comandos SQL do APEX) SELECT name,value FROM v$parameter order by name; A listagem com os parâmetros é mostrada, exempl...) |
mNo edit summary |
||
Line 1: | Line 1: | ||
== == | |||
Para verificar os parâmetros faça o seguinte (no Oracle XE) | |||
1) Clique em '''Início > Administração > Sobre o BD ''' | |||
2) Selecione apenas '''Parâmetros''' e clique no botão '''Ir''' | |||
== Através de SQL== | |||
Para verificar os parâmetros faça o seguinte (no SQL Plus ou Comandos SQL do APEX) | Para verificar os parâmetros faça o seguinte (no SQL Plus ou Comandos SQL do APEX) | ||
SELECT name,value FROM v$parameter | SELECT name,value,isdefault,description FROM v$parameter | ||
order by name; | order by name; | ||
A listagem com os parâmetros é mostrada, exemplo: | A listagem com os parâmetros é mostrada, exemplo: | ||
'''NAME''' '''VALUE''' | '''NAME''' '''VALUE''' '''ISDEFAULT''' '''DESCRIPTION''' | ||
active_instance_count - | active_instance_count - TRUE number of active instances in the cluster database | ||
aq_tm_processes 0 | aq_tm_processes 0 TRUE number of AQ Time Managers to start | ||
archive_lag_target 0 | archive_lag_target 0 TRUE Maximum number of seconds of redos the standby could lose | ||
asm_diskgroups - | asm_diskgroups - TRUE disk groups to mount automatically | ||
asm_diskstring - | asm_diskstring - TRUE disk set locations for discovery | ||
asm_power_limit 1 | asm_power_limit 1 TRUE number of processes for disk rebalancing | ||
audit_file_dest /usr/lib/oracle/xe/app/oracle/admin/XE/adump | audit_file_dest /usr/lib/oracle/xe/app/oracle/admin/XE/adump FALSE Directory in which auditing files are to reside | ||
audit_syslog_level - | audit_syslog_level - TRUE Syslog facility and level | ||
audit_sys_operations FALSE | audit_sys_operations FALSE TRUE enable sys auditing | ||
audit_trail NONE | audit_trail NONE TRUE enable system auditing | ||
background_core_dump partial | background_core_dump partial TRUE Core Size for Background Processes | ||
background_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/bdump | background_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/bdump FALSE Detached process dump directory | ||
backup_tape_io_slaves FALSE | backup_tape_io_slaves FALSE TRUE BACKUP Tape I/O slaves | ||
bitmap_merge_area_size 1048576 | bitmap_merge_area_size 1048576 TRUE maximum memory allow for BITMAP MERGE | ||
blank_trimming FALSE | blank_trimming FALSE TRUE blank trimming semantics parameter | ||
buffer_pool_keep - | buffer_pool_keep - TRUE Number of database blocks/latches in keep buffer pool | ||
buffer_pool_recycle - | buffer_pool_recycle - TRUE Number of database blocks/latches in recycle buffer pool | ||
circuits - | circuits - TRUE max number of circuits | ||
cluster_database FALSE | cluster_database FALSE TRUE if TRUE startup in cluster database mode | ||
cluster_database_instances 1 | cluster_database_instances 1 TRUE number of instances to use for sizing cluster db SGA structures | ||
cluster_interconnects - | cluster_interconnects - TRUE interconnects for RAC use | ||
commit_point_strength 1 | commit_point_strength 1 TRUE Bias this node has toward not preparing in a two-phase commit | ||
commit_write - | commit_write - TRUE transaction commit log write behaviour | ||
compatible 10.2.0.1.0 | compatible 10.2.0.1.0 FALSE Database will be completely compatible with this software version | ||
control_file_record_keep_time 7 | control_file_record_keep_time 7 TRUE control file record keep time in days | ||
control_files /usr/lib/oracle/xe/oradata/XE/control.dbf | control_files /usr/lib/oracle/xe/oradata/XE/control.dbf FALSE control file names list | ||
core_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/cdump | core_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/cdump FALSE Core dump directory | ||
cpu_count 1 | cpu_count 1 TRUE number of CPUs for this instance | ||
create_bitmap_area_size 8388608 | create_bitmap_area_size 8388608 TRUE size of create bitmap buffer for bitmap index | ||
create_stored_outlines - | create_stored_outlines - TRUE create stored outlines for DML statements | ||
cursor_sharing EXACT | cursor_sharing EXACT TRUE cursor sharing mode | ||
cursor_space_for_time FALSE | cursor_space_for_time FALSE TRUE use more memory in order to get faster execution | ||
db_block_buffers 0 | db_block_buffers 0 TRUE Number of database blocks cached in memory | ||
db_block_checking FALSE | db_block_checking FALSE TRUE header checking and data and index block checking | ||
db_block_checksum TRUE | db_block_checksum TRUE TRUE store checksum in db blocks and check during reads | ||
'''db_block_size''' | '''db_block_size 8192 TRUE Size of database block in bytes''' | ||
db_cache_advice ON | db_cache_advice ON TRUE Buffer cache sizing advisory | ||
'''db_cache_size''' | '''db_cache_size 0 TRUE Size of DEFAULT buffer pool for standard block size buffers''' | ||
db_create_file_dest - | db_create_file_dest - TRUE default database location | ||
db_create_online_log_dest_1 - | db_create_online_log_dest_1 - TRUE online log/controlfile destination #1 | ||
db_create_online_log_dest_2 - | db_create_online_log_dest_2 - TRUE online log/controlfile destination #2 | ||
db_create_online_log_dest_3 - | db_create_online_log_dest_3 - TRUE online log/controlfile destination #3 | ||
db_create_online_log_dest_4 - | db_create_online_log_dest_4 - TRUE online log/controlfile destination #4 | ||
db_create_online_log_dest_5 - | db_create_online_log_dest_5 - TRUE online log/controlfile destination #5 | ||
db_domain - | db_domain - TRUE directory part of global database name stored with CREATE DATABASE | ||
db_file_multiblock_read_count 128 | db_file_multiblock_read_count 128 TRUE db block to be read each IO | ||
db_file_name_convert - | db_file_name_convert - TRUE datafile name convert patterns and strings for standby/clone db | ||
db_files 200 | db_files 200 TRUE max allowable # db files | ||
db_flashback_retention_target 1440 | db_flashback_retention_target 1440 TRUE Maximum Flashback Database log retention time in minutes. | ||
db_keep_cache_size 0 | db_keep_cache_size 0 TRUE Size of KEEP buffer pool for standard block size buffers | ||
db_name XE | db_name XE FALSE database name specified in CREATE DATABASE | ||
db_recovery_file_dest /usr/lib/oracle/xe/app/oracle/flash_recovery_area | db_recovery_file_dest /usr/lib/oracle/xe/app/oracle/flash_recovery_area FALSE default database recovery file location | ||
db_recovery_file_dest_size 10737418240 | db_recovery_file_dest_size 10737418240 FALSE database recovery files size limit | ||
db_recycle_cache_size 0 | db_recycle_cache_size 0 TRUE Size of RECYCLE buffer pool for standard block size buffers | ||
db_unique_name XE | db_unique_name XE TRUE Database Unique Name | ||
dbwr_io_slaves 0 | dbwr_io_slaves 0 TRUE DBWR I/O slaves | ||
db_writer_processes 1 | db_writer_processes 1 TRUE number of background database writer processes to start | ||
db_16k_cache_size 0 | db_16k_cache_size 0 TRUE Size of cache for 16K buffers | ||
db_2k_cache_size 0 | db_2k_cache_size 0 TRUE Size of cache for 2K buffers | ||
db_32k_cache_size 0 | db_32k_cache_size 0 TRUE Size of cache for 32K buffers | ||
db_4k_cache_size 0 | db_4k_cache_size 0 TRUE Size of cache for 4K buffers | ||
db_8k_cache_size 0 | db_8k_cache_size 0 TRUE Size of cache for 8K buffers | ||
ddl_wait_for_locks FALSE | ddl_wait_for_locks FALSE TRUE Disable NOWAIT DML lock acquisitions | ||
dg_broker_config_file1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr1XE.dat | dg_broker_config_file1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr1XE.dat TRUE data guard broker configuration file #1 | ||
dg_broker_config_file2 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr2XE.dat | dg_broker_config_file2 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr2XE.dat TRUE data guard broker configuration file #2 | ||
dg_broker_start FALSE | dg_broker_start FALSE TRUE start Data Guard broker framework (DMON process) | ||
disk_asynch_io TRUE | disk_asynch_io TRUE TRUE Use asynch I/O for random access devices | ||
dispatchers (PROTOCOL=TCP) (SERVICE=XEXDB) | dispatchers (PROTOCOL=TCP) (SERVICE=XEXDB) FALSE specifications of dispatchers | ||
distributed_lock_timeout 60 | distributed_lock_timeout 60 TRUE number of seconds a distributed transaction waits for a lock | ||
dml_locks 212 | dml_locks 212 TRUE dml locks - one for each table modified in a transaction | ||
drs_start FALSE | drs_start FALSE TRUE start DG Broker monitor (DMON process) | ||
event - | event - TRUE debug event control - default null string | ||
fal_client - | fal_client - TRUE FAL client | ||
fal_server - | fal_server - TRUE FAL server list | ||
fast_start_io_target 0 | fast_start_io_target 0 TRUE Upper bound on recovery reads | ||
fast_start_mttr_target 0 | fast_start_mttr_target 0 TRUE MTTR target of forward crash recovery in seconds | ||
fast_start_parallel_rollback LOW | fast_start_parallel_rollback LOW TRUE max number of parallel recovery slaves that may be used | ||
fileio_network_adapters - | fileio_network_adapters - TRUE Network Adapters for File I/O | ||
file_mapping FALSE | file_mapping FALSE TRUE enable file mapping | ||
filesystemio_options none | filesystemio_options none TRUE IO operations on filesystem files | ||
fixed_date - | fixed_date - TRUE fixed SYSDATE value | ||
gc_files_to_locks - | gc_files_to_locks - TRUE mapping between file numbers and global cache locks | ||
gcs_server_processes 0 | gcs_server_processes 0 TRUE number of background gcs server processes to start | ||
global_context_pool_size - | global_context_pool_size - TRUE Global Application Context Pool Size in Bytes | ||
global_names FALSE | global_names FALSE TRUE enforce that database links have same name as remote database | ||
hash_area_size 131072 | hash_area_size 131072 TRUE size of in-memory hash work area | ||
hi_shared_memory_address 0 | hi_shared_memory_address 0 TRUE SGA starting address (high order 32-bits on 64-bit platforms) | ||
hs_autoregister TRUE | hs_autoregister TRUE TRUE enable automatic server DD updates in HS agent self-registration | ||
ifile - | ifile - TRUE include file in init.ora | ||
instance_groups - | instance_groups - TRUE list of instance group names | ||
instance_name XE | instance_name XE TRUE instance name supported by the instance | ||
instance_number 0 | instance_number 0 TRUE instance number | ||
instance_type RDBMS | instance_type RDBMS TRUE type of instance to be executed | ||
java_max_sessionspace_size 0 | java_max_sessionspace_size 0 TRUE max allowed size in bytes of a Java sessionspace | ||
java_pool_size 0 | java_pool_size 0 TRUE size in bytes of java pool | ||
java_soft_sessionspace_limit 0 | java_soft_sessionspace_limit 0 TRUE warning limit on size in bytes of a Java sessionspace | ||
job_queue_processes 4 | job_queue_processes 4 FALSE number of job queue slave processes | ||
large_pool_size 0 | large_pool_size 0 TRUE size in bytes of large pool | ||
ldap_directory_access NONE | ldap_directory_access NONE TRUE RDBMS's LDAP access option | ||
license_max_sessions 0 | license_max_sessions 0 TRUE maximum number of non-system user sessions allowed | ||
license_max_users 0 | license_max_users 0 TRUE maximum number of named users that can be created in the database | ||
license_sessions_warning 0 | license_sessions_warning 0 TRUE warning level for number of non-system user sessions | ||
local_listener - | local_listener - TRUE local listener | ||
lock_name_space - | lock_name_space - TRUE lock name space used for generating lock names for standby/clone database | ||
lock_sga FALSE | lock_sga FALSE TRUE Lock entire SGA in physical memory | ||
log_archive_config - | log_archive_config - TRUE log archive config parameter | ||
log_archive_dest - | log_archive_dest - TRUE archival destination text string | ||
log_archive_dest_state_1 enable | log_archive_dest_state_1 enable TRUE archival destination #1 state text string | ||
log_archive_dest_state_10 enable | log_archive_dest_state_10 enable TRUE archival destination #10 state text string | ||
log_archive_dest_state_2 enable | log_archive_dest_state_2 enable TRUE archival destination #2 state text string | ||
log_archive_dest_state_3 enable | log_archive_dest_state_3 enable TRUE archival destination #3 state text string | ||
log_archive_dest_state_4 enable | log_archive_dest_state_4 enable TRUE archival destination #4 state text string | ||
log_archive_dest_state_5 enable | log_archive_dest_state_5 enable TRUE archival destination #5 state text string | ||
log_archive_dest_state_6 enable | log_archive_dest_state_6 enable TRUE archival destination #6 state text string | ||
log_archive_dest_state_7 enable | log_archive_dest_state_7 enable TRUE archival destination #7 state text string | ||
log_archive_dest_state_8 enable | log_archive_dest_state_8 enable TRUE archival destination #8 state text string | ||
log_archive_dest_state_9 enable | log_archive_dest_state_9 enable TRUE archival destination #9 state text string | ||
log_archive_dest_1 - | log_archive_dest_1 - TRUE archival destination #1 text string | ||
log_archive_dest_10 - | log_archive_dest_10 - TRUE archival destination #10 text string | ||
log_archive_dest_2 - | log_archive_dest_2 - TRUE archival destination #2 text string | ||
log_archive_dest_3 - | log_archive_dest_3 - TRUE archival destination #3 text string | ||
log_archive_dest_4 - | log_archive_dest_4 - TRUE archival destination #4 text string | ||
log_archive_dest_5 - | log_archive_dest_5 - TRUE archival destination #5 text string | ||
log_archive_dest_6 - | log_archive_dest_6 - TRUE archival destination #6 text string | ||
log_archive_dest_7 - | log_archive_dest_7 - TRUE archival destination #7 text string | ||
log_archive_dest_8 - | log_archive_dest_8 - TRUE archival destination #8 text string | ||
log_archive_dest_9 - | log_archive_dest_9 - TRUE archival destination #9 text string | ||
log_archive_duplex_dest - | log_archive_duplex_dest - TRUE duplex archival destination text string | ||
log_archive_format %t_%s_%r.dbf | log_archive_format %t_%s_%r.dbf TRUE archival destination format | ||
log_archive_local_first TRUE | log_archive_local_first TRUE TRUE Establish EXPEDITE attribute default value | ||
log_archive_max_processes 2 | log_archive_max_processes 2 TRUE maximum number of active ARCH processes | ||
log_archive_min_succeed_dest 1 | log_archive_min_succeed_dest 1 TRUE minimum number of archive destinations that must succeed | ||
log_archive_start FALSE | log_archive_start FALSE TRUE start archival process on SGA initialization | ||
log_archive_trace 0 | log_archive_trace 0 TRUE Establish archivelog operation tracing level | ||
log_buffer 2887168 | log_buffer 2887168 TRUE redo circular buffer size | ||
log_checkpoint_interval 0 | log_checkpoint_interval 0 TRUE # redo blocks checkpoint threshold | ||
log_checkpoints_to_alert FALSE | log_checkpoints_to_alert FALSE TRUE log checkpoint begin/end to alert file | ||
log_checkpoint_timeout 1800 | log_checkpoint_timeout 1800 TRUE Maximum time interval between checkpoints in seconds | ||
log_file_name_convert - | log_file_name_convert - TRUE logfile name convert patterns and strings for standby/clone db | ||
logmnr_max_persistent_sessions 1 | logmnr_max_persistent_sessions 1 TRUE maximum number of threads to mine | ||
max_commit_propagation_delay 0 | max_commit_propagation_delay 0 TRUE Max age of new snapshot in .01 seconds | ||
max_dispatchers - | max_dispatchers - TRUE max number of dispatchers | ||
max_dump_file_size UNLIMITED | max_dump_file_size UNLIMITED TRUE Maximum size (blocks) of dump file | ||
max_enabled_roles 150 | max_enabled_roles 150 TRUE max number of roles a user can have enabled | ||
max_shared_servers - | max_shared_servers - TRUE max number of shared servers | ||
nls_calendar - | nls_calendar - TRUE NLS calendar system name | ||
nls_comp - | nls_comp - TRUE NLS comparison | ||
nls_currency - | nls_currency - TRUE NLS local currency symbol | ||
nls_date_format - | nls_date_format - TRUE NLS Oracle date format | ||
nls_date_language - | nls_date_language - TRUE NLS date language name | ||
nls_dual_currency - | nls_dual_currency - TRUE Dual currency symbol | ||
nls_iso_currency - | nls_iso_currency - TRUE NLS ISO currency territory name | ||
nls_language AMERICAN | nls_language AMERICAN TRUE NLS language name | ||
nls_length_semantics BYTE | nls_length_semantics BYTE TRUE create columns using byte or char semantics by default | ||
nls_nchar_conv_excp FALSE | nls_nchar_conv_excp FALSE TRUE NLS raise an exception instead of allowing implicit conversion | ||
nls_numeric_characters - | nls_numeric_characters - TRUE NLS numeric characters | ||
nls_sort - | nls_sort - TRUE NLS linguistic definition name | ||
nls_territory AMERICA | nls_territory AMERICA TRUE NLS territory name | ||
nls_time_format - | nls_time_format - TRUE time format | ||
nls_timestamp_format - | nls_timestamp_format - TRUE time stamp format | ||
nls_timestamp_tz_format - | nls_timestamp_tz_format - TRUE timestampe with timezone format | ||
nls_time_tz_format - | nls_time_tz_format - TRUE time with timezone format | ||
object_cache_max_size_percent 10 | object_cache_max_size_percent 10 TRUE percentage of maximum size over optimal of the user session's object cache | ||
object_cache_optimal_size 102400 | object_cache_optimal_size 102400 TRUE optimal size of the user session's object cache in bytes | ||
olap_page_pool_size 0 | olap_page_pool_size 0 TRUE size of the olap page pool in bytes | ||
open_cursors 300 | open_cursors 300 FALSE max # cursors per session | ||
open_links 4 | open_links 4 TRUE max # open links per session | ||
open_links_per_instance 4 | open_links_per_instance 4 TRUE max # open links per instance | ||
optimizer_dynamic_sampling 2 | optimizer_dynamic_sampling 2 TRUE optimizer dynamic sampling | ||
optimizer_features_enable 10.2.0.1 | optimizer_features_enable 10.2.0.1 TRUE optimizer plan compatibility parameter | ||
optimizer_index_caching 0 | optimizer_index_caching 0 TRUE optimizer percent index caching | ||
optimizer_index_cost_adj 100 | optimizer_index_cost_adj 100 TRUE optimizer index cost adjustment | ||
optimizer_mode ALL_ROWS | optimizer_mode ALL_ROWS TRUE optimizer mode | ||
optimizer_secure_view_merging TRUE | optimizer_secure_view_merging TRUE TRUE optimizer secure view merging and predicate pushdown/movearound | ||
os_authent_prefix - | os_authent_prefix - FALSE prefix for auto-logon accounts | ||
os_roles FALSE | os_roles FALSE TRUE retrieve roles from the operating system | ||
O7_DICTIONARY_ACCESSIBILITY FALSE | O7_DICTIONARY_ACCESSIBILITY FALSE TRUE Version 7 Dictionary Accessibility Support | ||
parallel_adaptive_multi_user TRUE | parallel_adaptive_multi_user TRUE TRUE enable adaptive setting of degree for multiple user streams | ||
parallel_automatic_tuning FALSE | parallel_automatic_tuning FALSE TRUE enable intelligent defaults for parallel execution parameters | ||
parallel_execution_message_size 2148 | parallel_execution_message_size 2148 TRUE message buffer size for parallel execution | ||
parallel_instance_group - | parallel_instance_group - TRUE instance group to use for all parallel operations | ||
parallel_max_servers 0 | parallel_max_servers 0 TRUE maximum parallel query servers per instance | ||
parallel_min_percent 0 | parallel_min_percent 0 TRUE minimum percent of threads required for parallel query | ||
parallel_min_servers 0 | parallel_min_servers 0 TRUE minimum parallel query servers per instance | ||
parallel_server FALSE | parallel_server FALSE TRUE if TRUE startup in parallel server mode | ||
parallel_server_instances 1 | parallel_server_instances 1 TRUE number of instances to use for sizing OPS SGA structures | ||
parallel_threads_per_cpu 2 | parallel_threads_per_cpu 2 TRUE number of parallel execution threads per CPU | ||
pga_aggregate_target 42205184 | pga_aggregate_target 42205184 FALSE Target size for the aggregate PGA memory consumed by the instance | ||
plsql_ccflags - | plsql_ccflags - TRUE PL/SQL ccflags | ||
plsql_code_type INTERPRETED | plsql_code_type INTERPRETED TRUE PL/SQL code-type | ||
plsql_compiler_flags INTERPRETED, NON_DEBUG | plsql_compiler_flags INTERPRETED, NON_DEBUG TRUE PL/SQL compiler flags | ||
plsql_debug FALSE | plsql_debug FALSE TRUE PL/SQL debug | ||
plsql_native_library_dir - | plsql_native_library_dir - TRUE plsql native library dir | ||
plsql_native_library_subdir_count 0 | plsql_native_library_subdir_count 0 TRUE plsql native library number of subdirectories | ||
plsql_optimize_level 2 | plsql_optimize_level 2 TRUE PL/SQL optimize level | ||
plsql_v2_compatibility FALSE | plsql_v2_compatibility FALSE TRUE PL/SQL version 2.x compatibility flag | ||
plsql_warnings DISABLE:ALL | plsql_warnings DISABLE:ALL TRUE PL/SQL compiler warnings settings | ||
pre_page_sga FALSE | pre_page_sga FALSE TRUE pre-page sga for process | ||
processes 40 | processes 40 TRUE user processes | ||
query_rewrite_enabled TRUE | query_rewrite_enabled TRUE TRUE allow rewrite of queries using materialized views if enabled | ||
query_rewrite_integrity enforced | query_rewrite_integrity enforced TRUE perform rewrite using materialized views with desired integrity | ||
rdbms_server_dn - | rdbms_server_dn - TRUE RDBMS's Distinguished Name | ||
read_only_open_delayed FALSE | read_only_open_delayed FALSE TRUE if TRUE delay opening of read only files until first access | ||
recovery_parallelism 0 | recovery_parallelism 0 TRUE number of server processes to use for parallel recovery | ||
recyclebin on | recyclebin on TRUE recyclebin processing | ||
remote_archive_enable true | remote_archive_enable true TRUE remote archival enable setting | ||
remote_dependencies_mode TIMESTAMP | remote_dependencies_mode TIMESTAMP TRUE remote-procedure-call dependencies mode parameter | ||
remote_listener - | remote_listener - TRUE remote listener | ||
remote_login_passwordfile EXCLUSIVE | remote_login_passwordfile EXCLUSIVE FALSE password file usage parameter | ||
remote_os_authent FALSE | remote_os_authent FALSE TRUE allow non-secure remote clients to use auto-logon accounts | ||
remote_os_roles FALSE | remote_os_roles FALSE TRUE allow non-secure remote clients to use os roles | ||
replication_dependency_tracking TRUE | replication_dependency_tracking TRUE TRUE tracking dependency for Replication parallel propagation | ||
resource_limit FALSE | resource_limit FALSE TRUE master switch for resource limit | ||
resource_manager_plan - | resource_manager_plan - TRUE resource mgr top plan | ||
resumable_timeout 0 | resumable_timeout 0 TRUE set resumable_timeout | ||
rollback_segments - | rollback_segments - TRUE undo segment list | ||
serial_reuse disable | serial_reuse disable TRUE reuse the frame segments | ||
service_names XE | service_names XE TRUE service names supported by the instance | ||
session_cached_cursors 20 | session_cached_cursors 20 TRUE Number of cursors to cache in a session. | ||
session_max_open_files 10 | session_max_open_files 10 TRUE maximum number of open files allowed per session | ||
sessions 49 | sessions 49 FALSE user and system sessions | ||
sga_max_size 146800640 | sga_max_size 146800640 TRUE max total SGA size | ||
sga_target 146800640 | sga_target 146800640 FALSE Target size of SGA | ||
shadow_core_dump partial | shadow_core_dump partial TRUE Core Size for Shadow Processes | ||
shared_memory_address 0 | shared_memory_address 0 TRUE SGA starting address (low order 32-bits on 64-bit platforms) | ||
shared_pool_reserved_size 2936012 | shared_pool_reserved_size 2936012 TRUE size in bytes of reserved area of shared pool | ||
shared_pool_size 0 | shared_pool_size 0 TRUE size in bytes of shared pool | ||
shared_servers 4 | shared_servers 4 FALSE number of shared servers to start up | ||
shared_server_sessions - | shared_server_sessions - TRUE max number of shared server sessions | ||
skip_unusable_indexes TRUE | skip_unusable_indexes TRUE TRUE skip unusable indexes if set to TRUE | ||
smtp_out_server - | smtp_out_server - TRUE utl_smtp server and port configuration parameter | ||
sort_area_retained_size 0 | sort_area_retained_size 0 TRUE size of in-memory sort work area retained between fetch calls | ||
sort_area_size 65536 | sort_area_size 65536 TRUE size of in-memory sort work area | ||
spfile /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora | spfile /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora TRUE server parameter file | ||
sql_trace FALSE | sql_trace FALSE TRUE enable SQL trace | ||
sqltune_category DEFAULT | sqltune_category DEFAULT TRUE Category qualifier for applying hintsets | ||
sql_version NATIVE | sql_version NATIVE TRUE sql language version parameter for compatibility issues | ||
sql92_security FALSE | sql92_security FALSE TRUE require select privilege for searched update/delete | ||
standby_archive_dest ?/dbs/arch | standby_archive_dest ?/dbs/arch TRUE standby database archivelog destination text string | ||
standby_file_management MANUAL | standby_file_management MANUAL TRUE if auto then files are created/dropped automatically on standby | ||
star_transformation_enabled FALSE | star_transformation_enabled FALSE TRUE enable the use of star transformation | ||
statistics_level TYPICAL | statistics_level TYPICAL TRUE statistics level | ||
streams_pool_size 0 | streams_pool_size 0 TRUE size in bytes of the streams pool | ||
tape_asynch_io TRUE | tape_asynch_io TRUE TRUE Use asynch I/O requests for tape devices | ||
thread 0 | thread 0 TRUE Redo thread to mount | ||
timed_os_statistics 0 | timed_os_statistics 0 TRUE internal os statistic gathering interval in seconds | ||
timed_statistics TRUE | timed_statistics TRUE TRUE maintain internal timing statistics | ||
trace_enabled TRUE | trace_enabled TRUE TRUE enable KST tracing | ||
tracefile_identifier - | tracefile_identifier - TRUE trace file custom identifier | ||
transactions 53 | transactions 53 TRUE max. number of concurrent active transactions | ||
transactions_per_rollback_segment 5 | transactions_per_rollback_segment 5 TRUE number of active transactions per rollback segment | ||
undo_management AUTO | undo_management AUTO FALSE instance runs in SMU mode if TRUE, else in RBU mode | ||
undo_retention 900 | undo_retention 900 TRUE undo retention in seconds | ||
undo_tablespace UNDO | undo_tablespace UNDO FALSE use/switch undo tablespace | ||
use_indirect_data_buffers FALSE | use_indirect_data_buffers FALSE TRUE Enable indirect data buffers (very large SGA on 32-bit platforms) | ||
user_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/udump | user_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/udump FALSE User process dump directory | ||
utl_file_dir - | utl_file_dir - TRUE utl_file accessible directories list | ||
workarea_size_policy AUTO | workarea_size_policy AUTO TRUE policy used to size SQL working areas (MANUAL/AUTO) |
Revision as of 14:06, 15 July 2008
Para verificar os parâmetros faça o seguinte (no Oracle XE)
1) Clique em Início > Administração > Sobre o BD 2) Selecione apenas Parâmetros e clique no botão Ir
Através de SQL
Para verificar os parâmetros faça o seguinte (no SQL Plus ou Comandos SQL do APEX)
SELECT name,value,isdefault,description FROM v$parameter order by name;
A listagem com os parâmetros é mostrada, exemplo:
NAME VALUE ISDEFAULT DESCRIPTION active_instance_count - TRUE number of active instances in the cluster database aq_tm_processes 0 TRUE number of AQ Time Managers to start archive_lag_target 0 TRUE Maximum number of seconds of redos the standby could lose asm_diskgroups - TRUE disk groups to mount automatically asm_diskstring - TRUE disk set locations for discovery asm_power_limit 1 TRUE number of processes for disk rebalancing audit_file_dest /usr/lib/oracle/xe/app/oracle/admin/XE/adump FALSE Directory in which auditing files are to reside audit_syslog_level - TRUE Syslog facility and level audit_sys_operations FALSE TRUE enable sys auditing audit_trail NONE TRUE enable system auditing background_core_dump partial TRUE Core Size for Background Processes background_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/bdump FALSE Detached process dump directory backup_tape_io_slaves FALSE TRUE BACKUP Tape I/O slaves bitmap_merge_area_size 1048576 TRUE maximum memory allow for BITMAP MERGE blank_trimming FALSE TRUE blank trimming semantics parameter buffer_pool_keep - TRUE Number of database blocks/latches in keep buffer pool buffer_pool_recycle - TRUE Number of database blocks/latches in recycle buffer pool circuits - TRUE max number of circuits cluster_database FALSE TRUE if TRUE startup in cluster database mode cluster_database_instances 1 TRUE number of instances to use for sizing cluster db SGA structures cluster_interconnects - TRUE interconnects for RAC use commit_point_strength 1 TRUE Bias this node has toward not preparing in a two-phase commit commit_write - TRUE transaction commit log write behaviour compatible 10.2.0.1.0 FALSE Database will be completely compatible with this software version control_file_record_keep_time 7 TRUE control file record keep time in days control_files /usr/lib/oracle/xe/oradata/XE/control.dbf FALSE control file names list core_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/cdump FALSE Core dump directory cpu_count 1 TRUE number of CPUs for this instance create_bitmap_area_size 8388608 TRUE size of create bitmap buffer for bitmap index create_stored_outlines - TRUE create stored outlines for DML statements cursor_sharing EXACT TRUE cursor sharing mode cursor_space_for_time FALSE TRUE use more memory in order to get faster execution db_block_buffers 0 TRUE Number of database blocks cached in memory db_block_checking FALSE TRUE header checking and data and index block checking db_block_checksum TRUE TRUE store checksum in db blocks and check during reads db_block_size 8192 TRUE Size of database block in bytes db_cache_advice ON TRUE Buffer cache sizing advisory db_cache_size 0 TRUE Size of DEFAULT buffer pool for standard block size buffers db_create_file_dest - TRUE default database location db_create_online_log_dest_1 - TRUE online log/controlfile destination #1 db_create_online_log_dest_2 - TRUE online log/controlfile destination #2 db_create_online_log_dest_3 - TRUE online log/controlfile destination #3 db_create_online_log_dest_4 - TRUE online log/controlfile destination #4 db_create_online_log_dest_5 - TRUE online log/controlfile destination #5 db_domain - TRUE directory part of global database name stored with CREATE DATABASE db_file_multiblock_read_count 128 TRUE db block to be read each IO db_file_name_convert - TRUE datafile name convert patterns and strings for standby/clone db db_files 200 TRUE max allowable # db files db_flashback_retention_target 1440 TRUE Maximum Flashback Database log retention time in minutes. db_keep_cache_size 0 TRUE Size of KEEP buffer pool for standard block size buffers db_name XE FALSE database name specified in CREATE DATABASE db_recovery_file_dest /usr/lib/oracle/xe/app/oracle/flash_recovery_area FALSE default database recovery file location db_recovery_file_dest_size 10737418240 FALSE database recovery files size limit db_recycle_cache_size 0 TRUE Size of RECYCLE buffer pool for standard block size buffers db_unique_name XE TRUE Database Unique Name dbwr_io_slaves 0 TRUE DBWR I/O slaves db_writer_processes 1 TRUE number of background database writer processes to start db_16k_cache_size 0 TRUE Size of cache for 16K buffers db_2k_cache_size 0 TRUE Size of cache for 2K buffers db_32k_cache_size 0 TRUE Size of cache for 32K buffers db_4k_cache_size 0 TRUE Size of cache for 4K buffers db_8k_cache_size 0 TRUE Size of cache for 8K buffers ddl_wait_for_locks FALSE TRUE Disable NOWAIT DML lock acquisitions dg_broker_config_file1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr1XE.dat TRUE data guard broker configuration file #1 dg_broker_config_file2 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr2XE.dat TRUE data guard broker configuration file #2 dg_broker_start FALSE TRUE start Data Guard broker framework (DMON process) disk_asynch_io TRUE TRUE Use asynch I/O for random access devices dispatchers (PROTOCOL=TCP) (SERVICE=XEXDB) FALSE specifications of dispatchers distributed_lock_timeout 60 TRUE number of seconds a distributed transaction waits for a lock dml_locks 212 TRUE dml locks - one for each table modified in a transaction drs_start FALSE TRUE start DG Broker monitor (DMON process) event - TRUE debug event control - default null string fal_client - TRUE FAL client fal_server - TRUE FAL server list fast_start_io_target 0 TRUE Upper bound on recovery reads fast_start_mttr_target 0 TRUE MTTR target of forward crash recovery in seconds fast_start_parallel_rollback LOW TRUE max number of parallel recovery slaves that may be used fileio_network_adapters - TRUE Network Adapters for File I/O file_mapping FALSE TRUE enable file mapping filesystemio_options none TRUE IO operations on filesystem files fixed_date - TRUE fixed SYSDATE value gc_files_to_locks - TRUE mapping between file numbers and global cache locks gcs_server_processes 0 TRUE number of background gcs server processes to start global_context_pool_size - TRUE Global Application Context Pool Size in Bytes global_names FALSE TRUE enforce that database links have same name as remote database hash_area_size 131072 TRUE size of in-memory hash work area hi_shared_memory_address 0 TRUE SGA starting address (high order 32-bits on 64-bit platforms) hs_autoregister TRUE TRUE enable automatic server DD updates in HS agent self-registration ifile - TRUE include file in init.ora instance_groups - TRUE list of instance group names instance_name XE TRUE instance name supported by the instance instance_number 0 TRUE instance number instance_type RDBMS TRUE type of instance to be executed java_max_sessionspace_size 0 TRUE max allowed size in bytes of a Java sessionspace java_pool_size 0 TRUE size in bytes of java pool java_soft_sessionspace_limit 0 TRUE warning limit on size in bytes of a Java sessionspace job_queue_processes 4 FALSE number of job queue slave processes large_pool_size 0 TRUE size in bytes of large pool ldap_directory_access NONE TRUE RDBMS's LDAP access option license_max_sessions 0 TRUE maximum number of non-system user sessions allowed license_max_users 0 TRUE maximum number of named users that can be created in the database license_sessions_warning 0 TRUE warning level for number of non-system user sessions local_listener - TRUE local listener lock_name_space - TRUE lock name space used for generating lock names for standby/clone database lock_sga FALSE TRUE Lock entire SGA in physical memory log_archive_config - TRUE log archive config parameter log_archive_dest - TRUE archival destination text string log_archive_dest_state_1 enable TRUE archival destination #1 state text string log_archive_dest_state_10 enable TRUE archival destination #10 state text string log_archive_dest_state_2 enable TRUE archival destination #2 state text string log_archive_dest_state_3 enable TRUE archival destination #3 state text string log_archive_dest_state_4 enable TRUE archival destination #4 state text string log_archive_dest_state_5 enable TRUE archival destination #5 state text string log_archive_dest_state_6 enable TRUE archival destination #6 state text string log_archive_dest_state_7 enable TRUE archival destination #7 state text string log_archive_dest_state_8 enable TRUE archival destination #8 state text string log_archive_dest_state_9 enable TRUE archival destination #9 state text string log_archive_dest_1 - TRUE archival destination #1 text string log_archive_dest_10 - TRUE archival destination #10 text string log_archive_dest_2 - TRUE archival destination #2 text string log_archive_dest_3 - TRUE archival destination #3 text string log_archive_dest_4 - TRUE archival destination #4 text string log_archive_dest_5 - TRUE archival destination #5 text string log_archive_dest_6 - TRUE archival destination #6 text string log_archive_dest_7 - TRUE archival destination #7 text string log_archive_dest_8 - TRUE archival destination #8 text string log_archive_dest_9 - TRUE archival destination #9 text string log_archive_duplex_dest - TRUE duplex archival destination text string log_archive_format %t_%s_%r.dbf TRUE archival destination format log_archive_local_first TRUE TRUE Establish EXPEDITE attribute default value log_archive_max_processes 2 TRUE maximum number of active ARCH processes log_archive_min_succeed_dest 1 TRUE minimum number of archive destinations that must succeed log_archive_start FALSE TRUE start archival process on SGA initialization log_archive_trace 0 TRUE Establish archivelog operation tracing level log_buffer 2887168 TRUE redo circular buffer size log_checkpoint_interval 0 TRUE # redo blocks checkpoint threshold log_checkpoints_to_alert FALSE TRUE log checkpoint begin/end to alert file log_checkpoint_timeout 1800 TRUE Maximum time interval between checkpoints in seconds log_file_name_convert - TRUE logfile name convert patterns and strings for standby/clone db logmnr_max_persistent_sessions 1 TRUE maximum number of threads to mine max_commit_propagation_delay 0 TRUE Max age of new snapshot in .01 seconds max_dispatchers - TRUE max number of dispatchers max_dump_file_size UNLIMITED TRUE Maximum size (blocks) of dump file max_enabled_roles 150 TRUE max number of roles a user can have enabled max_shared_servers - TRUE max number of shared servers nls_calendar - TRUE NLS calendar system name nls_comp - TRUE NLS comparison nls_currency - TRUE NLS local currency symbol nls_date_format - TRUE NLS Oracle date format nls_date_language - TRUE NLS date language name nls_dual_currency - TRUE Dual currency symbol nls_iso_currency - TRUE NLS ISO currency territory name nls_language AMERICAN TRUE NLS language name nls_length_semantics BYTE TRUE create columns using byte or char semantics by default nls_nchar_conv_excp FALSE TRUE NLS raise an exception instead of allowing implicit conversion nls_numeric_characters - TRUE NLS numeric characters nls_sort - TRUE NLS linguistic definition name nls_territory AMERICA TRUE NLS territory name nls_time_format - TRUE time format nls_timestamp_format - TRUE time stamp format nls_timestamp_tz_format - TRUE timestampe with timezone format nls_time_tz_format - TRUE time with timezone format object_cache_max_size_percent 10 TRUE percentage of maximum size over optimal of the user session's object cache object_cache_optimal_size 102400 TRUE optimal size of the user session's object cache in bytes olap_page_pool_size 0 TRUE size of the olap page pool in bytes open_cursors 300 FALSE max # cursors per session open_links 4 TRUE max # open links per session open_links_per_instance 4 TRUE max # open links per instance optimizer_dynamic_sampling 2 TRUE optimizer dynamic sampling optimizer_features_enable 10.2.0.1 TRUE optimizer plan compatibility parameter optimizer_index_caching 0 TRUE optimizer percent index caching optimizer_index_cost_adj 100 TRUE optimizer index cost adjustment optimizer_mode ALL_ROWS TRUE optimizer mode optimizer_secure_view_merging TRUE TRUE optimizer secure view merging and predicate pushdown/movearound os_authent_prefix - FALSE prefix for auto-logon accounts os_roles FALSE TRUE retrieve roles from the operating system O7_DICTIONARY_ACCESSIBILITY FALSE TRUE Version 7 Dictionary Accessibility Support parallel_adaptive_multi_user TRUE TRUE enable adaptive setting of degree for multiple user streams parallel_automatic_tuning FALSE TRUE enable intelligent defaults for parallel execution parameters parallel_execution_message_size 2148 TRUE message buffer size for parallel execution parallel_instance_group - TRUE instance group to use for all parallel operations parallel_max_servers 0 TRUE maximum parallel query servers per instance parallel_min_percent 0 TRUE minimum percent of threads required for parallel query parallel_min_servers 0 TRUE minimum parallel query servers per instance parallel_server FALSE TRUE if TRUE startup in parallel server mode parallel_server_instances 1 TRUE number of instances to use for sizing OPS SGA structures parallel_threads_per_cpu 2 TRUE number of parallel execution threads per CPU pga_aggregate_target 42205184 FALSE Target size for the aggregate PGA memory consumed by the instance plsql_ccflags - TRUE PL/SQL ccflags plsql_code_type INTERPRETED TRUE PL/SQL code-type plsql_compiler_flags INTERPRETED, NON_DEBUG TRUE PL/SQL compiler flags plsql_debug FALSE TRUE PL/SQL debug plsql_native_library_dir - TRUE plsql native library dir plsql_native_library_subdir_count 0 TRUE plsql native library number of subdirectories plsql_optimize_level 2 TRUE PL/SQL optimize level plsql_v2_compatibility FALSE TRUE PL/SQL version 2.x compatibility flag plsql_warnings DISABLE:ALL TRUE PL/SQL compiler warnings settings pre_page_sga FALSE TRUE pre-page sga for process processes 40 TRUE user processes query_rewrite_enabled TRUE TRUE allow rewrite of queries using materialized views if enabled query_rewrite_integrity enforced TRUE perform rewrite using materialized views with desired integrity rdbms_server_dn - TRUE RDBMS's Distinguished Name read_only_open_delayed FALSE TRUE if TRUE delay opening of read only files until first access recovery_parallelism 0 TRUE number of server processes to use for parallel recovery recyclebin on TRUE recyclebin processing remote_archive_enable true TRUE remote archival enable setting remote_dependencies_mode TIMESTAMP TRUE remote-procedure-call dependencies mode parameter remote_listener - TRUE remote listener remote_login_passwordfile EXCLUSIVE FALSE password file usage parameter remote_os_authent FALSE TRUE allow non-secure remote clients to use auto-logon accounts remote_os_roles FALSE TRUE allow non-secure remote clients to use os roles replication_dependency_tracking TRUE TRUE tracking dependency for Replication parallel propagation resource_limit FALSE TRUE master switch for resource limit resource_manager_plan - TRUE resource mgr top plan resumable_timeout 0 TRUE set resumable_timeout rollback_segments - TRUE undo segment list serial_reuse disable TRUE reuse the frame segments service_names XE TRUE service names supported by the instance session_cached_cursors 20 TRUE Number of cursors to cache in a session. session_max_open_files 10 TRUE maximum number of open files allowed per session sessions 49 FALSE user and system sessions sga_max_size 146800640 TRUE max total SGA size sga_target 146800640 FALSE Target size of SGA shadow_core_dump partial TRUE Core Size for Shadow Processes shared_memory_address 0 TRUE SGA starting address (low order 32-bits on 64-bit platforms) shared_pool_reserved_size 2936012 TRUE size in bytes of reserved area of shared pool shared_pool_size 0 TRUE size in bytes of shared pool shared_servers 4 FALSE number of shared servers to start up shared_server_sessions - TRUE max number of shared server sessions skip_unusable_indexes TRUE TRUE skip unusable indexes if set to TRUE smtp_out_server - TRUE utl_smtp server and port configuration parameter sort_area_retained_size 0 TRUE size of in-memory sort work area retained between fetch calls sort_area_size 65536 TRUE size of in-memory sort work area spfile /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora TRUE server parameter file sql_trace FALSE TRUE enable SQL trace sqltune_category DEFAULT TRUE Category qualifier for applying hintsets sql_version NATIVE TRUE sql language version parameter for compatibility issues sql92_security FALSE TRUE require select privilege for searched update/delete standby_archive_dest ?/dbs/arch TRUE standby database archivelog destination text string standby_file_management MANUAL TRUE if auto then files are created/dropped automatically on standby star_transformation_enabled FALSE TRUE enable the use of star transformation statistics_level TYPICAL TRUE statistics level streams_pool_size 0 TRUE size in bytes of the streams pool tape_asynch_io TRUE TRUE Use asynch I/O requests for tape devices thread 0 TRUE Redo thread to mount timed_os_statistics 0 TRUE internal os statistic gathering interval in seconds timed_statistics TRUE TRUE maintain internal timing statistics trace_enabled TRUE TRUE enable KST tracing tracefile_identifier - TRUE trace file custom identifier transactions 53 TRUE max. number of concurrent active transactions transactions_per_rollback_segment 5 TRUE number of active transactions per rollback segment undo_management AUTO FALSE instance runs in SMU mode if TRUE, else in RBU mode undo_retention 900 TRUE undo retention in seconds undo_tablespace UNDO FALSE use/switch undo tablespace use_indirect_data_buffers FALSE TRUE Enable indirect data buffers (very large SGA on 32-bit platforms) user_dump_dest /usr/lib/oracle/xe/app/oracle/admin/XE/udump FALSE User process dump directory utl_file_dir - TRUE utl_file accessible directories list workarea_size_policy AUTO TRUE policy used to size SQL working areas (MANUAL/AUTO)