Oracle: Verificando os parametros do Banco

From Wiki
Revision as of 13:54, 15 July 2008 by Ebasso (talk | contribs) (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...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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, exemplo:

NAME                  VALUE
_____________________  ___________________________________________
active_instance_count	 -
aq_tm_processes	0
archive_lag_target	0
asm_diskgroups	-
asm_diskstring	-
asm_power_limit	1
audit_file_dest	/usr/lib/oracle/xe/app/oracle/admin/XE/adump
audit_syslog_level	-
audit_sys_operations	FALSE
audit_trail	NONE
background_core_dump	partial
background_dump_dest	/usr/lib/oracle/xe/app/oracle/admin/XE/bdump
backup_tape_io_slaves	FALSE
bitmap_merge_area_size	1048576
blank_trimming	FALSE
buffer_pool_keep	-
buffer_pool_recycle	-
circuits	-
cluster_database	FALSE
cluster_database_instances	1
cluster_interconnects	-
commit_point_strength	1
commit_write	-
compatible	10.2.0.1.0
control_file_record_keep_time	7
control_files	/usr/lib/oracle/xe/oradata/XE/control.dbf
core_dump_dest	/usr/lib/oracle/xe/app/oracle/admin/XE/cdump
cpu_count	1
create_bitmap_area_size	8388608
create_stored_outlines	-
cursor_sharing	EXACT
cursor_space_for_time	FALSE
db_block_buffers	0
db_block_checking	FALSE
db_block_checksum	TRUE
db_block_size	8192
db_cache_advice	ON
db_cache_size	0
db_create_file_dest	-
db_create_online_log_dest_1	-
db_create_online_log_dest_2	-
db_create_online_log_dest_3	-
db_create_online_log_dest_4	-
db_create_online_log_dest_5	-
db_domain	-
db_file_multiblock_read_count	128
db_file_name_convert	-
db_files	200
db_flashback_retention_target	1440
db_keep_cache_size	0
db_name	XE
db_recovery_file_dest	/usr/lib/oracle/xe/app/oracle/flash_recovery_area
db_recovery_file_dest_size	10737418240
db_recycle_cache_size	0
db_unique_name	XE
dbwr_io_slaves	0
db_writer_processes	1
db_16k_cache_size	0
db_2k_cache_size	0
db_32k_cache_size	0
db_4k_cache_size	0
db_8k_cache_size	0
ddl_wait_for_locks	FALSE
dg_broker_config_file1	/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr1XE.dat
dg_broker_config_file2	/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/dr2XE.dat
dg_broker_start	FALSE
disk_asynch_io	TRUE
dispatchers	(PROTOCOL=TCP) (SERVICE=XEXDB)
distributed_lock_timeout	60
dml_locks	212
drs_start	FALSE
event	-
fal_client	-
fal_server	-
fast_start_io_target	0
fast_start_mttr_target	0
fast_start_parallel_rollback	LOW
fileio_network_adapters	-
file_mapping	FALSE
filesystemio_options	none
fixed_date	-
gc_files_to_locks	-
gcs_server_processes	0
global_context_pool_size	-
global_names	FALSE
hash_area_size	131072
hi_shared_memory_address	0
hs_autoregister	TRUE
ifile	-
instance_groups	-
instance_name	XE
instance_number	0
instance_type	RDBMS
java_max_sessionspace_size	0
java_pool_size	0
java_soft_sessionspace_limit	0
job_queue_processes	4
large_pool_size	0
ldap_directory_access	NONE
license_max_sessions	0
license_max_users	0
license_sessions_warning	0
local_listener	-
lock_name_space	-
lock_sga	FALSE
log_archive_config	-
log_archive_dest	-
log_archive_dest_state_1	enable
log_archive_dest_state_10	enable
log_archive_dest_state_2	enable
log_archive_dest_state_3	enable
log_archive_dest_state_4	enable
log_archive_dest_state_5	enable
log_archive_dest_state_6	enable
log_archive_dest_state_7	enable
log_archive_dest_state_8	enable
log_archive_dest_state_9	enable
log_archive_dest_1	-
log_archive_dest_10	-
log_archive_dest_2	-
log_archive_dest_3	-
log_archive_dest_4	-
log_archive_dest_5	-
log_archive_dest_6	-
log_archive_dest_7	-
log_archive_dest_8	-
log_archive_dest_9	-
log_archive_duplex_dest	-
log_archive_format	%t_%s_%r.dbf
log_archive_local_first	TRUE
log_archive_max_processes	2
log_archive_min_succeed_dest	1
log_archive_start	FALSE
log_archive_trace	0
log_buffer	2887168
log_checkpoint_interval	0
log_checkpoints_to_alert	FALSE
log_checkpoint_timeout	1800
log_file_name_convert	-
logmnr_max_persistent_sessions	1
max_commit_propagation_delay	0
max_dispatchers	-
max_dump_file_size	UNLIMITED
max_enabled_roles	150
max_shared_servers	-
nls_calendar	-
nls_comp	-
nls_currency	-
nls_date_format	-
nls_date_language	-
nls_dual_currency	-
nls_iso_currency	-
nls_language	AMERICAN
nls_length_semantics	BYTE
nls_nchar_conv_excp	FALSE
nls_numeric_characters	-
nls_sort	-
nls_territory	AMERICA
nls_time_format	-
nls_timestamp_format	-
nls_timestamp_tz_format	-
nls_time_tz_format	-
object_cache_max_size_percent	10
object_cache_optimal_size	102400
olap_page_pool_size	0
open_cursors	300
open_links	4
open_links_per_instance	4
optimizer_dynamic_sampling	2
optimizer_features_enable	10.2.0.1
optimizer_index_caching	0
optimizer_index_cost_adj	100
optimizer_mode	ALL_ROWS
optimizer_secure_view_merging	TRUE
os_authent_prefix	-
os_roles	FALSE
O7_DICTIONARY_ACCESSIBILITY	FALSE
parallel_adaptive_multi_user	TRUE
parallel_automatic_tuning	FALSE
parallel_execution_message_size	2148
parallel_instance_group	-
parallel_max_servers	0
parallel_min_percent	0
parallel_min_servers	0
parallel_server	FALSE
parallel_server_instances	1
parallel_threads_per_cpu	2
pga_aggregate_target	42205184
plsql_ccflags	-
plsql_code_type	INTERPRETED
plsql_compiler_flags	INTERPRETED, NON_DEBUG
plsql_debug	FALSE
plsql_native_library_dir	-
plsql_native_library_subdir_count	0
plsql_optimize_level	2
plsql_v2_compatibility	FALSE
plsql_warnings	DISABLE:ALL
pre_page_sga	FALSE
processes	40
query_rewrite_enabled	TRUE
query_rewrite_integrity	enforced
rdbms_server_dn	-
read_only_open_delayed	FALSE
recovery_parallelism	0
recyclebin	on
remote_archive_enable	true
remote_dependencies_mode	TIMESTAMP
remote_listener	-
remote_login_passwordfile	EXCLUSIVE
remote_os_authent	FALSE
remote_os_roles	FALSE
replication_dependency_tracking	TRUE
resource_limit	FALSE
resource_manager_plan	-
resumable_timeout	0
rollback_segments	-
serial_reuse	disable
service_names	XE
session_cached_cursors	20
session_max_open_files	10
sessions	49
sga_max_size	146800640
sga_target	146800640
shadow_core_dump	partial
shared_memory_address	0
shared_pool_reserved_size	2936012
shared_pool_size	0
shared_servers	4
shared_server_sessions	-
skip_unusable_indexes	TRUE
smtp_out_server	-
sort_area_retained_size	0
sort_area_size	65536
spfile	/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora
sql_trace	FALSE
sqltune_category	DEFAULT
sql_version	NATIVE
sql92_security	FALSE
standby_archive_dest	?/dbs/arch
standby_file_management	MANUAL
star_transformation_enabled	FALSE
statistics_level	TYPICAL
streams_pool_size	0
tape_asynch_io	TRUE
thread	0
timed_os_statistics	0
timed_statistics	TRUE
trace_enabled	TRUE
tracefile_identifier	-
transactions	53
transactions_per_rollback_segment	5
undo_management	AUTO
undo_retention	900
undo_tablespace	UNDO
use_indirect_data_buffers	FALSE
user_dump_dest	/usr/lib/oracle/xe/app/oracle/admin/XE/udump
utl_file_dir	-
workarea_size_policy	AUTO