Oracle: Verificando os parametros do Banco
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