ITPub博客

首页 > 数据库 > Oracle > 我的oracle健康检查报告

我的oracle健康检查报告

原创 Oracle 作者:lhrbest 时间:2015-08-26 16:31:21 14 删除 编辑


       最近一直想用sql来生成oracle的健康检查报告,这样看起来一目了然,经过网上搜资料加自己整理终于算是成型了,部分结果如下图所示, 具体参考附件,恳请广大网友看看是否还有需要添加的地方。 DB_healthcheck_by_lhr_ORADG11G_20150826160539.zip



ORADG11G 数据库巡检报告


Copyright (c) 2015-2100 (http://blog.itpub.net/26736162) lhrbest. All rights reserved.

巡检时间:2015-08-26 16:05:39 
巡检人:lhr 









目录 





巡检服务概要
数据库总体概况 数据库基本信息 所有的初始化参数 关键的初始化参数 数据库大小 资源使用情况
表空间情况 表空间状况信息 闪回空间使用情况 临时表空间使用情况 undo表空间使用情况 表空间扩展状况
数据文件状况 表空间扩展状况 表空间所有者
JOB情况 作业运行状况


巡检服务明细
RMAN信息 RMAN备份状况 RMAN配置情况 RMAN备份集 RMAN备份片 RMAN控制文件备份
spfile文件备份
归档信息 归档日志设置 归档日志生成情况 查看ARCHIVELOG日志使用率 近7天日志切换频率分析 最近10天中每天日志切换的量
日志组大小
SGA信息 SGA使用情况 SGA配置信息 SGA建议配置 SGA动态组件 PGA TARGET 建议配置
文件IO信息 文件IO分析 文件IO时间分析 全表扫描情况 排序情况
SQL监控 逻辑读TOP10的SQL语句 物理读TOP10的SQL语句 执行次数TOP10的SQL语句 解析次数TOP10的SQL语句 DISK SORT严重的SQL语句
ASM磁盘监控 ASM磁盘使用情况 ASM磁盘组使用情况 ASM磁盘组参数配置情况 ASM实例
闪回归档 闪回归档配置 开启了闪回归档的表 闪回归档空间
DG库 DG库配置情况 DG库运行情况 主库进程 standby日志


数据库安全
数据库用户 数据库用户一览 拥有DBA角色的用户 拥有SYS角色的用户 角色概况 密码为系统默认值的用户
整个用户有多大
系统表空间用户 系统表空间作为缺省表空间的用户 系统表空间作为临时表空间的用户 系统表空间上的对象


数据库对象
段情况 对象汇总 段的汇总 体积最大的10个段 扩展最多的10个段 LOB段
不能扩展的对象 扩展超过1/2最大扩展度的对象 行链接或行迁移的表
分区表情况 表大小超过10GB未建分区的 分区最多的前10个对象 分区个数超过100个的表
无效对象 无效的对象 无效的普通索引 无效的分区索引 无效的触发器
索引情况 索引个数超过5个的表 大表未建索引 组合索引与单列索引存在交叉 组合索引组合列超过4个的 位图索引和函数索引
将外键未建索引的情况列出
其他对象 数据库目录 回收站情况 数据库链路(db_link) 外部表 告警日志
所有的触发器 序列cache小于20
并行度 表带有并行度 索引带有并行度


数据库性能分析
AWR AWR统计 AWR参数配置状况 数据库服务器主机的情况 AWR视图中的load profile 热块
统计信息 统计信息是否自动收集 未收集或很久未收集的表 被收集统计信息的临时表
会话 会话概况 会话状态一览 登录时间最长的10个会话 超过10小时无响应的会话 提交次数最多的会话
CPU或等待最长的会话
查看LOCK锁情况 查看谁锁住了谁 游标使用情况 并行进程完成情况
内存占用 查询共享内存占有率 PGA占用最多的进程 命中率
等待事件 等待事件




数据库巡检服务概要



数据库总体概况





基本信息



巡检报告文件名称 DB_healthcheck_by_lhr_ORADG11G_20150826160539.html
巡检时间 2015-08-26 (Wednesday) 16:05:39 PM 时区 +08:00
数据库服务器名称 rhel6_lhr
数据库服务器IP地址 192.168.59.130
数据库名称 ORADG11G
数据库ID(DBID) 1403587593
数据库全局名 ORADG11G
操作系统信息 Linux x86 64-bit / 13
是否RAC集群模式? FALSE
RAC实例数目 1
数据库创建时间 2015-04-03 15:59:05
实例启动时间 实例1:2015-08-26 15:24:16
数据库归档模式 ARCHIVELOG
数据库字符集 ZHS16GBK


● 数据库系统版本信息

数据库系统版本信息
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


● 数据库实例状况



数据库实例名称 数据库实例号 线程号 主机名 数据库版本 实例启动时间 运行时间(天) RAC模式 实例状态 是否可登录 是否可归档
oradg11g
1
1
rhel6_lhr
11.2.0.3.0
2015-08-26 15:24:16
.03
NO
OPEN
ALLOWED
STARTED


● 数据库概要



INST_ID 数据库名 数据库ID 数据库 
Unique Name
创建时间 平台名称 当前SCN 日志模式 打开模式 是否强制日志 是否Flashback? 控制文件类型 Last Open 
Incarnation Num
DATABASE_ROLE SUPPLEME SUP
1
ORADG11G
1403587593
oradg11g
2015-04-03 15:59:05
Linux x86 64-bit
2282303
ARCHIVELOG
READ WRITE
YES
YES
CURRENT
4
PRIMARY IMPLICIT YES


[回到目录]



● 数据库服务器主机的情况



SNAP_ID DB_NAME DBID INSTANCE_NAME INSTANCE_NUMBER STARTUP_TIME RELEASE RAC HOST_NAME PLATFORM_NAME CPUS CORES SOCKETS Memory (GB)
113 ORADG11G 1403587593 oradg11g 1 26-AUG-15 03.24.24.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
112 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
111 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
110 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
109 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
108 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
107 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
106 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68
105 ORADG11G 1403587593 oradg11g 1 23-AUG-15 05.35.19.000 PM 11.2.0.3.0 NO rhel6_lhr Linux x86 64-bit 2 2 1 7.68


[回到目录] [下一项]



所有的初始化参数



SPFILE Usage
This database IS using an SPFILE.


Parameter Name Instance Name Value DISPLAY_VALUE Is Default? Is Dynamic? ISDEPRECATED DESCRIPTION
O7_DICTIONARY_ACCESSIBILITY oradg11g FALSE FALSE
TRUE
FALSE
FALSE Version 7 Dictionary Accessibility Support
active_instance_count oradg11g    
TRUE
FALSE
TRUE number of active instances in the cluster database
aq_tm_processes oradg11g 1 1
TRUE
IMMEDIATE
FALSE number of AQ Time Managers to start
archive_lag_target oradg11g 0 0
TRUE
IMMEDIATE
FALSE Maximum number of seconds of redos the standby could lose
asm_diskgroups oradg11g    
TRUE
IMMEDIATE
FALSE disk groups to mount automatically
asm_diskstring oradg11g    
TRUE
IMMEDIATE
FALSE disk set locations for discovery
asm_power_limit oradg11g 1 1
TRUE
IMMEDIATE
FALSE number of parallel relocations for disk rebalancing
asm_preferred_read_failure_groups oradg11g    
TRUE
IMMEDIATE
FALSE preferred read failure groups
audit_file_dest oradg11g /u01/app/oracle/admin/oradg11g/adump /u01/app/oracle/admin/oradg11g/adump
FALSE
DEFERRED
FALSE Directory in which auditing files are to reside
audit_sys_operations oradg11g FALSE FALSE
TRUE
FALSE
FALSE enable sys auditing
audit_syslog_level oradg11g    
TRUE
FALSE
FALSE Syslog facility and level
audit_trail oradg11g DB DB
FALSE
FALSE
FALSE enable system auditing
awr_snapshot_time_offset oradg11g 0 0
TRUE
IMMEDIATE
FALSE Setting for AWR Snapshot Time Offset
background_core_dump oradg11g partial partial
TRUE
FALSE
FALSE Core Size for Background Processes
background_dump_dest oradg11g /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace
TRUE
IMMEDIATE
TRUE Detached process dump directory
backup_tape_io_slaves oradg11g FALSE FALSE
TRUE
DEFERRED
FALSE BACKUP Tape I/O slaves
bitmap_merge_area_size oradg11g 1048576 1048576
TRUE
FALSE
FALSE maximum memory allow for BITMAP MERGE
blank_trimming oradg11g FALSE FALSE
TRUE
FALSE
FALSE blank trimming semantics parameter
buffer_pool_keep oradg11g    
TRUE
FALSE
TRUE Number of database blocks/latches in keep buffer pool
buffer_pool_recycle oradg11g    
TRUE
FALSE
TRUE Number of database blocks/latches in recycle buffer pool
cell_offload_compaction oradg11g ADAPTIVE ADAPTIVE
TRUE
IMMEDIATE
FALSE Cell packet compaction strategy
cell_offload_decryption oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE enable SQL processing offload of encrypted data to cells
cell_offload_parameters oradg11g    
TRUE
IMMEDIATE
FALSE Additional cell offload parameters
cell_offload_plan_display oradg11g AUTO AUTO
TRUE
IMMEDIATE
FALSE Cell offload explain plan display
cell_offload_processing oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE enable SQL processing offload to cells
circuits oradg11g    
TRUE
IMMEDIATE
FALSE max number of circuits
client_result_cache_lag oradg11g 3000 3000
TRUE
FALSE
FALSE client result cache maximum lag in milliseconds
client_result_cache_size oradg11g 0 0
TRUE
FALSE
FALSE client result cache max size in bytes
clonedb oradg11g FALSE FALSE
TRUE
FALSE
FALSE clone database
cluster_database oradg11g FALSE FALSE
TRUE
FALSE
FALSE if TRUE startup in cluster database mode
cluster_database_instances oradg11g 1 1
TRUE
FALSE
FALSE number of instances to use for sizing cluster db SGA structures
cluster_interconnects oradg11g    
TRUE
FALSE
FALSE interconnects for RAC use
commit_logging oradg11g    
TRUE
IMMEDIATE
FALSE transaction commit log write behaviour
commit_point_strength oradg11g 1 1
TRUE
FALSE
FALSE Bias this node has toward not preparing in a two-phase commit
commit_wait oradg11g    
TRUE
IMMEDIATE
FALSE transaction commit log wait behaviour
commit_write oradg11g    
TRUE
IMMEDIATE
TRUE transaction commit log write behaviour
compatible oradg11g 11.2.0.0.0 11.2.0.0.0
FALSE
FALSE
FALSE Database will be completely compatible with this software version
control_file_record_keep_time oradg11g 7 7
TRUE
IMMEDIATE
FALSE control file record keep time in days
control_files oradg11g /u01/app/oracle/oradata/oradg11g/control01.ctl, /u 01/app/oracle/flash_recovery_area/oradg11g/control02.ctl /u01/app/oracle/oradata/oradg11g/control01.ctl, /u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl
FALSE
FALSE
FALSE control file names list
control_management_pack_access oradg11g DIAGNOSTIC+TUNING DIAGNOSTIC+TUNING
TRUE
IMMEDIATE
FALSE declares which manageability packs are enabled
core_dump_dest oradg11g /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump
TRUE
IMMEDIATE
FALSE Core dump directory
cpu_count oradg11g 2 2
TRUE
IMMEDIATE
FALSE number of CPUs for this instance
create_bitmap_area_size oradg11g 8388608 8388608
TRUE
FALSE
FALSE size of create bitmap buffer for bitmap index
create_stored_outlines oradg11g    
TRUE
IMMEDIATE
FALSE create stored outlines for DML statements
cursor_bind_capture_destination oradg11g memory+disk memory+disk
TRUE
IMMEDIATE
FALSE Allowed destination for captured bind variables
cursor_sharing oradg11g EXACT EXACT
TRUE
IMMEDIATE
FALSE cursor sharing mode
cursor_space_for_time oradg11g FALSE FALSE
TRUE
FALSE
TRUE use more memory in order to get faster execution
db_16k_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of cache for 16K buffers
db_2k_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of cache for 2K buffers
db_32k_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of cache for 32K buffers
db_4k_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of cache for 4K buffers
db_8k_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of cache for 8K buffers
db_block_buffers oradg11g 0 0
TRUE
FALSE
FALSE Number of database blocks cached in memory
db_block_checking oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE header checking and data and index block checking
db_block_checksum oradg11g TYPICAL TYPICAL
TRUE
IMMEDIATE
FALSE store checksum in db blocks and check during reads
db_block_size oradg11g 8192 8192
FALSE
FALSE
FALSE Size of database block in bytes
db_cache_advice oradg11g ON ON
TRUE
IMMEDIATE
FALSE Buffer cache sizing advisory
db_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of DEFAULT buffer pool for standard block size buffers
db_create_file_dest oradg11g    
TRUE
IMMEDIATE
FALSE default database location
db_create_online_log_dest_1 oradg11g    
TRUE
IMMEDIATE
FALSE online log/controlfile destination #1
db_create_online_log_dest_2 oradg11g    
TRUE
IMMEDIATE
FALSE online log/controlfile destination #2
db_create_online_log_dest_3 oradg11g    
TRUE
IMMEDIATE
FALSE online log/controlfile destination #3
db_create_online_log_dest_4 oradg11g    
TRUE
IMMEDIATE
FALSE online log/controlfile destination #4
db_create_online_log_dest_5 oradg11g    
TRUE
IMMEDIATE
FALSE online log/controlfile destination #5
db_domain oradg11g  
FALSE
FALSE
FALSE directory part of global database name stored with CREATE DATABASE
db_file_multiblock_read_count oradg11g 7 7
TRUE
IMMEDIATE
FALSE db block to be read each IO
db_file_name_convert oradg11g oradglg, oradg11g oradglg, oradg11g
FALSE
FALSE
FALSE datafile name convert patterns and strings for standby/clone db
db_files oradg11g 200 200
TRUE
FALSE
FALSE max allowable # db files
db_flash_cache_file oradg11g    
TRUE
FALSE
FALSE flash cache file for default block size
db_flash_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE flash cache size for db_flash_cache_file
db_flashback_retention_target oradg11g 1440 1440
TRUE
IMMEDIATE
FALSE Maximum Flashback Database log retention time in minutes.
db_keep_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of KEEP buffer pool for standard block size buffers
db_lost_write_protect oradg11g NONE NONE
TRUE
IMMEDIATE
FALSE enable lost write detection
db_name oradg11g oradg11g oradg11g
FALSE
FALSE
FALSE database name specified in CREATE DATABASE
db_recovery_file_dest oradg11g /u01/app/oracle/flash_recovery_area /u01/app/oracle/flash_recovery_area
FALSE
IMMEDIATE
FALSE default database recovery file location
db_recovery_file_dest_size oradg11g 4322230272 4122M
FALSE
IMMEDIATE
FALSE database recovery files size limit
db_recycle_cache_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE Size of RECYCLE buffer pool for standard block size buffers
db_securefile oradg11g PERMITTED PERMITTED
TRUE
IMMEDIATE
FALSE permit securefile storage during lob creation
db_ultra_safe oradg11g OFF OFF
TRUE
FALSE
FALSE Sets defaults for other parameters that control protection levels
db_unique_name oradg11g oradg11g oradg11g
FALSE
FALSE
FALSE Database Unique Name
db_unrecoverable_scn_tracking oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE Track nologging SCN in controlfile
db_writer_processes oradg11g 1 1
TRUE
FALSE
FALSE number of background database writer processes to start
dbwr_io_slaves oradg11g 0 0
TRUE
FALSE
FALSE DBWR I/O slaves
ddl_lock_timeout oradg11g 0 0
TRUE
IMMEDIATE
FALSE timeout to restrict the time that ddls wait for dml lock
deferred_segment_creation oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE defer segment creation to first insert
dg_broker_config_file1 oradg11g /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat
TRUE
IMMEDIATE
FALSE data guard broker configuration file #1
dg_broker_config_file2 oradg11g /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat
TRUE
IMMEDIATE
FALSE data guard broker configuration file #2
dg_broker_start oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE start Data Guard broker (DMON process)
diagnostic_dest oradg11g /u01/app/oracle /u01/app/oracle
FALSE
IMMEDIATE
FALSE diagnostic base directory
disk_asynch_io oradg11g TRUE TRUE
TRUE
FALSE
FALSE Use asynch I/O for random access devices
dispatchers oradg11g (PROTOCOL=TCP) (SERVICE=oradg11gXDB) (PROTOCOL=TCP) (SERVICE=oradg11gXDB)
FALSE
IMMEDIATE
FALSE specifications of dispatchers
distributed_lock_timeout oradg11g 60 60
TRUE
FALSE
FALSE number of seconds a distributed transaction waits for a lock
dml_locks oradg11g 1088 1088
TRUE
FALSE
FALSE dml locks - one for each table modified in a transaction
dst_upgrade_insert_conv oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE Enables/Disables internal conversions during DST upgrade
enable_ddl_logging oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE enable ddl logging
event oradg11g    
TRUE
FALSE
FALSE debug event control - default null string
fal_client oradg11g oradg11g oradg11g
FALSE
IMMEDIATE
FALSE FAL client
fal_server oradg11g oradglg oradglg
FALSE
IMMEDIATE
FALSE FAL server list
fast_start_io_target oradg11g 0 0
TRUE
IMMEDIATE
TRUE Upper bound on recovery reads
fast_start_mttr_target oradg11g 0 0
TRUE
IMMEDIATE
FALSE MTTR target in seconds
fast_start_parallel_rollback oradg11g LOW LOW
TRUE
IMMEDIATE
FALSE max number of parallel recovery slaves that may be used
file_mapping oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE enable file mapping
fileio_network_adapters oradg11g    
TRUE
FALSE
FALSE Network Adapters for File I/O
filesystemio_options oradg11g none none
TRUE
FALSE
FALSE IO operations on filesystem files
fixed_date oradg11g    
TRUE
IMMEDIATE
FALSE fixed SYSDATE value
gcs_server_processes oradg11g 0 0
TRUE
FALSE
FALSE number of background gcs server processes to start
global_context_pool_size oradg11g    
TRUE
FALSE
TRUE Global Application Context Pool Size in Bytes
global_names oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE enforce that database links have same name as remote database
global_txn_processes oradg11g 1 1
TRUE
IMMEDIATE
FALSE number of background global transaction processes to start
hash_area_size oradg11g 131072 131072
TRUE
FALSE
FALSE size of in-memory hash work area
hi_shared_memory_address oradg11g 0 0
TRUE
FALSE
FALSE SGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregister oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE enable automatic server DD updates in HS agent self-registration
ifile oradg11g    
TRUE
FALSE
FALSE include file in init.ora
instance_groups oradg11g    
TRUE
FALSE
TRUE list of instance group names
instance_name oradg11g oradg11g oradg11g
TRUE
FALSE
FALSE instance name supported by the instance
instance_number oradg11g 0 0
TRUE
FALSE
FALSE instance number
instance_type oradg11g RDBMS RDBMS
TRUE
FALSE
FALSE type of instance to be executed
java_jit_enabled oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE Java VM JIT enabled
java_max_sessionspace_size oradg11g 0 0
TRUE
FALSE
FALSE max allowed size in bytes of a Java sessionspace
java_pool_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE size in bytes of java pool
java_soft_sessionspace_limit oradg11g 0 0
TRUE
FALSE
FALSE warning limit on size in bytes of a Java sessionspace
job_queue_processes oradg11g 1000 1000
TRUE
IMMEDIATE
FALSE maximum number of job queue slave processes
large_pool_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE size in bytes of large pool
ldap_directory_access oradg11g NONE NONE
TRUE
IMMEDIATE
FALSE RDBMS's LDAP access option
ldap_directory_sysauth oradg11g no no
TRUE
FALSE
FALSE OID usage parameter
license_max_sessions oradg11g 0 0
TRUE
IMMEDIATE
FALSE maximum number of non-system user sessions allowed
license_max_users oradg11g 0 0
TRUE
IMMEDIATE
FALSE maximum number of named users that can be created in the database
license_sessions_warning oradg11g 0 0
TRUE
IMMEDIATE
FALSE warning level for number of non-system user sessions
listener_networks oradg11g    
TRUE
IMMEDIATE
FALSE listener registration networks
local_listener oradg11g    
TRUE
IMMEDIATE
FALSE local listener
lock_name_space oradg11g    
TRUE
FALSE
TRUE lock name space used for generating lock names for standby/clone database
lock_sga oradg11g FALSE FALSE
TRUE
FALSE
FALSE Lock entire SGA in physical memory
log_archive_config oradg11g DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font> DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)
FALSE
IMMEDIATE
FALSE log archive config parameter
log_archive_dest oradg11g    
TRUE
IMMEDIATE
FALSE archival destination text string
log_archive_dest_1 oradg11g LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
FALSE
IMMEDIATE
FALSE archival destination #1 text string
log_archive_dest_10 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #10 text string
log_archive_dest_11 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #11 text string
log_archive_dest_12 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #12 text string
log_archive_dest_13 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #13 text string
log_archive_dest_14 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #14 text string
log_archive_dest_15 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #15 text string
log_archive_dest_16 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #16 text string
log_archive_dest_17 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #17 text string
log_archive_dest_18 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #18 text string
log_archive_dest_19 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #19 text string
log_archive_dest_2 oradg11g SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=ora dgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
FALSE
IMMEDIATE
FALSE archival destination #2 text string
log_archive_dest_20 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #20 text string
log_archive_dest_21 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #21 text string
log_archive_dest_22 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #22 text string
log_archive_dest_23 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #23 text string
log_archive_dest_24 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #24 text string
log_archive_dest_25 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #25 text string
log_archive_dest_26 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #26 text string
log_archive_dest_27 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #27 text string
log_archive_dest_28 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #28 text string
log_archive_dest_29 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #29 text string
log_archive_dest_3 oradg11g SERVICE=tns_oradglg LGWR ASYNC db_unique_name=orad glg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
FALSE
IMMEDIATE
FALSE archival destination #3 text string
log_archive_dest_30 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #30 text string
log_archive_dest_31 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #31 text string
log_archive_dest_4 oradg11g SERVICE=tns_oradgss LGWR ASYNC db_unique_name=orad gss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
FALSE
IMMEDIATE
FALSE archival destination #4 text string
log_archive_dest_5 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #5 text string
log_archive_dest_6 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #6 text string
log_archive_dest_7 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #7 text string
log_archive_dest_8 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #8 text string
log_archive_dest_9 oradg11g    
TRUE
IMMEDIATE
FALSE archival destination #9 text string
log_archive_dest_state_1 oradg11g ENABLE ENABLE
FALSE
IMMEDIATE
FALSE archival destination #1 state text string
log_archive_dest_state_10 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #10 state text string
log_archive_dest_state_11 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #11 state text string
log_archive_dest_state_12 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #12 state text string
log_archive_dest_state_13 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #13 state text string
log_archive_dest_state_14 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #14 state text string
log_archive_dest_state_15 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #15 state text string
log_archive_dest_state_16 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #16 state text string
log_archive_dest_state_17 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #17 state text string
log_archive_dest_state_18 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #18 state text string
log_archive_dest_state_19 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #19 state text string
log_archive_dest_state_2 oradg11g ENABLE ENABLE
FALSE
IMMEDIATE
FALSE archival destination #2 state text string
log_archive_dest_state_20 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #20 state text string
log_archive_dest_state_21 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #21 state text string
log_archive_dest_state_22 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #22 state text string
log_archive_dest_state_23 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #23 state text string
log_archive_dest_state_24 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #24 state text string
log_archive_dest_state_25 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #25 state text string
log_archive_dest_state_26 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #26 state text string
log_archive_dest_state_27 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #27 state text string
log_archive_dest_state_28 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #28 state text string
log_archive_dest_state_29 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #29 state text string
log_archive_dest_state_3 oradg11g ENABLE ENABLE
FALSE
IMMEDIATE
FALSE archival destination #3 state text string
log_archive_dest_state_30 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #30 state text string
log_archive_dest_state_31 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #31 state text string
log_archive_dest_state_4 oradg11g ENABLE ENABLE
FALSE
IMMEDIATE
FALSE archival destination #4 state text string
log_archive_dest_state_5 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #5 state text string
log_archive_dest_state_6 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #6 state text string
log_archive_dest_state_7 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #7 state text string
log_archive_dest_state_8 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #8 state text string
log_archive_dest_state_9 oradg11g enable enable
TRUE
IMMEDIATE
FALSE archival destination #9 state text string
log_archive_duplex_dest oradg11g    
TRUE
IMMEDIATE
FALSE duplex archival destination text string
log_archive_format oradg11g %t_%s_%r.dbf %t_%s_%r.dbf
TRUE
FALSE
FALSE archival destination format
log_archive_local_first oradg11g TRUE TRUE
TRUE
IMMEDIATE
TRUE Establish EXPEDITE attribute default value
log_archive_max_processes oradg11g 4 4
FALSE
IMMEDIATE
FALSE maximum number of active ARCH processes
log_archive_min_succeed_dest oradg11g 1 1
TRUE
IMMEDIATE
FALSE minimum number of archive destinations that must succeed
log_archive_start oradg11g FALSE FALSE
TRUE
FALSE
TRUE start archival process on SGA initialization
log_archive_trace oradg11g 0 0
TRUE
IMMEDIATE
FALSE Establish archivelog operation tracing level
log_buffer oradg11g 8110080 8110080
TRUE
FALSE
FALSE redo circular buffer size
log_checkpoint_interval oradg11g 0 0
TRUE
IMMEDIATE
FALSE # redo blocks checkpoint threshold
log_checkpoint_timeout oradg11g 1800 1800
TRUE
IMMEDIATE
FALSE Maximum time interval between checkpoints in seconds
log_checkpoints_to_alert oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE log checkpoint begin/end to alert file
log_file_name_convert oradg11g oradglg, oradg11g oradglg, oradg11g
FALSE
FALSE
FALSE logfile name convert patterns and strings for standby/clone db
max_dispatchers oradg11g    
TRUE
IMMEDIATE
FALSE max number of dispatchers
max_dump_file_size oradg11g unlimited unlimited
TRUE
IMMEDIATE
FALSE Maximum size (in bytes) of dump file
max_enabled_roles oradg11g 150 150
TRUE
FALSE
TRUE max number of roles a user can have enabled
max_shared_servers oradg11g    
TRUE
IMMEDIATE
FALSE max number of shared servers
memory_max_target oradg11g 419430400 400M
FALSE
FALSE
FALSE Max size for Memory Target
memory_target oradg11g 314572800 300M
FALSE
IMMEDIATE
FALSE Target size of Oracle SGA and PGA memory
nls_calendar oradg11g GREGORIAN GREGORIAN
TRUE
FALSE
FALSE NLS calendar system name
nls_comp oradg11g BINARY BINARY
TRUE
FALSE
FALSE NLS comparison
nls_currency oradg11g
TRUE
FALSE
FALSE NLS local currency symbol
nls_date_format oradg11g YYYY-MM-DD HH24:mi:ss YYYY-MM-DD HH24:mi:ss
TRUE
FALSE
FALSE NLS Oracle date format
nls_date_language oradg11g AMERICAN AMERICAN
TRUE
FALSE
FALSE NLS date language name
nls_dual_currency oradg11g
TRUE
FALSE
FALSE Dual currency symbol
nls_iso_currency oradg11g CHINA CHINA
TRUE
FALSE
FALSE NLS ISO currency territory name
nls_language oradg11g AMERICAN AMERICAN
TRUE
FALSE
FALSE NLS language name
nls_length_semantics oradg11g BYTE BYTE
TRUE
IMMEDIATE
FALSE create columns using byte or char semantics by default
nls_nchar_conv_excp oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE NLS raise an exception instead of allowing implicit conversion
nls_numeric_characters oradg11g ., .,
TRUE
FALSE
FALSE NLS numeric characters
nls_sort oradg11g BINARY BINARY
TRUE
FALSE
FALSE NLS linguistic definition name
nls_territory oradg11g CHINA CHINA
TRUE
FALSE
FALSE NLS territory name
nls_time_format oradg11g HH.MI.SSXFF AM HH.MI.SSXFF AM
TRUE
FALSE
FALSE time format
nls_time_tz_format oradg11g HH.MI.SSXFF AM TZR HH.MI.SSXFF AM TZR
TRUE
FALSE
FALSE time with timezone format
nls_timestamp_format oradg11g DD-MON-RR HH.MI.SSXFF AM DD-MON-RR HH.MI.SSXFF AM
TRUE
FALSE
FALSE time stamp format
nls_timestamp_tz_format oradg11g DD-MON-RR HH.MI.SSXFF AM TZR DD-MON-RR HH.MI.SSXFF AM TZR
TRUE
FALSE
FALSE timestamp with timezone format
object_cache_max_size_percent oradg11g 10 10
TRUE
DEFERRED
FALSE percentage of maximum size over optimal of the user session's object cache
object_cache_optimal_size oradg11g 102400 102400
TRUE
DEFERRED
FALSE optimal size of the user session's object cache in bytes
olap_page_pool_size oradg11g 0 0
TRUE
DEFERRED
FALSE size of the olap page pool in bytes
open_cursors oradg11g 300 300
FALSE
IMMEDIATE
FALSE max # cursors per session
open_links oradg11g 4 4
TRUE
FALSE
FALSE max # open links per session
open_links_per_instance oradg11g 4 4
TRUE
FALSE
FALSE max # open links per instance
optimizer_capture_sql_plan_baselines oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE automatic capture of SQL plan baselines for repeatable statements
optimizer_dynamic_sampling oradg11g 2 2
TRUE
IMMEDIATE
FALSE optimizer dynamic sampling
optimizer_features_enable oradg11g 11.2.0.3 11.2.0.3
TRUE
IMMEDIATE
FALSE optimizer plan compatibility parameter
optimizer_index_caching oradg11g 0 0
TRUE
IMMEDIATE
FALSE optimizer percent index caching
optimizer_index_cost_adj oradg11g 100 100
TRUE
IMMEDIATE
FALSE optimizer index cost adjustment
optimizer_mode oradg11g ALL_ROWS ALL_ROWS
TRUE
IMMEDIATE
FALSE optimizer mode
optimizer_secure_view_merging oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE optimizer secure view merging and predicate pushdown/movearound
optimizer_use_invisible_indexes oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE Usage of invisible indexes (TRUE/FALSE)
optimizer_use_pending_statistics oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE Control whether to use optimizer pending statistics
optimizer_use_sql_plan_baselines oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE use of SQL plan baselines for captured sql statements
os_authent_prefix oradg11g ops$ ops$
TRUE
FALSE
FALSE prefix for auto-logon accounts
os_roles oradg11g FALSE FALSE
TRUE
FALSE
FALSE retrieve roles from the operating system
parallel_adaptive_multi_user oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE enable adaptive setting of degree for multiple user streams
parallel_automatic_tuning oradg11g FALSE FALSE
TRUE
FALSE
TRUE enable intelligent defaults for parallel execution parameters
parallel_degree_limit oradg11g CPU CPU
TRUE
IMMEDIATE
FALSE limit placed on degree of parallelism
parallel_degree_policy oradg11g MANUAL MANUAL
TRUE
IMMEDIATE
FALSE policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
parallel_execution_message_size oradg11g 16384 16384
TRUE
FALSE
FALSE message buffer size for parallel execution
parallel_force_local oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE force single instance execution
parallel_instance_group oradg11g    
TRUE
IMMEDIATE
FALSE instance group to use for all parallel operations
parallel_io_cap_enabled oradg11g FALSE FALSE
TRUE