Oracle show parameters全部参数

最新推荐文章于 2021-04-15 22:04:58 发布
最新推荐文章于 2021-04-15 22:04:58 发布
阅读量7.8k 收藏 1
点赞数
分类专栏： Database 文章标签： parameters oracle integer string archive parallel
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jillcomputer/article/details/5405038
版权

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE                         
active_instance_count                integer                                   
aq_tm_processes                      integer     0                             
archive_lag_target                   integer     0                             
asm_diskgroups                       string                                    
asm_diskstring                       string                                    
asm_power_limit                      integer     1                             
asm_preferred_read_failure_groups    string                                    
audit_file_dest                      string      D:/ORACLE/ADMIN/ORCL/ADUMP    
audit_sys_operations                 boolean     FALSE                         
audit_trail                          string      DB                            

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial                       
background_dump_dest                 string      d:/oracle/diag/rdbms/orcl/orcl
                                                 /trace                        
backup_tape_io_slaves                boolean     FALSE                         
bitmap_merge_area_size               integer     1048576                       
blank_trimming                       boolean     FALSE                         
buffer_pool_keep                     string                                    
buffer_pool_recycle                  string                                    
cell_offload_compaction              string      ADAPTIVE                      
cell_offload_parameters              string                                    
cell_offload_plan_display            string      AUTO                          

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
cell_offload_processing              boolean     TRUE                          
cell_partition_large_extents         string      DEFAULT                       
circuits                             integer                                   
client_result_cache_lag              big integer 3000                          
client_result_cache_size             big integer 0                             
cluster_database                     boolean     FALSE                         
cluster_database_instances           integer     1                             
cluster_interconnects                string                                    
commit_logging                       string                                    
commit_point_strength                integer     1                             
commit_wait                          string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
commit_write                         string                                    
compatible                           string      11.1.0.0.0                    
control_file_record_keep_time        integer     7                             
control_files                        string      D:/ORACLE/DATA/ORCL/CONTROL01.
                                                 CTL, D:/ORACLE/DATA/ORCL/CONTR
                                                 OL02.CTL, D:/ORACLE/DATA/ORCL/
                                                 CONTROL03.CTL                 
control_management_pack_access       string      DIAGNOSTIC+TUNING             
core_dump_dest                       string      d:/oracle/diag/rdbms/orcl/orcl
                                                 /cdump                        
cpu_count                            integer     2                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
create_bitmap_area_size              integer     8388608                       
create_stored_outlines               string                                    
cursor_sharing                       string      EXACT                         
cursor_space_for_time                boolean     FALSE                         
db_16k_cache_size                    big integer 0                             
db_2k_cache_size                     big integer 0                             
db_32k_cache_size                    big integer 0                             
db_4k_cache_size                     big integer 0                             
db_8k_cache_size                     big integer 0                             
db_block_buffers                     integer     0                             
db_block_checking                    string      FALSE                         

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
db_block_checksum                    string      TYPICAL                       
db_block_size                        integer     8192                          
db_cache_advice                      string      ON                            
db_cache_size                        big integer 0                             
db_create_file_dest                  string                                    
db_create_online_log_dest_1          string                                    
db_create_online_log_dest_2          string                                    
db_create_online_log_dest_3          string                                    
db_create_online_log_dest_4          string                                    
db_create_online_log_dest_5          string                                    
db_domain                            string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count        integer     128                           
db_file_name_convert                 string                                    
db_files                             integer     200                           
db_flashback_retention_target        integer     1440                          
db_keep_cache_size                   big integer 0                             
db_lost_write_protect                string      NONE                          
db_name                              string      orcl                          
db_recovery_file_dest                string      D:/Oracle/flash_recovery_area 
db_recovery_file_dest_size           big integer 2G                            
db_recycle_cache_size                big integer 0                             
db_securefile                        string      PERMITTED                     

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
db_ultra_safe                        string      OFF                           
db_unique_name                       string      orcl                          
db_writer_processes                  integer     1                             
dbwr_io_slaves                       integer     0                             
ddl_lock_timeout                     integer     0                             
dg_broker_config_file1               string      D:/ORACLE/PRODUCT/11.1.0/DB_1/
                                                 DATABASE/DR1ORCL.DAT          
dg_broker_config_file2               string      D:/ORACLE/PRODUCT/11.1.0/DB_1/
                                                 DATABASE/DR2ORCL.DAT          
dg_broker_start                      boolean     FALSE                         
diagnostic_dest                      string      D:/ORACLE                     

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
disk_asynch_io                       boolean     TRUE                          
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=orclXD
                                                 B)                            
distributed_lock_timeout             integer     60                            
dml_locks                            integer     748                           
drs_start                            boolean     FALSE                         
enable_ddl_logging                   boolean     FALSE                         
event                                string                                    
fal_client                           string                                    
fal_server                           string                                    
fast_start_io_target                 integer     0                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
fast_start_mttr_target               integer     0                             
fast_start_parallel_rollback         string      LOW                           
file_mapping                         boolean     FALSE                         
fileio_network_adapters              string                                    
filesystemio_options                 string                                    
fixed_date                           string                                    
gc_files_to_locks                    string                                    
gcs_server_processes                 integer     0                             
global_context_pool_size             string                                    
global_names                         boolean     FALSE                         
global_txn_processes                 integer     1                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
hash_area_size                       integer     131072                        
hi_shared_memory_address             integer     0                             
hs_autoregister                      boolean     TRUE                          
ifile                                file                                      
instance_groups                      string                                    
instance_name                        string      orcl                          
instance_number                      integer     0                             
instance_type                        string      RDBMS                         
java_jit_enabled                     boolean     TRUE                          
java_max_sessionspace_size           integer     0                             
java_pool_size                       big integer 0                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
java_soft_sessionspace_limit         integer     0                             
job_queue_processes                  integer     1000                          
large_pool_size                      big integer 0                             
ldap_directory_access                string      NONE                          
ldap_directory_sysauth               string      no                            
license_max_sessions                 integer     0                             
license_max_users                    integer     0                             
license_sessions_warning             integer     0                             
local_listener                       string                                    
lock_name_space                      string                                    
lock_sga                             boolean     FALSE                         

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
log_archive_config                   string                                    
log_archive_dest                     string                                    
log_archive_dest_1                   string      location=d:/archivelog        
log_archive_dest_10                  string                                    
log_archive_dest_2                   string                                    
log_archive_dest_3                   string                                    
log_archive_dest_4                   string                                    
log_archive_dest_5                   string                                    
log_archive_dest_6                   string                                    
log_archive_dest_7                   string                                    
log_archive_dest_8                   string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
log_archive_dest_9                   string                                    
log_archive_dest_state_1             string      enable                        
log_archive_dest_state_10            string      enable                        
log_archive_dest_state_2             string      enable                        
log_archive_dest_state_3             string      enable                        
log_archive_dest_state_4             string      enable                        
log_archive_dest_state_5             string      enable                        
log_archive_dest_state_6             string      enable                        
log_archive_dest_state_7             string      enable                        
log_archive_dest_state_8             string      enable                        
log_archive_dest_state_9             string      enable                        

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest              string                                    
log_archive_format                   string      ARC%S_%R.%T                   
log_archive_local_first              boolean     TRUE                          
log_archive_max_processes            integer     4                             
log_archive_min_succeed_dest         integer     1                             
log_archive_start                    boolean     FALSE                         
log_archive_trace                    integer     0                             
log_buffer                           integer     5443584                       
log_checkpoint_interval              integer     0                             
log_checkpoint_timeout               integer     1800                          
log_checkpoints_to_alert             boolean     FALSE                         

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
log_file_name_convert                string                                    
max_commit_propagation_delay         integer     0                             
max_dispatchers                      integer                                   
max_dump_file_size                   string      unlimited                     
max_enabled_roles                    integer     150                           
max_shared_servers                   integer                                   
memory_max_target                    big integer 0                             
memory_target                        big integer 0                             
nls_calendar                         string                                    
nls_comp                             string      BINARY                        
nls_currency                         string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
nls_date_format                      string                                    
nls_date_language                    string                                    
nls_dual_currency                    string                                    
nls_iso_currency                     string                                    
nls_language                         string      SIMPLIFIED CHINESE            
nls_length_semantics                 string      BYTE                          
nls_nchar_conv_excp                  string      FALSE                         
nls_numeric_characters               string                                    
nls_sort                             string                                    
nls_territory                        string      CHINA                         
nls_time_format                      string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
nls_time_tz_format                   string                                    
nls_timestamp_format                 string                                    
nls_timestamp_tz_format              string                                    
object_cache_max_size_percent        integer     10                            
object_cache_optimal_size            integer     102400                        
olap_page_pool_size                  big integer 0                             
open_cursors                         integer     300                           
open_links                           integer     4                             
open_links_per_instance              integer     4                             
optimizer_capture_sql_plan_baselines boolean     FALSE                         
optimizer_dynamic_sampling           integer     2                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
optimizer_features_enable            string      11.1.0.7                      
optimizer_index_caching              integer     0                             
optimizer_index_cost_adj             integer     100                           
optimizer_mode                       string      ALL_ROWS                      
optimizer_secure_view_merging        boolean     TRUE                          
optimizer_use_invisible_indexes      boolean     FALSE                         
optimizer_use_pending_statistics     boolean     FALSE                         
optimizer_use_sql_plan_baselines     boolean     TRUE                          
os_authent_prefix                    string      OPS$                          
os_roles                             boolean     FALSE                         
parallel_adaptive_multi_user         boolean     TRUE                          

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
parallel_automatic_tuning            boolean     FALSE                         
parallel_execution_message_size      integer     2148                          
parallel_instance_group              string                                    
parallel_io_cap_enabled              boolean     FALSE                         
parallel_max_servers                 integer     40                            
parallel_min_percent                 integer     0                             
parallel_min_servers                 integer     0                             
parallel_server                      boolean     FALSE                         
parallel_server_instances            integer     1                             
parallel_threads_per_cpu             integer     2                             
pga_aggregate_target                 big integer 198M                          

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
plscope_settings                     string      IDENTIFIERS:NONE              
plsql_ccflags                        string                                    
plsql_code_type                      string      INTERPRETED                   
plsql_debug                          boolean     FALSE                         
plsql_native_library_dir             string                                    
plsql_native_library_subdir_count    integer     0                             
plsql_optimize_level                 integer     2                             
plsql_v2_compatibility               boolean     FALSE                         
plsql_warnings                       string      DISABLE:ALL                   
pre_page_sga                         boolean     FALSE                         
processes                            integer     150                           

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
query_rewrite_enabled                string      TRUE                          
query_rewrite_integrity              string      enforced                      
rdbms_server_dn                      string                                    
read_only_open_delayed               boolean     FALSE                         
recovery_parallelism                 integer     0                             
recyclebin                           string      on                            
redo_transport_user                  string                                    
remote_dependencies_mode             string      TIMESTAMP                     
remote_listener                      string                                    
remote_login_passwordfile            string      EXCLUSIVE                     
remote_os_authent                    boolean     FALSE                         

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
remote_os_roles                      boolean     FALSE                         
replication_dependency_tracking      boolean     TRUE                          
resource_limit                       boolean     FALSE                         
resource_manager_cpu_allocation      integer     2                             
resource_manager_plan                string                                    
result_cache_max_result              integer     5                             
result_cache_max_size                big integer 3M                            
result_cache_mode                    string      MANUAL                        
result_cache_remote_expiration       integer     0                             
resumable_timeout                    integer     0                             
rollback_segments                    string                                    

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE                          
sec_max_failed_login_attempts        integer     10                            
sec_protocol_error_further_action    string      CONTINUE                      
sec_protocol_error_trace_action      string      TRACE                         
sec_return_server_release_banner     boolean     FALSE                         
serial_reuse                         string      disable                       
service_names                        string      orcl                          
session_cached_cursors               integer     50                            
session_max_open_files               integer     10                            
sessions                             integer     170                           
sga_max_size                         big integer 596M                          

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
sga_target                           big integer 596M                          
shadow_core_dump                     string      none                          
shared_memory_address                integer     0                             
shared_pool_reserved_size            big integer 8178892                       
shared_pool_size                     big integer 0                             
shared_server_sessions               integer                                   
shared_servers                       integer     1                             
skip_unusable_indexes                boolean     TRUE                          
smtp_out_server                      string                                    
sort_area_retained_size              integer     0                             
sort_area_size                       integer     65536                         

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
spfile                               string      D:/ORACLE/PRODUCT/11.1.0/DB_1/
                                                 DATABASE/SPFILEORCL.ORA       
sql92_security                       boolean     FALSE                         
sql_trace                            boolean     FALSE                         
sql_version                          string      NATIVE                        
sqltune_category                     string      DEFAULT                       
standby_archive_dest                 string      %ORACLE_HOME%/RDBMS           
standby_file_management              string      MANUAL                        
star_transformation_enabled          string      FALSE                         
statistics_level                     string      TYPICAL                       
streams_pool_size                    big integer 0                             

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
tape_asynch_io                       boolean     TRUE                          
thread                               integer     0                             
timed_os_statistics                  integer     0                             
timed_statistics                     boolean     TRUE                          
trace_enabled                        boolean     TRUE                          
tracefile_identifier                 string                                    
transactions                         integer     187                           
transactions_per_rollback_segment    integer     5                             
undo_management                      string      AUTO                          
undo_retention                       integer     900                           
undo_tablespace                      string      UNDOTBS1                      

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
use_indirect_data_buffers            boolean     FALSE                         
user_dump_dest                       string      d:/oracle/diag/rdbms/orcl/orcl
                                                 /trace                        
utl_file_dir                         string                                    
workarea_size_policy                 string      AUTO                          
xml_db_events                        string      enable        

jillcomputer
关注
专栏目录
Oracle数据库：参数文件与诊断文件
Sebastien23的博客
06-06 642
Oracle数据库：参数文件与诊断文件参数文件初始化参数pfilespfile相关运维操作诊断文件ADRAlert logDDL logTrace filesdump文件 参数文件 Oracle中的参数文件是一个包含一系列参数以及参数对应值的操作系统文件。它们是在数据库实例启动时候加载的，决定了数据库的物理 结构、内存、数据库的限制及系统大量的默认值、数据库的各种物理属性、指定数据库控制文件名和路径等信息，是进行数据库设计和性能调优的重要文件。 Oracle数据库实例启动时必须通过参数文件（paramete
ShowParameters
junjielkj的专栏
02-25 241
import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.util.*; //获取所有的参数 public class ShowParameters extends HttpServlet { public void doGet(HttpServletRequest r...
oracle show version,Show parameters
weixin_34626779的博客
04-15 170
1001544 wrote:Hello,Oracle version 11.2.0.3Is there any way by which we can find out the path of PFILE by which the instance is started on UNIX based server?Not for a pfile startup.If the database was...
oracle查询参数值,查询oracle的所有parameter参数
weixin_27310985的博客
04-03 1144
show parameter实际上查询的是v$parameter，可以通过sql_trace(alter session set sql_trace= true，11g的路径是@oracle_home\diag\rdbms\orcl\orcl\trace，10g的路径是%oracle_home%\admin\orcl\udump,其中orcl是数据库实例。)跟踪得到。我们经常要去查看某一个参数的值...
让Oracle的 SHOW PARAMETER 命令显示隐藏参数
DBA never sleep-DBA，永不眠
03-01 2678
Find internal of "show parameter" by session tracing SQL> select * from v$version;      BANNER   --------------------------------------------------------------------------------   Oracl
oracle的parameters怎么用,oracle普通用户使用show parameter方法
weixin_42397141的博客
04-06 738
在Oracle中一般只有sys用户可以使用show parameter来查看参数的设置，如果想要普通用户也可以使用showparameter，需要给普通用户授予在V_$PARAMETER视图上SELECT权限。Oracle官方解释：Your output may vary depending on the version and configurationof the Oracle Databas...
Oracle 11G参数文件
最新发布
03-04
SHOW PARAMETERS; ``` - **显示特定初始化参数**： ```sql SHOW PARAMETER db_block_size; ``` 2. **查询V$PARAMETER视图** - **显示所有初始化参数**： ```sql SELECT NAME, TYPE, VALUE FROM V$...
oracle静态,Oracle 静态参数与动态参数类型介绍
weixin_35529833的博客
04-03 711
Oracle 参数类型介绍首先 配置文件:pfile(参数文件),spfile(服务器配置文件) 在以前8i 以前的版本 是不可以动态的修改 系统参数的 但是 从9i 过后 就开始有了 spfile 提供给 管理员 更方便的 修改系统参数 两个文件 区别: pfile 是 文本文件 可以通过 文本编辑器 编辑参数 而spfile是二进制文件 最好不要用文本编辑软件编辑 内容,系统st...
oracle实验二 体系结构、存储结构与各类参数
10-18
- 使用SQL*Plus命令：`SHOW PARAMETERS 参数名`，如`SHOW PARAMETERS memory_max_target` - **初始化参数文件类型**： - **PFILE（文本文件）**：默认位置是 `$ORACLE_HOME/admin/pfile`。 - 特点：易于编辑，但...
oracle分配内存参数,Oracle 内存参数调整
weixin_34900758的博客
04-03 683
-- 优化Oracle内存结构-- 优化SGA(System Global Area )-- SGA = data buffer + 用于存放从数据文件读入的数据块，可以尽可能的大-- shared_pool_size + 通常设为500M左右，不应超过700M 用于保存数据字典及当前执行的SQL语句和存储过程-- log_buffer + 通...
oracle普通用户使用show parameter方法（转）
Uridis的博客
11-25 1242
在Oracle中一般只有sys用户可以使用show parameter来查看参数的设置，如果想要普通用户也可以使用show parameter，需要给普通用户授予在V_$PARAMETER视图上SELECT权限。 Oracle官方解释： Your output may vary depending on the version and configuration of the Oracle Database server to which you are connected. You need SELECT
管理例程——管理初始化参数——显示参数文件
weixin_33736649的博客
05-09 127
1.使用show parameters 命令像是初始化参数 该命令用于显示当前会话初始化参数的名称，类型及值。若不带参数，则会显示所有会话参数。如只显示部分参数，则需要带有参数全名或部分字符。 例子：显示resource_limit show parameters resource_limit SQL> show parameters resource_limit NA...
oracle show parameter,oracle show tables
weixin_42300167的博客
04-06 279
SQL codeCREATE DATABASE db_nameLOGFILEGROUP 1 ('/opt/oracle/u02/oradata/db_name/redo01.log','/opt/oracle/u02/oradata/db_name/redo01_1.log') size 500m reuse,GROUP 2 ('/opt/oracle/u02/oradata/db_name/re...
oracle show parameter,用show parameter也能显示隐含参数
weixin_33865450的博客
04-06 2486
Oracle 数据库启动时用到的数据库初始化参数，我们通常是在 sqlplus 中使用 show parameter 命令来获取。但这里看到只会是一些公开的参数，和已经修改的隐含参数。 Oracle 还有一批隐含参数，在 debug 或者实现某些功能时非常有用。在网上，你可以很方便的查到如何查询这些隐含参数。但是，如果我还想继续使用 show parameter 方法显示隐含参数呢？这该如何实现？...
oracle查看parameter,查看参数（parameter）的字典与数据库字符集
weixin_35555014的博客
04-13 1189
在日常管理数据库当中，离不开数据库字典，包括数据库的参数字典以及数据字典，通常使用show parameter 或者select方式查看相关的字典。总的来说，使用show parameter方式查看更多，因为使用方便。但两者之间是查看不同的内容，parameter展示的是数据库里的参数，而select查看的是相关数据字典的视图，展示更详细更多的内容。从以下的例子可以很直观的体现到。---数据库的各...
oracle 11g show parameter显示隐含参数hidden parameter_x$ksppi
09-01 329
结论： 1，v$parameter视图不能重建，只能查询，因为它是ORACLE自己构建的视图，而非用户后期定义的视图 2，show parameter显示隐含参数，可以在SYS用户定义视图，然后在非SYS用户构...
oracle show parameter,在sqlplus里用show parameter 直接显示oracle隐含参数
weixin_36194553的博客
04-06 1925
Oracle 启动用到了初始化参数，通常我们都可以在sqlplus里用show parameter 来获得。而Oracle为了debug 或者解决一些特殊的问题，还提供了一些以“_”开头的隐含参数。 网络上有一些script可以让我们轻松检查这些隐含参数. 但是，有没有想过,我们可以直接在sqlplus 用show parameter 来获取这些隐含参数呢？答案是可以的。下面，我将演示一下如何用s...
用show parameter显示Oracle隐含参数
朝着梦想 渐行前进
11-08 1797
Oracle数据库的启动用到了初始化参数，一般情况下可以在sqlplus里用show parameter 来获得。而Oracle数据库为了debug 或者解决一些特殊的问题，还提供了一些以“_”开头的隐含参数。 网络上有一些script可以让我们轻松检查这些隐含参数. 下面我们来详细介绍一下如何直接在sqlplus 用show parameter来获取隐含参数？ 　　用sqlplus里的show
Oracle入门（五E）之讲解show parameter命令模糊查询
茅坤宝骏氹的博客
05-28 4787
转载自 讲解Oracle show parameter命令的小技巧Oracle参数查询命令show parameter的一个小技巧，可以使用模糊查询，比如我想查询包含db_的参数，那么我就可以用：SQL> show parameter db_;NAME TYPE VALUE------------------------------------ ----------- -----------...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值