Ebasso: /* Ver também */

2013-02-05T23:11:56Z

Ver também

← Older revision		Revision as of 23:11, 5 February 2013
Line 286:		Line 286:


	*[[Oracle\| Mais Artigos sobre Oracle]		*[[Oracle\| Mais Artigos sobre Oracle]]
	*[[DB2\| Mais Artigos sobre DB2]		*[[DB2\| Mais Artigos sobre DB2]]
	*[[Linux\| Mais Artigos sobre Linux / UNIX / AIX]]		*[[Linux\| Mais Artigos sobre Linux / UNIX / AIX]]
	*[[Tecnologias\| Mais Artigos sobre outras Tecnologias]]		*[[Tecnologias\| Mais Artigos sobre outras Tecnologias]]

Ebasso at 23:11, 5 February 2013

2013-02-05T23:11:39Z

← Older revision		Revision as of 23:11, 5 February 2013
Line 277:		Line 277:
	utl_file_dir - TRUE utl_file accessible directories list		utl_file_dir - TRUE utl_file accessible directories list
	workarea_size_policy AUTO TRUE policy used to size SQL working areas (MANUAL/AUTO)		workarea_size_policy AUTO TRUE policy used to size SQL working areas (MANUAL/AUTO)

			== Ver também ==

			*[[Oracle: Iniciando o Enterprise Manager]]
			*[[Oracle: Iniciando o iSQLPlus]]
			*[[Oracle: Instalando o Oracle XE no Linux]]
			*[[Oracle: Liberando o acesso remoto (http) do Oracle XE]]


			*[[Oracle\| Mais Artigos sobre Oracle]
			*[[DB2\| Mais Artigos sobre DB2]
			*[[Linux\| Mais Artigos sobre Linux / UNIX / AIX]]
			*[[Tecnologias\| Mais Artigos sobre outras Tecnologias]]


			[[Category:Oracle]]
			[[Category:Databases]]
			[[Category:Tecnologias]]

Ebasso: /* Através de SQL */

2008-07-15T14:30:37Z

Através de SQL

← Older revision		Revision as of 14:30, 15 July 2008
Line 7:		Line 7:
	== Através de SQL==		== 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)

			SHOW PARAMETER

			ou

	SELECT name,value,isdefault,description FROM v$parameter		SELECT name,value,isdefault,description FROM v$parameter

Ebasso at 14:06, 15 July 2008

2008-07-15T14:06:04Z

Show changes

Ebasso: 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...

2008-07-15T13:54:40Z

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...

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

← Older revision		Revision as of 23:11, 5 February 2013
Line 286:		Line 286:


	*[[Oracle\| Mais Artigos sobre Oracle]		*[[Oracle\| Mais Artigos sobre Oracle]]
	*[[DB2\| Mais Artigos sobre DB2]		*[[DB2\| Mais Artigos sobre DB2]]
	*[[Linux\| Mais Artigos sobre Linux / UNIX / AIX]]		*[[Linux\| Mais Artigos sobre Linux / UNIX / AIX]]
	*[[Tecnologias\| Mais Artigos sobre outras Tecnologias]]		*[[Tecnologias\| Mais Artigos sobre outras Tecnologias]]

Oracle: Verificando os parametros do Banco - Revision history

Ebasso: /* Ver também */

Ebasso at 23:11, 5 February 2013

Ebasso: /* Através de SQL */

Ebasso at 14:06, 15 July 2008

Ebasso: 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...