我的oracle 健康检查报告


       最近一直想用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_ROLESUPPLEMESUP
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_IDDB_NAMEDBIDINSTANCE_NAMEINSTANCE_NUMBERSTARTUP_TIMERELEASERACHOST_NAMEPLATFORM_NAMECPUSCORESSOCKETSMemory (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 NameInstance NameValueDISPLAY_VALUEIs Default?Is Dynamic?ISDEPRECATEDDESCRIPTION
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
IMMEDIATE
TRUE enable capping DOP by IO bandwidth
parallel_max_servers oradg11g 80 80
TRUE
IMMEDIATE
FALSE maximum parallel query servers per instance
parallel_min_percent oradg11g 0 0
TRUE
FALSE
FALSE minimum percent of threads required for parallel query
parallel_min_servers oradg11g 0 0
TRUE
IMMEDIATE
FALSE minimum parallel query servers per instance
parallel_min_time_threshold oradg11g AUTO AUTO
TRUE
IMMEDIATE
FALSE threshold above which a plan is a candidate for parallelization (in seconds)
parallel_server oradg11g FALSE FALSE
TRUE
FALSE
TRUE if TRUE startup in parallel server mode
parallel_server_instances oradg11g 1 1
TRUE
FALSE
TRUE number of instances to use for sizing OPS SGA structures
parallel_servers_target oradg11g 32 32
TRUE
IMMEDIATE
FALSE instance target in terms of number of parallel servers
parallel_threads_per_cpu oradg11g 2 2
TRUE
IMMEDIATE
FALSE number of parallel execution threads per CPU
permit_92_wrap_format oradg11g TRUE TRUE
TRUE
FALSE
FALSE allow 9.2 or older wrap format in PL/SQL
pga_aggregate_target oradg11g 0 0
TRUE
IMMEDIATE
FALSE Target size for the aggregate PGA memory consumed by the instance
plscope_settings oradg11g IDENTIFIERS:NONE IDENTIFIERS:NONE
TRUE
IMMEDIATE
FALSE plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
plsql_ccflags oradg11g    
TRUE
IMMEDIATE
FALSE PL/SQL ccflags
plsql_code_type oradg11g INTERPRETED INTERPRETED
TRUE
IMMEDIATE
FALSE PL/SQL code-type
plsql_debug oradg11g FALSE FALSE
TRUE
IMMEDIATE
TRUE PL/SQL debug
plsql_optimize_level oradg11g 2 2
TRUE
IMMEDIATE
FALSE PL/SQL optimize level
plsql_v2_compatibility oradg11g FALSE FALSE
TRUE
IMMEDIATE
TRUE PL/SQL version 2.x compatibility flag
plsql_warnings oradg11g DISABLE:ALL DISABLE:ALL
TRUE
IMMEDIATE
FALSE PL/SQL compiler warnings settings
pre_page_sga oradg11g FALSE FALSE
TRUE
FALSE
FALSE pre-page sga for process
processes oradg11g 150 150
FALSE
FALSE
FALSE user processes
processor_group_name oradg11g    
TRUE
FALSE
FALSE Name of the processor group that this instance should run in.
query_rewrite_enabled oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE allow rewrite of queries using materialized views if enabled
query_rewrite_integrity oradg11g enforced enforced
TRUE
IMMEDIATE
FALSE perform rewrite using materialized views with desired integrity
rdbms_server_dn oradg11g    
TRUE
FALSE
FALSE RDBMS's Distinguished Name
read_only_open_delayed oradg11g FALSE FALSE
TRUE
FALSE
FALSE if TRUE delay opening of read only files until first access
recovery_parallelism oradg11g 0 0
TRUE
FALSE
FALSE number of server processes to use for parallel recovery
recyclebin oradg11g on on
TRUE
DEFERRED
FALSE recyclebin processing
redo_transport_user oradg11g    
TRUE
IMMEDIATE
FALSE Data Guard transport user when using password file
remote_dependencies_mode oradg11g TIMESTAMP TIMESTAMP
TRUE
IMMEDIATE
FALSE remote-procedure-call dependencies mode parameter
remote_listener oradg11g    
TRUE
IMMEDIATE
FALSE remote listener
remote_login_passwordfile oradg11g EXCLUSIVE EXCLUSIVE
FALSE
FALSE
FALSE password file usage parameter
remote_os_authent oradg11g FALSE FALSE
TRUE
FALSE
TRUE allow non-secure remote clients to use auto-logon accounts
remote_os_roles oradg11g FALSE FALSE
TRUE
FALSE
FALSE allow non-secure remote clients to use os roles
replication_dependency_tracking oradg11g TRUE TRUE
TRUE
FALSE
FALSE tracking dependency for Replication parallel propagation
resource_limit oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE master switch for resource limit
resource_manager_cpu_allocation oradg11g 2 2
TRUE
IMMEDIATE
TRUE Resource Manager CPU allocation
resource_manager_plan oradg11g    
TRUE
IMMEDIATE
FALSE resource mgr top plan
result_cache_max_result oradg11g 5 5
TRUE
IMMEDIATE
FALSE maximum result size as percent of cache size
result_cache_max_size oradg11g 786432 768K
TRUE
IMMEDIATE
FALSE maximum amount of memory to be used by the cache
result_cache_mode oradg11g MANUAL MANUAL
TRUE
IMMEDIATE
FALSE result cache operator usage mode
result_cache_remote_expiration oradg11g 0 0
TRUE
IMMEDIATE
FALSE maximum life time (min) for any result using a remote object
resumable_timeout oradg11g 0 0
TRUE
IMMEDIATE
FALSE set resumable_timeout
rollback_segments oradg11g    
TRUE
FALSE
FALSE undo segment list
sec_case_sensitive_logon oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE case sensitive password enabled for logon
sec_max_failed_login_attempts oradg11g 10 10
TRUE
FALSE
FALSE maximum number of failed login attempts on a connection
sec_protocol_error_further_action oradg11g CONTINUE CONTINUE
TRUE
IMMEDIATE
FALSE TTC protocol error continue action
sec_protocol_error_trace_action oradg11g TRACE TRACE
TRUE
IMMEDIATE
FALSE TTC protocol error action
sec_return_server_release_banner oradg11g FALSE FALSE
TRUE
FALSE
FALSE whether the server retruns the complete version information
serial_reuse oradg11g disable disable
TRUE
FALSE
TRUE reuse the frame segments
service_names oradg11g oradg11g oradg11g
TRUE
IMMEDIATE
FALSE service names supported by the instance
session_cached_cursors oradg11g 50 50
TRUE
FALSE
FALSE Number of cursors to cache in a session.
session_max_open_files oradg11g 10 10
TRUE
FALSE
FALSE maximum number of open files allowed per session
sessions oradg11g 248 248
TRUE
FALSE
FALSE user and system sessions
sga_max_size oradg11g 419430400 400M
TRUE
FALSE
FALSE max total SGA size
sga_target oradg11g 0 0
TRUE
IMMEDIATE
FALSE Target size of SGA
shadow_core_dump oradg11g partial partial
TRUE
FALSE
FALSE Core Size for Shadow Processes
shared_memory_address oradg11g 0 0
TRUE
FALSE
FALSE SGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_size oradg11g 8178892 8178892
TRUE
FALSE
FALSE size in bytes of reserved area of shared pool
shared_pool_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE size in bytes of shared pool
shared_server_sessions oradg11g    
TRUE
IMMEDIATE
FALSE max number of shared server sessions
shared_servers oradg11g 1 1
TRUE
IMMEDIATE
FALSE number of shared servers to start up
skip_unusable_indexes oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE skip unusable indexes if set to TRUE
smtp_out_server oradg11g    
TRUE
IMMEDIATE
FALSE utl_smtp server and port configuration parameter
sort_area_retained_size oradg11g 0 0
TRUE
DEFERRED
FALSE size of in-memory sort work area retained between fetch calls
sort_area_size oradg11g 65536 65536
TRUE
DEFERRED
FALSE size of in-memory sort work area
spfile oradg11g /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora
TRUE
IMMEDIATE
FALSE server parameter file
sql92_security oradg11g FALSE FALSE
TRUE
FALSE
FALSE require select privilege for searched update/delete
sql_trace oradg11g FALSE FALSE
TRUE
IMMEDIATE
TRUE enable SQL trace
sqltune_category oradg11g DEFAULT DEFAULT
TRUE
IMMEDIATE
FALSE Category qualifier for applying hintsets
standby_archive_dest oradg11g ?/dbs/arch ?/dbs/arch
TRUE
IMMEDIATE
TRUE standby database archivelog destination text string
standby_file_management oradg11g AUTO AUTO
FALSE
IMMEDIATE
FALSE if auto then files are created/dropped automatically on standby
star_transformation_enabled oradg11g FALSE FALSE
TRUE
IMMEDIATE
FALSE enable the use of star transformation
statistics_level oradg11g TYPICAL TYPICAL
TRUE
IMMEDIATE
FALSE statistics level
streams_pool_size oradg11g 0 0
TRUE
IMMEDIATE
FALSE size in bytes of the streams pool
tape_asynch_io oradg11g TRUE TRUE
TRUE
FALSE
FALSE Use asynch I/O requests for tape devices
thread oradg11g 0 0
TRUE
IMMEDIATE
FALSE Redo thread to mount
timed_os_statistics oradg11g 0 0
TRUE
IMMEDIATE
FALSE internal os statistic gathering interval in seconds
timed_statistics oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE maintain internal timing statistics
trace_enabled oradg11g TRUE TRUE
TRUE
IMMEDIATE
FALSE enable in memory tracing
tracefile_identifier oradg11g    
TRUE
FALSE
FALSE trace file custom identifier
transactions oradg11g 272 272
TRUE
FALSE
FALSE max. number of concurrent active transactions
transactions_per_rollback_segment oradg11g 5 5
TRUE
FALSE
FALSE number of active transactions per rollback segment
undo_management oradg11g AUTO AUTO
TRUE
FALSE
FALSE instance runs in SMU mode if TRUE, else in RBU mode
undo_retention oradg11g 900 900
TRUE
IMMEDIATE
FALSE undo retention in seconds
undo_tablespace oradg11g UNDOTBS1 UNDOTBS1
FALSE
IMMEDIATE
FALSE use/switch undo tablespace
use_indirect_data_buffers oradg11g FALSE FALSE
TRUE
FALSE
FALSE Enable indirect data buffers (very large SGA on 32-bit platforms)
use_large_pages oradg11g TRUE TRUE
TRUE
FALSE
FALSE Use large pages if available (TRUE/FALSE/ONLY)
user_dump_dest oradg11g /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace
TRUE
IMMEDIATE
TRUE User process dump directory
utl_file_dir oradg11g    
TRUE
FALSE
FALSE utl_file accessible directories list
workarea_size_policy oradg11g AUTO AUTO
TRUE
IMMEDIATE
FALSE policy used to size SQL working areas (MANUAL/AUTO)
xml_db_events oradg11g enable enable
TRUE
IMMEDIATE
FALSE are XML DB events enabled

 

[回到目录] [上一项]





关键的初始化参数


 

参数名称实例名称参数值
cpu_count oradg11g 2
cursor_sharing oradg11g EXACT
db_block_size oradg11g 8192
db_cache_size oradg11g 0
db_file_multiblock_read_count oradg11g 7
instance_name oradg11g oradg11g
instance_number oradg11g 0
java_pool_size oradg11g 0
job_queue_processes oradg11g 1000
large_pool_size oradg11g 0
local_listener oradg11g  
log_archive_dest_1 oradg11g LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
log_buffer oradg11g 8110080
open_cursors oradg11g 300
optimizer_index_caching oradg11g 0
optimizer_index_cost_adj oradg11g 100
optimizer_mode oradg11g ALL_ROWS
pga_aggregate_target oradg11g 0
processes oradg11g 150
sessions oradg11g 248
sga_max_size oradg11g 419430400
sga_target oradg11g 0
shared_pool_size oradg11g 0
sort_area_size oradg11g 65536
spfile oradg11g /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora
thread oradg11g 0

 

[回到目录]



数据库大小


 

dmp全备份约(G)RMAN全备份约(G)数据文件容量(G)
2
2 3

 

[回到目录]





资源使用情况


 

资源名称当前值最大值初始值限制值
processes 37 52 150 150
sessions 45 58 248 248
enqueue_locks 28 55 3160 3160
enqueue_resources 22 44 1308 UNLIMITED
ges_procs 0 0 0 0
ges_ress 0 0 0 UNLIMITED
ges_locks 0 0 0 UNLIMITED
ges_cache_ress 0 0 0 UNLIMITED
ges_reg_msgs 0 0 0 UNLIMITED
ges_big_msgs 0 0 0 UNLIMITED
ges_rsv_msgs 0 0 0 0
gcs_resources 0 0 UNLIMITED UNLIMITED
gcs_shadows 0 0 UNLIMITED UNLIMITED
smartio_overhead_memory 0 0 0 UNLIMITED
smartio_buffer_memory 0 0 0 UNLIMITED
smartio_metadata_memory 0 0 0 UNLIMITED
smartio_sessions 0 0 0 UNLIMITED
dml_locks 0 0 1088 UNLIMITED
temporary_table_locks 0 0 UNLIMITED UNLIMITED
transactions 0 0 272 UNLIMITED
branches 0 0 272 UNLIMITED
cmtcallbk 0 1 272 UNLIMITED
max_rollback_segments 11 11 272 65535
sort_segment_locks 1 3 UNLIMITED UNLIMITED
k2q_locks 0 0 496 UNLIMITED
max_shared_servers 1 1 UNLIMITED UNLIMITED
parallel_max_servers 0 16 80 3600

 

[回到目录]





表空间情况


 



表空间状况


 

状态表空间名称表空间类型扩展管理方段管理方�表空间大小(MB)空闲(MB)使用(MB)Pct. Used
ONLINE
EXAMPLE PERMANENT LOCAL AUTO 346 36 310
89 %
ONLINE
LOGMNRTBS PERMANENT LOCAL AUTO 355 255 100
28 %
ONLINE
SYSAUX PERMANENT LOCAL AUTO 580 50 530
91 %
ONLINE
SYSTEM PERMANENT LOCAL MANUAL 860 127 733
85 %
ONLINE
TEMP TEMPORARY LOCAL MANUAL 29 18 11
37 %
ONLINE
UNDOTBS1 UNDO LOCAL MANUAL 95 60 36
37 %
ONLINE
USERS PERMANENT LOCAL AUTO 41 3 38
92 %
          -------------------- -------------------- --------------------  
Total:         2,306 548 1,758  

 

TS#TS_NAMECONTENTSTS_SIZE_MFREE_SIZE_MUSED_SIZE_MUSED_PERMAX_SIZE_GMAX_SIZE_FREE_GUSED_PER_MAXBLOCK_SIZELOGGING状态TS_DF_COUNTDATA_FILE_NAMEFOREXTENT_MANSEGMENRETENTIONDEF_TAB_
0 SYSTEM PERMANENT 860 127 733 85.276 32 31.284 2.238 8192 LOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/system01.dbf NO LOCAL MANUAL NOT APPLY DISABLED
1 SYSAUX PERMANENT 580 50 530 91.369 32 31.482 1.617 8192 LOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/sysaux01.dbf NO LOCAL AUTO NOT APPLY DISABLED
2 UNDOTBS1 UNDO 95 60 36 37.368 32 31.965 .108 8192 LOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/undotbs01.dbf NO LOCAL MANUAL NOGUARANTEE DISABLED
3 TEMP TEMPORARY 29 27 2 6.897 32 31.998 .006 8192 NOLOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/temp01.dbf NO LOCAL MANUAL NOT APPLY DISABLED
4 USERS PERMANENT 41 3 38 92.879 32 31.963 .117 8192 LOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/users01.dbf NO LOCAL AUTO NOT APPLY DISABLED
6 EXAMPLE PERMANENT 346 36 310 89.729 32 31.697 .946 8192 NOLOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/example01.dbf NO LOCAL AUTO NOT APPLY DISABLED
7 LOGMNRTBS PERMANENT 355 255 100 28.169 1.953 1.855 5 8192 LOGGING ONLINE 1 /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf NO LOCAL AUTO NOT APPLY DISABLED
  所有表空间   2305.875 557 1749 75.861 194 192.245                      

 

[回到目录]



数据库闪回空间使用情况



● 数据库闪回空间总体使用情况


 

NAMELIMIT_GBUSED_GBUSED%RECLAIM_GBFILE#
/u01/app/oracle/flash_recovery_area 4.025 .6 14.904 .46 63

 

[回到目录]



● 数据库闪回空间详细使用情况


 

TYPEUSED_GBUSED%RECLAIMABLE%RECLAIM_GBFILES#
ARCHIVED LOG .091 2.26 0 0 45
BACKUP PIECE 0 0 0 0 0
CONTROL FILE 0 0 0 0 0
FLASHBACK LOG .488 12.13 10.92 .44 10
FOREIGN ARCHIVED LOG .021 .52 .51 .021 8
IMAGE COPY 0 0 0 0 0
REDO LOG 0 0 0 0 0
  ---------- ---------- ------------ ---------- ----------
.6 14.91 11.43 .461 63

 

[回到目录]



临时表空间使用情况


 

NameSize (M)HWM (M)HWM %Using (M)Using %
TEMP 29.000 11.000 37.93 1.000 3.45

 

[回到目录]



查谁占用了undo表空间


 

[回到目录]



数据文件状况


 

Tablespace Name / File ClassFilenameFile SizeAutoextensibleNextMax
EXAMPLE /u01/app/oracle/oradata/oradg11g/example01.dbf 362,414,080
YES
655,360 34,359,721,984
LOGMNRTBS /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 372,244,480
YES
5,242,880 2,097,152,000
SYSAUX /u01/app/oracle/oradata/oradg11g/sysaux01.dbf 608,174,080
YES
10,485,760 34,359,721,984
SYSTEM /u01/app/oracle/oradata/oradg11g/system01.dbf 901,775,360
YES
10,485,760 34,359,721,984
TEMP /u01/app/oracle/oradata/oradg11g/temp01.dbf 30,408,704
YES
655,360 34,359,721,984
UNDOTBS1 /u01/app/oracle/oradata/oradg11g/undotbs01.dbf 99,614,720
YES
5,242,880 34,359,721,984
USERS /u01/app/oracle/oradata/oradg11g/users01.dbf 43,253,760
YES
1,310,720 34,359,721,984
[ CONTROL FILE ] /u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl        
[ CONTROL FILE ] /u01/app/oracle/oradata/oradg11g/control01.ctl        
[ ONLINE REDO LOG ] /u01/app/oracle/oradata/oradg11g/redo01.log 52,428,800      
[ ONLINE REDO LOG ] /u01/app/oracle/oradata/oradg11g/redo02.log 52,428,800      
[ ONLINE REDO LOG ] /u01/app/oracle/oradata/oradg11g/redo03.log 52,428,800      
    --------------------      
Total:   2,575,171,584      

 

FILE_IDTABLESPACE_NAMETS_SIZE_MFILE_NAMEFILE_SIZE_MFILE_MAX_SIZE_GAutINCREMENT_MAUTOEXTEND_RATIO
5 EXAMPLE 345.63 /u01/app/oracle/oradata/oradg11g/example01.dbf 345.63 32 YES .63 1.05
6 LOGMNRTBS 355 /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 355 1.95 YES 5 17.75
2 SYSAUX 580 /u01/app/oracle/oradata/oradg11g/sysaux01.dbf 580 32 YES 10 1.77
1 SYSTEM 860 /u01/app/oracle/oradata/oradg11g/system01.dbf 860 32 YES 10 2.62
1 TEMP 29 /u01/app/oracle/oradata/oradg11g/temp01.dbf 29 32 YES .63 .09
3 UNDOTBS1 95 /u01/app/oracle/oradata/oradg11g/undotbs01.dbf 95 32 YES 5 .29
4 USERS 41.25 /u01/app/oracle/oradata/oradg11g/users01.dbf 41.25 32 YES 1.25 .13

 

[回到目录]



表空间扩展


 

Tablespace NameLargest ExtentSmallest ExtentTotal FreeNumber of Free Extents
EXAMPLE 34,668,544 589,824 37,224,448 3
LOGMNRTBS 200,278,016 1,048,576 267,386,880 10
SYSAUX 35,651,584 65,536 52,494,336 63
SYSTEM 132,120,576 655,360 132,775,936 2
UNDOTBS1 24,117,248 65,536 62,390,272 26
USERS 2,359,296 65,536 3,080,192 3
  -------------------- -------------------- -------------------- ----------------------
Total: 429,195,264 2,490,368 555,352,064 107

 

[回到目录]



观察回滚段,临时段及普通段否是自动扩展



● 回滚段


 

FILE_NAMETABLESPACE_NAMESIZE_MAUTONLINE_
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf UNDOTBS1 95 YES ONLINE

● 临时段


 

FILE_NAMESIZE_MSTATUSAUT
/u01/app/oracle/oradata/oradg11g/temp01.dbf 29 ONLINE YES

● 普通段


 

FILE_NAMETABLESPACE_NAMESTATUSSIZE_MAUT
/u01/app/oracle/oradata/oradg11g/users01.dbf USERS AVAILABLE 41.25 YES
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf UNDOTBS1 AVAILABLE 95 YES
/u01/app/oracle/oradata/oradg11g/sysaux01.dbf SYSAUX AVAILABLE 580 YES
/u01/app/oracle/oradata/oradg11g/system01.dbf SYSTEM AVAILABLE 860 YES
/u01/app/oracle/oradata/oradg11g/example01.dbf EXAMPLE AVAILABLE 345.625 YES
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf LOGMNRTBS AVAILABLE 355 YES

● 所有段


 

FILE_IDTABLESPACE_NAMETS_SIZE_MFILE_NAMEFILE_SIZE_MFILE_MAX_SIZEAUTINCREMENT_BYSTATUSINCREMENT_BY_BLOCKBYTESBLOCKSMAXBYTESMAXBLOCKSUSER_BYTESUSER_BLOCKS
5 EXAMPLE 345.625 /u01/app/oracle/oradata/oradg11g/example01.dbf 345.625 32767.984 YES .625 AVAILABLE 80 362414080 44240 3.4360E+10 4194302 361365504 44112
6 LOGMNRTBS 355 /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 355 2000 YES 5 AVAILABLE 640 372244480 45440 2097152000 256000 371195904 45312
2 SYSAUX 580 /u01/app/oracle/oradata/oradg11g/sysaux01.dbf 580 32767.984 YES 10 AVAILABLE 1280 608174080 74240 3.4360E+10 4194302 607125504 74112
1 SYSTEM 860 /u01/app/oracle/oradata/oradg11g/system01.dbf 860 32767.984 YES 10 AVAILABLE 1280 901775360 110080 3.4360E+10 4194302 900726784 109952
1 TEMP 29 /u01/app/oracle/oradata/oradg11g/temp01.dbf 29 32767.984 YES .625 ONLINE 80 30408704 3712 3.4360E+10 4194302 29360128 3584
3 UNDOTBS1 95 /u01/app/oracle/oradata/oradg11g/undotbs01.dbf 95 32767.984 YES 5 AVAILABLE 640 99614720 12160 3.4360E+10 4194302 98566144 12032
4 USERS 41.25 /u01/app/oracle/oradata/oradg11g/users01.dbf 41.25 32767.984 YES 1.25 AVAILABLE 160 43253760 5280 3.4360E+10 4194302 42205184 5152

 

[回到目录]





表空间所有者


 

Tablespace NameOwnerSegment TypeSize (in Bytes)Segment Count
EXAMPLE
HR
INDEX
1,245,184 19
 
HR
TABLE
393,216 6
 
IX
INDEX
917,504 14
 
IX
LOBINDEX
196,608 3
 
IX
LOBSEGMENT
196,608 3
 
IX
TABLE
524,288 8
 
OE
INDEX
2,162,688 22
 
OE
LOBINDEX
327,680 5
 
OE
LOBSEGMENT
393,216 5
 
OE
TABLE
3,735,552 8
 
PM
INDEX
262,144 4
 
PM
LOBINDEX
1,114,112 17
 
PM
LOBSEGMENT
11,206,656 17
 
PM
NESTED TABLE
65,536 1
 
PM
TABLE
196,608 2
 
SH
INDEX PARTITION
11,141,120 112
 
SH
INDEX
2,490,368 19
 
SH
LOBINDEX
131,072 2
 
SH
LOBSEGMENT
131,072 2
 
SH
TABLE PARTITION
268,435,456 32
 
SH
TABLE
18,874,368 12
LOGMNRTBS
SYSTEM
INDEX PARTITION
23,199,744 104
 
SYSTEM
INDEX
917,504 14
 
SYSTEM
LOBINDEX
589,824 6
 
SYSTEM
LOBSEGMENT
4,521,984 6
 
SYSTEM
TABLE PARTITION
73,662,464 76
 
SYSTEM
TABLE
917,504 14
SYSAUX
APEX_030200
INDEX
39,976,960 262
 
APEX_030200
LOBINDEX
3,276,800 50
 
APEX_030200
LOBSEGMENT
10,420,224 50
 
APEX_030200
TABLE
35,913,728 105
 
CTXSYS
INDEX
2,490,368 38
 
CTXSYS
LOBINDEX
131,072 2
 
CTXSYS
LOBSEGMENT
131,072 2
 
CTXSYS
TABLE
1,179,648 17
 
DBSNMP
INDEX
327,680 5
 
DBSNMP
TABLE
196,608 3
 
EXFSYS
INDEX
2,424,832 37
 
EXFSYS
LOBINDEX
65,536 1
 
EXFSYS
LOBSEGMENT
65,536 1
 
EXFSYS
TABLE
1,245,184 19
 
MDSYS
INDEX
7,405,568 98
 
MDSYS
LOBINDEX
12,976,128 197
 
MDSYS
LOBSEGMENT
41,877,504 197
 
MDSYS
NESTED TABLE
1,048,576 16
 
MDSYS
TABLE
14,221,312 64
 
OLAPSYS
INDEX
5,242,880 80
 
OLAPSYS
TABLE
3,997,696 61
 
ORDDATA
INDEX
6,946,816 95
 
ORDDATA
LOBINDEX
393,216 6
 
ORDDATA
LOBSEGMENT
3,014,656 6
 
ORDDATA
NESTED TABLE
131,072 2
 
ORDDATA
TABLE
3,735,552 51
 
ORDSYS
INDEX
196,608 3
 
ORDSYS
TABLE
262,144 4
 
SYS
CLUSTER
2,097,152 1
 
SYS
INDEX PARTITION
4,521,984 54
 
SYS
INDEX
37,355,520 358
 
SYS
LOB PARTITION
65,536 1
 
SYS
LOBINDEX
4,063,232 62
 
SYS
LOBSEGMENT
45,744,128 62
 
SYS
TABLE PARTITION
4,784,128 51
 
SYS
TABLE SUBPARTITION
2,097,152 32
 
SYS
TABLE
35,913,728 302
 
SYSMAN
INDEX
24,969,216 301
 
SYSMAN
LOBINDEX
2,818,048 43
 
SYSMAN
LOBSEGMENT
3,407,872 43
 
SYSMAN
NESTED TABLE
131,072 2
 
SYSMAN
TABLE
16,842,752 190
 
SYSTEM
INDEX
524,288 8
 
SYSTEM
LOBINDEX
131,072 2
 
SYSTEM
LOBSEGMENT
131,072 2
 
SYSTEM
TABLE PARTITION
65,536 1
 
SYSTEM
TABLE
655,360 10
 
WMSYS
INDEX
1,966,080 30
 
WMSYS
LOBINDEX
327,680 5
 
WMSYS
LOBSEGMENT
327,680 5
 
WMSYS
NESTED TABLE
131,072 2
 
WMSYS
TABLE
917,504 14
 
XDB
INDEX
9,502,720 109
 
XDB
LOBINDEX
38,338,560 585
 
XDB
LOBSEGMENT
95,223,808 585
 
XDB
NESTED TABLE
655,360 10
 
XDB
TABLE
21,626,880 83
SYSTEM
OUTLN
INDEX
262,144 4
 
OUTLN
LOBINDEX
65,536 1
 
OUTLN
LOBSEGMENT
65,536 1
 
OUTLN
TABLE
196,608 3
 
SYS
CLUSTER
51,707,904 9
 
SYS
INDEX
148,373,504 642
 
SYS
LOBINDEX
7,602,176 116
 
SYS
LOBSEGMENT
20,578,304 116
 
SYS
NESTED TABLE
1,048,576 16
 
SYS
ROLLBACK
393,216 1
 
SYS
TABLE
520,880,128 531
 
SYSTEM
INDEX
9,043,968 138
 
SYSTEM
LOBINDEX
917,504 14
 
SYSTEM
LOBSEGMENT
917,504 14
 
SYSTEM
TABLE
5,898,240 90
UNDOTBS1
SYS
TYPE2 UNDO
36,175,872 10
USERS
LHR
TABLE
35,979,264 6
 
OE
INDEX
786,432 11
 
OE
LOBINDEX
655,360 10
 
OE
LOBSEGMENT
655,360 10
 
OE
NESTED TABLE
589,824 4
 
OE
TABLE
196,608 2
 
SCOTT
INDEX
131,072 2
 
SCOTT
TABLE
196,608 3
***************************************************************************     -------------------- ----------------
Total:     1,825,898,496 6,712

 

[回到目录]





JOB情况


 



作业运行状况



● dba_jobs


 

作业ID用户作业内容下一次运行时间间隔上一次运行时间失败次数是否损坏?
4001
SYS wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24);
2015-08-26 23:24:32
sysdate + 8/24
2015-08-26 15:24:32
0
N
4002
SYS wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'),wwv_flow_platform.get_preference('SMTP_HOST_PORT'));
2015-08-26 16:14:45
sysdate + 10/1440
2015-08-26 16:04:45
0
N

● dba_scheduler_jobs


 

INSTANCE_IDJOB_CREATOROWNERJOB_NAMEJOB_STATECOMMENTSIJOB_TYPEJOB_ACTIONJOB_STYLEPROGRAM_OWNERPROGRAM_NAMESCHEDULE_TYPREPEAT_INTERVALSTART_DATEEND_DATENEXT_RUN_DATELAST_START_DATELAST_RUN_DURATIONSTART_DATERUN_COUNTNUMBER_OF_ARGUMENTSENABLAUTO_MAX_RUN_DURATIONMAX_FAILURESMAX_RUNSLOGGING_LEVIS_SYRUNNING_INSTANCECPU_USEDUSERNAMESIDSERIAL#SPIDSTATUSCOMMANDLOGON_TIMEOSUSER
  SYS SYS FGR$AUTOPURGE_JOB DISABLED file group auto-purge job N PLSQL_BLOCK sys.dbms_file_group.purge_file_group(NULL); REGULAR     CALENDAR freq=daily;byhour=0;byminute=0;bysecond=0             0 0 FALSE TRUE       OFF TRUE                    
  SYS SYS FILE_WATCHER DISABLED File watcher job N     REGULAR SYS FILE_WATCHER_PROGRAM NAMED               0   FALSE FALSE       OFF TRUE                    
  SYS SYS HM_CREATE_OFFLINE_DICTIONARY DISABLED Create offline dictionary in ADR for DRA name translation N STORED_PROCEDURE dbms_hm.create_offline_dictionary REGULAR     WINDOW_GROUP               0 0 FALSE FALSE       OFF TRUE                    
  SYS SYS XMLDB_NFS_CLEANUP_JOB DISABLED   N STORED_PROCEDURE xdb.dbms_xdbutil_int.cleanup_expired_nfsclients REGULAR     CALENDAR Freq=minutely;interval=5             0 0 FALSE TRUE       OFF TRUE                    
  SYS SYS BSLN_MAINTAIN_STATS_JOB SCHEDULED Oracle defined automatic moving window baseline statistics computation job N     REGULAR SYS BSLN_MAINTAIN_STATS_PROG NAMED   2011-09-18 00:00:00   2015-08-30 00:00:00 2015-08-23 02:35:47 +000000000 00:00:05.752290 18-SEP-11 12.00.00.000000 AM -07:00 8   TRUE FALSE       OFF TRUE                    
  SYS SYS DRA_REEVALUATE_OPEN_FAILURES SCHEDULED Reevaluate open failures for DRA N STORED_PROCEDURE dbms_ir.reevaluateopenfailures REGULAR     WINDOW_GROUP         2015-08-02 00:50:42 +000000000 00:00:00.994666   5 4 TRUE FALSE       OFF TRUE                    
  SYS ORACLE_OCM MGMT_CONFIG_JOB SCHEDULED Configuration collection job. N STORED_PROCEDURE ORACLE_OCM.MGMT_CONFIG.collect_config REGULAR     WINDOW_GROUP         2015-08-02 00:50:42 +000000000 00:00:01.888136   5 0 TRUE FALSE       OFF FALSE                    
  SYS ORACLE_OCM MGMT_STATS_CONFIG_JOB SCHEDULED OCM Statistics collection job. N STORED_PROCEDURE ORACLE_OCM.MGMT_CONFIG.collect_stats REGULAR     CALENDAR freq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=01 2011-09-17 09:52:15   2015-09-01 01:01:01 2015-08-02 00:50:42 +000000000 00:00:02.030012 17-SEP-11 09.52.15.221975 AM -07:00 3 0 TRUE FALSE       OFF FALSE                    
  SYS SYS ORA$AUTOTASK_CLEAN SCHEDULED Delete obsolete AUTOTASK repository data N     REGULAR SYS ORA$AGE_AUTOTASK_DATA NAMED   2011-09-18 03:00:00   2015-08-26 03:00:00 2015-08-26 00:24:33 +000000000 00:00:00.006193 18-SEP-11 03.00.00.000000 AM PST8PDT 24   TRUE FALSE       OFF TRUE                    
  SYS SYS PURGE_LOG SCHEDULED purge log job N     REGULAR SYS PURGE_LOG_PROG NAMED   2011-09-18 03:00:00   2015-08-26 03:00:00 2015-08-26 00:24:33 +000000000 00:00:00.244195 18-SEP-11 03.00.00.200000 AM PST8PDT 24   TRUE FALSE       OFF TRUE                    
  SYS EXFSYS RLM$EVTCLEANUP SCHEDULED   N PLSQL_BLOCK begin dbms_rlmgr_dr.cleanup_events; end; REGULAR     CALENDAR FREQ = HOURLY; INTERVAL = 1 2011-09-17 10:00:15   2015-08-26 02:00:15 2015-08-26 01:00:25 +000000000 00:00:00.033407 17-SEP-11 10.00.15.000000 AM -07:00 128 0 TRUE FALSE       OFF FALSE                    
  SYS EXFSYS RLM$SCHDNEGACTION SCHEDULED   N PLSQL_BLOCK begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end; REGULAR     CALENDAR FREQ=MINUTELY;INTERVAL=60 2015-08-26 16:22:08   2015-08-26 16:22:08 2015-08-26 15:24:32 +000000000 00:00:00.183255 26-AUG-15 04.22.08.000000 PM +08:00 123 0 TRUE FALSE       OFF FALSE                    
  SYS SYS RSE$CLEAN_RECOVERABLE_SCRIPT SCHEDULED auto clean job for recoverable script N PLSQL_BLOCK sys.dbms_streams_auto_int.clean_recoverable_script; REGULAR     CALENDAR freq=daily;byhour=0;byminute=0;bysecond=0 2011-09-17 09:52:27   2015-08-27 00:00:00 2015-08-26 00:24:32 +000000000 00:00:00.050735 17-SEP-11 09.52.27.122955 AM PST8PDT 25 0 TRUE TRUE       OFF TRUE                    
  SYS SYS SM$CLEAN_AUTO_SPLIT_MERGE SCHEDULED auto clean job for auto split merge N PLSQL_BLOCK sys.dbms_streams_auto_int.clean_auto_split_merge; REGULAR     CALENDAR freq=daily;byhour=0;byminute=0;bysecond=0 2011-09-17 09:52:27   2015-08-27 00:00:00 2015-08-26 00:24:32 +000000000 00:00:00.025368 17-SEP-11 09.52.27.133715 AM PST8PDT 25 0 TRUE TRUE       OFF TRUE                    

 

[回到目录]





数据库巡检服务明细

 



RMAN信息


 



RMAN备份状况


 

备份名称开始时间花费时间状态输入类型输出设备输入大小输出大小每秒钟输出率
2015-08-23T23:42:45
2015-08-23 23:42:48
00:00:60
COMPLETED
DB FULL  
2.24G
13.30M
227.07K
2015-08-23T21:55:49
2015-08-23 21:55:54
00:05:02
COMPLETED
DB FULL  
2.24G
4.59M
15.55K
2015-07-27T00:26:45
2015-07-27 00:30:42
00:02:05
COMPLETED
DB FULL DISK
1.63G
1.17G
9.63M

 

[回到目录]



RMAN 配置



All non-default RMAN configuration settings 

[回到目录]



RMAN备份集


 

BS KeyBackup TypeDevice TypeControlfile Included?SPFILE Included?Incremental Level# of PiecesStart TimeEnd TimeElapsed SecondsTagBlock SizeKeep?Keep UntilKeep Options
            ----------------     --------------------          
Total:                            

 

[回到目录]



RMAN备份片


 

[回到目录]



RMAN控制文件备份



Available automatic control files within all available (and expired) backup sets 

[回到目录]



RMAN SPFILE备份



Available automatic SPFILE backups within all available (and expired) backup sets 

[回到目录]



归档信息


 



归档参数配置情况


 

Parameter NameParameter Value
log_archive_config DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)
log_archive_dest  
log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
log_archive_dest_10  
log_archive_dest_11  
log_archive_dest_12  
log_archive_dest_13  
log_archive_dest_14  
log_archive_dest_15  
log_archive_dest_16  
log_archive_dest_17  
log_archive_dest_18  
log_archive_dest_19  
log_archive_dest_2 SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_20  
log_archive_dest_21  
log_archive_dest_22  
log_archive_dest_23  
log_archive_dest_24  
log_archive_dest_25  
log_archive_dest_26  
log_archive_dest_27  
log_archive_dest_28  
log_archive_dest_29  
log_archive_dest_3 SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_30  
log_archive_dest_31  
log_archive_dest_4 SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_5  
log_archive_dest_6  
log_archive_dest_7  
log_archive_dest_8  
log_archive_dest_9  
log_archive_dest_state_1 ENABLE
log_archive_dest_state_10 enable
log_archive_dest_state_11 enable
log_archive_dest_state_12 enable
log_archive_dest_state_13 enable
log_archive_dest_state_14 enable
log_archive_dest_state_15 enable
log_archive_dest_state_16 enable
log_archive_dest_state_17 enable
log_archive_dest_state_18 enable
log_archive_dest_state_19 enable
log_archive_dest_state_2 ENABLE
log_archive_dest_state_20 enable
log_archive_dest_state_21 enable
log_archive_dest_state_22 enable
log_archive_dest_state_23 enable
log_archive_dest_state_24 enable
log_archive_dest_state_25 enable
log_archive_dest_state_26 enable
log_archive_dest_state_27 enable
log_archive_dest_state_28 enable
log_archive_dest_state_29 enable
log_archive_dest_state_3 ENABLE
log_archive_dest_state_30 enable
log_archive_dest_state_31 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_duplex_dest  
log_archive_format %t_%s_%r.dbf
log_archive_local_first TRUE
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 8110080
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert oradglg, oradg11g

 

[回到目录]



归档日志生成情况




● 所有归档日志情况


 

实例名称归档日期每天归档日志量(MB)每小时平均归档日志量(MB)
1
2015-08-26
4
.18
 
2015-08-24
53
2.21
 
2015-08-23
36
1.48
 
2015-08-02
398
16.6
 
2015-07-27
38
1.58
 
2015-07-26
1
.04


● 近7天的归档日志情况


 

实例名称归档日期每天归档日志量(MB)每小时平均归档日志量(MB)
1
2015-08-26
4
.18
 
2015-08-24
53
2.21
 
2015-08-23
36
1.48

 

[回到目录]



查看ARCHIVELOG日志使用率



● 进而观察DB_RECOVERY_FILE_DEST_SIZ参数,后续可以考虑crosscheck archivelog all; delete expired archivelog all; 

NAMESPACE_LIMIT_MSPACE_USED_MPERCENT_SPACE_USEDSPACE_RECLAIMABLEPERCENT_SPACE_RECLAIMABLENUMBER_OF_FILES
/u01/app/oracle/flash_recovery_area 4122 614.332031 .15 471.23 .11 63
CONTROL FILE 4122 0 0 0 0 0
REDO LOG 4122 0 0 0 0 0
ARCHIVED LOG 4122 93.16 2.26 0 0 45
BACKUP PIECE 4122 0 0 0 0 0
IMAGE COPY 4122 0 0 0 0 0
FLASHBACK LOG 4122 500 12.13 450.12 10.92 10
FOREIGN ARCHIVED LOG 4122 21.43 .52 21.02 .51 8
---DISABLED 4122     0 0 1

 

[回到目录]



近7天日志切换频率分析



● 注意观察各行里first_time之间的时间差异会不会很短,很短就是切换过频繁 

THREAD#SEQUENCE#FIRST_TIMEEND_TIMETOTAL_MINLOGSIZE_M
1 90 2015-08-26 15:29:26 2015-08-26 15:29:26 0 3.818
1 90 2015-08-26 15:29:26 2015-08-26 15:54:33 25.12 3.818
1 90 2015-08-26 15:29:26 2015-08-26 15:29:26 0 3.818
1 90 2015-08-26 15:29:26 2015-08-26 15:29:26 0 3.818
1 89 2015-08-26 15:28:56 2015-08-26 15:28:56 0 .041
1 89 2015-08-26 15:28:56 2015-08-26 15:29:26 .5 .041
1 89 2015-08-26 15:28:56 2015-08-26 15:28:56 0 .041
1 89 2015-08-26 15:28:56 2015-08-26 15:28:56 0 .041
1 88 2015-08-26 15:24:28 2015-08-26 15:24:28 0 .522
1 88 2015-08-26 15:24:28 2015-08-26 15:28:56 4.47 .522
1 88 2015-08-26 15:24:28 2015-08-26 15:24:28 0 .522
1 88 2015-08-26 15:24:28 2015-08-26 15:24:28 0 .522
1 87 2015-08-26 15:24:24 2015-08-26 15:24:24 0 .037
1 87 2015-08-26 15:24:24 2015-08-26 15:24:28 .07 .037
1 87 2015-08-26 15:24:24 2015-08-26 15:24:24 0 .037
1 87 2015-08-26 15:24:24 2015-08-26 15:24:24 0 .037
1 86 2015-08-24 00:51:26 2015-08-24 00:51:26 0 2.071
1 86 2015-08-24 00:51:26 2015-08-26 15:24:24 3752.97 2.071
1 86 2015-08-24 00:51:26 2015-08-24 00:51:26 0 2.071
1 86 2015-08-24 00:51:26 2015-08-24 00:51:26 0 2.071
1 85 2015-08-24 00:49:17 2015-08-24 00:49:17 0 .052
1 85 2015-08-24 00:49:17 2015-08-24 00:51:26 2.15 .052
1 85 2015-08-24 00:49:17 2015-08-24 00:49:17 0 .052
1 85 2015-08-24 00:49:17 2015-08-24 00:49:17 0 .052
1 84 2015-08-24 00:49:04 2015-08-24 00:49:04 0 .007
1 84 2015-08-24 00:49:04 2015-08-24 00:49:17 .22 .007
1 84 2015-08-24 00:49:04 2015-08-24 00:49:04 0 .007
1 84 2015-08-24 00:49:04 2015-08-24 00:49:04 0 .007
1 83 2015-08-24 00:48:28 2015-08-24 00:48:28 0 .019
1 83 2015-08-24 00:48:28 2015-08-24 00:49:04 .6 .019
1 83 2015-08-24 00:48:28 2015-08-24 00:48:28 0 .019
1 83 2015-08-24 00:48:28 2015-08-24 00:48:28 0 .019
1 82 2015-08-24 00:46:34 2015-08-24 00:46:34 0 .088
1 82 2015-08-24 00:46:34 2015-08-24 00:48:28 1.9 .088
1 82 2015-08-24 00:46:34 2015-08-24 00:46:34 0 .088
1 82 2015-08-24 00:46:34 2015-08-24 00:46:34 0 .088
1 81 2015-08-24 00:43:16 2015-08-24 00:43:16 0 .114
1 81 2015-08-24 00:43:16 2015-08-24 00:46:34 3.3 .114
1 81 2015-08-24 00:43:16 2015-08-24 00:43:16 0 .114
1 81 2015-08-24 00:43:16 2015-08-24 00:43:16 0 .114
1 80 2015-08-24 00:43:07 2015-08-24 00:43:07 0 .009
1 80 2015-08-24 00:43:07 2015-08-24 00:43:07 0 .009
1 80 2015-08-24 00:43:07 2015-08-24 00:43:16 .15 .009
1 80 2015-08-24 00:43:07 2015-08-24 00:43:07 0 .009
1 80 2015-08-24 00:43:07 2015-08-24 00:43:07 0 .009
1 79 2015-08-24 00:42:45 2015-08-24 00:42:45 0 15.935
1 79 2015-08-24 00:42:45 2015-08-24 00:42:45 0 15.935
1 79 2015-08-24 00:42:45 2015-08-24 00:43:07 .37 15.935
1 79 2015-08-24 00:42:45 2015-08-24 00:42:45 0 15.935
1 79 2015-08-24 00:42:45 2015-08-24 00:42:45 0 15.935
1 78 2015-08-24 00:39:28 2015-08-24 00:39:28 0 34.147
1 78 2015-08-24 00:39:28 2015-08-24 00:42:45 3.28 34.147
1 78 2015-08-24 00:39:28 2015-08-24 00:39:28 0 34.147
1 78 2015-08-24 00:39:28 2015-08-24 00:39:28 0 34.147
1 77 2015-08-24 00:37:27 2015-08-24 00:37:27 0 .059
1 77 2015-08-24 00:37:27 2015-08-24 00:39:28 2.02 .059
1 77 2015-08-24 00:37:27 2015-08-24 00:37:27 0 .059
1 77 2015-08-24 00:37:27 2015-08-24 00:37:27 0 .059
1 76 2015-08-24 00:35:33 2015-08-24 00:35:33 0 .063
1 76 2015-08-24 00:35:33 2015-08-24 00:37:27 1.9 .063
1 76 2015-08-24 00:35:33 2015-08-24 00:35:33 0 .063
1 76 2015-08-24 00:35:33 2015-08-24 00:35:33 0 .063
1 75 2015-08-24 00:35:09 2015-08-24 00:35:09 0 .013
1 75 2015-08-24 00:35:09 2015-08-24 00:35:33 .4 .013
1 75 2015-08-24 00:35:09 2015-08-24 00:35:09 0 .013
1 75 2015-08-24 00:35:09 2015-08-24 00:35:09 0 .013
1 74 2015-08-24 00:34:21 2015-08-24 00:34:21 0 .026
1 74 2015-08-24 00:34:21 2015-08-24 00:35:09 .8 .026
1 74 2015-08-24 00:34:21 2015-08-24 00:34:21 0 .026
1 74 2015-08-24 00:34:21 2015-08-24 00:34:21 0 .026
1 73 2015-08-24 00:34:20 2015-08-24 00:34:20 0 .001
1 73 2015-08-24 00:34:20 2015-08-24 00:34:21 .02 .001
1 73 2015-08-24 00:34:20 2015-08-24 00:34:20 0 .001
1 73 2015-08-24 00:34:20 2015-08-24 00:34:20 0 .001
1 72 2015-08-24 00:31:50 2015-08-24 00:31:50 0 .073
1 72 2015-08-24 00:31:50 2015-08-24 00:34:20 2.5 .073
1 72 2015-08-24 00:31:50 2015-08-24 00:31:50 0 .073
1 72 2015-08-24 00:31:50 2015-08-24 00:31:50 0 .073
1 71 2015-08-24 00:29:25 2015-08-24 00:29:25 0 .056
1 71 2015-08-24 00:29:25 2015-08-24 00:31:50 2.42 .056
1 71 2015-08-24 00:29:25 2015-08-24 00:29:25 0 .056
1 71 2015-08-24 00:29:25 2015-08-24 00:29:25 0 .056
1 70 2015-08-24 00:19:28 2015-08-24 00:19:28 0 .359
1 70 2015-08-24 00:19:28 2015-08-24 00:29:25 9.95 .359
1 70 2015-08-24 00:19:28 2015-08-24 00:19:28 0 .359
1 69 2015-08-23 23:54:16 2015-08-23 23:54:16 0 2.235
1 69 2015-08-23 23:54:16 2015-08-23 23:54:16 0 2.235
1 69 2015-08-23 23:54:16 2015-08-24 00:19:28 25.2 2.235
1 68 2015-08-23 23:52:56 2015-08-23 23:52:56 0 .039
1 68 2015-08-23 23:52:56 2015-08-23 23:54:16 1.33 .039
1 68 2015-08-23 23:52:56 2015-08-23 23:52:56 0 .039
1 68 2015-08-23 23:52:56 2015-08-23 23:52:56 0 .039
1 67 2015-08-23 23:38:22 2015-08-23 23:38:22 0 .494
1 67 2015-08-23 23:38:22 2015-08-23 23:52:56 14.57 .494
1 67 2015-08-23 23:38:22 2015-08-23 23:38:22 0 .494
1 67 2015-08-23 23:38:22 2015-08-23 23:38:22 0 .494
1 66 2015-08-23 23:33:32 2015-08-23 23:33:32 0 .148
1 66 2015-08-23 23:33:32 2015-08-23 23:38:22 4.83 .148
1 66 2015-08-23 23:33:32 2015-08-23 23:33:32 0 .148
1 66 2015-08-23 23:33:32 2015-08-23 23:33:32 0 .148
1 65 2015-08-23 23:19:50 2015-08-23 23:19:50 0 .444
1 65 2015-08-23 23:19:50 2015-08-23 23:33:32 13.7 .444
1 65 2015-08-23 23:19:50 2015-08-23 23:19:50 0 .444
1 65 2015-08-23 23:19:50 2015-08-23 23:19:50 0 .444
1 64 2015-08-23 23:13:50 2015-08-23 23:13:50 0 .178
1 64 2015-08-23 23:13:50 2015-08-23 23:19:50 6 .178
1 64 2015-08-23 23:13:50 2015-08-23 23:13:50 0 .178
1 64 2015-08-23 23:13:50 2015-08-23 23:13:50 0 .178
1 63 2015-08-23 23:05:24 2015-08-23 23:05:24 0 .528
1 63 2015-08-23 23:05:24 2015-08-23 23:13:50 8.43 .528
1 63 2015-08-23 23:05:24 2015-08-23 23:05:24 0 .528
1 63 2015-08-23 23:05:24 2015-08-23 23:05:24 0 .528
1 62 2015-08-23 22:59:45 2015-08-23 22:59:45 0 1.363
1 62 2015-08-23 22:59:45 2015-08-23 23:05:24 5.65 1.363
1 62 2015-08-23 22:59:45 2015-08-23 22:59:45 0 1.363
1 62 2015-08-23 22:59:45 2015-08-23 22:59:45 0 1.363
1 61 2015-08-23 22:45:14 2015-08-23 22:45:14 0 .44
1 61 2015-08-23 22:45:14 2015-08-23 22:59:45 14.52 .44
1 61 2015-08-23 22:45:14 2015-08-23 22:45:14 0 .44
1 61 2015-08-23 22:45:14 2015-08-23 22:45:14 0 .44
1 60 2015-08-23 22:35:37 2015-08-23 22:35:37 0 .304
1 60 2015-08-23 22:35:37 2015-08-23 22:45:14 9.62 .304
1 60 2015-08-23 22:35:37 2015-08-23 22:35:37 0 .304
1 60 2015-08-23 22:35:37 2015-08-23 22:35:37 0 .304
1 59 2015-08-23 22:28:21 2015-08-23 22:28:21 0 .204
1 59 2015-08-23 22:28:21 2015-08-23 22:35:37 7.27 .204
1 59 2015-08-23 22:28:21 2015-08-23 22:28:21 0 .204
1 59 2015-08-23 22:28:21 2015-08-23 22:28:21 0 .204
1 58 2015-08-23 21:19:46 2015-08-23 21:19:46 0 3.721
1 58 2015-08-23 21:19:46 2015-08-23 22:28:21 68.58 3.721
1 58 2015-08-23 21:19:46 2015-08-23 21:19:46 0 3.721
1 58 2015-08-23 21:19:46 2015-08-23 21:19:46 0 3.721
1 57 2015-08-23 20:57:15 2015-08-23 20:57:15 0 2.45
1 57 2015-08-23 20:57:15 2015-08-23 21:19:46 22.52 2.45
1 57 2015-08-23 20:57:15 2015-08-23 20:57:15 0 2.45
1 57 2015-08-23 20:57:15 2015-08-23 20:57:15 0 2.45
1 56 2015-08-23 20:56:56 2015-08-23 20:56:56 0 .012
1 56 2015-08-23 20:56:56 2015-08-23 20:57:15 .32 .012
1 56 2015-08-23 20:56:56 2015-08-23 20:56:56 0 .012
1 56 2015-08-23 20:56:56 2015-08-23 20:56:56 0 .012
1 55 2015-08-23 20:56:52 2015-08-23 20:56:56 .07 .002
1 54 2015-08-23 20:55:07 2015-08-23 20:56:52 1.75 .091
1 53 2015-08-23 20:55:05 2015-08-23 20:55:05 0 .001
1 53 2015-08-23 20:55:05 2015-08-23 20:55:07 .03 .001
1 53 2015-08-23 20:55:05 2015-08-23 20:55:05 0 .001
1 53 2015-08-23 20:55:05 2015-08-23 20:55:05 0 .001
1 52 2015-08-23 20:54:57 2015-08-23 20:54:57 0 .004
1 52 2015-08-23 20:54:57 2015-08-23 20:55:05 .13 .004
1 52 2015-08-23 20:54:57 2015-08-23 20:54:57 0 .004
1 52 2015-08-23 20:54:57 2015-08-23 20:54:57 0 .004
1 51 2015-08-23 20:54:56 2015-08-23 20:54:56 0 .001
1 51 2015-08-23 20:54:56 2015-08-23 20:54:57 .02 .001
1 51 2015-08-23 20:54:56 2015-08-23 20:54:56 0 .001
1 51 2015-08-23 20:54:56 2015-08-23 20:54:56 0 .001
1 50 2015-08-23 20:54:54 2015-08-23 20:54:54 0 .001
1 50 2015-08-23 20:54:54 2015-08-23 20:54:56 .03 .001
1 50 2015-08-23 20:54:54 2015-08-23 20:54:54 0 .001
1 50 2015-08-23 20:54:54 2015-08-23 20:54:54 0 .001
1 49 2015-08-23 19:23:13 2015-08-23 19:23:13 0 5.976
1 49 2015-08-23 19:23:13 2015-08-23 20:54:54 91.68 5.976
1 49 2015-08-23 19:23:13 2015-08-23 19:23:13 0 5.976
1 49 2015-08-23 19:23:13 2015-08-23 19:23:13 0 5.976
1 48 2015-08-23 19:23:11 2015-08-23 19:23:11 0 .001
1 48 2015-08-23 19:23:11 2015-08-23 19:23:13 .03 .001
1 48 2015-08-23 19:23:11 2015-08-23 19:23:11 0 .001
1 48 2015-08-23 19:23:11 2015-08-23 19:23:11 0 .001
1 47 2015-08-23 17:40:38 2015-08-23 17:40:38 0 16.55
1 47 2015-08-23 17:40:38 2015-08-23 19:23:11 102.55 16.55
1 47 2015-08-23 17:40:38 2015-08-23 17:40:38 0 16.55
1 47 2015-08-23 17:40:38 2015-08-23 17:40:38 0 16.55
1 46 2015-08-23 17:35:22 2015-08-23 17:35:22 0 .402
1 46 2015-08-23 17:35:22 2015-08-23 17:40:38 5.27 .402
1 46 2015-08-23 17:35:22 2015-08-23 17:35:22 0 .402
1 46 2015-08-23 17:35:22 2015-08-23 17:35:22 0 .402
1 45 2015-08-23 17:35:19 2015-08-23 17:35:22 .05 .001
1 45 2015-08-23 17:35:19 2015-08-23 17:35:19 0 .001

 

[回到目录]



最近10天中每天日志切换的量



● 即可分析10天的波度,又可分析24小时内,可很容易看出异常情况 

THREAD#DAYH00H01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23TOTAL
1 08/26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 4
1 08/24 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17
1 08/23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 2 8 1 4 7 25

 

[回到目录]



日志组大小


 

GROUP#THREAD#SEQUENCE#SIZE_MSTATUSARCMEMBERSMEMBERTYPE
1 1 90 50 INACTIVE YES 1 /u01/app/oracle/oradata/oradg11g/redo01.log ONLINE
2 1 91 50 CURRENT NO 1 /u01/app/oracle/oradata/oradg11g/redo02.log ONLINE
3 1 89 50 INACTIVE YES 1 /u01/app/oracle/oradata/oradg11g/redo03.log ONLINE

 

[回到目录]



SGA信息


 



SGA使用情况


 

实例名称名称值(MB)是否可调
1 Fixed SGA Size 2 No
1 Redo Buffers 8 No
1 Buffer Cache Size 20 Yes
1 Shared Pool Size 152 Yes
1 Large Pool Size 4 Yes
1 Java Pool Size 4 Yes
1 Streams Pool Size 0 Yes
1 Shared IO Pool Size 0 Yes
1 Granule Size 4 No
1 Maximum SGA Size 398 No
1 Startup overhead in Shared Pool 64 No
1 Free SGA Memory Available 208  

 

[回到目录]





SGA 配置信息


 

Instance NamePool NameBytes
oradg11g
Variable Size
385,879,344
 
Database Buffers
20,971,520
 
Redo Buffers
8,466,432
 
Fixed Size
2,228,944
*******************************************************************************   --------------------
Total:   417,546,240

 

[回到目录]



SGA Target Advice


 

Instance NameParameter NameValue
oradg11g
sga_max_size
419,430,400
  sga_target
0

 

Instance NameSGA SizeSGA Size FactorEstimated DB TimeEstimated DB Time FactorEstimated Physical Reads
oradg11g
192 1 219 1 28,531
  240 1 212 1 23,122
  288 2 209 1 23,122
  336 2 209 1 23,122
  384 2 209 1 23,122

 

[回到目录]



SGA (ASMM) 动态组件


 

Instance NameComponent NameCurrent SizeMin SizeMax SizeUser Specified 
Size
Oper. 
Count
Last Oper. 
Type
Last Oper. 
Mode
Last Oper. 
Time
Granule Size
oradg11g
streams pool 0 0 0 0 0 STATIC  
 
4,194,304
  shared pool 159,383,552 159,383,552 163,577,856 0 1 SHRINK DEFERRED
2015-08-26 15:25:03
4,194,304
  large pool 4,194,304 4,194,304 4,194,304 0 0 STATIC  
 
4,194,304
  java pool 4,194,304 4,194,304 4,194,304 0 0 STATIC  
 
4,194,304
  Shared IO Pool 0 0 0 0 0 STATIC  
 
4,194,304
  RECYCLE buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  KEEP buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  DEFAULT buffer cache 20,971,520 16,777,216 20,971,520 0 1 GROW DEFERRED
2015-08-26 15:25:03
4,194,304
  DEFAULT 8K buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  DEFAULT 4K buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  DEFAULT 32K buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  DEFAULT 2K buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  DEFAULT 16K buffer cache 0 0 0 0 0 STATIC  
 
4,194,304
  ASM Buffer Cache 0 0 0 0 0 STATIC  
 
4,194,304

 

[回到目录]



PGA Target 建议


 

Instance NameParameter NameValue
oradg11g
pga_aggregate_target
0
  workarea_size_policy
AUTO

 

Instance NamePGA Target for EstimateEstimated Extra Bytes R/WEstimated PGA Cache Hit %ESTD_OVERALLOC_COUNT
oradg11g
14,155,776 116,457,472 75 12
  28,311,552 116,457,472 75 12
  56,623,104 116,457,472 75 12
  84,934,656 116,457,472 75 12
  113,246,208 0 100 12
  135,895,040 0 100 11
  158,543,872 0 100 6
  181,193,728 0 100 6
  203,842,560 0 100 5
  226,492,416 0 100 2
  339,738,624 0 100 0
  452,984,832 0 100 0
  679,477,248 0 100 0
  905,969,664 0 100 0

 

[回到目录]



文件IO信息


 



文件IO分析



Ordered by "Physical Reads" since last startup of the Oracle instance 

TablespaceFile NamePhysical ReadsRead Pct.Physical WritesWrite Pct.Total I/O
SYSTEM /u01/app/oracle/oradata/oradg11g/system01.dbf 59,179
80.61%
92
14.02%
59,271
SYSAUX /u01/app/oracle/oradata/oradg11g/sysaux01.dbf 12,683
17.28%
397
60.52%
13,080
EXAMPLE /u01/app/oracle/oradata/oradg11g/example01.dbf 669
.91%
0
0%
669
LOGMNRTBS /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 455
.62%
0
0%
455
UNDOTBS1 /u01/app/oracle/oradata/oradg11g/undotbs01.dbf 258
.35%
152
23.17%
410
USERS /u01/app/oracle/oradata/oradg11g/users01.dbf 153
.21%
0
0%
153
TEMP /u01/app/oracle/oradata/oradg11g/temp01.dbf 20
.03%
15
2.29%
35
    --------------------   --------------------   --------------------
Total:   73,417   656   74,073

 

[回到目录]



文件IO时间分析



Average time (in milliseconds) for an I/O call per datafile since last startup of the Oracle instance - (ordered by Physical Reads) 

File NamePhysical ReadsAverage Read Time
(milliseconds per read)
Physical WritesAverage Write Time
(milliseconds per write)
/u01/app/oracle/oradata/oradg11g/system01.dbf 59,179 .03 92 .43
/u01/app/oracle/oradata/oradg11g/sysaux01.dbf 12,683 .13 397 .11
/u01/app/oracle/oradata/oradg11g/example01.dbf 669 .22 0 .00
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 455 .07 0 .00
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf 258 .26 152 .27
/u01/app/oracle/oradata/oradg11g/users01.dbf 153 .06 0 .00
/u01/app/oracle/oradata/oradg11g/temp01.dbf 20 .05 15 .27
  -------------------- -------------------------------------------- -------------------- ----------------------------------------------
Average:   .12   .15
Total: 73,417   656  

 

[回到目录]



全表扫描统计


 

Large Table ScansSmall Table ScansPct. Large Scans
131 1,586
7.63%

 

[回到目录]



排序情况统计


 

Disk SortsMemory SortsPct. Disk Sorts
0 10,877
0%

 

NAMECNTHit Ratio
workarea executions - optimal 6566 100
workarea executions - onepass 0 0
workarea executions - multipass 0 0

 

[回到目录]



SQL监控


 



逻辑读TOP10的SQL语句



Top 100 SQL statements with buffer gets greater than 1000 

INST_IDUsernameBuffer GetsExecutionsBuffer Gets / ExecutionSQL Text
1 LHR 36,670 1 36,670 select '
' || c.sum3|| '
' sum3,a.sum1 sum1,b.sum2 sum2 from (SELECT ceil(SUM(BYTES)/1024/1024/1024) sum1 FROM DBA_se gments) a,(select ceil(sum(bytes)/1024/1024/1024) sum2 from v$datafile) b,(select ceil(sum(bytes)/1024/1024/1024) sum3 from dba_extents where segment_type not like 'INDEX%' an d segment_type not in('ROLLBACK','CACHE','LOBINDEX','TYPE2 UNDO')) c
1 LHR 23,169 56 414 select col.*, com.Comments from sys.all_tab_columns col, sys.all_col_comments com where col.owner = 'SYS' and col.table_name = 'GV_$DATABASE' and com.Owner (+) = 'SYS' an d com.Table_Name (+) = 'GV_$DATABASE' and com.Column_Name (+) = col.Column_Name order by col.column_id
1 LHR 12,845 61 211 select constraint_name from sys.all_constraints where owner = :object_owner and table_name = :object_name and constraint_type = 'V' and constraint_name not like 'SYS_%'
1 LHR 8,331 1 8,331 SELECT '
' || r.command_id || '
' backup_name , '
' || TO_CHAR(r.start_time, 'yyyy-mm-dd HH24:MI:SS') || '
' start_time , '
' || r.time_taken_display || '
' elapsed_time , DECODE( r.status , 'COMPLETED' , '
' || r.status || '
' , 'RUNNING' , '
' || r.status || '
' , 'FAILED' , '
' || r.status || '
' , '
' || r.status || '
' ) status , r.input_
1 LHR 7,469 1 7,469 SELECT '' || tablespace_name || '' tablespace_name , '
' || owner || '
' owner , '' || segment_type || '' segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY tablespace_name , owner , segment_type ORDER BY tablespace_name , owner , s egment_type
1 APEX_030200 2,637 5 527 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'),w wv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1 APEX_030200 1,513 1 1,513 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24); :mydate := nex t_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1 MDSYS 1,141 4 285 declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar 2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); P RAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_typ e='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event ; m_stmt:='select SYS_CONTEXT(''USERENV'',''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'',''CURRENT_USER'') fr om dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execu
1 LHR 1,060 61 17 select * from sys.all_views where owner = :owner and view_name = :view_name

 

[回到目录]



物理读TOP10的SQL语句



Top 100 SQL statements with disk reads greater than 1000 

INST_IDUsernameDisk ReadsExecutionsReads / ExecutionSQL Text
1 LHR 20,903 1 20,903 select '
' || c.sum3|| '
' sum3,a.sum1 sum1,b.sum2 sum2 from (SELECT ceil(SUM(BYTES)/1024/1024/1024) sum1 FROM DBA_se gments) a,(select ceil(sum(bytes)/1024/1024/1024) sum2 from v$datafile) b,(select ceil(sum(bytes)/1024/1024/1024) sum3 from dba_extents where segment_type not like 'INDEX%' an d segment_type not in('ROLLBACK','CACHE','LOBINDEX','TYPE2 UNDO')) c
1 LHR 11,160 61 183 select constraint_name from sys.all_constraints where owner = :object_owner and table_name = :object_name and constraint_type = 'V' and constraint_name not like 'SYS_%'
1 LHR 7,323 1 7,323 SELECT '' || tablespace_name || '' tablespace_name , '
' || owner || '
' owner , '' || segment_type || '' segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY tablespace_name , owner , segment_type ORDER BY tablespace_name , owner , s egment_type

 

[回到目录]



执行次数TOP10的SQL语句


 

INST_IDSQL_IDSQL_TEXTEXECUTIONSLAST_LOAD_TIMEFIRST_LOAD_TIMEDISK_READSBUFFER_GETSPARSE_CALLS
1 96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist _head$ where obj#=:1 and intcol#=:2 4671 2015-08-26 15:24:26 2015-08-26/15:24:26 304 12330 39
1 53saa2zkr6wc3 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 1776 2015-08-26 15:24:33 2015-08-26/15:24:26 45 8023 29
1 3nkd3g3ju5ph1 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null 1766 2015-08-26 15:24:26 2015-08-26/15:24:25 265 6885 33
1 32hbap2vtmf53 select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_sub name,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc 1522 2015-08-26 15:24:28 2015-08-26/15:24:28 211 24391 18
1 3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), n onequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + decode(bitand(:flag,16),0,0,1), null_preds = null_preds + decode(bitand(:flag,32),0,0,1), timestamp = :time where obj# = :objn and intcol# = :coln 1387 2015-08-26 15:39:44 2015-08-26/15:39:44 73 4550 4
1 db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket 1035 2015-08-26 15:24:26 2015-08-26/15:24:26 412 3152 24
1 grwydz59pu6mc select text from view$ where rowid=:1 803 2015-08-26 15:24:33 2015-08-26/15:24:26 68 1622 21
1 83taa7kaw59c1 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale, 0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol# 709 2015-08-26 15:24:33 2015-08-26/15:24:25 220 2348 33
1 5n1fs4m2n2y0r select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 699 2015-08-26 15:24:33 2015-08-26/15:24:25 34 4330 31
1 9tgj4g8y4rwy8 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0 ) from seg$ where ts#=:1 and file#=:2 and block#=:3 686 2015-08-26 15:24:33 2015-08-26/15:24:26 62 2091 22

 

[回到目录]



解析次数TOP10的SQL语句


 

INST_IDSQL_IDSQL_TEXTEXECUTIONSLAST_LOAD_TIMEFIRST_LOAD_TIMEDISK_READSBUFFER_GETSPARSE_CALLS
1 b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait 519 2015-08-26 15:39:44 2015-08-26/15:39:44 1 26 519
1 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 107 2015-08-26 15:39:44 2015-08-26/15:39:44 1 21 107
1 3ktacv9r56b51 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# 640 2015-08-26 15:24:33 2015-08-26/15:24:25 577 8039 43
1 8swypbbr0m372 select order#,columns,types from access$ where d_obj#=:1 640 2015-08-26 15:24:33 2015-08-26/15:24:25 337 6271 43
1 83cq1aqjw5gmg select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# 0 2015-08-26 15:24:28 2015-08-26/15:24:28 0 0 42
1 96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist _head$ where obj#=:1 and intcol#=:2 4671 2015-08-26 15:24:26 2015-08-26/15:24:26 304 12330 39
1 cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# 225 2015-08-26 15:24:33 2015-08-26/15:24:27 966 2851 36
1 39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# 225 2015-08-26 15:24:33 2015-08-26/15:24:27 423 1433 36
1 ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# 225 2015-08-26 15:24:33 2015-08-26/15:24:26 212 1369 36
1 c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# 225 2015-08-26 15:24:33 2015-08-26/15:24:27 139 805 36

 

[回到目录]



DISK SORT严重的SQL语句


 

[回到目录]



ASM磁盘监控


 



ASM磁盘使用情况


 

NAMEPATHSTATETOTAL_MBFREE_MBCREATE_DATEMOUNT_DATE
DATA_0000 /dev/asm-diskb NORMAL 5120 669 2014-06-14 22:45:25 2015-08-23 17:33:07
FRA_0000 /dev/asm-diske NORMAL 10240 7184 2014-06-14 22:50:19 2015-08-23 17:33:07
DATA_0001 /dev/asm-diskc NORMAL 5120 664 2014-06-14 22:45:25 2015-08-23 17:33:07
DATA_0002 /dev/asm-diskd NORMAL 5120 670 2014-06-14 22:45:25 2015-08-23 17:33:07
DATA_0003 /dev/raw/raw1 NORMAL 2000 0 2015-05-19 18:00:59 2015-08-23 17:33:07
  /dev/raw/raw2 NORMAL 0 0    
      ---------- ----------    
Total     27600 9187    

 

[回到目录]



ASM磁盘组使用情况


 

NAMEBLOCK_SIZESTATETYPETOTAL_MBFREE_MB
DATA 4096 MOUNTED NORMAL 17360 2003
FRA 4096 MOUNTED EXTERN 10240 7184
        ---------- ----------
Total       27600 9187

 

[回到目录]



ASM磁盘组参数配置情况


 

NAMEVALUEGROUP_NUMBERATTRIBUTE_INDEXATTRIBUTE_INCARNATIONREAD_ONSYSTEM_
access_control.enabled FALSE 1 40 1 N Y
access_control.umask 066 1 41 1 N Y
au_size 1048576 1 5 1 Y Y
cell.smart_scan_capable FALSE 1 30 1 N N
compatible.asm 11.2.0.0.0 1 20 1 N Y
compatible.rdbms 10.1.0.0.0 1 21 1 N Y
disk_repair_time 3.6h 1 0 1 N Y
sector_size 512 1 6 1 Y Y
template_version 186646528 1 50 1 N Y
access_control.enabled FALSE 2 40 1 N Y
access_control.umask 066 2 41 1 N Y
au_size 1048576 2 5 1 Y Y
cell.smart_scan_capable FALSE 2 30 1 N N
compatible.asm 11.2.0.0.0 2 20 1 N Y
compatible.rdbms 10.1.0.0.0 2 21 1 N Y
disk_repair_time 3.6h 2 0 1 N Y
sector_size 512 2 6 1 Y Y
template_version 186646528 2 50 1 N Y

 

[回到目录]



ASM实例


 

[回到目录]



闪回归档


 



闪回归档配置


 

[回到目录]



开启了闪回归档的表


 

[回到目录]



闪回归档空间


 

[回到目录]



DG库


 



DG库配置情况


 

参数名称实例名称参数值
db_file_name_convert oradg11g oradglg, oradg11g
fal_client oradg11g oradg11g
fal_server oradg11g oradglg
log_archive_config oradg11g DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font>
log_archive_dest_1 oradg11g LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
log_archive_dest_2 oradg11g SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=ora dgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_3 oradg11g SERVICE=tns_oradglg LGWR ASYNC db_unique_name=orad glg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_4 oradg11g SERVICE=tns_oradgss LGWR ASYNC db_unique_name=orad gss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_state_1 oradg11g ENABLE
log_archive_dest_state_2 oradg11g ENABLE
log_archive_dest_state_3 oradg11g ENABLE
log_archive_dest_state_4 oradg11g ENABLE
log_file_name_convert oradg11g oradglg, oradg11g
standby_file_management oradg11g AUTO

 

[回到目录]



DG库运行情况


 

INST_IDNAMELOG_MODEOPEN_MODEDATABASE_ROLESWITCHOVER_STATUSDB_UNIQUE_NAMEFLASHBACK_ONPROTECTION_MODEPROTECTION_LEVELREMOTE_ASWITCHOVER#SWITCHOVER_STATUSDATAGUARGUARD_SSUPPLEMESUPSUPFORSUPSUPSTANDBY_BECAME_PRIMARY_SCNFS_FAILOVER_STATUSFS_FAILOVER_CURRENT_TARGETFS_FAILOVER_THRESHOLDFS_FAILFS_FAILOVER_OBSERVER_HOSTCONPRIMARY_DB_UNIQUE_NAMESUPMIN_REQUIRED_CAPTURE_CHANGE#
1 ORADG11G ARCHIVELOG READ WRITE PRIMARY TO STANDBY oradg11g YES MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE ENABLED 1414208659 TO STANDBY DISABLED NONE IMPLICIT YES YES YES NO NO 2076848 DISABLED   0     NO oradglg YES  

 

THREAD#DEST_IDDEST_NAMETARGETDATABASE_MODESTATUSERRORRECOVERY_MODEDB_UNIQUE_NAMEDESTINATIONGAP_STATUSCURRENT_SEQ#LAST_ARCHIVEDAPPLIED_SEQ#APPLIED_SCN
1 1 LOG_ARCHIVE_DEST_1 LOCAL PRIMARY OPEN VALID   IDLE oradg11g     91 90 8 0
1 2 LOG_ARCHIVE_DEST_2 PHYSICAL STANDBY OPEN_READ-ONLY VALID   MANAGED REAL TIME APPLY oradgphy tns_oradgphy NO GAP 91 90 89 2282617
1 3 LOG_ARCHIVE_DEST_3 LOGICAL STANDBY OPEN VALID   LOGICAL REAL TIME APPLY oradglg tns_oradglg NO GAP 91 90 90 2282614
1 4 LOG_ARCHIVE_DEST_4 PHYSICAL STANDBY OPEN_READ-ONLY VALID   MANAGED REAL TIME APPLY oradgss tns_oradgss NO GAP 91 90 89 2282617

 

[回到目录]



主库进程


 

INSTANCE_NAMEPROCESSCLIENT_PCLIENT_PIDSTATUSGROUP_#THREAD#SEQUENCE#DELAY_MINSRESETLOG_IDSIDSERIAL#SPID
oradg11g ARCH ARCH 58780 CLOSING N/A 1 90 0 886695024 135 3 58780
oradg11g ARCH ARCH 58786 CLOSING 3 1 89 0 886695024 10 1 58786
oradg11g ARCH ARCH 58788 CLOSING N/A 1 87 0 886695024 136 3 58788
oradg11g LNS LNS 58800 WRITING 2 1 91 0 886695024 13 1 58800
oradg11g LNS LNS 58798 WRITING 2 1 91 0 886695024 138 1 58798
oradg11g LNS LNS 58802 WRITING 2 1 91 0 886695024 139 1 58802
oradg11g ARCH ARCH 58790 CLOSING N/A 1 90 0 886695024 11 1 58790

 

[回到目录]



standby 日志


 

GROUP#DB_IDTHREAD#SEQUENCE#BYTESUSEDARCSTATUSFIRST_CHANGE#NEXT_CHANGE#LAST_CHANGE#
4 UNASSIGNED 1 0 52428800 0 YES UNASSIGNED      
5 UNASSIGNED 1 0 52428800 0 YES UNASSIGNED      
6 UNASSIGNED 1 0 52428800 0 YES UNASSIGNED      
7 UNASSIGNED 1 0 52428800 0 YES UNASSIGNED      

 

[回到目录]


数据库安全

 



数据库用户


 



数据库用户一览


 

UsernameAccount StatusExpire DateDefault Tbs.Temp Tbs.Created OnProfileSYSDBASYSOPER
ANONYMOUS
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 09:58:25
DEFAULT
 
 
APEX_030200
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 10:13:33
DEFAULT
 
 
APEX_PUBLIC_USER
EXPIRED & LOCKED
2011-09-17 10:21:08
USERS TEMP
2011-09-17 10:13:33
DEFAULT
 
 
APPQOSSYS
EXPIRED & LOCKED
2011-09-17 09:52:28
SYSAUX TEMP
2011-09-17 09:52:28
DEFAULT
 
 
BI
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
CTXSYS
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 09:58:00
DEFAULT
 
 
DBSNMP
EXPIRED & LOCKED
2011-09-17 09:52:27
SYSAUX TEMP
2011-09-17 09:52:27
MONITORING_PROFILE
 
 
DIP
EXPIRED & LOCKED
2011-09-17 09:47:52
USERS TEMP
2011-09-17 09:47:52
DEFAULT
 
 
EXFSYS
EXPIRED & LOCKED
2011-09-17 09:57:46
SYSAUX TEMP
2011-09-17 09:57:46
DEFAULT
 
 
FLOWS_FILES
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 10:13:33
DEFAULT
 
 
HR
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
IX
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
LHR
OPEN
2015-09-30 17:07:39
USERS TEMP
2015-04-03 17:07:39
DEFAULT
 
 
MDDATA
EXPIRED & LOCKED
2011-09-17 10:21:08
USERS TEMP
2011-09-17 10:05:26
DEFAULT
 
 
MDSYS
EXPIRED & LOCKED
2011-09-17 10:00:09
SYSAUX TEMP
2011-09-17 10:00:09
DEFAULT
 
 
MGMT_VIEW
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSTEM TEMP
2011-09-17 10:12:38
DEFAULT
 
 
OE
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
OLAPSYS
EXPIRED & LOCKED
2011-09-17 10:04:19
SYSAUX TEMP
2011-09-17 10:04:19
DEFAULT
 
 
ORACLE_OCM
EXPIRED & LOCKED
2011-09-17 09:48:28
USERS TEMP
2011-09-17 09:48:28
DEFAULT
 
 
ORDDATA
EXPIRED & LOCKED
2011-09-17 10:00:09
SYSAUX TEMP
2011-09-17 10:00:09
DEFAULT
 
 
ORDPLUGINS
EXPIRED & LOCKED
2011-09-17 10:00:09
SYSAUX TEMP
2011-09-17 10:00:09
DEFAULT
 
 
ORDSYS
EXPIRED & LOCKED
2011-09-17 10:00:09
SYSAUX TEMP
2011-09-17 10:00:09
DEFAULT
 
 
OUTLN
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSTEM TEMP
2011-09-17 09:46:25
DEFAULT
 
 
OWBSYS
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 10:21:02
DEFAULT
 
 
OWBSYS_AUDIT
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 10:21:03
DEFAULT
 
 
PM
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
SCOTT
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2011-09-17 10:21:59
DEFAULT
 
 
SH
EXPIRED & LOCKED
2015-04-03 16:01:59
USERS TEMP
2015-04-03 15:59:12
DEFAULT
 
 
SI_INFORMTN_SCHEMA
EXPIRED & LOCKED
2011-09-17 10:00:09
SYSAUX TEMP
2011-09-17 10:00:09
DEFAULT
 
 
SPATIAL_CSW_ADMIN_USR
EXPIRED & LOCKED
2011-09-17 10:09:45
USERS TEMP
2011-09-17 10:09:45
DEFAULT
 
 
SPATIAL_WFS_ADMIN_USR
EXPIRED & LOCKED
2011-09-17 10:09:40
USERS TEMP
2011-09-17 10:09:40
DEFAULT
 
 
SYS
OPEN
2015-09-30 16:01:55
SYSTEM TEMP
2011-09-17 09:46:22
DEFAULT
TRUE
TRUE
SYSMAN
EXPIRED & LOCKED
2011-09-17 10:21:08
SYSAUX TEMP
2011-09-17 10:09:57
DEFAULT
 
 
SYSTEM
OPEN
2015-09-30 16:01:55
SYSTEM TEMP
2011-09-17 09:46:22
DEFAULT
 
 
WMSYS
EXPIRED & LOCKED
2011-09-17 09:53:14
SYSAUX TEMP
2011-09-17 09:53:14
DEFAULT
 
 
XDB
EXPIRED & LOCKED
2011-09-17 09:58:25
SYSAUX TEMP
2011-09-17 09:58:25
DEFAULT
 
 
XS$NULL
EXPIRED & LOCKED
2011-09-17 09:59:56
USERS TEMP
2011-09-17 09:59:56
DEFAULT
 
 

 

[回到目录]



拥有DBA角色的用户


 

GranteeGranted RoleAdmin. Option?Default Role?
LHR
DBA
NO
YES
SYS
DBA
YES
YES
SYSTEM
DBA
YES
YES

 

[回到目录]



拥有SYS角色的用户


 

USERNAMESYSDBSYSOPSYSAS
SYS TRUE TRUE FALSE

 

[回到目录]



角色概况


 

Role NameGranteeAdmin Option?Default Role?
ADM_PARALLEL_EXECUTE_TASK SYS
YES
YES
APEX_ADMINISTRATOR_ROLE SYS
YES
YES
AQ_ADMINISTRATOR_ROLE IX
NO
YES
  OWBSYS
NO
YES
  SYS
YES
YES
  SYSTEM
YES
YES
AQ_USER_ROLE IX
NO
YES
  OWBSYS
NO
YES
  SYS
YES
YES
AUTHENTICATEDUSER SYS
YES
YES
CONNECT APEX_030200
YES
YES
  IX
NO
YES
  MDDATA
NO
YES
  MDSYS
NO
YES
  OWBSYS
YES
YES
  PM
NO
YES
  SCOTT
NO
YES
  SPATIAL_CSW_ADMIN_USR
NO
YES
  SPATIAL_WFS_ADMIN_USR
NO
YES
  SYS
YES
YES
  WMSYS
NO
YES
CSW_USR_ROLE SYS
YES
YES
CTXAPP CTXSYS
YES
YES
  SYS
YES
YES
  XDB
NO
YES
CWM_USER OWBSYS
YES
YES
  SH
NO
YES
  SYS
YES
YES
DATAPUMP_EXP_FULL_DATABASE DBA
NO
YES
  SYS
YES
YES
DATAPUMP_IMP_FULL_DATABASE DBA
NO
YES
  SYS
YES
YES
DBA LHR
NO
YES
  SYS
YES
YES
  SYSTEM
YES
YES
DBFS_ROLE SYS
YES
YES
DELETE_CATALOG_ROLE DBA
YES
YES
  SYS
YES
YES
EJBCLIENT SYS
YES
YES
EXECUTE_CATALOG_ROLE DBA
YES
YES
  EXP_FULL_DATABASE
NO
YES
  IMP_FULL_DATABASE
NO
YES
  SYS
YES
YES
EXP_FULL_DATABASE DATAPUMP_EXP_FULL_DATABASE
NO
YES
  DATAPUMP_IMP_FULL_DATABASE
NO
YES
  DBA
NO
YES
  SYS
YES
YES
GATHER_SYSTEM_STATISTICS DBA
NO
YES
  SYS
YES
YES
GLOBAL_AQ_USER_ROLE      
HS_ADMIN_EXECUTE_ROLE EXECUTE_CATALOG_ROLE
NO
YES
  HS_ADMIN_ROLE
NO
YES
  SYS
YES
YES
HS_ADMIN_ROLE SYS
YES
YES
HS_ADMIN_SELECT_ROLE HS_ADMIN_ROLE
NO
YES
  SELECT_CATALOG_ROLE
NO
YES
  SYS
YES
YES
IMP_FULL_DATABASE DATAPUMP_IMP_FULL_DATABASE
NO
YES
  DBA
NO
YES
  SYS
YES
YES
JAVADEBUGPRIV SYS
YES
YES
JAVAIDPRIV SYS
YES
YES
JAVASYSPRIV SYS
YES
YES
JAVAUSERPRIV JAVASYSPRIV
NO
YES
  ORDSYS
NO
YES
  OWBSYS
NO
YES
  SYS
YES
YES
  XDB
NO
YES
JAVA_ADMIN DBA
NO
YES
  OWBSYS
NO
YES
  SYS
YES
YES
JAVA_DEPLOY DBA
NO
YES
  SYS
YES
YES
JMXSERVER SYS
YES
YES
LOGSTDBY_ADMINISTRATOR SYS
YES
YES
MGMT_USER MGMT_VIEW
NO
YES
  SYS
YES
YES
  SYSMAN
YES
YES
  SYSTEM
NO
YES
OEM_ADVISOR SYS
YES
YES
OEM_MONITOR DBSNMP
NO
YES
  SYS
YES
YES
OLAP_DBA DBA
NO
YES
  OLAPSYS
NO
YES
  SYS
YES
YES
OLAP_USER OWBSYS
YES
YES
  SYS
YES
YES
OLAP_XS_ADMIN DBA
NO
YES
  SYS
YES
YES
ORDADMIN SYS
YES
YES
OWB$CLIENT OWBSYS
YES
YES
  SYS
YES
YES
OWB_DESIGNCENTER_VIEW OWBSYS
YES
YES
  SYS
YES
YES
OWB_USER OWBSYS
YES
YES
  SYS
YES
YES
RECOVERY_CATALOG_OWNER SYS
YES
YES
RESOURCE APEX_030200
YES
YES
  BI
NO
YES
  CTXSYS
NO
YES
  EXFSYS
NO
YES
  HR
NO
YES
  IX
NO
YES
  LOGSTDBY_ADMINISTRATOR
NO
YES
  MDDATA
NO
YES
  MDSYS
NO
YES
  OE
NO
YES
  OLAPSYS
NO
YES
  OUTLN
NO
YES
  PM
NO
YES
  SCOTT
NO
YES
  SH
NO
YES
  SPATIAL_CSW_ADMIN_USR
NO
YES
  SPATIAL_WFS_ADMIN_USR
NO
YES
  SYS
YES
YES
  SYSMAN
NO
YES
  WMSYS
NO
YES
  XDB
NO
YES
SCHEDULER_ADMIN DBA
YES
YES
  SYS
YES
YES
SELECT_CATALOG_ROLE DBA
YES
YES
  EXP_FULL_DATABASE
NO
YES
  IMP_FULL_DATABASE
NO
YES
  IX
NO
YES
  OEM_MONITOR
NO
YES
  SH
NO
YES
  SYS
YES
YES
  SYSMAN
YES
YES
SPATIAL_CSW_ADMIN SPATIAL_CSW_ADMIN_USR
YES
YES
  SYS
YES
YES
SPATIAL_WFS_ADMIN SPATIAL_WFS_ADMIN_USR
YES
YES
  SYS
YES
YES
WFS_USR_ROLE SYS
YES
YES
WM_ADMIN_ROLE DBA
NO
YES
  WMSYS
YES
YES
XDBADMIN DBA
NO
YES
  OE
NO
YES
  SYS
YES
YES
XDB_SET_INVOKER DBA
NO
YES
  SYS
YES
YES
XDB_WEBSERVICES SYS
YES
YES
XDB_WEBSERVICES_OVER_HTTP SYS
YES
YES
XDB_WEBSERVICES_WITH_PUBLIC SYS
YES
YES

 

[回到目录]



密码为系统默认值的用户


 

[回到目录]



整个用户有多大


 

OWNERsize(M)
SYS 880.63
SH 287.25
XDB 157.69
SYSTEM 116.44
APEX_030200 85.44
MDSYS 73.94
SYSMAN 45.94
LHR 34.31
ORDDATA 13.56
PM 12.25
OE 9.06
OLAPSYS 8.81
CTXSYS 3.75
EXFSYS 3.63
WMSYS 3.5
IX 1.75
HR 1.56
OUTLN .56
DBSNMP .5
ORDSYS .44
SCOTT .31

 

[回到目录]



系统表空间用户


 



系统表空间作为缺省表空间的用户


 

UsernameDefault TablespaceTemporary TablespaceCreatedAccount Status
MGMT_VIEW
SYSTEM
TEMP
2011-09-17 10:12:38
EXPIRED & LOCKED
OUTLN
SYSTEM
TEMP
2011-09-17 09:46:25
EXPIRED & LOCKED
SYS
SYSTEM
TEMP
2011-09-17 09:46:22
OPEN
SYSTEM
SYSTEM
TEMP
2011-09-17 09:46:22
OPEN

 

[回到目录]



系统表空间作为临时表空间的用户


 

[回到目录]



系统表空间上的对象




● 系统表空间上的对象概况


 

OWNERSEGMENT_TYPESIZE_GCOUNTS
OUTLN
INDEX 0 4
OUTLN
LOBSEGMENT 0 1
OUTLN
TABLE 0 3
OUTLN
LOBINDEX 0 1


● 系统表空间上的对象详情


 

OwnerSegment NameTypeTablespaceBytes 
Alloc
ExtentsInitial 
Ext
Next 
Ext
Pct 
Inc
OUTLN
OL$ TABLE SYSTEM 65,536 1 65,536 1,048,576  
  OL$HINTS TABLE SYSTEM 65,536 1 65,536 1,048,576  
  OL$HNT_NUM INDEX SYSTEM 65,536 1 65,536 1,048,576  
  OL$NAME INDEX SYSTEM 65,536 1 65,536 1,048,576  
  OL$NODES TABLE SYSTEM 65,536 1 65,536 1,048,576  
  OL$NODE_OL_NAME INDEX SYSTEM 65,536 1 65,536 1,048,576  
  OL$SIGNATURE INDEX SYSTEM 65,536 1 65,536 1,048,576  
  SYS_IL0000000451C00021$$ LOBINDEX SYSTEM 65,536 1 65,536 1,048,576  
  SYS_LOB0000000451C00021$$ LOBSEGMENT SYSTEM 65,536 1 65,536 1,048,576  
*************************************************************************** -----------------------------------------------------------------------------------------------------------------------------     --------------------        
Total Count: 9              
Total Bytes:       589,824        

 

[回到目录]



● 哪些表建在系统表空间上


 

TABLE_NAMEOWNERTABLESPACE_NAME
OL$NODES OUTLN SYSTEM
OL$HINTS OUTLN SYSTEM
OL$ OUTLN SYSTEM
WWV_FLOW_FILE_OBJECTS$ FLOWS_FILES SYSAUX

 

[回到目录]



● 哪些索引建在系统表空间上


 

INDEX_NAMEOWNERTABLESPACE_NAME
OL$NAME OUTLN SYSTEM
OL$SIGNATURE OUTLN SYSTEM
SYS_IL0000000451C00021$$ OUTLN SYSTEM
OL$HNT_NUM OUTLN SYSTEM
OL$NODE_OL_NAME OUTLN SYSTEM
WWV_FLOW_FILE_OBJ_PK FLOWS_FILES SYSAUX
SYS_IL0000072495C00017$$ FLOWS_FILES SYSAUX
SYS_C008628 FLOWS_FILES SYSAUX
WWV_FLOW_FILES_SGID_FK_IDX FLOWS_FILES SYSAUX
WWV_FLOW_FILES_USER_IDX FLOWS_FILES SYSAUX

 

[回到目录]


数据库对象

 



段情况


 



对象汇总


 

OwnerObject TypeObject Count
APEX_030200 FUNCTION 12
  INDEX 1,101
  LOB 155
  PACKAGE 189
  PACKAGE BODY 181
  PROCEDURE 19
  SEQUENCE 4
  SYNONYM 45
  TABLE 360
  TRIGGER 366
  TYPE 4
  VIEW 125
APPQOSSYS SYNONYM 1
  TABLE 4
BI SYNONYM 8
CTXSYS FUNCTION 2
  INDEX 63
  INDEXTYPE 4
  LIBRARY 1
  LOB 2
  OPERATOR 6
  PACKAGE 74
  PACKAGE BODY 63
  PROCEDURE 2
  SEQUENCE 3
  TABLE 50
  TYPE 35
  TYPE BODY 6
  VIEW 77
DBSNMP INDEX 10
  PACKAGE 4
  PACKAGE BODY 4
  PROCEDURE 1
  SEQUENCE 2
  SYNONYM 1
  TABLE 20
  TYPE 8
  VIEW 7
EXFSYS FUNCTION 26
  INDEX 41
  INDEXTYPE 1
  JAVA CLASS 47
  JAVA RESOURCE 1
  JOB 2
  LIBRARY 1
  LOB 2
  OPERATOR 1
  PACKAGE 18
  PACKAGE BODY 18
  PROCEDURE 10
  SEQUENCE 1
  TABLE 47
  TRIGGER 5
  TYPE 30
  TYPE BODY 5
  VIEW 56
FLOWS_FILES INDEX 5
  LOB 1
  SYNONYM 5
  TABLE 1
  TRIGGER 1
HR INDEX 19
  PROCEDURE 2
  SEQUENCE 3
  TABLE 7
  TRIGGER 2
  VIEW 1
IX EVALUATION CONTEXT 2
  INDEX 17
  LOB 3
  QUEUE 4
  RULE SET 4
  SEQUENCE 2
  TABLE 17
  TYPE 1
  VIEW 8
LHR TABLE 6
  VIEW 1
MDSYS FUNCTION 108
  INDEX 367
  INDEXTYPE 2
  JAVA CLASS 535
  JAVA RESOURCE 3
  LIBRARY 18
  LOB 214
  OPERATOR 25
  PACKAGE 70
  PACKAGE BODY 66
  PROCEDURE 2
  SEQUENCE 15
  TABLE 148
  TRIGGER 64
  TYPE 207
  TYPE BODY 43
  VIEW 86
OE FUNCTION 1
  INDEX 48
  LOB 15
  SEQUENCE 1
  SYNONYM 6
  TABLE 14
  TRIGGER 4
  TYPE 37
  TYPE BODY 3
  VIEW 13
OLAPSYS FUNCTION 1
  INDEX 137
  LOB 2
  PACKAGE 45
  PACKAGE BODY 43
  SEQUENCE 5
  TABLE 126
  TRIGGER 48
  TYPE 7
  VIEW 307
ORACLE_OCM JOB 2
  PACKAGE 3
  PACKAGE BODY 3
ORDDATA INDEX 138
  LOB 9
  SEQUENCE 12
  TABLE 73
  VIEW 25
ORDPLUGINS PACKAGE 5
  PACKAGE BODY 5
ORDSYS FUNCTION 32
  INDEX 4
  JAVA CLASS 1,876
  JAVA RESOURCE 72
  LIBRARY 2
  PACKAGE 28
  PACKAGE BODY 20
  PROCEDURE 7
  TABLE 5
  TYPE 446
  TYPE BODY 15
  VIEW 5
OUTLN INDEX 5
  LOB 1
  PROCEDURE 1
  TABLE 3
OWBSYS INDEX 1
  TABLE 1
OWBSYS_AUDIT SYNONYM 12
PM INDEX 21
  LOB 17
  TABLE 3
  TYPE 3
PUBLIC SYNONYM 28,027
SCOTT INDEX 2
  TABLE 4
SH DIMENSION 5
  INDEX 29
  INDEX PARTITION 196
  LOB 2
  MATERIALIZED VIEW 2
  TABLE 17
  TABLE PARTITION 56
  VIEW 1
SI_INFORMTN_SCHEMA SYNONYM 8
SYS CLUSTER 10
  CONSUMER GROUP 25
  CONTEXT 7
  DESTINATION 2
  DIRECTORY 9
  EDITION 1
  EVALUATION CONTEXT 10
  FUNCTION 100
  INDEX 1,221
  INDEX PARTITION 54
  JAVA CLASS 20,707
  JAVA DATA 328
  JAVA RESOURCE 761
  JAVA SOURCE 2
  JOB 10
  JOB CLASS 14
  LIBRARY 147
  LOB 189
  LOB PARTITION 1
  OPERATOR 7
  PACKAGE 633
  PACKAGE BODY 607
  PROCEDURE 105
  PROGRAM 19
  QUEUE 18
  RESOURCE PLAN 10
  RULE 1
  RULE SET 13
  SCHEDULE 3
  SCHEDULER GROUP 4
  SEQUENCE 135
  SYNONYM 9
  TABLE 1,004
  TABLE PARTITION 52
  TABLE SUBPARTITION 32
  TRIGGER 9
  TYPE 1,347
  TYPE BODY 113
  UNDEFINED 11
  VIEW 3,849
  WINDOW 9
SYSMAN EVALUATION CONTEXT 2
  FUNCTION 12
  INDEX 1,028
  LOB 75
  MATERIALIZED VIEW 1
  PACKAGE 193
  PACKAGE BODY 193
  PROCEDURE 3
  QUEUE 12
  RULE SET 4
  SEQUENCE 13
  TABLE 729
  TRIGGER 97
  TYPE 672
  TYPE BODY 49
  VIEW 471
SYSTEM INDEX 241
  INDEX PARTITION 104
  LOB 25
  PACKAGE 1
  PACKAGE BODY 1
  PROCEDURE 1
  QUEUE 4
  SEQUENCE 20
  SYNONYM 8
  TABLE 161
  TABLE PARTITION 77
  TRIGGER 2
  TYPE 1
  VIEW 14
WMSYS EVALUATION CONTEXT 1
  FUNCTION 4
  INDEX 70
  LOB 9
  OPERATOR 9
  PACKAGE 22
  PACKAGE BODY 22
  PROCEDURE 4
  QUEUE 2
  RULE SET 2
  SEQUENCE 9
  TABLE 46
  TRIGGER 2
  TYPE 18
  TYPE BODY 1
  VIEW 111
XDB FUNCTION 7
  INDEX 697
  INDEXTYPE 2
  LIBRARY 17
  LOB 586
  OPERATOR 7
  PACKAGE 35
  PACKAGE BODY 33
  PROCEDURE 4
  SEQUENCE 5
  TABLE 94
  TRIGGER 27
  TYPE 97
  TYPE BODY 5
  VIEW 20
  XML SCHEMA 54
************************************************************   ----------------
Total:   75,307

 

[回到目录]



段的汇总


 

OwnerSegment TypeSegment CountSize (in Bytes)
APEX_030200 INDEX 262 39,976,960
  LOBINDEX 50 3,276,800
  LOBSEGMENT 50 10,420,224
  TABLE 105 35,913,728
CTXSYS INDEX 38 2,490,368
  LOBINDEX 2 131,072
  LOBSEGMENT 2 131,072
  TABLE 17 1,179,648
DBSNMP INDEX 5 327,680
  TABLE 3 196,608
EXFSYS INDEX 37 2,424,832
  LOBINDEX 1 65,536
  LOBSEGMENT 1 65,536
  TABLE 19 1,245,184
HR INDEX 19 1,245,184
  TABLE 6 393,216
IX INDEX 14 917,504
  LOBINDEX 3 196,608
  LOBSEGMENT 3 196,608
  TABLE 8 524,288
LHR TABLE 6 35,979,264
MDSYS INDEX 98 7,405,568
  LOBINDEX 197 12,976,128
  LOBSEGMENT 197 41,877,504
  NESTED TABLE 16 1,048,576
  TABLE 64 14,221,312
OE INDEX 33 2,949,120
  LOBINDEX 15 983,040
  LOBSEGMENT 15 1,048,576
  NESTED TABLE 4 589,824
  TABLE 10 3,932,160
OLAPSYS INDEX 80 5,242,880
  TABLE 61 3,997,696
ORDDATA INDEX 95 6,946,816
  LOBINDEX 6 393,216
  LOBSEGMENT 6 3,014,656
  NESTED TABLE 2 131,072
  TABLE 51 3,735,552
ORDSYS INDEX 3 196,608
  TABLE 4 262,144
OUTLN INDEX 4 262,144
  LOBINDEX 1 65,536
  LOBSEGMENT 1 65,536
  TABLE 3 196,608
PM INDEX 4 262,144
  LOBINDEX 17 1,114,112
  LOBSEGMENT 17 11,206,656
  NESTED TABLE 1 65,536
  TABLE 2 196,608
SCOTT INDEX 2 131,072
  TABLE 3 196,608
SH INDEX 19 2,490,368
  INDEX PARTITION 112 11,141,120
  LOBINDEX 2 131,072
  LOBSEGMENT 2 131,072
  TABLE 12 18,874,368
  TABLE PARTITION 32 268,435,456
SYS CLUSTER 10 53,805,056
  INDEX 1,000 185,729,024
  INDEX PARTITION 54 4,521,984
  LOB PARTITION 1 65,536
  LOBINDEX 178 11,665,408
  LOBSEGMENT 178 66,322,432
  NESTED TABLE 16 1,048,576
  ROLLBACK 1 393,216
  TABLE 833 556,793,856
  TABLE PARTITION 51 4,784,128
  TABLE SUBPARTITION 32 2,097,152
  TYPE2 UNDO 10 36,175,872
SYSMAN INDEX 301 24,969,216
  LOBINDEX 43 2,818,048
  LOBSEGMENT 43 3,407,872
  NESTED TABLE 2 131,072
  TABLE 190 16,842,752
SYSTEM INDEX 160 10,485,760
  INDEX PARTITION 104 23,199,744
  LOBINDEX 22 1,638,400
  LOBSEGMENT 22 5,570,560
  TABLE 114 7,471,104
  TABLE PARTITION 77 73,728,000
WMSYS INDEX 30 1,966,080
  LOBINDEX 5 327,680
  LOBSEGMENT 5 327,680
  NESTED TABLE 2 131,072
  TABLE 14 917,504
XDB INDEX 109 9,502,720
  LOBINDEX 585 38,338,560
  LOBSEGMENT 585 95,223,808
  NESTED TABLE 10 655,360
  TABLE 83 21,626,880
**************************************************   ---------------- --------------------
Total:   6,712 1,825,898,496

 

[回到目录]



体积最大的10个段


 

OwnerSegment NamePartition NameSegment TypeTablespace NameSize (in bytes)Extents
SYS IDL_UB1$   TABLE SYSTEM 260,046,848 102
SYS SOURCE$   TABLE SYSTEM 75,497,472 80
XDB SYS_LOB0000057465C00025$$   LOBSEGMENT SYSAUX 55,771,136 55
LHR TEST   TABLE USERS 35,651,584 49
SYS IDL_UB2$   TABLE SYSTEM 32,505,856 46
MDSYS SYS_LOB0000064008C00006$$   LOBSEGMENT SYSAUX 27,262,976 41
SYS C_TOID_VERSION#   CLUSTER SYSTEM 25,165,824 39
SYS TEST1   TABLE SYSTEM 17,825,792 32
SYS SYS_LOB0000065858C00004$$   LOBSEGMENT SYSAUX 16,908,288 17
SYS ARGUMENT$   TABLE SYSTEM 12,582,912 27
          ------------------------ ------------------------
Total         559,218,688 488

 

OwnerSegment NameSegment TypeOBJECT_SIZE_M
SYS IDL_UB1$ TABLE 248
SH COSTS TABLE PARTITION 128
SH SALES TABLE PARTITION 128
SYS SOURCE$ TABLE 72
XDB SYS_LOB0000057465C00025$$ LOBSEGMENT 53
LHR TEST TABLE 34
SYS IDL_UB2$ TABLE 31
MDSYS SYS_LOB0000064008C00006$$ LOBSEGMENT 26
SYS C_TOID_VERSION# CLUSTER 24
SYS TEST1 TABLE 17
      -------------
Total     761

 

[回到目录]



扩展最多的10个段


 

OwnerSegment NamePartition NameSegment TypeTablespace NameExtentsSize (in bytes)
SYS IDL_UB1$   TABLE SYSTEM 102 260,046,848
SYS SOURCE$   TABLE SYSTEM 80 75,497,472
XDB SYS_LOB0000057465C00025$$   LOBSEGMENT SYSAUX 55 55,771,136
LHR TEST   TABLE USERS 49 35,651,584
SYS IDL_UB2$   TABLE SYSTEM 46 32,505,856
MDSYS SYS_LOB0000064008C00006$$   LOBSEGMENT SYSAUX 41 27,262,976
SYS C_TOID_VERSION#   CLUSTER SYSTEM 39 25,165,824
SYS TEST1   TABLE SYSTEM 32 17,825,792
SYS ARGUMENT$   TABLE SYSTEM 27 12,582,912
SH CUSTOMERS   TABLE EXAMPLE 27 12,582,912
          ------------------------ ------------------------
Total         498 554,893,312

 

[回到目录]



LOB段



Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM) 

OwnerTable NameColumn NameLOB Segment NameTablespace NameSegment SizeLOB Index NameIn Row?
APEX_030200
WWV_FLOW_BANNER
BANNER
SYS_LOB0000072547C00002$$
SYSAUX
65,536
SYS_IL0000072547C00002$$
YES
 
WWV_FLOW_BUTTON_TEMPLATES
TEMPLATE
SYS_LOB0000072681C00004$$
SYSAUX
65,536
SYS_IL0000072681C00004$$
YES
 
WWV_FLOW_CUSTOM_AUTH_SETUPS
AUTH_FUNCTION
SYS_LOB0000072997C00011$$
SYSAUX
65,536
SYS_IL0000072997C00011$$
YES
   
PAGE_SENTRY_FUNCTION
SYS_LOB0000072997C00006$$
SYSAUX
65,536
SYS_IL0000072997C00006$$
YES
   
POST_AUTH_PROCESS
SYS_LOB0000072997C00012$$
SYSAUX
65,536
SYS_IL0000072997C00012$$
YES
   
PRE_AUTH_PROCESS
SYS_LOB0000072997C00010$$
SYSAUX
65,536
SYS_IL0000072997C00010$$
YES
   
SESS_VERIFY_FUNCTION
SYS_LOB0000072997C00007$$
SYSAUX
65,536
SYS_IL0000072997C00007$$
YES
 
WWV_FLOW_FLASH_CHARTS
CHART_XML
SYS_LOB0000073217C00049$$
SYSAUX
65,536
SYS_IL0000073217C00049$$
YES
 
WWV_FLOW_FLASH_CHART_SERIES
SERIES_QUERY
SYS_LOB0000073224C00006$$
SYSAUX
65,536
SYS_IL0000073224C00006$$
YES
 
WWV_FLOW_INSTALL
DEINSTALL_SCRIPT
SYS_LOB0000073178C00021$$
SYSAUX
65,536
SYS_IL0000073178C00021$$
YES
 
WWV_FLOW_LIST_TEMPLATES
ITEM_TEMPLATE_CURR_W_CHILD
SYS_LOB0000072709C00014$$
SYSAUX
65,536
SYS_IL0000072709C00014$$
YES
   
ITEM_TEMPLATE_NONCURR_W_CHILD
SYS_LOB0000072709C00015$$
SYSAUX
65,536
SYS_IL0000072709C00015$$
YES
   
LIST_TEMPLATE_CURRENT
SYS_LOB0000072709C00004$$
SYSAUX
65,536
SYS_IL0000072709C00004$$
YES
   
LIST_TEMPLATE_NONCURRENT
SYS_LOB0000072709C00005$$
SYSAUX
65,536
SYS_IL0000072709C00005$$
YES
   
SUB_LIST_ITEM_CURRENT
SYS_LOB0000072709C00012$$
SYSAUX
65,536
SYS_IL0000072709C00012$$
YES
   
SUB_LIST_ITEM_NONCURRENT
SYS_LOB0000072709C00013$$
SYSAUX
65,536
SYS_IL0000072709C00013$$
YES
   
SUB_TEMPLATE_CURR_W_CHILD
SYS_LOB0000072709C00016$$
SYSAUX
65,536
SYS_IL0000072709C00016$$
YES
   
SUB_TEMPLATE_NONCURR_W_CHILD
SYS_LOB0000072709C00017$$
SYSAUX
65,536
SYS_IL0000072709C00017$$
YES
 
WWV_FLOW_PAGE_GENERIC_ATTR
ATTRIBUTE_VALUE
SYS_LOB0000072739C00005$$
SYSAUX
65,536
SYS_IL0000072739C00005$$
YES
 
WWV_FLOW_PAGE_PLUGS
CUSTOM_ITEM_LAYOUT
SYS_LOB0000072729C00128$$
SYSAUX
65,536
SYS_IL0000072729C00128$$
YES
   
PLUG_SOURCE
SYS_LOB0000072729C00010$$
SYSAUX
4,194,304
SYS_IL0000072729C00010$$
YES
 
WWV_FLOW_PAGE_PLUG_TEMPLATES
TEMPLATE
SYS_LOB0000072687C00004$$
SYSAUX
65,536
SYS_IL0000072687C00004$$
YES
   
TEMPLATE2
SYS_LOB0000072687C00005$$
SYSAUX
65,536
SYS_IL0000072687C00005$$
YES
   
TEMPLATE3
SYS_LOB0000072687C00006$$
SYSAUX
65,536
SYS_IL0000072687C00006$$
YES
 
WWV_FLOW_PROCESSING
PROCESS_SQL_CLOB
SYS_LOB0000072604C00007$$
SYSAUX
65,536
SYS_IL0000072604C00007$$
YES
 
WWV_FLOW_RANDOM_IMAGES
BLOB_CONTENT
SYS_LOB0000073229C00004$$
SYSAUX
65,536
SYS_IL0000073229C00004$$
YES
 
WWV_FLOW_REGION_REPORT_COLUMN
PK_COL_SOURCE
SYS_LOB0000073093C00044$$
SYSAUX
65,536
SYS_IL0000073093C00044$$
YES
 
WWV_FLOW_ROW_TEMPLATES
ROW_TEMPLATE1
SYS_LOB0000072697C00008$$
SYSAUX
65,536
SYS_IL0000072697C00008$$
YES
   
ROW_TEMPLATE2
SYS_LOB0000072697C00011$$
SYSAUX
65,536
SYS_IL0000072697C00011$$
YES
   
ROW_TEMPLATE3
SYS_LOB0000072697C00014$$
SYSAUX
65,536
SYS_IL0000072697C00014$$
YES
   
ROW_TEMPLATE4
SYS_LOB0000072697C00017$$
SYSAUX
65,536
SYS_IL0000072697C00017$$
YES
 
WWV_FLOW_SHORTCUTS
SHORTCUT
SYS_LOB0000072852C00013$$
SYSAUX
65,536
SYS_IL0000072852C00013$$
YES
 
WWV_FLOW_STEPS
HELP_TEXT
SYS_LOB0000072636C00016$$
SYSAUX
65,536
SYS_IL0000072636C00016$$
YES
   
HTML_PAGE_HEADER
SYS_LOB0000072636C00021$$
SYSAUX
458,752
SYS_IL0000072636C00021$$
YES
 
WWV_FLOW_STEP_PROCESSING
PROCESS_SQL_CLOB
SYS_LOB0000072675C00009$$
SYSAUX
2,097,152
SYS_IL0000072675C00009$$
YES
 
WWV_FLOW_TEMPLATES
BOX
SYS_LOB0000072582C00018$$
SYSAUX
65,536
SYS_IL0000072582C00018$$
YES
   
FOOTER_TEMPLATE
SYS_LOB0000072582C00006$$
SYSAUX
65,536
SYS_IL0000072582C00006$$
YES
   
HEADER_TEMPLATE
SYS_LOB0000072582C00005$$
SYSAUX
65,536
SYS_IL0000072582C00005$$
YES
 
WWV_FLOW_THEMES
THEME_IMAGE
SYS_LOB0000072752C00029$$
SYSAUX
65,536
SYS_IL0000072752C00029$$
YES
 
WWV_FLOW_WORKSHEETS
SQL_QUERY
SYS_LOB0000073235C00019$$
SYSAUX
327,680
SYS_IL0000073235C00019$$
YES
 
WWV_MIG_FORMS
FILE_CONTENT
SYS_LOB0000074404C00007$$
SYSAUX
65,536
SYS_IL0000074404C00007$$
YES
   
SYS_NC00009$
SYS_LOB0000074404C00009$$
SYSAUX
131,072
SYS_IL0000074404C00009$$
YES
 
WWV_MIG_FRM_MENUS
FILE_CONTENT
SYS_LOB0000074783C00007$$
SYSAUX
65,536
SYS_IL0000074783C00007$$
YES
   
SYS_NC00009$
SYS_LOB0000074783C00009$$
SYSAUX
131,072
SYS_IL0000074783C00009$$
YES
 
WWV_MIG_OLB
FILE_CONTENT
SYS_LOB0000074852C00007$$
SYSAUX
65,536
SYS_IL0000074852C00007$$
YES
   
SYS_NC00009$
SYS_LOB0000074852C00009$$
SYSAUX
131,072
SYS_IL0000074852C00009$$
YES
 
WWV_MIG_PLSQL_LIBS
FILE_CONTENT
SYS_LOB0000074414C00007$$
SYSAUX
65,536
SYS_IL0000074414C00007$$
YES
   
SYS_NC00010$
SYS_LOB0000074414C00010$$
SYSAUX
131,072
SYS_IL0000074414C00010$$
YES
 
WWV_MIG_RPTS
FILE_CONTENT
SYS_LOB0000074692C00007$$
SYSAUX
65,536
SYS_IL0000074692C00007$$
YES
   
SYS_NC00009$
SYS_LOB0000074692C00009$$
SYSAUX
131,072
SYS_IL0000074692C00009$$
YES
OE
ACTION_TABLE
SYS_XDBPD$
SYS_LOB0000076715C00004$$
USERS
65,536
SYS_IL0000076715C00004$$
YES
 
CUSTOMERS
"CUST_GEO_LOCATION"."SDO_ELEM_INFO"
SYS_LOB0000076295C00022$$
EXAMPLE
65,536
SYS_IL0000076295C00022$$
YES
   
"CUST_GEO_LOCATION"."SDO_ORDINATES"
SYS_LOB0000076295C00023$$
EXAMPLE
65,536
SYS_IL0000076295C00023$$
YES
 
LINEITEM_TABLE
"PART"."SYS_XDBPD$"
SYS_LOB0000076719C00010$$
USERS
65,536
SYS_IL0000076719C00010$$
YES
   
SYS_XDBPD$
SYS_LOB0000076719C00005$$
USERS
65,536
SYS_IL0000076719C00005$$
YES
 
PURCHASEORDER
"XMLDATA"."ACTIONS"."SYS_XDBPD$"
SYS_XDBPD$882_L
USERS
65,536
SYS_IL0000076714C00012$$
YES
   
"XMLDATA"."LINEITEMS"."SYS_XDBPD$"
SYS_XDBPD$885_L
USERS
65,536
SYS_IL0000076714C00033$$
YES
   
"XMLDATA"."REJECTION"."SYS_XDBPD$"
SYS_XDBPD$883_L
USERS
65,536
SYS_IL0000076714C00017$$
YES
   
"XMLDATA"."SHIPPING_INSTRUCTIONS"."SYS_XDBPD$"
SYS_XDBPD$884_L
USERS
65,536
SYS_IL0000076714C00026$$
YES
   
"XMLDATA"."SYS_XDBPD$"
SYS_XDBPD$881_L
USERS
65,536
SYS_IL0000076714C00008$$
YES
   
"XMLEXTRA"."EXTRADATA"
EXTRADATA886_L
USERS
65,536
SYS_IL0000076714C00005$$
YES
   
"XMLEXTRA"."NAMESPACES"
NAMESPACES887_L
USERS
65,536
SYS_IL0000076714C00004$$
YES
 
WAREHOUSES
"WH_GEO_LOCATION"."SDO_ELEM_INFO"
SYS_LOB0000076300C00012$$
EXAMPLE
65,536
SYS_IL0000076300C00012$$
YES
   
"WH_GEO_LOCATION"."SDO_ORDINATES"
SYS_LOB0000076300C00013$$
EXAMPLE
65,536
SYS_IL0000076300C00013$$
YES
   
SYS_NC00003$
SYS_LOB0000076300C00003$$
EXAMPLE
131,072
SYS_IL0000076300C00003$$
YES
ORDDATA
ORDDCM_CT_PRED_OPRD
SYS_NC00004$
SYS_LOB0000059398C00004$$
SYSAUX
131,072
SYS_IL0000059398C00004$$
YES
 
ORDDCM_CT_PRED_OPRD_WRK
SYS_NC00004$
SYS_LOB0000059522C00004$$
SYSAUX
131,072
SYS_IL0000059522C00004$$
YES
 
ORDDCM_DOCS
SYS_NC00005$
SYS_LOB0000059327C00005$$
SYSAUX
1,245,184
SYS_IL0000059327C00005$$
YES
 
ORDDCM_DOCS_WRK
SYS_NC00005$
SYS_LOB0000059475C00005$$
SYSAUX
1,245,184
SYS_IL0000059475C00005$$
YES
 
ORDDCM_MAPPING_DOCS
SYS_NC00007$
SYS_LOB0000059354C00007$$
SYSAUX
131,072
SYS_IL0000059354C00007$$
YES
 
ORDDCM_MAPPING_DOCS_WRK
SYS_NC00007$
SYS_LOB0000059494C00007$$
SYSAUX
131,072
SYS_IL0000059494C00007$$
YES
PM
ONLINE_MEDIA
"PRODUCT_AUDIO"."COMMENTS"
SYS_LOB0000076307C00062$$
EXAMPLE
65,536
SYS_IL0000076307C00062$$
YES
   
"PRODUCT_AUDIO"."SOURCE"."LOCALDATA"
SYS_LOB0000076307C00054$$
EXAMPLE
4,194,304
SYS_IL0000076307C00054$$
YES
   
"PRODUCT_PHOTO"."SOURCE"."LOCALDATA"
SYS_LOB0000076307C00003$$
EXAMPLE
196,608
SYS_IL0000076307C00003$$
YES
   
"PRODUCT_PHOTO_SIGNATURE"."SIGNATURE"
SYS_LOB0000076307C00017$$
EXAMPLE
65,536
SYS_IL0000076307C00017$$
YES
   
"PRODUCT_TESTIMONIALS"."COMMENTS"
SYS_LOB0000076307C00080$$
EXAMPLE
65,536
SYS_IL0000076307C00080$$
YES
   
"PRODUCT_TESTIMONIALS"."SOURCE"."LOCALDATA"
SYS_LOB0000076307C00071$$
EXAMPLE
65,536
SYS_IL0000076307C00071$$
YES
   
"PRODUCT_THUMBNAIL"."SOURCE"."LOCALDATA"
SYS_LOB0000076307C00019$$
EXAMPLE
65,536
SYS_IL0000076307C00019$$
YES
   
"PRODUCT_VIDEO"."COMMENTS"
SYS_LOB0000076307C00042$$
EXAMPLE
458,752
SYS_IL0000076307C00042$$
YES
   
"PRODUCT_VIDEO"."SOURCE"."LOCALDATA"
SYS_LOB0000076307C00034$$
EXAMPLE
5,242,880
SYS_IL0000076307C00034$$
YES
   
PRODUCT_TEXT
SYS_LOB0000076307C00069$$
EXAMPLE
65,536
SYS_IL0000076307C00069$$
YES
 
PRINT_MEDIA
"AD_HEADER"."LOGO"
SYS_LOB0000076328C00015$$
EXAMPLE
131,072
SYS_IL0000076328C00015$$
YES
   
AD_COMPOSITE
SYS_LOB0000076328C00003$$
EXAMPLE
196,608
SYS_IL0000076328C00003$$
YES
   
AD_FINALTEXT
SYS_LOB0000076328C00005$$
EXAMPLE
65,536
SYS_IL0000076328C00005$$
YES
   
AD_FLTEXTN
SYS_LOB0000076328C00006$$
EXAMPLE
65,536
SYS_IL0000076328C00006$$
YES
   
AD_PHOTO
SYS_LOB0000076328C00009$$
EXAMPLE
65,536
SYS_IL0000076328C00009$$
YES
   
AD_SOURCETEXT
SYS_LOB0000076328C00004$$
EXAMPLE
65,536
SYS_IL0000076328C00004$$
YES
 
TEXTDOCS_NESTEDTAB
FORMATTED_DOC
SYS_LOB0000076329C00004$$
EXAMPLE
131,072
SYS_IL0000076329C00004$$
YES
SH
DR$SUP_TEXT_IDX$I
TOKEN_INFO
SYS_LOB0000076629C00006$$
EXAMPLE
65,536
SYS_IL0000076629C00006$$
YES
 
DR$SUP_TEXT_IDX$R
DATA
SYS_LOB0000076632C00002$$
EXAMPLE
65,536
SYS_IL0000076632C00002$$
YES

 

[回到目录]



不能扩展的对象



Segments that cannot extend because of MAXEXTENTS or not enough space 

[回到目录]



扩展超过1/2最大扩展度的对象


 

[回到目录]



行链接或行迁移的表



NOTE: Tables must have statistics gathered 

[回到目录]



分区表情况


 



表大小超过10GB未建分区的


 

[回到目录]



分区最多的前10个对象


 

TABLE_OWNERTABLE_NAMECNT
SH SALES 28
SH COSTS 28
SYS WRH$_ACTIVE_SESSION_HISTORY 2
SYSTEM LOGMNR_LOBFRAG$ 2
SYSTEM LOGMNR_OPQTYPE$ 2
SYS WRH$_WAITSTAT 2
SYSTEM LOGMNRC_GTCS 2
SYSTEM LOGMNRP_CTAS_PART_MAP 2
SYSTEM LOGMNR_ATTRCOL$ 2
SYSTEM LOGMNR_DICTSTATE$ 2

 

[回到目录]



分区个数超过100个的表


 

[回到目录]



无效对象


 



无效的对象


 

OwnerObject NameObject TypeStatusHANDS_ON
************************************************************************************* ------------------------------      
Grand Total: 0      

 

[回到目录]



无效的普通索引


 

[回到目录]



无效的分区索引




无效的触发器


 

OWNERTRIGGER_NAMETABLE_NAMESTATUS
HR SECURE_EMPLOYEES EMPLOYEES DISABLED

 

[回到目录]



索引情况


 



索引个数超过5个的表


 

OWNERTABLE_NAMECNT
PM ONLINE_MEDIA 11
OE PURCHASEORDER 10
PM PRINT_MEDIA 8
OE CUSTOMERS 7
HR EMPLOYEES 6
OE WAREHOUSES 5
FLOWS_FILES WWV_FLOW_FILE_OBJECTS$ 5
SH SALES 5

 

[回到目录]



大表未建索引



● 大于2G大表未建索引




● 大于2GB的分区表未建任何索引


 

[回到目录]



组合索引与单列索引存在交叉


 

TABLE_OWNERTABLE_NAMECROSS_IDX_RATE
FLOWS_FILES WWV_FLOW_FILE_OBJECTS$ .8
HR JOB_HISTORY .8
OE INVENTORIES .66
IX AQ$_STREAMS_QUEUE_TABLE_C .66
OE ORDER_ITEMS .5

 

[回到目录]



组合索引组合列超过4个的


 

TABLE_OWNERTABLE_NAMEINDEX_NAMECOUNT(*)
IX AQ$_STREAMS_QUEUE_TABLE_I SYS_IOT_TOP_76262 9
IX AQ$_ORDERS_QUEUETABLE_I SYS_IOT_TOP_76256 8
SH DR$SUP_TEXT_IDX$I DR$SUP_TEXT_IDX$X 5
IX AQ$_STREAMS_QUEUE_TABLE_G SYS_IOT_TOP_76266 4
IX AQ$_STREAMS_QUEUE_TABLE_H SYS_IOT_TOP_76258 4
IX AQ$_ORDERS_QUEUETABLE_G SYS_IOT_TOP_76253 4
IX AQ$_ORDERS_QUEUETABLE_H SYS_IOT_TOP_76251 4

 

[回到目录]



位图索引和函数索引


 

OWNERTABLE_NAMEINDEX_NAMEINDEX_TYPESTATUSBLEVELLEAF_BLOCKS
OE CUSTOMERS CUST_UPPER_NAME_IX FUNCTION-BASED NORMAL VALID 1 2
SH COSTS COSTS_PROD_BIX BITMAP N/A 1 25
SH CUSTOMERS CUSTOMERS_GENDER_BIX BITMAP VALID 1 3
SH CUSTOMERS CUSTOMERS_MARITAL_BIX BITMAP VALID 1 5
SH CUSTOMERS CUSTOMERS_YOB_BIX BITMAP VALID 1 19
SH FWEEK_PSCAT_SALES_MV FW_PSC_S_MV_SUBCAT_BIX BITMAP VALID 1 3
SH FWEEK_PSCAT_SALES_MV FW_PSC_S_MV_CHAN_BIX BITMAP VALID 0 1
SH FWEEK_PSCAT_SALES_MV FW_PSC_S_MV_PROMO_BIX BITMAP VALID 0 1
SH FWEEK_PSCAT_SALES_MV FW_PSC_S_MV_WD_BIX BITMAP VALID 1 4
SH PRODUCTS PRODUCTS_PROD_STATUS_BIX BITMAP VALID 0 1
SH SALES SALES_PROD_BIX BITMAP N/A 1 32
SH SALES SALES_CHANNEL_BIX BITMAP N/A 1 47
SH SALES SALES_TIME_BIX BITMAP N/A 1 57
SH SALES SALES_PROMO_BIX BITMAP N/A 1 30
SH SALES SALES_CUST_BIX BITMAP N/A 1 452
SH COSTS COSTS_TIME_BIX BITMAP N/A 1 34

 

[回到目录]



将外键未建索引的情况列出


 

OWNERTABLE_NAMECONSTRAINT_NAMECOLUMNS
SH CUSTOMERS CUSTOMERS_COUNTRY_FK COUNTRY_ID
SH COSTS COSTS_CHANNEL_FK CHANNEL_ID
SCOTT EMP FK_DEPTNO DEPTNO
HR COUNTRIES COUNTR_REG_FK REGION_ID
HR LOCATIONS LOC_C_ID_FK PRODUCT_ID
SH COSTS COSTS_PROMO_FK PROMO_ID
HR DEPARTMENTS DEPT_MGR_FK MANAGER_ID
PM ONLINE_MEDIA LOC_C_ID_FK PRODUCT_ID

 

[回到目录]



其他对象


 



数据库目录



● 数据库目录概览


 

OwnerDirectory NameDirectory Path
SYS
DATA_FILE_DIR /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/sales_history/
  DATA_PUMP_DIR /u01/app/oracle/admin/oradg11g/dpdump/
  DIR_ALERT_CHECKHELTH_LHR_1 /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace
  LOG_FILE_DIR /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/log/
  MEDIA_DIR /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/product_media/
  ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/dbhome_1/ccr/state
  SS_OE_XMLDIR /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry/
  SUBDIR /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry//2002/Sep
  XMLDIR /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/xml


● 目录权限


 

Directory NameGranteePrivilegeGrantable?
DATA_FILE_DIR SH READ
NO
DATA_PUMP_DIR EXP_FULL_DATABASE READ
NO
    WRITE
NO
  IMP_FULL_DATABASE READ
NO
    WRITE
NO
DIR_ALERT_CHECKHELTH_LHR_1 LHR READ
YES
    WRITE
YES
LOG_FILE_DIR SH READ
NO
    WRITE
NO
MEDIA_DIR PM READ
NO
ORACLE_OCM_CONFIG_DIR ORACLE_OCM READ
NO
    WRITE
NO
SS_OE_XMLDIR OE READ
YES
    WRITE
YES
SUBDIR OE READ
YES
    WRITE
YES

 

[回到目录]



回收站情况



● 回收站中最早的10个对象


 

Owneroriginal_nameObject 
Type
object_nameTablespaceOperationcreatetimedroptimeCan 
Undrop?
Can 
Purge?
Bytes
LHR
TESTDG TABLE BIN$HfsE79K3Nl/gU4I7qMC29w==$0 USERS DROP
2015-07-27:14:07:32
2015-08-23:20:55:45
YES
YES
65,536

 

[回到目录]


● 回收站中对象的大小


 

OwnerSUM(RECYB_SIZE_M)SUM(RECYB_CNT)
LHR .0625 1
合计 .0625 1

 

[回到目录]



数据库链路


 

[回到目录]



外部表


 

OWNERTABLE_NAMETYPTYPE_NAMEDEFDEFAULT_DIRECTORY_NAMEREJECT_LIMITACCESS_ACCESS_PARAMETERSPROPERTY
SH SALES_TRANSACTIONS_EXT SYS ORACLE_LOADER SYS DATA_FILE_DIR 100 CLOB RECORDS DELIMITED BY NEWLINE CHARACTERSE T US7ASCII TERRITORY AMERICAN BA DFILE log_file_dir:'ext_1v3.bad' LOG FILE log_file_dir:'ext_1v3.log' FIEL DS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '^' LDRTRIM ( PROD_ID , CUST_ID , TIME_ID DATE(10) "YYYY-MM-DD", CHANN EL_ID , PROMO_ID , QUANTITY_SOLD , AMOUNT_SOLD , UNIT_COST , UNIT_ PRICE ) ALL
LHR T_ALERT_CHECKHELTH_LHR_1 SYS ORACLE_LOADER SYS DIR_ALERT_CHECKHELTH_LHR_1 UNLIMITED CLOB records delimited by newline    ALL

 

[回到目录]



告警日志



● 查看最新的100行告警日志记录(排除日志切换)


 

INSTANCERNTEXT
instance1 992 NSA2 started with pid=25
instance1 993 Wed Aug 26 15:24:25 2015
instance1 994 NSA3 started with pid=26
instance1 995 Wed Aug 26 15:24:25 2015
instance1 996 NSA4 started with pid=27
instance1 998 Error 1034 received logging on to the standby
instance1 999 PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradglg'. Error is 1034.
instance1 1000 Error 1034 received logging on to the standby
instance1 1001 FAL[server
instance1 1002 FAL[server
instance1 1003 ARCH: FAL archive failed. Archiver continuing
instance1 1004 ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance1 1005 Error 1034 received logging on to the standby
instance1 1006 PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradgphy'. Error is 1034.
instance1 1007 Error 1034 received logging on to the standby
instance1 1008 FAL[server
instance1 1009 FAL[server
instance1 1010 ARCH: FAL archive failed. Archiver continuing
instance1 1011 ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance1 1012 [58778] Successfully onlined Undo Tablespace 2.
instance1 1013 Undo initialization finished serial:0 start:52945694 end:52946474 diff:780 (7 seconds)
instance1 1014 Verifying file header compatibility for 11g tablespace encryption..
instance1 1015 Verifying 11g file header compatibility for tablespace encryption completed
instance1 1016 SMON: enabling tx recovery
instance1 1017 Database Characterset is ZHS16GBK
instance1 1018 No Resource Manager plan active
instance1 1019 replication_dependency_tracking turned off (no async multimaster replication found)
instance1 1020 Starting background process QMNC
instance1 1021 Wed Aug 26 15:24:27 2015
instance1 1022 QMNC started with pid=28
instance1 1023 Error 1034 received logging on to the standby
instance1 1024 FAL[server
instance1 1025 FAL[server
instance1 1026 ARCH: FAL archive failed. Archiver continuing
instance1 1027 ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance1 1028 Wed Aug 26 15:24:28 2015
instance1 1031 Completed: ALTER DATABASE OPEN
instance1 1033 Wed Aug 26 15:24:29 2015
instance1 1034 Starting background process CJQ0
instance1 1035 Wed Aug 26 15:24:29 2015
instance1 1036 db_recovery_file_dest_size of 4122 MB is 3.37% used. This is a
instance1 1037 user-specified limit on the amount of space that will be used by this
instance1 1038 database for recovery-related files
instance1 1039 space available in the underlying filesystem or ASM diskgroup.
instance1 1040 Wed Aug 26 15:24:29 2015
instance1 1041 CJQ0 started with pid=33
instance1 1042 Wed Aug 26 15:28:56 2015
instance1 1045 Wed Aug 26 15:28:56 2015
instance1 1047 Wed Aug 26 15:29:26 2015
instance1 1050 Wed Aug 26 15:29:26 2015
instance1 1051 ARC2: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_2
instance1 1052 Wed Aug 26 15:29:26 2015
instance1 1054 Wed Aug 26 15:29:26 2015
instance1 1055 ******************************************************************
instance1 1056 LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
instance1 1057 ******************************************************************
instance1 1058 LNS: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_2
instance1 1059 Wed Aug 26 15:29:27 2015
instance1 1060 Starting background process SMCO
instance1 1061 Wed Aug 26 15:29:29 2015
instance1 1062 SMCO started with pid=29
instance1 1063 ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_3
instance1 1064 Wed Aug 26 15:29:35 2015
instance1 1065 ARC0: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_2
instance1 1066 Wed Aug 26 15:29:39 2015
instance1 1067 ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_4
instance1 1068 Wed Aug 26 15:30:23 2015
instance1 1069 Time drift detected. Please check VKTM trace file for more details.
instance1 1070 Wed Aug 26 15:30:42 2015
instance1 1071 ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_4
instance1 1072 ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_3
instance1 1073 Wed Aug 26 15:54:33 2015
instance1 1076 Wed Aug 26 15:54:33 2015
instance1 1077 ******************************************************************
instance1 1078 LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_3
instance1 1079 ******************************************************************
instance1 1080 Wed Aug 26 15:54:33 2015
instance1 1081 ******************************************************************
instance1 1082 LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_4
instance1 1083 ******************************************************************
instance1 1084 Wed Aug 26 15:54:33 2015
instance1 1085 LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_2
instance1 1086 Wed Aug 26 15:54:34 2015
instance1 1088 LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_4
instance1 1089 LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_3
instance1 1090 Wed Aug 26 15:54:36 2015
instance1 1091 ARC0: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_3
instance1 1092 ARC3: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_4

 

                FROM   T_ALERT_CHECKHELTH_LHR_2 t) a
                       *

ERROR at line 8: 
ORA-00942: table or view does not exist 
● 查看最新的10条ora告警日志记录


 

INSTANCERNTEXT
instance1 334 ORA-03135: connection lost contact
instance1 368 ORA-03135: connection lost contact
instance1 430 ORA-03135: connection lost contact
instance1 450 ORA-03135: connection lost contact
instance1 470 ORA-03135: connection lost contact
instance1 515 ORA-03135: connection lost contact
instance1 552 ORA-03135: connection lost contact
instance1 564 ORA-16439: Standby not ready to receive redo at this time
instance1 738 ORA-03135: connection lost contact

 

                FROM   T_ALERT_CHECKHELTH_LHR_2 t) a
                       *

ERROR at line 8: 
ORA-00942: table or view does not exist 

[回到目录]



所有的触发器


 

OWNERTRIGGER_NAMETABLE_NAMESTATUS
FLOWS_FILES WWV_BIU_FLOW_FILE_OBJECTS WWV_FLOW_FILE_OBJECTS$ ENABLED
HR SECURE_EMPLOYEES EMPLOYEES DISABLED
HR UPDATE_JOB_HISTORY EMPLOYEES ENABLED
OE INSERT_ORD_LINE ORDER_ITEMS ENABLED
OE PURCHASEORDER$xd PURCHASEORDER ENABLED
OE ORDERS_ITEMS_TRG OC_ORDERS ENABLED
OE ORDERS_TRG OC_ORDERS ENABLED

 

[回到目录]



序列cache小于20



● 序列cache小于20,一般情况下将其增至1000左右,序列默认的20太小了 

SEQUENCE_OWNERSEQUENCE_NAMECACHE_SIZEALTER_SEQUENCE
DBSNMP MGMT_RESPONSE_SNAPSHOT_ID 20 alter sequence DBSNMP.MGMT_RESPONSE_SNAPSHOT_ID cache 1000;
DBSNMP MGMT_RESPONSE_CAPTURE_ID 20 alter sequence DBSNMP.MGMT_RESPONSE_CAPTURE_ID cache 1000;
XDB CLIENTID_SEQUENCE 10 alter sequence XDB.CLIENTID_SEQUENCE cache 1000;
XDB STATEID_RESTART_SEQUENCE 20 alter sequence XDB.STATEID_RESTART_SEQUENCE cache 1000;
XDB XDB$TYPEID_SEQ 20 alter sequence XDB.XDB$TYPEID_SEQ cache 1000;
XDB XDB$NAMESUFF_SEQ 20 alter sequence XDB.XDB$NAMESUFF_SEQ cache 1000;
XDB XDB$PROPNUM_SEQ 20 alter sequence XDB.XDB$PROPNUM_SEQ cache 1000;
ORDDATA ORDDCM_CT_PRED_SET_SEQ 0 alter sequence ORDDATA.ORDDCM_CT_PRED_SET_SEQ cache 1000;
ORDDATA ORDDCM_CT_PRED_SEQ 0 alter sequence ORDDATA.ORDDCM_CT_PRED_SEQ cache 1000;
ORDDATA ORDDCM_DATA_MODEL_SEQ 0 alter sequence ORDDATA.ORDDCM_DATA_MODEL_SEQ cache 1000;
ORDDATA ORDDCM_UID_DEFS_UDID_SEQ 0 alter sequence ORDDATA.ORDDCM_UID_DEFS_UDID_SEQ cache 1000;
ORDDATA ORDDCM_RT_PREF_P_PPID_SEQ 0 alter sequence ORDDATA.ORDDCM_RT_PREF_P_PPID_SEQ cache 1000;
ORDDATA ORDDCM_ANON_ATTRS_SEQ 0 alter sequence ORDDATA.ORDDCM_ANON_ATTRS_SEQ cache 1000;
ORDDATA ORDDCM_MPD_P_MPID_SEQ 0 alter sequence ORDDATA.ORDDCM_MPD_P_MPID_SEQ cache 1000;
ORDDATA ORDDCM_DICT_A_DA_ID_SEQ 0 alter sequence ORDDATA.ORDDCM_DICT_A_DA_ID_SEQ cache 1000;
ORDDATA ORDDCM_PRV_A_PA_ID_SEQ 0 alter sequence ORDDATA.ORDDCM_PRV_A_PA_ID_SEQ cache 1000;
ORDDATA ORDDCM_STD_A_SA_ID_SEQ 0 alter sequence ORDDATA.ORDDCM_STD_A_SA_ID_SEQ cache 1000;
ORDDATA ORDDCM_DOCS_ID_SEQ 0 alter sequence ORDDATA.ORDDCM_DOCS_ID_SEQ cache 1000;
ORDDATA ORDDCM_STOREDTAGS_STID_SEQ 0 alter sequence ORDDATA.ORDDCM_STOREDTAGS_STID_SEQ cache 1000;
APEX_030200 WWV_FLOW_WORKSHEET_SEQ 20 alter sequence APEX_030200.WWV_FLOW_WORKSHEET_SEQ cache 1000;
APEX_030200 WWV_FLOW_VERSION_SEQ 20 alter sequence APEX_030200.WWV_FLOW_VERSION_SEQ cache 1000;
APEX_030200 WWV_FLOW_SESSION_SEQ 20 alter sequence APEX_030200.WWV_FLOW_SESSION_SEQ cache 1000;
APEX_030200 WWV_SEQ 20 alter sequence APEX_030200.WWV_SEQ cache 1000;
HR EMPLOYEES_SEQ 0 alter sequence HR.EMPLOYEES_SEQ cache 1000;
HR DEPARTMENTS_SEQ 0 alter sequence HR.DEPARTMENTS_SEQ cache 1000;
HR LOCATIONS_SEQ 0 alter sequence HR.LOCATIONS_SEQ cache 1000;
OE ORDERS_SEQ 0 alter sequence OE.ORDERS_SEQ cache 1000;
IX AQ$_STREAMS_QUEUE_TABLE_N 20 alter sequence IX.AQ$_STREAMS_QUEUE_TABLE_N cache 1000;
IX AQ$_ORDERS_QUEUETABLE_N 20 alter sequence IX.AQ$_ORDERS_QUEUETABLE_N cache 1000;

● 历史等待事件中是否有序列等待 

[回到目录]



并行度


 



表带有并行度


 

OWNERTABLE_NAMEDEGREE
LHR T_ALERT_CHECKHELTH_LHR_1 8

 

[回到目录]



索引带有并行度


 

[回到目录]


数据库性能分析

 



AWR


 



AWR统计


 

实例 
名称
统计时间内存读(MB)磁盘读(MB)磁盘写(KB)日志量(KB)硬分析(个)分析(个)事务数CPU(秒)
1
2015-08-26 15:34:42 0 0 -1 -1 0 0 0 29
  2015-08-25 09:18:07 0 0 1 0 0 0 0 12
  2015-08-24 00:01:06 0 0 1 1 0 1 0 6
  2015-08-23 23:00:26 0 0 3 1 0 0 0 5
  2015-08-23 22:00:49 0 0 1 1 0 0 0 6
  2015-08-23 21:01:07 0 0 2 1 0 0 0 7
  2015-08-23 20:00:27 0 0 2 1 0 0 0 7
  2015-08-23 19:00:48 1 0 4 3 0 1 0 32

 

[回到目录]



AWR参数配置状况


 

Database IDDatabase NameSnap IntervalRetention PeriodTop N SQL
1403587593
ORADG11G +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT

 

[回到目录]



AWR视图中的load profile



● 近7天以来AWR视图中的load profile信息
 

SNAP_DATESNAP_TIME_RANGESNAP_ID_RANGETIMESTARTUP_TIMEelapse(min)DB time(min)SESSIONSCursors/SessionREDOredo/sredo/tLOGICALlogical/slogical/tPHYSICALphy/sphy/tEXECSexecs/sexecs/tPARSEparse/sparse/tHARDPARSEhardparse/shardparse/tTRANStrans/s
2015-08-25 2015-08-24 00:01~2015-08-25 09:18 111~112 09:18 2015-08-23 17:35:19 1997.02 2.99 33~32 1.09~.96 52713324 439.93 304701.29 217925 1.82 1259.68 45023 .38 260.25 35977 .3 207.96 6871 .06 39.72 2056 .02 11.88 173 0
2015-08-24 2015-08-23 23:00~2015-08-24 00:01 110~111 00:01 2015-08-23 17:35:19 60.67 .04 34~33 .94~1.09 2074312 569.87 62857.94 45272 12.44 1371.88 2039 .56 61.79 11038 3.03 334.48 1850 .51 56.06 465 .13 14.09 33 .01
2015-08-23 2015-08-23 22:00~2015-08-23 23:00 109~110 23:00 2015-08-23 17:35:19 59.62 .02 35~34 1.08~.94 2075428 580.21 61042 43888 12.27 1290.82 1858 .52 54.65 8709 2.43 256.15 1265 .35 37.21 430 .12 12.65 34 .01
2015-08-23 2015-08-23 21:01~2015-08-23 22:00 108~109 22:00 2015-08-23 17:35:19 59.7 .08 31~35 1.19~1.08 2208704 616.61 66930.42 33874 9.46 1026.48 1755 .49 53.18 7585 2.12 229.85 1177 .33 35.67 379 .11 11.48 33 .01
2015-08-23 2015-08-23 20:00~2015-08-23 21:01 107~108 21:01 2015-08-23 17:35:19 60.67 .06 37~31 1.05~1.19 3626028 996.16 95421.79 45485 12.5 1196.97 2290 .63 60.26 9350 2.57 246.05 1382 .38 36.37 447 .12 11.76 38 .01
2015-08-23 2015-08-23 19:00~2015-08-23 20:00 106~107 20:00 2015-08-23 17:35:19 59.65 .05 38~37 1.13~1.05 2684040 749.94 76686.86 49804 13.92 1422.97 3119 .87 89.11 10948 3.06 312.8 1568 .44 44.8 528 .15 15.09 35 .01
2015-08-23 2015-08-23 17:46~2015-08-23 19:00 105~106 19:00 2015-08-23 17:35:19 74.28 .14 33~38 1.33~1.13 12363432 2773.94 475516.62 330477 74.15 12710.65 51483 11.55 1980.12 27628 6.2 1062.62 3689 .83 141.88 1288 .29 49.54 26 .01

 

[回到目录]



热块



● 热块(汇总) 

                          FROM x$bh
                               *

ERROR at line 6: 
ORA-00942: table or view does not exist 
● 热块(展开,未汇总) 

                          FROM x$bh
                               *

ERROR at line 6: 
ORA-00942: table or view does not exist 

[回到目录]



统计信息


 



统计信息是否自动收集


 

CLIENT_NAMESTATUS
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED

 

WINDOW_NAMEWINDOW_NEXT_TIMEWINDOAUTOTASKOPTIMIZESEGMENT_SQL_TUNEHEALTH_M
MONDAY_WINDOW 2015-08-31 22:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
TUESDAY_WINDOW 2015-09-01 22:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
WEDNESDAY_WINDOW 2015-08-26 22:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
THURSDAY_WINDOW 2015-08-27 22:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
FRIDAY_WINDOW 2015-08-28 22:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
SATURDAY_WINDOW 2015-08-29 06:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
SUNDAY_WINDOW 2015-08-30 06:00:00 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED

 

[回到目录]



未收集或很久未收集的表




被收集统计信息的临时表


 

[回到目录]



会话


 



会话概况


 

Instance NameThread NumberCurrent No. of ProcessesMax No. of Processes% Usage
oradg11g
1
34
150
22.67%

 

[回到目录]



会话状态一览



User sessions (excluding SYS and background processes) 

Instance NameThread NumberOracle UserTotal Number of LoginsActive LoginsInactive LoginsKilled Logins
oradg11g
1
LHR
4 1 3 0

 

[回到目录]



登录时间最长的10个会话


 

INST_IDSIDSERIAL#SPIDPROGRAMSTATUSSQL_IDPREV_SQL_IDEVENTWAIT_CLASSLOGON_TIMETOTAL_H
1 125 5 58778 sqlplus@rhel6_lhr (TNS V1-V3) INACTIVE   gg5409ku2xk00 SQL*Net message from client Idle 2015-08-26 15:24:23 .71
1 20 11 59791 plsqldev.exe INACTIVE   3nz260v5dwqnv SQL*Net message from client Idle 2015-08-26 15:32:23 .57
1 146 11 59795 plsqldev.exe INACTIVE   9m7787camwh4m SQL*Net message from client Idle 2015-08-26 15:32:25 .57
1 25 11 59949 sqlplus.exe INACTIVE   ab6c4m41phxmf SQL*Net message from client Idle 2015-08-26 15:35:18 .53
1 154 133 61557 sqlplus.exe ACTIVE f683w8x4kggjj 9babjv8yq8ru3 SQL*Net message to client Network 2015-08-26 16:05:39 .02

 

[回到目录]



超过10小时无响应的会话


 

[回到目录]



提交次数最多的会话


 

[回到目录]



30分钟内CPU或等待最长的会话


 

INST_IDUSERNAMEEVENTSECONDSSQL_IDSQLTEXTSIDSERIAL#MACHINEPROGRAMOSUSER
1 LHR Cpu + Wait For Cpu 1 fq128d6s13bx8 SELECT '
' || l.owner || '
'
         
1 LHR Cpu + Wait For Cpu 1 96ub5w77tu2ac SELECT column_name,data_type_owner,data_type FROM dba_tab_columns where owner=:o and table_name=:t          
1 LHR Cpu + Wait For Cpu 1 duwq6t6ck11ba select * from (select owner, segment_name, segment_type,          
1 LHR Cpu + Wait For Cpu 1 3nd96vy0fb1sv SELECT j.instance_id, j.JOB_CREATOR, j.OWNER, j.job_name, j.state job_ST          
1 SYS Cpu + Wait For Cpu 1 3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1),          
1 LHR Cpu + Wait For Cpu 1 2bmgd7b5y2x6t select owner,table_name, count(*) cnt from dba_indexes where owner not in ('XDB',          
1 LHR Cpu + Wait For Cpu 1 cm4vhpunwknmz SELECT al.thread#, ads.dest_id, ads.DEST_NAME, (SELECT ads.TYPE || ' ' || ad.TA          

 

[回到目录]




 



查看LOCK锁情况


 

INST_IDOS_USER_NAMEUSER_NAMELOCK_TYPEOBJECTLOCK_MODEOWNERSIDSERIAL_NUMID1ID2
1 Administrator LHR   SDO_GEOR_DDL__TABLE$$ Row Exclusive MDSYS 154 133 68064 1

 

[回到目录]



查看谁锁住了谁


 

[回到目录]



游标使用情况


 

[回到目录]



并行进程完成情况


 

[回到目录]



内存占用


 



查询共享内存占有率


 

COUNT(*)ROUND(SUM(SHARABLE_MEM)/1024/1024,2)
5467 41.34

 

[回到目录]



PGA占用最多的进程


 

INST_IDSPIDPIDSIDSERIAL#STATUSPGA_ALLOC_MEMUSERNAMEOSUSERPROGRAMSQL_ID
1 58780 21 135 3 ACTIVE 65055208   oracle oracle@rhel6_lhr (ARC0)  
1 58790 24 11 1 ACTIVE 58894824   oracle oracle@rhel6_lhr (ARC3)  
1 58788 23 136 3 ACTIVE 31361304   oracle oracle@rhel6_lhr (ARC2)  
1 58798 25 138 1 ACTIVE 29862376   oracle oracle@rhel6_lhr (NSA2)  
1 58802 27 139 1 ACTIVE 29862376   oracle oracle@rhel6_lhr (NSA4)  
1 58800 26 13 1 ACTIVE 29862376   oracle oracle@rhel6_lhr (NSA3)  
1 58786 22 10 1 ACTIVE 29534696   oracle oracle@rhel6_lhr (ARC1)  
1 58756 11 130 1 ACTIVE 12085064   oracle oracle@rhel6_lhr (LGWR)  
1 61557 31 154 133 ACTIVE 4426040 LHR Administrator sqlplus.exe 96rxbcbf0rw1x
1 58754 10 5 1 ACTIVE 4147048   oracle oracle@rhel6_lhr (DBW0)  
1 59949 30 25 11 INACTIVE 2787640 LHR Administrator sqlplus.exe  
1 59795 51 146 11 INACTIVE 2573976 LHR Administrator plsqldev.exe  
1 58764 15 132 1 ACTIVE 2320200   oracle oracle@rhel6_lhr (MMON)  
1 58778 19 125 5 INACTIVE 2214552 SYS oracle sqlplus@rhel6_lhr (TNS V1-V3)  
1 58760 13 131 1 ACTIVE 1935672   oracle oracle@rhel6_lhr (SMON)  
1 58863 33 133 11 ACTIVE 1878504   oracle oracle@rhel6_lhr (CJQ0)  
1 59791 50 20 11 INACTIVE 1607992 LHR Administrator plsqldev.exe  
1 58750 8 4 1 ACTIVE 1468232   oracle oracle@rhel6_lhr (DIA0)  
1 58906 37 144 5 ACTIVE 1345848   oracle oracle@rhel6_lhr (Q000)  
1 58762 14 7 1 ACTIVE 1149240   oracle oracle@rhel6_lhr (RECO)  

 

[回到目录]



buffer cache 命中率


 

PHYSICAL_READSDB_BLOCK_GETSCONSISTENT_GETSHit Ratio
58815 14528 951454 93.91%

 

[回到目录]



● librarycache 整体命中率


 

GETSGETHITSHit RatioPINSPINHITSHit Ratio
31803 21473 67.52 77742 65139 83.79

 

[回到目录]



● librarycache 各namaspace 的命中率


 

NAMESPACEGETSGETHITSHit RatioPINSPINHITSHit Ratio
ACCOUNT_STATUS 12 11 91.67 0 0 0
BODY 246 172 69.92 1540 1454 94.42
CLUSTER 722 711 98.48 757 746 98.55
DBINSTANCE 1 0 0 0 0 0
DBLINK 16 15 93.75 0 0 0
DIRECTORY 66 64 96.97 80 74 92.5
EDITION 37 36 97.3 52 49 94.23
INDEX 74 5 6.76 74 5 6.76
JAVA DATA 2 0 0 2 0 0
JAVA RESOURCE 2 0 0 2 0 0
JAVA SOURCE 2 0 0 2 0 0
OBJECT ID 70 0 0 0 0 0
QUEUE 4 2 50 6 2 33.33
RULESET 1 0 0 3 2 66.67
SCHEMA 5367 5348 99.65 0 0 0
SQL AREA 6440 3163 49.11 47913 42276 88.23
SQL AREA BUILD 1852 120 6.48 0 0 0
SQL AREA STATS 1825 77 4.22 1825 77 4.22
TABLE/PROCEDURE 14999 11713 78.09 25433 20429 80.32
TRIGGER 75 43 57.33 75 43 57.33

 

[回到目录]



● latch 的命中率


 

SUM(GETS)SUM(MISSES)ROUND(1-SUM(MISSES)/SUM(GETS),4)
5749373 1838 .9997

 

[回到目录]



等待事件


 



等待事件



● 等待事件(当前)


 

INST_IDWAIT_CLASS#WAIT_CLASSEVENTCOUNTS
1 7 Network SQL*Net message to client 1

 

[回到目录]



● 等待事件(历史汇集)


 

INST_IDEVENTWAIT_CLASSTOTAL_WAITS
1 direct path read User I/O 62530
1 db file sequential read User I/O 36954
1 control file sequential read System I/O 16622
1 SQL*Net message to client Network 6108
1 LNS wait on SENDREQ Network 4072
1 db file scattered read User I/O 3019
1 log file parallel write System I/O 2906
1 control file parallel write System I/O 2790
1 ADR block file write Other 637
1 ADR file lock Other 590
1 Disk file operations I/O User I/O 577
1 ADR block file read Other 397
1 asynch descriptor resize Other 368
1 db file async I/O submit System I/O 239
1 db file parallel read User I/O 221
1 external table write User I/O 176
1 log file sequential read System I/O 147
1 PX Deq: Slave Session Stats Other 128
1 os thread startup Concurrency 102
1 flashback log file read System I/O 88
1 direct path write temp User I/O 87
1 Parameter File I/O User I/O 84
1 LGWR wait for redo copy Other 70
1 Log archive I/O System I/O 69
1 ARCH wait on SENDREQ Network 66
1 PX Deq: Signal ACK RSG Other 64
1 PX Deq: Signal ACK EXT Other 64
1 flashback log file write System I/O 62
1 latch: shared pool Concurrency 59
1 direct path read temp User I/O 54
1 SQL*Net more data to client Network 38
1 SQL*Net break/reset to client Application 32
1 db file single write User I/O 30
1 direct path write User I/O 30
1 latch free Other 28
1 ARCH wait for archivelog lock Other 28
1 flashback log file sync User I/O 26
1 external table open User I/O 24
1 log file sync Commit 22
1 ARCH wait on ATTACH Network 21
1 enq: CF - contention Other 18
1 ARCH wait on DETACH Network 17
1 rdbms ipc reply Other 17
1 library cache: mutex X Concurrency 16
1 log file single write System I/O 14
1 library cache load lock Concurrency 14
1 CSS operation: query Other 12
1 latch: enqueue hash chains Other 10
1 external table read User I/O 8
1 external table seek User I/O 8

 

[回到目录]

 


 

数据库巡检服务报告结束

 

 

...........................................................................................................................................................................................

本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用

ITPUB BLOG:http://blog.itpub.net/26736162

本文地址:http://blog.itpub.net/26736162/viewspace-1783297/

本文pdf版:http://yunpan.cn/cdEQedhCs2kFz  (提取码:ed9b) 

QQ:642808185 若加QQ请注明你所正在读的文章标题

创作时间地点:2015-05-15 10:00~ 2015-08-26 19:00 于唐镇金唐公寓宿舍

<版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任!>

...........................................................................................................................................................................................

 

posted @ 2015-08-26 17:00  DB宝  阅读(5108)  评论(0编辑  收藏  举报