最近一直想用sql来生成oracle的健康检查报告，这样看起来一目了然，经过网上搜资料加自己整理终于算是成型了，部分结果如下图所示， 具体参考附件，恳请广大网友看看是否还有需要添加的地方。 我的oracle 健康检查报告_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   
并行度表带有并行度索引带有并行度   









数据库性能分析
AWRAWR统计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

PRIMARYIMPLICITYES

 

[回到目录]



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

 

SNAP_IDDB_NAMEDBIDINSTANCE_NAMEINSTANCE_NUMBERSTARTUP_TIMERELEASERACHOST_NAMEPLATFORM_NAMECPUSCORESSOCKETSMemory (GB)
113ORADG11G1403587593oradg11g126-AUG-15 03.24.24.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
112ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
111ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
110ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
109ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
108ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
107ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
106ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68
105ORADG11G1403587593oradg11g123-AUG-15 05.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit2217.68

 

[回到目录] [下一项]



所有的初始化参数

 

SPFILE Usage
This database IS using an SPFILE.

 

Parameter NameInstance NameValueDISPLAY_VALUEIs Default?Is Dynamic?ISDEPRECATEDDESCRIPTION
O7_DICTIONARY_ACCESSIBILITYoradg11gFALSEFALSE

TRUE

FALSE

FALSEVersion 7 Dictionary Accessibility Support
active_instance_countoradg11g  

TRUE

FALSE

TRUEnumber of active instances in the cluster database
aq_tm_processesoradg11g11

TRUE

IMMEDIATE

FALSEnumber of AQ Time Managers to start
archive_lag_targetoradg11g00

TRUE

IMMEDIATE

FALSEMaximum number of seconds of redos the standby could lose
asm_diskgroupsoradg11g  

TRUE

IMMEDIATE

FALSEdisk groups to mount automatically
asm_diskstringoradg11g  

TRUE

IMMEDIATE

FALSEdisk set locations for discovery
asm_power_limitoradg11g11

TRUE

IMMEDIATE

FALSEnumber of parallel relocations for disk rebalancing
asm_preferred_read_failure_groupsoradg11g  

TRUE

IMMEDIATE

FALSEpreferred read failure groups
audit_file_destoradg11g/u01/app/oracle/admin/oradg11g/adump/u01/app/oracle/admin/oradg11g/adump

FALSE

DEFERRED

FALSEDirectory in which auditing files are to reside
audit_sys_operationsoradg11gFALSEFALSE

TRUE

FALSE

FALSEenable sys auditing
audit_syslog_leveloradg11g  

TRUE

FALSE

FALSESyslog facility and level
audit_trailoradg11gDBDB

FALSE

FALSE

FALSEenable system auditing
awr_snapshot_time_offsetoradg11g00

TRUE

IMMEDIATE

FALSESetting for AWR Snapshot Time Offset
background_core_dumporadg11gpartialpartial

TRUE

FALSE

FALSECore Size for Background Processes
background_dump_destoradg11g/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace

TRUE

IMMEDIATE

TRUEDetached process dump directory
backup_tape_io_slavesoradg11gFALSEFALSE

TRUE

DEFERRED

FALSEBACKUP Tape I/O slaves
bitmap_merge_area_sizeoradg11g10485761048576

TRUE

FALSE

FALSEmaximum memory allow for BITMAP MERGE
blank_trimmingoradg11gFALSEFALSE

TRUE

FALSE

FALSEblank trimming semantics parameter
buffer_pool_keeporadg11g  

TRUE

FALSE

TRUENumber of database blocks/latches in keep buffer pool
buffer_pool_recycleoradg11g  

TRUE

FALSE

TRUENumber of database blocks/latches in recycle buffer pool
cell_offload_compactionoradg11gADAPTIVEADAPTIVE

TRUE

IMMEDIATE

FALSECell packet compaction strategy
cell_offload_decryptionoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEenable SQL processing offload of encrypted data to cells
cell_offload_parametersoradg11g  

TRUE

IMMEDIATE

FALSEAdditional cell offload parameters
cell_offload_plan_displayoradg11gAUTOAUTO

TRUE

IMMEDIATE

FALSECell offload explain plan display
cell_offload_processingoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEenable SQL processing offload to cells
circuitsoradg11g  

TRUE

IMMEDIATE

FALSEmax number of circuits
client_result_cache_lagoradg11g30003000

TRUE

FALSE

FALSEclient result cache maximum lag in milliseconds
client_result_cache_sizeoradg11g00

TRUE

FALSE

FALSEclient result cache max size in bytes
clonedboradg11gFALSEFALSE

TRUE

FALSE

FALSEclone database
cluster_databaseoradg11gFALSEFALSE

TRUE

FALSE

FALSEif TRUE startup in cluster database mode
cluster_database_instancesoradg11g11

TRUE

FALSE

FALSEnumber of instances to use for sizing cluster db SGA structures
cluster_interconnectsoradg11g  

TRUE

FALSE

FALSEinterconnects for RAC use
commit_loggingoradg11g  

TRUE

IMMEDIATE

FALSEtransaction commit log write behaviour
commit_point_strengthoradg11g11

TRUE

FALSE

FALSEBias this node has toward not preparing in a two-phase commit
commit_waitoradg11g  

TRUE

IMMEDIATE

FALSEtransaction commit log wait behaviour
commit_writeoradg11g  

TRUE

IMMEDIATE

TRUEtransaction commit log write behaviour
compatibleoradg11g11.2.0.0.011.2.0.0.0

FALSE

FALSE

FALSEDatabase will be completely compatible with this software version
control_file_record_keep_timeoradg11g77

TRUE

IMMEDIATE

FALSEcontrol file record keep time in days
control_filesoradg11g/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

FALSEcontrol file names list
control_management_pack_accessoradg11gDIAGNOSTIC+TUNINGDIAGNOSTIC+TUNING

TRUE

IMMEDIATE

FALSEdeclares which manageability packs are enabled
core_dump_destoradg11g/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump

TRUE

IMMEDIATE

FALSECore dump directory
cpu_countoradg11g22

TRUE

IMMEDIATE

FALSEnumber of CPUs for this instance
create_bitmap_area_sizeoradg11g83886088388608

TRUE

FALSE

FALSEsize of create bitmap buffer for bitmap index
create_stored_outlinesoradg11g  

TRUE

IMMEDIATE

FALSEcreate stored outlines for DML statements
cursor_bind_capture_destinationoradg11gmemory+diskmemory+disk

TRUE

IMMEDIATE

FALSEAllowed destination for captured bind variables
cursor_sharingoradg11gEXACTEXACT

TRUE

IMMEDIATE

FALSEcursor sharing mode
cursor_space_for_timeoradg11gFALSEFALSE

TRUE

FALSE

TRUEuse more memory in order to get faster execution
db_16k_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of cache for 16K buffers
db_2k_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of cache for 2K buffers
db_32k_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of cache for 32K buffers
db_4k_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of cache for 4K buffers
db_8k_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of cache for 8K buffers
db_block_buffersoradg11g00

TRUE

FALSE

FALSENumber of database blocks cached in memory
db_block_checkingoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEheader checking and data and index block checking
db_block_checksumoradg11gTYPICALTYPICAL

TRUE

IMMEDIATE

FALSEstore checksum in db blocks and check during reads
db_block_sizeoradg11g81928192

FALSE

FALSE

FALSESize of database block in bytes
db_cache_adviceoradg11gONON

TRUE

IMMEDIATE

FALSEBuffer cache sizing advisory
db_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of DEFAULT buffer pool for standard block size buffers
db_create_file_destoradg11g  

TRUE

IMMEDIATE

FALSEdefault database location
db_create_online_log_dest_1oradg11g  

TRUE

IMMEDIATE

FALSEonline log/controlfile destination #1
db_create_online_log_dest_2oradg11g  

TRUE

IMMEDIATE

FALSEonline log/controlfile destination #2
db_create_online_log_dest_3oradg11g  

TRUE

IMMEDIATE

FALSEonline log/controlfile destination #3
db_create_online_log_dest_4oradg11g  

TRUE

IMMEDIATE

FALSEonline log/controlfile destination #4
db_create_online_log_dest_5oradg11g  

TRUE

IMMEDIATE

FALSEonline log/controlfile destination #5
db_domainoradg11g  

FALSE

FALSE

FALSEdirectory part of global database name stored with CREATE DATABASE
db_file_multiblock_read_countoradg11g77

TRUE

IMMEDIATE

FALSEdb block to be read each IO
db_file_name_convertoradg11goradglg, oradg11goradglg, oradg11g

FALSE

FALSE

FALSEdatafile name convert patterns and strings for standby/clone db
db_filesoradg11g200200

TRUE

FALSE

FALSEmax allowable # db files
db_flash_cache_fileoradg11g  

TRUE

FALSE

FALSEflash cache file for default block size
db_flash_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSEflash cache size for db_flash_cache_file
db_flashback_retention_targetoradg11g14401440

TRUE

IMMEDIATE

FALSEMaximum Flashback Database log retention time in minutes.
db_keep_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of KEEP buffer pool for standard block size buffers
db_lost_write_protectoradg11gNONENONE

TRUE

IMMEDIATE

FALSEenable lost write detection
db_nameoradg11goradg11goradg11g

FALSE

FALSE

FALSEdatabase name specified in CREATE DATABASE
db_recovery_file_destoradg11g/u01/app/oracle/flash_recovery_area/u01/app/oracle/flash_recovery_area

FALSE

IMMEDIATE

FALSEdefault database recovery file location
db_recovery_file_dest_sizeoradg11g43222302724122M

FALSE

IMMEDIATE

FALSEdatabase recovery files size limit
db_recycle_cache_sizeoradg11g00

TRUE

IMMEDIATE

FALSESize of RECYCLE buffer pool for standard block size buffers
db_securefileoradg11gPERMITTEDPERMITTED

TRUE

IMMEDIATE

FALSEpermit securefile storage during lob creation
db_ultra_safeoradg11gOFFOFF

TRUE

FALSE

FALSESets defaults for other parameters that control protection levels
db_unique_nameoradg11goradg11goradg11g

FALSE

FALSE

FALSEDatabase Unique Name
db_unrecoverable_scn_trackingoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSETrack nologging SCN in controlfile
db_writer_processesoradg11g11

TRUE

FALSE

FALSEnumber of background database writer processes to start
dbwr_io_slavesoradg11g00

TRUE

FALSE

FALSEDBWR I/O slaves
ddl_lock_timeoutoradg11g00

TRUE

IMMEDIATE

FALSEtimeout to restrict the time that ddls wait for dml lock
deferred_segment_creationoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEdefer segment creation to first insert
dg_broker_config_file1oradg11g/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

FALSEdata guard broker configuration file #1
dg_broker_config_file2oradg11g/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

FALSEdata guard broker configuration file #2
dg_broker_startoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEstart Data Guard broker (DMON process)
diagnostic_destoradg11g/u01/app/oracle/u01/app/oracle

FALSE

IMMEDIATE

FALSEdiagnostic base directory
disk_asynch_iooradg11gTRUETRUE

TRUE

FALSE

FALSEUse asynch I/O for random access devices
dispatchersoradg11g(PROTOCOL=TCP) (SERVICE=oradg11gXDB)(PROTOCOL=TCP) (SERVICE=oradg11gXDB)

FALSE

IMMEDIATE

FALSEspecifications of dispatchers
distributed_lock_timeoutoradg11g6060

TRUE

FALSE

FALSEnumber of seconds a distributed transaction waits for a lock
dml_locksoradg11g10881088

TRUE

FALSE

FALSEdml locks - one for each table modified in a transaction
dst_upgrade_insert_convoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEEnables/Disables internal conversions during DST upgrade
enable_ddl_loggingoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEenable ddl logging
eventoradg11g  

TRUE

FALSE

FALSEdebug event control - default null string
fal_clientoradg11goradg11goradg11g

FALSE

IMMEDIATE

FALSEFAL client
fal_serveroradg11goradglgoradglg

FALSE

IMMEDIATE

FALSEFAL server list
fast_start_io_targetoradg11g00

TRUE

IMMEDIATE

TRUEUpper bound on recovery reads
fast_start_mttr_targetoradg11g00

TRUE

IMMEDIATE

FALSEMTTR target in seconds
fast_start_parallel_rollbackoradg11gLOWLOW

TRUE

IMMEDIATE

FALSEmax number of parallel recovery slaves that may be used
file_mappingoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEenable file mapping
fileio_network_adaptersoradg11g  

TRUE

FALSE

FALSENetwork Adapters for File I/O
filesystemio_optionsoradg11gnonenone

TRUE

FALSE

FALSEIO operations on filesystem files
fixed_dateoradg11g  

TRUE

IMMEDIATE

FALSEfixed SYSDATE value
gcs_server_processesoradg11g00

TRUE

FALSE

FALSEnumber of background gcs server processes to start
global_context_pool_sizeoradg11g  

TRUE

FALSE

TRUEGlobal Application Context Pool Size in Bytes
global_namesoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEenforce that database links have same name as remote database
global_txn_processesoradg11g11

TRUE

IMMEDIATE

FALSEnumber of background global transaction processes to start
hash_area_sizeoradg11g131072131072

TRUE

FALSE

FALSEsize of in-memory hash work area
hi_shared_memory_addressoradg11g00

TRUE

FALSE

FALSESGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregisteroradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEenable automatic server DD updates in HS agent self-registration
ifileoradg11g  

TRUE

FALSE

FALSEinclude file in init.ora
instance_groupsoradg11g  

TRUE

FALSE

TRUElist of instance group names
instance_nameoradg11goradg11goradg11g

TRUE

FALSE

FALSEinstance name supported by the instance
instance_numberoradg11g00

TRUE

FALSE

FALSEinstance number
instance_typeoradg11gRDBMSRDBMS

TRUE

FALSE

FALSEtype of instance to be executed
java_jit_enabledoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEJava VM JIT enabled
java_max_sessionspace_sizeoradg11g00

TRUE

FALSE

FALSEmax allowed size in bytes of a Java sessionspace
java_pool_sizeoradg11g00

TRUE

IMMEDIATE

FALSEsize in bytes of java pool
java_soft_sessionspace_limitoradg11g00

TRUE

FALSE

FALSEwarning limit on size in bytes of a Java sessionspace
job_queue_processesoradg11g10001000

TRUE

IMMEDIATE

FALSEmaximum number of job queue slave processes
large_pool_sizeoradg11g00

TRUE

IMMEDIATE

FALSEsize in bytes of large pool
ldap_directory_accessoradg11gNONENONE

TRUE

IMMEDIATE

FALSERDBMS's LDAP access option
ldap_directory_sysauthoradg11gnono

TRUE

FALSE

FALSEOID usage parameter
license_max_sessionsoradg11g00

TRUE

IMMEDIATE

FALSEmaximum number of non-system user sessions allowed
license_max_usersoradg11g00

TRUE

IMMEDIATE

FALSEmaximum number of named users that can be created in the database
license_sessions_warningoradg11g00

TRUE

IMMEDIATE

FALSEwarning level for number of non-system user sessions
listener_networksoradg11g  

TRUE

IMMEDIATE

FALSElistener registration networks
local_listeneroradg11g  

TRUE

IMMEDIATE

FALSElocal listener
lock_name_spaceoradg11g  

TRUE

FALSE

TRUElock name space used for generating lock names for standby/clone database
lock_sgaoradg11gFALSEFALSE

TRUE

FALSE

FALSELock entire SGA in physical memory
log_archive_configoradg11gDG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font>DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)

FALSE

IMMEDIATE

FALSElog archive config parameter
log_archive_destoradg11g  

TRUE

IMMEDIATE

FALSEarchival destination text string
log_archive_dest_1oradg11gLOCATION=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

FALSEarchival destination #1 text string
log_archive_dest_10oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #10 text string
log_archive_dest_11oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #11 text string
log_archive_dest_12oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #12 text string
log_archive_dest_13oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #13 text string
log_archive_dest_14oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #14 text string
log_archive_dest_15oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #15 text string
log_archive_dest_16oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #16 text string
log_archive_dest_17oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #17 text string
log_archive_dest_18oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #18 text string
log_archive_dest_19oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #19 text string
log_archive_dest_2oradg11gSERVICE=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

FALSEarchival destination #2 text string
log_archive_dest_20oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #20 text string
log_archive_dest_21oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #21 text string
log_archive_dest_22oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #22 text string
log_archive_dest_23oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #23 text string
log_archive_dest_24oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #24 text string
log_archive_dest_25oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #25 text string
log_archive_dest_26oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #26 text string
log_archive_dest_27oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #27 text string
log_archive_dest_28oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #28 text string
log_archive_dest_29oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #29 text string
log_archive_dest_3oradg11gSERVICE=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

FALSEarchival destination #3 text string
log_archive_dest_30oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #30 text string
log_archive_dest_31oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #31 text string
log_archive_dest_4oradg11gSERVICE=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

FALSEarchival destination #4 text string
log_archive_dest_5oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #5 text string
log_archive_dest_6oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #6 text string
log_archive_dest_7oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #7 text string
log_archive_dest_8oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #8 text string
log_archive_dest_9oradg11g  

TRUE

IMMEDIATE

FALSEarchival destination #9 text string
log_archive_dest_state_1oradg11gENABLEENABLE

FALSE

IMMEDIATE

FALSEarchival destination #1 state text string
log_archive_dest_state_10oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #10 state text string
log_archive_dest_state_11oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #11 state text string
log_archive_dest_state_12oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #12 state text string
log_archive_dest_state_13oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #13 state text string
log_archive_dest_state_14oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #14 state text string
log_archive_dest_state_15oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #15 state text string
log_archive_dest_state_16oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #16 state text string
log_archive_dest_state_17oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #17 state text string
log_archive_dest_state_18oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #18 state text string
log_archive_dest_state_19oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #19 state text string
log_archive_dest_state_2oradg11gENABLEENABLE

FALSE

IMMEDIATE

FALSEarchival destination #2 state text string
log_archive_dest_state_20oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #20 state text string
log_archive_dest_state_21oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #21 state text string
log_archive_dest_state_22oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #22 state text string
log_archive_dest_state_23oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #23 state text string
log_archive_dest_state_24oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #24 state text string
log_archive_dest_state_25oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #25 state text string
log_archive_dest_state_26oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #26 state text string
log_archive_dest_state_27oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #27 state text string
log_archive_dest_state_28oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #28 state text string
log_archive_dest_state_29oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #29 state text string
log_archive_dest_state_3oradg11gENABLEENABLE

FALSE

IMMEDIATE

FALSEarchival destination #3 state text string
log_archive_dest_state_30oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #30 state text string
log_archive_dest_state_31oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #31 state text string
log_archive_dest_state_4oradg11gENABLEENABLE

FALSE

IMMEDIATE

FALSEarchival destination #4 state text string
log_archive_dest_state_5oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #5 state text string
log_archive_dest_state_6oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #6 state text string
log_archive_dest_state_7oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #7 state text string
log_archive_dest_state_8oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #8 state text string
log_archive_dest_state_9oradg11genableenable

TRUE

IMMEDIATE

FALSEarchival destination #9 state text string
log_archive_duplex_destoradg11g  

TRUE

IMMEDIATE

FALSEduplex archival destination text string
log_archive_formatoradg11g%t_%s_%r.dbf%t_%s_%r.dbf

TRUE

FALSE

FALSEarchival destination format
log_archive_local_firstoradg11gTRUETRUE

TRUE

IMMEDIATE

TRUEEstablish EXPEDITE attribute default value
log_archive_max_processesoradg11g44

FALSE

IMMEDIATE

FALSEmaximum number of active ARCH processes
log_archive_min_succeed_destoradg11g11

TRUE

IMMEDIATE

FALSEminimum number of archive destinations that must succeed
log_archive_startoradg11gFALSEFALSE

TRUE

FALSE

TRUEstart archival process on SGA initialization
log_archive_traceoradg11g00

TRUE

IMMEDIATE

FALSEEstablish archivelog operation tracing level
log_bufferoradg11g81100808110080

TRUE

FALSE

FALSEredo circular buffer size
log_checkpoint_intervaloradg11g00

TRUE

IMMEDIATE

FALSE# redo blocks checkpoint threshold
log_checkpoint_timeoutoradg11g18001800

TRUE

IMMEDIATE

FALSEMaximum time interval between checkpoints in seconds
log_checkpoints_to_alertoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSElog checkpoint begin/end to alert file
log_file_name_convertoradg11goradglg, oradg11goradglg, oradg11g

FALSE

FALSE

FALSElogfile name convert patterns and strings for standby/clone db
max_dispatchersoradg11g  

TRUE

IMMEDIATE

FALSEmax number of dispatchers
max_dump_file_sizeoradg11gunlimitedunlimited

TRUE

IMMEDIATE

FALSEMaximum size (in bytes) of dump file
max_enabled_rolesoradg11g150150

TRUE

FALSE

TRUEmax number of roles a user can have enabled
max_shared_serversoradg11g  

TRUE

IMMEDIATE

FALSEmax number of shared servers
memory_max_targetoradg11g419430400400M

FALSE

FALSE

FALSEMax size for Memory Target
memory_targetoradg11g314572800300M

FALSE

IMMEDIATE

FALSETarget size of Oracle SGA and PGA memory
nls_calendaroradg11gGREGORIANGREGORIAN

TRUE

FALSE

FALSENLS calendar system name
nls_comporadg11gBINARYBINARY

TRUE

FALSE

FALSENLS comparison
nls_currencyoradg11g￥￥

TRUE

FALSE

FALSENLS local currency symbol
nls_date_formatoradg11gYYYY-MM-DD HH24:mi:ssYYYY-MM-DD HH24:mi:ss

TRUE

FALSE

FALSENLS Oracle date format
nls_date_languageoradg11gAMERICANAMERICAN

TRUE

FALSE

FALSENLS date language name
nls_dual_currencyoradg11g￥￥

TRUE

FALSE

FALSEDual currency symbol
nls_iso_currencyoradg11gCHINACHINA

TRUE

FALSE

FALSENLS ISO currency territory name
nls_languageoradg11gAMERICANAMERICAN

TRUE

FALSE

FALSENLS language name
nls_length_semanticsoradg11gBYTEBYTE

TRUE

IMMEDIATE

FALSEcreate columns using byte or char semantics by default
nls_nchar_conv_excporadg11gFALSEFALSE

TRUE

IMMEDIATE

FALSENLS raise an exception instead of allowing implicit conversion
nls_numeric_charactersoradg11g.,.,

TRUE

FALSE

FALSENLS numeric characters
nls_sortoradg11gBINARYBINARY

TRUE

FALSE

FALSENLS linguistic definition name
nls_territoryoradg11gCHINACHINA

TRUE

FALSE

FALSENLS territory name
nls_time_formatoradg11gHH.MI.SSXFF AMHH.MI.SSXFF AM

TRUE

FALSE

FALSEtime format
nls_time_tz_formatoradg11gHH.MI.SSXFF AM TZRHH.MI.SSXFF AM TZR

TRUE

FALSE

FALSEtime with timezone format
nls_timestamp_formatoradg11gDD-MON-RR HH.MI.SSXFF AMDD-MON-RR HH.MI.SSXFF AM

TRUE

FALSE

FALSEtime stamp format
nls_timestamp_tz_formatoradg11gDD-MON-RR HH.MI.SSXFF AM TZRDD-MON-RR HH.MI.SSXFF AM TZR

TRUE

FALSE

FALSEtimestamp with timezone format
object_cache_max_size_percentoradg11g1010

TRUE

DEFERRED

FALSEpercentage of maximum size over optimal of the user session's object cache
object_cache_optimal_sizeoradg11g102400102400

TRUE

DEFERRED

FALSEoptimal size of the user session's object cache in bytes
olap_page_pool_sizeoradg11g00

TRUE

DEFERRED

FALSEsize of the olap page pool in bytes
open_cursorsoradg11g300300

FALSE

IMMEDIATE

FALSEmax # cursors per session
open_linksoradg11g44

TRUE

FALSE

FALSEmax # open links per session
open_links_per_instanceoradg11g44

TRUE

FALSE

FALSEmax # open links per instance
optimizer_capture_sql_plan_baselinesoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEautomatic capture of SQL plan baselines for repeatable statements
optimizer_dynamic_samplingoradg11g22

TRUE

IMMEDIATE

FALSEoptimizer dynamic sampling
optimizer_features_enableoradg11g11.2.0.311.2.0.3

TRUE

IMMEDIATE

FALSEoptimizer plan compatibility parameter
optimizer_index_cachingoradg11g00

TRUE

IMMEDIATE

FALSEoptimizer percent index caching
optimizer_index_cost_adjoradg11g100100

TRUE

IMMEDIATE

FALSEoptimizer index cost adjustment
optimizer_modeoradg11gALL_ROWSALL_ROWS

TRUE

IMMEDIATE

FALSEoptimizer mode
optimizer_secure_view_mergingoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEoptimizer secure view merging and predicate pushdown/movearound
optimizer_use_invisible_indexesoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEUsage of invisible indexes (TRUE/FALSE)
optimizer_use_pending_statisticsoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEControl whether to use optimizer pending statistics
optimizer_use_sql_plan_baselinesoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEuse of SQL plan baselines for captured sql statements
os_authent_prefixoradg11gops$ops$

TRUE

FALSE

FALSEprefix for auto-logon accounts
os_rolesoradg11gFALSEFALSE

TRUE

FALSE

FALSEretrieve roles from the operating system
parallel_adaptive_multi_useroradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEenable adaptive setting of degree for multiple user streams
parallel_automatic_tuningoradg11gFALSEFALSE

TRUE

FALSE

TRUEenable intelligent defaults for parallel execution parameters
parallel_degree_limitoradg11gCPUCPU

TRUE

IMMEDIATE

FALSElimit placed on degree of parallelism
parallel_degree_policyoradg11gMANUALMANUAL

TRUE

IMMEDIATE

FALSEpolicy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
parallel_execution_message_sizeoradg11g1638416384

TRUE

FALSE

FALSEmessage buffer size for parallel execution
parallel_force_localoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEforce single instance execution
parallel_instance_grouporadg11g  

TRUE

IMMEDIATE

FALSEinstance group to use for all parallel operations
parallel_io_cap_enabledoradg11gFALSEFALSE

TRUE

IMMEDIATE

TRUEenable capping DOP by IO bandwidth
parallel_max_serversoradg11g8080

TRUE

IMMEDIATE

FALSEmaximum parallel query servers per instance
parallel_min_percentoradg11g00

TRUE

FALSE

FALSEminimum percent of threads required for parallel query
parallel_min_serversoradg11g00

TRUE

IMMEDIATE

FALSEminimum parallel query servers per instance
parallel_min_time_thresholdoradg11gAUTOAUTO

TRUE

IMMEDIATE

FALSEthreshold above which a plan is a candidate for parallelization (in seconds)
parallel_serveroradg11gFALSEFALSE

TRUE

FALSE

TRUEif TRUE startup in parallel server mode
parallel_server_instancesoradg11g11

TRUE

FALSE

TRUEnumber of instances to use for sizing OPS SGA structures
parallel_servers_targetoradg11g3232

TRUE

IMMEDIATE

FALSEinstance target in terms of number of parallel servers
parallel_threads_per_cpuoradg11g22

TRUE

IMMEDIATE

FALSEnumber of parallel execution threads per CPU
permit_92_wrap_formatoradg11gTRUETRUE

TRUE

FALSE

FALSEallow 9.2 or older wrap format in PL/SQL
pga_aggregate_targetoradg11g00

TRUE

IMMEDIATE

FALSETarget size for the aggregate PGA memory consumed by the instance
plscope_settingsoradg11gIDENTIFIERS:NONEIDENTIFIERS:NONE

TRUE

IMMEDIATE

FALSEplscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
plsql_ccflagsoradg11g  

TRUE

IMMEDIATE

FALSEPL/SQL ccflags
plsql_code_typeoradg11gINTERPRETEDINTERPRETED

TRUE

IMMEDIATE

FALSEPL/SQL code-type
plsql_debugoradg11gFALSEFALSE

TRUE

IMMEDIATE

TRUEPL/SQL debug
plsql_optimize_leveloradg11g22

TRUE

IMMEDIATE

FALSEPL/SQL optimize level
plsql_v2_compatibilityoradg11gFALSEFALSE

TRUE

IMMEDIATE

TRUEPL/SQL version 2.x compatibility flag
plsql_warningsoradg11gDISABLE:ALLDISABLE:ALL

TRUE

IMMEDIATE

FALSEPL/SQL compiler warnings settings
pre_page_sgaoradg11gFALSEFALSE

TRUE

FALSE

FALSEpre-page sga for process
processesoradg11g150150

FALSE

FALSE

FALSEuser processes
processor_group_nameoradg11g  

TRUE

FALSE

FALSEName of the processor group that this instance should run in.
query_rewrite_enabledoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEallow rewrite of queries using materialized views if enabled
query_rewrite_integrityoradg11genforcedenforced

TRUE

IMMEDIATE

FALSEperform rewrite using materialized views with desired integrity
rdbms_server_dnoradg11g  

TRUE

FALSE

FALSERDBMS's Distinguished Name
read_only_open_delayedoradg11gFALSEFALSE

TRUE

FALSE

FALSEif TRUE delay opening of read only files until first access
recovery_parallelismoradg11g00

TRUE

FALSE

FALSEnumber of server processes to use for parallel recovery
recyclebinoradg11gonon

TRUE

DEFERRED

FALSErecyclebin processing
redo_transport_useroradg11g  

TRUE

IMMEDIATE

FALSEData Guard transport user when using password file
remote_dependencies_modeoradg11gTIMESTAMPTIMESTAMP

TRUE

IMMEDIATE

FALSEremote-procedure-call dependencies mode parameter
remote_listeneroradg11g  

TRUE

IMMEDIATE

FALSEremote listener
remote_login_passwordfileoradg11gEXCLUSIVEEXCLUSIVE

FALSE

FALSE

FALSEpassword file usage parameter
remote_os_authentoradg11gFALSEFALSE

TRUE

FALSE

TRUEallow non-secure remote clients to use auto-logon accounts
remote_os_rolesoradg11gFALSEFALSE

TRUE

FALSE

FALSEallow non-secure remote clients to use os roles
replication_dependency_trackingoradg11gTRUETRUE

TRUE

FALSE

FALSEtracking dependency for Replication parallel propagation
resource_limitoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEmaster switch for resource limit
resource_manager_cpu_allocationoradg11g22

TRUE

IMMEDIATE

TRUEResource Manager CPU allocation
resource_manager_planoradg11g  

TRUE

IMMEDIATE

FALSEresource mgr top plan
result_cache_max_resultoradg11g55

TRUE

IMMEDIATE

FALSEmaximum result size as percent of cache size
result_cache_max_sizeoradg11g786432768K

TRUE

IMMEDIATE

FALSEmaximum amount of memory to be used by the cache
result_cache_modeoradg11gMANUALMANUAL

TRUE

IMMEDIATE

FALSEresult cache operator usage mode
result_cache_remote_expirationoradg11g00

TRUE

IMMEDIATE

FALSEmaximum life time (min) for any result using a remote object
resumable_timeoutoradg11g00

TRUE

IMMEDIATE

FALSEset resumable_timeout
rollback_segmentsoradg11g  

TRUE

FALSE

FALSEundo segment list
sec_case_sensitive_logonoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEcase sensitive password enabled for logon
sec_max_failed_login_attemptsoradg11g1010

TRUE

FALSE

FALSEmaximum number of failed login attempts on a connection
sec_protocol_error_further_actionoradg11gCONTINUECONTINUE

TRUE

IMMEDIATE

FALSETTC protocol error continue action
sec_protocol_error_trace_actionoradg11gTRACETRACE

TRUE

IMMEDIATE

FALSETTC protocol error action
sec_return_server_release_banneroradg11gFALSEFALSE

TRUE

FALSE

FALSEwhether the server retruns the complete version information
serial_reuseoradg11gdisabledisable

TRUE

FALSE

TRUEreuse the frame segments
service_namesoradg11goradg11goradg11g

TRUE

IMMEDIATE

FALSEservice names supported by the instance
session_cached_cursorsoradg11g5050

TRUE

FALSE

FALSENumber of cursors to cache in a session.
session_max_open_filesoradg11g1010

TRUE

FALSE

FALSEmaximum number of open files allowed per session
sessionsoradg11g248248

TRUE

FALSE

FALSEuser and system sessions
sga_max_sizeoradg11g419430400400M

TRUE

FALSE

FALSEmax total SGA size
sga_targetoradg11g00

TRUE

IMMEDIATE

FALSETarget size of SGA
shadow_core_dumporadg11gpartialpartial

TRUE

FALSE

FALSECore Size for Shadow Processes
shared_memory_addressoradg11g00

TRUE

FALSE

FALSESGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_sizeoradg11g81788928178892

TRUE

FALSE

FALSEsize in bytes of reserved area of shared pool
shared_pool_sizeoradg11g00

TRUE

IMMEDIATE

FALSEsize in bytes of shared pool
shared_server_sessionsoradg11g  

TRUE

IMMEDIATE

FALSEmax number of shared server sessions
shared_serversoradg11g11

TRUE

IMMEDIATE

FALSEnumber of shared servers to start up
skip_unusable_indexesoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEskip unusable indexes if set to TRUE
smtp_out_serveroradg11g  

TRUE

IMMEDIATE

FALSEutl_smtp server and port configuration parameter
sort_area_retained_sizeoradg11g00

TRUE

DEFERRED

FALSEsize of in-memory sort work area retained between fetch calls
sort_area_sizeoradg11g6553665536

TRUE

DEFERRED

FALSEsize of in-memory sort work area
spfileoradg11g/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

FALSEserver parameter file
sql92_securityoradg11gFALSEFALSE

TRUE

FALSE

FALSErequire select privilege for searched update/delete
sql_traceoradg11gFALSEFALSE

TRUE

IMMEDIATE

TRUEenable SQL trace
sqltune_categoryoradg11gDEFAULTDEFAULT

TRUE

IMMEDIATE

FALSECategory qualifier for applying hintsets
standby_archive_destoradg11g?/dbs/arch?/dbs/arch

TRUE

IMMEDIATE

TRUEstandby database archivelog destination text string
standby_file_managementoradg11gAUTOAUTO

FALSE

IMMEDIATE

FALSEif auto then files are created/dropped automatically on standby
star_transformation_enabledoradg11gFALSEFALSE

TRUE

IMMEDIATE

FALSEenable the use of star transformation
statistics_leveloradg11gTYPICALTYPICAL

TRUE

IMMEDIATE

FALSEstatistics level
streams_pool_sizeoradg11g00

TRUE

IMMEDIATE

FALSEsize in bytes of the streams pool
tape_asynch_iooradg11gTRUETRUE

TRUE

FALSE

FALSEUse asynch I/O requests for tape devices
threadoradg11g00

TRUE

IMMEDIATE

FALSERedo thread to mount
timed_os_statisticsoradg11g00

TRUE

IMMEDIATE

FALSEinternal os statistic gathering interval in seconds
timed_statisticsoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEmaintain internal timing statistics
trace_enabledoradg11gTRUETRUE

TRUE

IMMEDIATE

FALSEenable in memory tracing
tracefile_identifieroradg11g  

TRUE

FALSE

FALSEtrace file custom identifier
transactionsoradg11g272272

TRUE

FALSE

FALSEmax. number of concurrent active transactions
transactions_per_rollback_segmentoradg11g55

TRUE

FALSE

FALSEnumber of active transactions per rollback segment
undo_managementoradg11gAUTOAUTO

TRUE

FALSE

FALSEinstance runs in SMU mode if TRUE, else in RBU mode
undo_retentionoradg11g900900

TRUE

IMMEDIATE

FALSEundo retention in seconds
undo_tablespaceoradg11gUNDOTBS1UNDOTBS1

FALSE

IMMEDIATE

FALSEuse/switch undo tablespace
use_indirect_data_buffersoradg11gFALSEFALSE

TRUE

FALSE

FALSEEnable indirect data buffers (very large SGA on 32-bit platforms)
use_large_pagesoradg11gTRUETRUE

TRUE

FALSE

FALSEUse large pages if available (TRUE/FALSE/ONLY)
user_dump_destoradg11g/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace

TRUE

IMMEDIATE

TRUEUser process dump directory
utl_file_diroradg11g  

TRUE

FALSE

FALSEutl_file accessible directories list
workarea_size_policyoradg11gAUTOAUTO

TRUE

IMMEDIATE

FALSEpolicy used to size SQL working areas (MANUAL/AUTO)
xml_db_eventsoradg11genableenable

TRUE

IMMEDIATE

FALSEare XML DB events enabled

 

[回到目录] [上一项]





关键的初始化参数

 

参数名称实例名称参数值
cpu_countoradg11g2
cursor_sharingoradg11gEXACT
db_block_sizeoradg11g8192
db_cache_sizeoradg11g0
db_file_multiblock_read_countoradg11g7
instance_nameoradg11goradg11g
instance_numberoradg11g0
java_pool_sizeoradg11g0
job_queue_processesoradg11g1000
large_pool_sizeoradg11g0
local_listeneroradg11g 
log_archive_dest_1oradg11gLOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
log_bufferoradg11g8110080
open_cursorsoradg11g300
optimizer_index_cachingoradg11g0
optimizer_index_cost_adjoradg11g100
optimizer_modeoradg11gALL_ROWS
pga_aggregate_targetoradg11g0
processesoradg11g150
sessionsoradg11g248
sga_max_sizeoradg11g419430400
sga_targetoradg11g0
shared_pool_sizeoradg11g0
sort_area_sizeoradg11g65536
spfileoradg11g/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora
threadoradg11g0

 

[回到目录]



数据库大小

 

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

2

23

 

[回到目录]





资源使用情况

 

资源名称当前值最大值初始值限制值
processes3752150150
sessions4558248248
enqueue_locks285531603160
enqueue_resources22441308UNLIMITED
ges_procs0000
ges_ress000UNLIMITED
ges_locks000UNLIMITED
ges_cache_ress000UNLIMITED
ges_reg_msgs000UNLIMITED
ges_big_msgs000UNLIMITED
ges_rsv_msgs0000
gcs_resources00UNLIMITEDUNLIMITED
gcs_shadows00UNLIMITEDUNLIMITED
smartio_overhead_memory000UNLIMITED
smartio_buffer_memory000UNLIMITED
smartio_metadata_memory000UNLIMITED
smartio_sessions000UNLIMITED
dml_locks001088UNLIMITED
temporary_table_locks00UNLIMITEDUNLIMITED
transactions00272UNLIMITED
branches00272UNLIMITED
cmtcallbk01272UNLIMITED
max_rollback_segments111127265535
sort_segment_locks13UNLIMITEDUNLIMITED
k2q_locks00496UNLIMITED
max_shared_servers11UNLIMITEDUNLIMITED
parallel_max_servers016803600

 

[回到目录]





表空间情况

 



表空间状况

 

状态表空间名称表空间类型扩展管理方段管理方�表空间大小(MB)空闲(MB)使用(MB)Pct. Used

ONLINE

EXAMPLEPERMANENTLOCALAUTO34636310

89 %

ONLINE

LOGMNRTBSPERMANENTLOCALAUTO355255100

28 %

ONLINE

SYSAUXPERMANENTLOCALAUTO58050530

91 %

ONLINE

SYSTEMPERMANENTLOCALMANUAL860127733

85 %

ONLINE

TEMPTEMPORARYLOCALMANUAL291811

37 %

ONLINE

UNDOTBS1UNDOLOCALMANUAL956036

37 %

ONLINE

USERSPERMANENTLOCALAUTO41338

92 %

     ------------------------------------------------------------ 
Total:    2,3065481,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_
0SYSTEMPERMANENT86012773385.2763231.2842.2388192LOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/system01.dbfNOLOCALMANUALNOT APPLYDISABLED
1SYSAUXPERMANENT5805053091.3693231.4821.6178192LOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/sysaux01.dbfNOLOCALAUTONOT APPLYDISABLED
2UNDOTBS1UNDO95603637.3683231.965.1088192LOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/undotbs01.dbfNOLOCALMANUALNOGUARANTEEDISABLED
3TEMPTEMPORARY292726.8973231.998.0068192NOLOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/temp01.dbfNOLOCALMANUALNOT APPLYDISABLED
4USERSPERMANENT4133892.8793231.963.1178192LOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/users01.dbfNOLOCALAUTONOT APPLYDISABLED
6EXAMPLEPERMANENT3463631089.7293231.697.9468192NOLOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/example01.dbfNOLOCALAUTONOT APPLYDISABLED
7LOGMNRTBSPERMANENT35525510028.1691.9531.85558192LOGGINGONLINE1/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbfNOLOCALAUTONOT APPLYDISABLED
 所有表空间 2305.875557174975.861194192.245           

 

[回到目录]



数据库闪回空间使用情况


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

 

NAMELIMIT_GBUSED_GBUSED%RECLAIM_GBFILE#
/u01/app/oracle/flash_recovery_area4.025.614.904.4663

 

[回到目录]



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

 

TYPEUSED_GBUSED%RECLAIMABLE%RECLAIM_GBFILES#
ARCHIVED LOG.0912.260045
BACKUP PIECE00000
CONTROL FILE00000
FLASHBACK LOG.48812.1310.92.4410
FOREIGN ARCHIVED LOG.021.52.51.0218
IMAGE COPY00000
REDO LOG00000
 ----------------------------------------------------
.614.9111.43.46163

 

[回到目录]



临时表空间使用情况

 

NameSize (M)HWM (M)HWM %Using (M)Using %
TEMP29.00011.00037.931.0003.45

 

[回到目录]



查谁占用了undo表空间

 

[回到目录]



数据文件状况

 

Tablespace Name / File ClassFilenameFile SizeAutoextensibleNextMax
EXAMPLE/u01/app/oracle/oradata/oradg11g/example01.dbf362,414,080

YES

655,36034,359,721,984
LOGMNRTBS/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf372,244,480

YES

5,242,8802,097,152,000
SYSAUX/u01/app/oracle/oradata/oradg11g/sysaux01.dbf608,174,080

YES

10,485,76034,359,721,984
SYSTEM/u01/app/oracle/oradata/oradg11g/system01.dbf901,775,360

YES

10,485,76034,359,721,984
TEMP/u01/app/oracle/oradata/oradg11g/temp01.dbf30,408,704

YES

655,36034,359,721,984
UNDOTBS1/u01/app/oracle/oradata/oradg11g/undotbs01.dbf99,614,720

YES

5,242,88034,359,721,984
USERS/u01/app/oracle/oradata/oradg11g/users01.dbf43,253,760

YES

1,310,72034,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.log52,428,800   
[ ONLINE REDO LOG ]/u01/app/oracle/oradata/oradg11g/redo02.log52,428,800   
[ ONLINE REDO LOG ]/u01/app/oracle/oradata/oradg11g/redo03.log52,428,800   
  --------------------   
Total: 2,575,171,584   

 

FILE_IDTABLESPACE_NAMETS_SIZE_MFILE_NAMEFILE_SIZE_MFILE_MAX_SIZE_GAutINCREMENT_MAUTOEXTEND_RATIO
5EXAMPLE345.63/u01/app/oracle/oradata/oradg11g/example01.dbf345.6332YES.631.05
6LOGMNRTBS355/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf3551.95YES517.75
2SYSAUX580/u01/app/oracle/oradata/oradg11g/sysaux01.dbf58032YES101.77
1SYSTEM860/u01/app/oracle/oradata/oradg11g/system01.dbf86032YES102.62
1TEMP29/u01/app/oracle/oradata/oradg11g/temp01.dbf2932YES.63.09
3UNDOTBS195/u01/app/oracle/oradata/oradg11g/undotbs01.dbf9532YES5.29
4USERS41.25/u01/app/oracle/oradata/oradg11g/users01.dbf41.2532YES1.25.13

 

[回到目录]



表空间扩展

 

Tablespace NameLargest ExtentSmallest ExtentTotal FreeNumber of Free Extents
EXAMPLE34,668,544589,82437,224,4483
LOGMNRTBS200,278,0161,048,576267,386,88010
SYSAUX35,651,58465,53652,494,33663
SYSTEM132,120,576655,360132,775,9362
UNDOTBS124,117,24865,53662,390,27226
USERS2,359,29665,5363,080,1923
 ----------------------------------------------------------------------------------
Total:429,195,2642,490,368555,352,064107

 

[回到目录]



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


● 回滚段

 

FILE_NAMETABLESPACE_NAMESIZE_MAUTONLINE_
/u01/app/oracle/oradata/oradg11g/undotbs01.dbfUNDOTBS195YESONLINE

● 临时段

 

FILE_NAMESIZE_MSTATUSAUT
/u01/app/oracle/oradata/oradg11g/temp01.dbf29ONLINEYES

● 普通段

 

FILE_NAMETABLESPACE_NAMESTATUSSIZE_MAUT
/u01/app/oracle/oradata/oradg11g/users01.dbfUSERSAVAILABLE41.25YES
/u01/app/oracle/oradata/oradg11g/undotbs01.dbfUNDOTBS1AVAILABLE95YES
/u01/app/oracle/oradata/oradg11g/sysaux01.dbfSYSAUXAVAILABLE580YES
/u01/app/oracle/oradata/oradg11g/system01.dbfSYSTEMAVAILABLE860YES
/u01/app/oracle/oradata/oradg11g/example01.dbfEXAMPLEAVAILABLE345.625YES
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbfLOGMNRTBSAVAILABLE355YES

● 所有段

 

FILE_IDTABLESPACE_NAMETS_SIZE_MFILE_NAMEFILE_SIZE_MFILE_MAX_SIZEAUTINCREMENT_BYSTATUSINCREMENT_BY_BLOCKBYTESBLOCKSMAXBYTESMAXBLOCKSUSER_BYTESUSER_BLOCKS
5EXAMPLE345.625/u01/app/oracle/oradata/oradg11g/example01.dbf345.62532767.984YES.625AVAILABLE80362414080442403.4360E+10419430236136550444112
6LOGMNRTBS355/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf3552000YES5AVAILABLE64037224448045440209715200025600037119590445312
2SYSAUX580/u01/app/oracle/oradata/oradg11g/sysaux01.dbf58032767.984YES10AVAILABLE1280608174080742403.4360E+10419430260712550474112
1SYSTEM860/u01/app/oracle/oradata/oradg11g/system01.dbf86032767.984YES10AVAILABLE12809017753601100803.4360E+104194302900726784109952
1TEMP29/u01/app/oracle/oradata/oradg11g/temp01.dbf2932767.984YES.625ONLINE803040870437123.4360E+104194302293601283584
3UNDOTBS195/u01/app/oracle/oradata/oradg11g/undotbs01.dbf9532767.984YES5AVAILABLE64099614720121603.4360E+1041943029856614412032
4USERS41.25/u01/app/oracle/oradata/oradg11g/users01.dbf41.2532767.984YES1.25AVAILABLE1604325376052803.4360E+104194302422051845152

 

[回到目录]





表空间所有者

 

Tablespace NameOwnerSegment TypeSize (in Bytes)Segment Count
EXAMPLE

HR

INDEX

1,245,18419
 

HR

TABLE

393,2166
 

IX

INDEX

917,50414
 

IX

LOBINDEX

196,6083
 

IX

LOBSEGMENT

196,6083
 

IX

TABLE

524,2888
 

OE

INDEX

2,162,68822
 

OE

LOBINDEX

327,6805
 

OE

LOBSEGMENT

393,2165
 

OE

TABLE

3,735,5528
 

PM

INDEX

262,1444
 

PM

LOBINDEX

1,114,11217
 

PM

LOBSEGMENT

11,206,65617
 

PM

NESTED TABLE

65,5361
 

PM

TABLE

196,6082
 

SH

INDEX PARTITION

11,141,120112
 

SH

INDEX

2,490,36819
 

SH

LOBINDEX

131,0722
 

SH

LOBSEGMENT

131,0722
 

SH

TABLE PARTITION

268,435,45632
 

SH

TABLE

18,874,36812
LOGMNRTBS

SYSTEM

INDEX PARTITION

23,199,744104
 

SYSTEM

INDEX

917,50414
 

SYSTEM

LOBINDEX

589,8246
 

SYSTEM

LOBSEGMENT

4,521,9846
 

SYSTEM

TABLE PARTITION

73,662,46476
 

SYSTEM

TABLE

917,50414
SYSAUX

APEX_030200

INDEX

39,976,960262
 

APEX_030200

LOBINDEX

3,276,80050
 

APEX_030200

LOBSEGMENT

10,420,22450
 

APEX_030200

TABLE

35,913,728105
 

CTXSYS

INDEX

2,490,36838
 

CTXSYS

LOBINDEX

131,0722
 

CTXSYS

LOBSEGMENT

131,0722
 

CTXSYS

TABLE

1,179,64817
 

DBSNMP

INDEX

327,6805
 

DBSNMP

TABLE

196,6083
 

EXFSYS

INDEX

2,424,83237
 

EXFSYS

LOBINDEX

65,5361
 

EXFSYS

LOBSEGMENT

65,5361
 

EXFSYS

TABLE

1,245,18419
 

MDSYS

INDEX

7,405,56898
 

MDSYS

LOBINDEX

12,976,128197
 

MDSYS

LOBSEGMENT

41,877,504197
 

MDSYS

NESTED TABLE

1,048,57616
 

MDSYS

TABLE

14,221,31264
 

OLAPSYS

INDEX

5,242,88080
 

OLAPSYS

TABLE

3,997,69661
 

ORDDATA

INDEX

6,946,81695
 

ORDDATA

LOBINDEX

393,2166
 

ORDDATA

LOBSEGMENT

3,014,6566
 

ORDDATA

NESTED TABLE

131,0722
 

ORDDATA

TABLE

3,735,55251
 

ORDSYS

INDEX

196,6083
 

ORDSYS

TABLE

262,1444
 

SYS

CLUSTER

2,097,1521
 

SYS

INDEX PARTITION

4,521,98454
 

SYS

INDEX

37,355,520358
 

SYS

LOB PARTITION

65,5361
 

SYS

LOBINDEX

4,063,23262
 

SYS

LOBSEGMENT

45,744,12862
 

SYS

TABLE PARTITION

4,784,12851
 

SYS

TABLE SUBPARTITION

2,097,15232
 

SYS

TABLE

35,913,728302
 

SYSMAN

INDEX

24,969,216301
 

SYSMAN

LOBINDEX

2,818,04843
 

SYSMAN

LOBSEGMENT

3,407,87243
 

SYSMAN

NESTED TABLE

131,0722
 

SYSMAN

TABLE

16,842,752190
 

SYSTEM

INDEX

524,2888
 

SYSTEM

LOBINDEX

131,0722
 

SYSTEM

LOBSEGMENT

131,0722
 

SYSTEM

TABLE PARTITION

65,5361
 

SYSTEM

TABLE

655,36010
 

WMSYS

INDEX

1,966,08030
 

WMSYS

LOBINDEX

327,6805
 

WMSYS

LOBSEGMENT

327,6805
 

WMSYS

NESTED TABLE

131,0722
 

WMSYS

TABLE

917,50414
 

XDB

INDEX

9,502,720109
 

XDB

LOBINDEX

38,338,560585
 

XDB

LOBSEGMENT

95,223,808585
 

XDB

NESTED TABLE

655,36010
 

XDB

TABLE

21,626,88083
SYSTEM

OUTLN

INDEX

262,1444
 

OUTLN

LOBINDEX

65,5361
 

OUTLN

LOBSEGMENT

65,5361
 

OUTLN

TABLE

196,6083
 

SYS

CLUSTER

51,707,9049
 

SYS

INDEX

148,373,504642
 

SYS

LOBINDEX

7,602,176116
 

SYS

LOBSEGMENT

20,578,304116
 

SYS

NESTED TABLE

1,048,57616
 

SYS

ROLLBACK

393,2161
 

SYS

TABLE

520,880,128531
 

SYSTEM

INDEX

9,043,968138
 

SYSTEM

LOBINDEX

917,50414
 

SYSTEM

LOBSEGMENT

917,50414
 

SYSTEM

TABLE

5,898,24090
UNDOTBS1

SYS

TYPE2 UNDO

36,175,87210
USERS

LHR

TABLE

35,979,2646
 

OE

INDEX

786,43211
 

OE

LOBINDEX

655,36010
 

OE

LOBSEGMENT

655,36010
 

OE

NESTED TABLE

589,8244
 

OE

TABLE

196,6082
 

SCOTT

INDEX

131,0722
 

SCOTT

TABLE

196,6083
***************************************************************************  ------------------------------------
Total:  1,825,898,4966,712

 

[回到目录]





JOB情况

 



作业运行状况


● dba_jobs

 

作业ID用户作业内容下一次运行时间间隔上一次运行时间失败次数是否损坏？

4001

SYSwwv_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

SYSwwv_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
 SYSSYSFGR$AUTOPURGE_JOBDISABLEDfile group auto-purge jobNPLSQL_BLOCKsys.dbms_file_group.purge_file_group(NULL);REGULAR  CALENDARfreq=daily;byhour=0;byminute=0;bysecond=0      00FALSETRUE   OFFTRUE          
 SYSSYSFILE_WATCHERDISABLEDFile watcher jobN  REGULARSYSFILE_WATCHER_PROGRAMNAMED       0 FALSEFALSE   OFFTRUE          
 SYSSYSHM_CREATE_OFFLINE_DICTIONARYDISABLEDCreate offline dictionary in ADR for DRA name translationNSTORED_PROCEDUREdbms_hm.create_offline_dictionaryREGULAR  WINDOW_GROUP       00FALSEFALSE   OFFTRUE          
 SYSSYSXMLDB_NFS_CLEANUP_JOBDISABLED NSTORED_PROCEDURExdb.dbms_xdbutil_int.cleanup_expired_nfsclientsREGULAR  CALENDARFreq=minutely;interval=5      00FALSETRUE   OFFTRUE          
 SYSSYSBSLN_MAINTAIN_STATS_JOBSCHEDULEDOracle defined automatic moving window baseline statistics computation jobN  REGULARSYSBSLN_MAINTAIN_STATS_PROGNAMED 2011-09-18 00:00:00 2015-08-30 00:00:002015-08-23 02:35:47+000000000 00:00:05.75229018-SEP-11 12.00.00.000000 AM -07:008 TRUEFALSE   OFFTRUE          
 SYSSYSDRA_REEVALUATE_OPEN_FAILURESSCHEDULEDReevaluate open failures for DRANSTORED_PROCEDUREdbms_ir.reevaluateopenfailuresREGULAR  WINDOW_GROUP    2015-08-02 00:50:42+000000000 00:00:00.994666 54TRUEFALSE   OFFTRUE          
 SYSORACLE_OCMMGMT_CONFIG_JOBSCHEDULEDConfiguration collection job.NSTORED_PROCEDUREORACLE_OCM.MGMT_CONFIG.collect_configREGULAR  WINDOW_GROUP    2015-08-02 00:50:42+000000000 00:00:01.888136 50TRUEFALSE   OFFFALSE          
 SYSORACLE_OCMMGMT_STATS_CONFIG_JOBSCHEDULEDOCM Statistics collection job.NSTORED_PROCEDUREORACLE_OCM.MGMT_CONFIG.collect_statsREGULAR  CALENDARfreq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=012011-09-17 09:52:15 2015-09-01 01:01:012015-08-02 00:50:42+000000000 00:00:02.03001217-SEP-11 09.52.15.221975 AM -07:0030TRUEFALSE   OFFFALSE          
 SYSSYSORA$AUTOTASK_CLEANSCHEDULEDDelete obsolete AUTOTASK repository dataN  REGULARSYSORA$AGE_AUTOTASK_DATANAMED 2011-09-18 03:00:00 2015-08-26 03:00:002015-08-26 00:24:33+000000000 00:00:00.00619318-SEP-11 03.00.00.000000 AM PST8PDT24 TRUEFALSE   OFFTRUE          
 SYSSYSPURGE_LOGSCHEDULEDpurge log jobN  REGULARSYSPURGE_LOG_PROGNAMED 2011-09-18 03:00:00 2015-08-26 03:00:002015-08-26 00:24:33+000000000 00:00:00.24419518-SEP-11 03.00.00.200000 AM PST8PDT24 TRUEFALSE   OFFTRUE          
 SYSEXFSYSRLM$EVTCLEANUPSCHEDULED NPLSQL_BLOCKbegin dbms_rlmgr_dr.cleanup_events; end;REGULAR  CALENDARFREQ = HOURLY; INTERVAL = 12011-09-17 10:00:15 2015-08-26 02:00:152015-08-26 01:00:25+000000000 00:00:00.03340717-SEP-11 10.00.15.000000 AM -07:001280TRUEFALSE   OFFFALSE          
 SYSEXFSYSRLM$SCHDNEGACTIONSCHEDULED NPLSQL_BLOCKbegin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end;REGULAR  CALENDARFREQ=MINUTELY;INTERVAL=602015-08-26 16:22:08 2015-08-26 16:22:082015-08-26 15:24:32+000000000 00:00:00.18325526-AUG-15 04.22.08.000000 PM +08:001230TRUEFALSE   OFFFALSE          
 SYSSYSRSE$CLEAN_RECOVERABLE_SCRIPTSCHEDULEDauto clean job for recoverable scriptNPLSQL_BLOCKsys.dbms_streams_auto_int.clean_recoverable_script;REGULAR  CALENDARfreq=daily;byhour=0;byminute=0;bysecond=02011-09-17 09:52:27 2015-08-27 00:00:002015-08-26 00:24:32+000000000 00:00:00.05073517-SEP-11 09.52.27.122955 AM PST8PDT250TRUETRUE   OFFTRUE          
 SYSSYSSM$CLEAN_AUTO_SPLIT_MERGESCHEDULEDauto clean job for auto split mergeNPLSQL_BLOCKsys.dbms_streams_auto_int.clean_auto_split_merge;REGULAR  CALENDARfreq=daily;byhour=0;byminute=0;bysecond=02011-09-17 09:52:27 2015-08-27 00:00:002015-08-26 00:24:32+000000000 00:00:00.02536817-SEP-11 09.52.27.133715 AM PST8PDT250TRUETRUE   OFFTRUE          

 

[回到目录]





数据库巡检服务明细

 



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 FULLDISK

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_configDG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)
log_archive_dest 
log_archive_dest_1LOCATION=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_2SERVICE=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_3SERVICE=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_4SERVICE=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_1ENABLE
log_archive_dest_state_10enable
log_archive_dest_state_11enable
log_archive_dest_state_12enable
log_archive_dest_state_13enable
log_archive_dest_state_14enable
log_archive_dest_state_15enable
log_archive_dest_state_16enable
log_archive_dest_state_17enable
log_archive_dest_state_18enable
log_archive_dest_state_19enable
log_archive_dest_state_2ENABLE
log_archive_dest_state_20enable
log_archive_dest_state_21enable
log_archive_dest_state_22enable
log_archive_dest_state_23enable
log_archive_dest_state_24enable
log_archive_dest_state_25enable
log_archive_dest_state_26enable
log_archive_dest_state_27enable
log_archive_dest_state_28enable
log_archive_dest_state_29enable
log_archive_dest_state_3ENABLE
log_archive_dest_state_30enable
log_archive_dest_state_31enable
log_archive_dest_state_4ENABLE
log_archive_dest_state_5enable
log_archive_dest_state_6enable
log_archive_dest_state_7enable
log_archive_dest_state_8enable
log_archive_dest_state_9enable
log_archive_duplex_dest 
log_archive_format%t_%s_%r.dbf
log_archive_local_firstTRUE
log_archive_max_processes4
log_archive_min_succeed_dest1
log_archive_startFALSE
log_archive_trace0
log_buffer8110080
log_checkpoint_interval0
log_checkpoint_timeout1800
log_checkpoints_to_alertFALSE
log_file_name_convertoradglg, 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_area4122614.332031.15471.23.1163
CONTROL FILE412200000
REDO LOG412200000
ARCHIVED LOG412293.162.260045
BACKUP PIECE412200000
IMAGE COPY412200000
FLASHBACK LOG412250012.13450.1210.9210
FOREIGN ARCHIVED LOG412221.43.5221.02.518
---DISABLED4122  001

 

[回到目录]



近7天日志切换频率分析


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

THREAD#SEQUENCE#FIRST_TIMEEND_TIMETOTAL_MINLOGSIZE_M
1902015-08-26 15:29:262015-08-26 15:29:2603.818
1902015-08-26 15:29:262015-08-26 15:54:3325.123.818
1902015-08-26 15:29:262015-08-26 15:29:2603.818
1902015-08-26 15:29:262015-08-26 15:29:2603.818
1892015-08-26 15:28:562015-08-26 15:28:560.041
1892015-08-26 15:28:562015-08-26 15:29:26.5.041
1892015-08-26 15:28:562015-08-26 15:28:560.041
1892015-08-26 15:28:562015-08-26 15:28:560.041
1882015-08-26 15:24:282015-08-26 15:24:280.522
1882015-08-26 15:24:282015-08-26 15:28:564.47.522
1882015-08-26 15:24:282015-08-26 15:24:280.522
1882015-08-26 15:24:282015-08-26 15:24:280.522
1872015-08-26 15:24:242015-08-26 15:24:240.037
1872015-08-26 15:24:242015-08-26 15:24:28.07.037
1872015-08-26 15:24:242015-08-26 15:24:240.037
1872015-08-26 15:24:242015-08-26 15:24:240.037
1862015-08-24 00:51:262015-08-24 00:51:2602.071
1862015-08-24 00:51:262015-08-26 15:24:243752.972.071
1862015-08-24 00:51:262015-08-24 00:51:2602.071
1862015-08-24 00:51:262015-08-24 00:51:2602.071
1852015-08-24 00:49:172015-08-24 00:49:170.052
1852015-08-24 00:49:172015-08-24 00:51:262.15.052
1852015-08-24 00:49:172015-08-24 00:49:170.052
1852015-08-24 00:49:172015-08-24 00:49:170.052
1842015-08-24 00:49:042015-08-24 00:49:040.007
1842015-08-24 00:49:042015-08-24 00:49:17.22.007
1842015-08-24 00:49:042015-08-24 00:49:040.007
1842015-08-24 00:49:042015-08-24 00:49:040.007
1832015-08-24 00:48:282015-08-24 00:48:280.019
1832015-08-24 00:48:282015-08-24 00:49:04.6.019
1832015-08-24 00:48:282015-08-24 00:48:280.019
1832015-08-24 00:48:282015-08-24 00:48:280.019
1822015-08-24 00:46:342015-08-24 00:46:340.088
1822015-08-24 00:46:342015-08-24 00:48:281.9.088
1822015-08-24 00:46:342015-08-24 00:46:340.088
1822015-08-24 00:46:342015-08-24 00:46:340.088
1812015-08-24 00:43:162015-08-24 00:43:160.114
1812015-08-24 00:43:162015-08-24 00:46:343.3.114
1812015-08-24 00:43:162015-08-24 00:43:160.114
1812015-08-24 00:43:162015-08-24 00:43:160.114
1802015-08-24 00:43:072015-08-24 00:43:070.009
1802015-08-24 00:43:072015-08-24 00:43:070.009
1802015-08-24 00:43:072015-08-24 00:43:16.15.009
1802015-08-24 00:43:072015-08-24 00:43:070.009
1802015-08-24 00:43:072015-08-24 00:43:070.009
1792015-08-24 00:42:452015-08-24 00:42:45015.935
1792015-08-24 00:42:452015-08-24 00:42:45015.935
1792015-08-24 00:42:452015-08-24 00:43:07.3715.935
1792015-08-24 00:42:452015-08-24 00:42:45015.935
1792015-08-24 00:42:452015-08-24 00:42:45015.935
1782015-08-24 00:39:282015-08-24 00:39:28034.147
1782015-08-24 00:39:282015-08-24 00:42:453.2834.147
1782015-08-24 00:39:282015-08-24 00:39:28034.147
1782015-08-24 00:39:282015-08-24 00:39:28034.147
1772015-08-24 00:37:272015-08-24 00:37:270.059
1772015-08-24 00:37:272015-08-24 00:39:282.02.059
1772015-08-24 00:37:272015-08-24 00:37:270.059
1772015-08-24 00:37:272015-08-24 00:37:270.059
1762015-08-24 00:35:332015-08-24 00:35:330.063
1762015-08-24 00:35:332015-08-24 00:37:271.9.063
1762015-08-24 00:35:332015-08-24 00:35:330.063
1762015-08-24 00:35:332015-08-24 00:35:330.063
1752015-08-24 00:35:092015-08-24 00:35:090.013
1752015-08-24 00:35:092015-08-24 00:35:33.4.013
1752015-08-24 00:35:092015-08-24 00:35:090.013
1752015-08-24 00:35:092015-08-24 00:35:090.013
1742015-08-24 00:34:212015-08-24 00:34:210.026
1742015-08-24 00:34:212015-08-24 00:35:09.8.026
1742015-08-24 00:34:212015-08-24 00:34:210.026
1742015-08-24 00:34:212015-08-24 00:34:210.026
1732015-08-24 00:34:202015-08-24 00:34:200.001
1732015-08-24 00:34:202015-08-24 00:34:21.02.001
1732015-08-24 00:34:202015-08-24 00:34:200.001
1732015-08-24 00:34:202015-08-24 00:34:200.001
1722015-08-24 00:31:502015-08-24 00:31:500.073
1722015-08-24 00:31:502015-08-24 00:34:202.5.073
1722015-08-24 00:31:502015-08-24 00:31:500.073
1722015-08-24 00:31:502015-08-24 00:31:500.073
1712015-08-24 00:29:252015-08-24 00:29:250.056
1712015-08-24 00:29:252015-08-24 00:31:502.42.056
1712015-08-24 00:29:252015-08-24 00:29:250.056
1712015-08-24 00:29:252015-08-24 00:29:250.056
1702015-08-24 00:19:282015-08-24 00:19:280.359
1702015-08-24 00:19:282015-08-24 00:29:259.95.359
1702015-08-24 00:19:282015-08-24 00:19:280.359
1692015-08-23 23:54:162015-08-23 23:54:1602.235
1692015-08-23 23:54:162015-08-23 23:54:1602.235
1692015-08-23 23:54:162015-08-24 00:19:2825.22.235
1682015-08-23 23:52:562015-08-23 23:52:560.039
1682015-08-23 23:52:562015-08-23 23:54:161.33.039
1682015-08-23 23:52:562015-08-23 23:52:560.039
1682015-08-23 23:52:562015-08-23 23:52:560.039
1672015-08-23 23:38:222015-08-23 23:38:220.494
1672015-08-23 23:38:222015-08-23 23:52:5614.57.494
1672015-08-23 23:38:222015-08-23 23:38:220.494
1672015-08-23 23:38:222015-08-23 23:38:220.494
1662015-08-23 23:33:322015-08-23 23:33:320.148
1662015-08-23 23:33:322015-08-23 23:38:224.83.148
1662015-08-23 23:33:322015-08-23 23:33:320.148
1662015-08-23 23:33:322015-08-23 23:33:320.148
1652015-08-23 23:19:502015-08-23 23:19:500.444
1652015-08-23 23:19:502015-08-23 23:33:3213.7.444
1652015-08-23 23:19:502015-08-23 23:19:500.444
1652015-08-23 23:19:502015-08-23 23:19:500.444
1642015-08-23 23:13:502015-08-23 23:13:500.178
1642015-08-23 23:13:502015-08-23 23:19:506.178
1642015-08-23 23:13:502015-08-23 23:13:500.178
1642015-08-23 23:13:502015-08-23 23:13:500.178
1632015-08-23 23:05:242015-08-23 23:05:240.528
1632015-08-23 23:05:242015-08-23 23:13:508.43.528
1632015-08-23 23:05:242015-08-23 23:05:240.528
1632015-08-23 23:05:242015-08-23 23:05:240.528
1622015-08-23 22:59:452015-08-23 22:59:4501.363
1622015-08-23 22:59:452015-08-23 23:05:245.651.363
1622015-08-23 22:59:452015-08-23 22:59:4501.363
1622015-08-23 22:59:452015-08-23 22:59:4501.363
1612015-08-23 22:45:142015-08-23 22:45:140.44
1612015-08-23 22:45:142015-08-23 22:59:4514.52.44
1612015-08-23 22:45:142015-08-23 22:45:140.44
1612015-08-23 22:45:142015-08-23 22:45:140.44
1602015-08-23 22:35:372015-08-23 22:35:370.304
1602015-08-23 22:35:372015-08-23 22:45:149.62.304
1602015-08-23 22:35:372015-08-23 22:35:370.304
1602015-08-23 22:35:372015-08-23 22:35:370.304
1592015-08-23 22:28:212015-08-23 22:28:210.204
1592015-08-23 22:28:212015-08-23 22:35:377.27.204
1592015-08-23 22:28:212015-08-23 22:28:210.204
1592015-08-23 22:28:212015-08-23 22:28:210.204
1582015-08-23 21:19:462015-08-23 21:19:4603.721
1582015-08-23 21:19:462015-08-23 22:28:2168.583.721
1582015-08-23 21:19:462015-08-23 21:19:4603.721
1582015-08-23 21:19:462015-08-23 21:19:4603.721
1572015-08-23 20:57:152015-08-23 20:57:1502.45
1572015-08-23 20:57:152015-08-23 21:19:4622.522.45
1572015-08-23 20:57:152015-08-23 20:57:1502.45
1572015-08-23 20:57:152015-08-23 20:57:1502.45
1562015-08-23 20:56:562015-08-23 20:56:560.012
1562015-08-23 20:56:562015-08-23 20:57:15.32.012
1562015-08-23 20:56:562015-08-23 20:56:560.012
1562015-08-23 20:56:562015-08-23 20:56:560.012
1552015-08-23 20:56:522015-08-23 20:56:56.07.002
1542015-08-23 20:55:072015-08-23 20:56:521.75.091
1532015-08-23 20:55:052015-08-23 20:55:050.001
1532015-08-23 20:55:052015-08-23 20:55:07.03.001
1532015-08-23 20:55:052015-08-23 20:55:050.001
1532015-08-23 20:55:052015-08-23 20:55:050.001
1522015-08-23 20:54:572015-08-23 20:54:570.004
1522015-08-23 20:54:572015-08-23 20:55:05.13.004
1522015-08-23 20:54:572015-08-23 20:54:570.004
1522015-08-23 20:54:572015-08-23 20:54:570.004
1512015-08-23 20:54:562015-08-23 20:54:560.001
1512015-08-23 20:54:562015-08-23 20:54:57.02.001
1512015-08-23 20:54:562015-08-23 20:54:560.001
1512015-08-23 20:54:562015-08-23 20:54:560.001
1502015-08-23 20:54:542015-08-23 20:54:540.001
1502015-08-23 20:54:542015-08-23 20:54:56.03.001
1502015-08-23 20:54:542015-08-23 20:54:540.001
1502015-08-23 20:54:542015-08-23 20:54:540.001
1492015-08-23 19:23:132015-08-23 19:23:1305.976
1492015-08-23 19:23:132015-08-23 20:54:5491.685.976
1492015-08-23 19:23:132015-08-23 19:23:1305.976
1492015-08-23 19:23:132015-08-23 19:23:1305.976
1482015-08-23 19:23:112015-08-23 19:23:110.001
1482015-08-23 19:23:112015-08-23 19:23:13.03.001
1482015-08-23 19:23:112015-08-23 19:23:110.001
1482015-08-23 19:23:112015-08-23 19:23:110.001
1472015-08-23 17:40:382015-08-23 17:40:38016.55
1472015-08-23 17:40:382015-08-23 19:23:11102.5516.55
1472015-08-23 17:40:382015-08-23 17:40:38016.55
1472015-08-23 17:40:382015-08-23 17:40:38016.55
1462015-08-23 17:35:222015-08-23 17:35:220.402
1462015-08-23 17:35:222015-08-23 17:40:385.27.402
1462015-08-23 17:35:222015-08-23 17:35:220.402
1462015-08-23 17:35:222015-08-23 17:35:220.402
1452015-08-23 17:35:192015-08-23 17:35:22.05.001
1452015-08-23 17:35:192015-08-23 17:35:190.001

 

[回到目录]



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


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

THREAD#DAYH00H01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23TOTAL
108/260000000000000004000000004
108/24170000000000000000000000017
108/2300000000000000000302814725

 

[回到目录]



日志组大小

 

GROUP#THREAD#SEQUENCE#SIZE_MSTATUSARCMEMBERSMEMBERTYPE
119050INACTIVEYES1/u01/app/oracle/oradata/oradg11g/redo01.logONLINE
219150CURRENTNO1/u01/app/oracle/oradata/oradg11g/redo02.logONLINE
318950INACTIVEYES1/u01/app/oracle/oradata/oradg11g/redo03.logONLINE

 

[回到目录]



SGA信息

 



SGA使用情况

 

实例名称名称值(MB)是否可调
1Fixed SGA Size2No
1Redo Buffers8No
1Buffer Cache Size20Yes
1Shared Pool Size152Yes
1Large Pool Size4Yes
1Java Pool Size4Yes
1Streams Pool Size0Yes
1Shared IO Pool Size0Yes
1Granule Size4No
1Maximum SGA Size398No
1Startup overhead in Shared Pool64No
1Free SGA Memory Available208 

 

[回到目录]





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

1921219128,531
 2401212123,122
 2882209123,122
 3362209123,122
 3842209123,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 pool00000STATIC 

 

4,194,304
 shared pool159,383,552159,383,552163,577,85601SHRINKDEFERRED

2015-08-26 15:25:03

4,194,304
 large pool4,194,3044,194,3044,194,30400STATIC 

 

4,194,304
 java pool4,194,3044,194,3044,194,30400STATIC 

 

4,194,304
 Shared IO Pool00000STATIC 

 

4,194,304
 RECYCLE buffer cache00000STATIC 

 

4,194,304
 KEEP buffer cache00000STATIC 

 

4,194,304
 DEFAULT buffer cache20,971,52016,777,21620,971,52001GROWDEFERRED

2015-08-26 15:25:03

4,194,304
 DEFAULT 8K buffer cache00000STATIC 

 

4,194,304
 DEFAULT 4K buffer cache00000STATIC 

 

4,194,304
 DEFAULT 32K buffer cache00000STATIC 

 

4,194,304
 DEFAULT 2K buffer cache00000STATIC 

 

4,194,304
 DEFAULT 16K buffer cache00000STATIC 

 

4,194,304
 ASM Buffer Cache00000STATIC 

 

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,776116,457,4727512
 28,311,552116,457,4727512
 56,623,104116,457,4727512
 84,934,656116,457,4727512
 113,246,208010012
 135,895,040010011
 158,543,87201006
 181,193,72801006
 203,842,56001005
 226,492,41601002
 339,738,62401000
 452,984,83201000
 679,477,24801000
 905,969,66401000

 

[回到目录]



文件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.dbf59,179

80.61%

92

14.02%

59,271
SYSAUX/u01/app/oracle/oradata/oradg11g/sysaux01.dbf12,683

17.28%

397

60.52%

13,080
EXAMPLE/u01/app/oracle/oradata/oradg11g/example01.dbf669

.91%

0

0%

669
LOGMNRTBS/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf455

.62%

0

0%

455
UNDOTBS1/u01/app/oracle/oradata/oradg11g/undotbs01.dbf258

.35%

152

23.17%

410
USERS/u01/app/oracle/oradata/oradg11g/users01.dbf153

.21%

0

0%

153
TEMP/u01/app/oracle/oradata/oradg11g/temp01.dbf20

.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.dbf59,179.0392.43
/u01/app/oracle/oradata/oradg11g/sysaux01.dbf12,683.13397.11
/u01/app/oracle/oradata/oradg11g/example01.dbf669.220.00
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf455.070.00
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf258.26152.27
/u01/app/oracle/oradata/oradg11g/users01.dbf153.060.00
/u01/app/oracle/oradata/oradg11g/temp01.dbf20.0515.27
 ----------------------------------------------------------------------------------------------------------------------------------
Average: .12 .15
Total:73,417 656 

 

[回到目录]



全表扫描统计

 

Large Table ScansSmall Table ScansPct. Large Scans
1311,586

7.63%

 

[回到目录]



排序情况统计

 

Disk SortsMemory SortsPct. Disk Sorts
010,877

0%

 

NAMECNTHit Ratio
workarea executions - optimal6566100
workarea executions - onepass00
workarea executions - multipass00

 

[回到目录]



SQL监控

 



逻辑读TOP10的SQL语句


Top 100 SQL statements with buffer gets greater than 1000 

INST_IDUsernameBuffer GetsExecutionsBuffer Gets / ExecutionSQL Text
1LHR36,670136,670select '

' || 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
1LHR23,16956414select 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
1LHR12,84561211select 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_%'
1LHR8,33118,331SELECT '

' || 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_
1LHR7,46917,469SELECT '' || 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
1APEX_0302002,6375527DECLARE 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;
1APEX_0302001,51311,513DECLARE 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;
1MDSYS1,1414285declare 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
1LHR1,0606117select * 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
1LHR20,903120,903select '

' || 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
1LHR11,16061183select 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_%'
1LHR7,32317,323SELECT '' || 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
196g93hntrzjtrselect /*+ 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#=:246712015-08-26 15:24:262015-08-26/15:24:263041233039
153saa2zkr6wc3select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:117762015-08-26 15:24:332015-08-26/15:24:2645802329
13nkd3g3ju5ph1select 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 null17662015-08-26 15:24:262015-08-26/15:24:25265688533
132hbap2vtmf53select 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# desc15222015-08-26 15:24:282015-08-26/15:24:282112439118
13c1kubcdjnppqupdate 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# = :coln13872015-08-26 15:39:442015-08-26/15:39:447345504
1db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket10352015-08-26 15:24:262015-08-26/15:24:26412315224
1grwydz59pu6mcselect text from view$ where rowid=:18032015-08-26 15:24:332015-08-26/15:24:2668162221
183taa7kaw59c1select 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#7092015-08-26 15:24:332015-08-26/15:24:25220234833
15n1fs4m2n2y0rselect pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:16992015-08-26 15:24:332015-08-26/15:24:2534433031
19tgj4g8y4rwy8select 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#=:36862015-08-26 15:24:332015-08-26/15:24:2662209122

 

[回到目录]



解析次数TOP10的SQL语句

 

INST_IDSQL_IDSQL_TEXTEXECUTIONSLAST_LOAD_TIMEFIRST_LOAD_TIMEDISK_READSBUFFER_GETSPARSE_CALLS
1b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait5192015-08-26 15:39:442015-08-26/15:39:44126519
1350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait1072015-08-26 15:39:442015-08-26/15:39:44121107
13ktacv9r56b51select 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#6402015-08-26 15:24:332015-08-26/15:24:25577803943
18swypbbr0m372select order#,columns,types from access$ where d_obj#=:16402015-08-26 15:24:332015-08-26/15:24:25337627143
183cq1aqjw5gmgselect ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure#02015-08-26 15:24:282015-08-26/15:24:280042
196g93hntrzjtrselect /*+ 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#=:246712015-08-26 15:24:262015-08-26/15:24:263041233039
1cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#2252015-08-26 15:24:332015-08-26/15:24:27966285136
139m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#2252015-08-26 15:24:332015-08-26/15:24:27423143336
1ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#2252015-08-26 15:24:332015-08-26/15:24:26212136936
1c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#2252015-08-26 15:24:332015-08-26/15:24:2713980536

 

[回到目录]



DISK SORT严重的SQL语句

 

[回到目录]



ASM磁盘监控

 



ASM磁盘使用情况

 

NAMEPATHSTATETOTAL_MBFREE_MBCREATE_DATEMOUNT_DATE
DATA_0000/dev/asm-diskbNORMAL51206692014-06-14 22:45:252015-08-23 17:33:07
FRA_0000/dev/asm-diskeNORMAL1024071842014-06-14 22:50:192015-08-23 17:33:07
DATA_0001/dev/asm-diskcNORMAL51206642014-06-14 22:45:252015-08-23 17:33:07
DATA_0002/dev/asm-diskdNORMAL51206702014-06-14 22:45:252015-08-23 17:33:07
DATA_0003/dev/raw/raw1NORMAL200002015-05-19 18:00:592015-08-23 17:33:07
 /dev/raw/raw2NORMAL00  
   --------------------  
Total  276009187  

 

[回到目录]



ASM磁盘组使用情况

 

NAMEBLOCK_SIZESTATETYPETOTAL_MBFREE_MB
DATA4096MOUNTEDNORMAL173602003
FRA4096MOUNTEDEXTERN102407184
    --------------------
Total   276009187

 

[回到目录]



ASM磁盘组参数配置情况

 

NAMEVALUEGROUP_NUMBERATTRIBUTE_INDEXATTRIBUTE_INCARNATIONREAD_ONSYSTEM_
access_control.enabledFALSE1401NY
access_control.umask0661411NY
au_size1048576151YY
cell.smart_scan_capableFALSE1301NN
compatible.asm11.2.0.0.01201NY
compatible.rdbms10.1.0.0.01211NY
disk_repair_time3.6h101NY
sector_size512161YY
template_version1866465281501NY
access_control.enabledFALSE2401NY
access_control.umask0662411NY
au_size1048576251YY
cell.smart_scan_capableFALSE2301NN
compatible.asm11.2.0.0.02201NY
compatible.rdbms10.1.0.0.02211NY
disk_repair_time3.6h201NY
sector_size512261YY
template_version1866465282501NY

 

[回到目录]



ASM实例

 

[回到目录]



闪回归档

 



闪回归档配置

 

[回到目录]



开启了闪回归档的表

 

[回到目录]



闪回归档空间

 

[回到目录]



DG库

 



DG库配置情况

 

参数名称实例名称参数值
db_file_name_convertoradg11goradglg, oradg11g
fal_clientoradg11goradg11g
fal_serveroradg11goradglg
log_archive_configoradg11gDG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font>
log_archive_dest_1oradg11gLOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)
log_archive_dest_2oradg11gSERVICE=tns_oradgphy LGWR ASYNC db_unique_name=ora dgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_3oradg11gSERVICE=tns_oradglg LGWR ASYNC db_unique_name=orad glg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_4oradg11gSERVICE=tns_oradgss LGWR ASYNC db_unique_name=orad gss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_state_1oradg11gENABLE
log_archive_dest_state_2oradg11gENABLE
log_archive_dest_state_3oradg11gENABLE
log_archive_dest_state_4oradg11gENABLE
log_file_name_convertoradg11goradglg, oradg11g
standby_file_managementoradg11gAUTO

 

[回到目录]



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#
1ORADG11GARCHIVELOGREAD WRITEPRIMARYTO STANDBYoradg11gYESMAXIMUM PERFORMANCEMAXIMUM PERFORMANCEENABLED1414208659TO STANDBYDISABLEDNONEIMPLICITYESYESYESNONO2076848DISABLED 0  NOoradglgYES 

 

THREAD#DEST_IDDEST_NAMETARGETDATABASE_MODESTATUSERRORRECOVERY_MODEDB_UNIQUE_NAMEDESTINATIONGAP_STATUSCURRENT_SEQ#LAST_ARCHIVEDAPPLIED_SEQ#APPLIED_SCN
11LOG_ARCHIVE_DEST_1LOCAL PRIMARYOPENVALID IDLEoradg11g  919080
12LOG_ARCHIVE_DEST_2PHYSICAL STANDBYOPEN_READ-ONLYVALID MANAGED REAL TIME APPLYoradgphytns_oradgphyNO GAP9190892282617
13LOG_ARCHIVE_DEST_3LOGICAL STANDBYOPENVALID LOGICAL REAL TIME APPLYoradglgtns_oradglgNO GAP9190902282614
14LOG_ARCHIVE_DEST_4PHYSICAL STANDBYOPEN_READ-ONLYVALID MANAGED REAL TIME APPLYoradgsstns_oradgssNO GAP9190892282617

 

[回到目录]



主库进程

 

INSTANCE_NAMEPROCESSCLIENT_PCLIENT_PIDSTATUSGROUP_#THREAD#SEQUENCE#DELAY_MINSRESETLOG_IDSIDSERIAL#SPID
oradg11gARCHARCH58780CLOSINGN/A1900886695024135358780
oradg11gARCHARCH58786CLOSING3189088669502410158786
oradg11gARCHARCH58788CLOSINGN/A1870886695024136358788
oradg11gLNSLNS58800WRITING2191088669502413158800
oradg11gLNSLNS58798WRITING21910886695024138158798
oradg11gLNSLNS58802WRITING21910886695024139158802
oradg11gARCHARCH58790CLOSINGN/A190088669502411158790

 

[回到目录]



standby 日志

 

GROUP#DB_IDTHREAD#SEQUENCE#BYTESUSEDARCSTATUSFIRST_CHANGE#NEXT_CHANGE#LAST_CHANGE#
4UNASSIGNED10524288000YESUNASSIGNED   
5UNASSIGNED10524288000YESUNASSIGNED   
6UNASSIGNED10524288000YESUNASSIGNED   
7UNASSIGNED10524288000YESUNASSIGNED   

 

[回到目录]


数据库安全

 



数据库用户

 



数据库用户一览

 

UsernameAccount StatusExpire DateDefault Tbs.Temp Tbs.Created OnProfileSYSDBASYSOPER
ANONYMOUS

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 09:58:25

DEFAULT

 

 

APEX_030200

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 10:13:33

DEFAULT

 

 

APEX_PUBLIC_USER

EXPIRED & LOCKED

2011-09-17 10:21:08

USERSTEMP

2011-09-17 10:13:33

DEFAULT

 

 

APPQOSSYS

EXPIRED & LOCKED

2011-09-17 09:52:28

SYSAUXTEMP

2011-09-17 09:52:28

DEFAULT

 

 

BI

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

CTXSYS

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 09:58:00

DEFAULT

 

 

DBSNMP

EXPIRED & LOCKED

2011-09-17 09:52:27

SYSAUXTEMP

2011-09-17 09:52:27

MONITORING_PROFILE

 

 

DIP

EXPIRED & LOCKED

2011-09-17 09:47:52

USERSTEMP

2011-09-17 09:47:52

DEFAULT

 

 

EXFSYS

EXPIRED & LOCKED

2011-09-17 09:57:46

SYSAUXTEMP

2011-09-17 09:57:46

DEFAULT

 

 

FLOWS_FILES

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 10:13:33

DEFAULT

 

 

HR

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

IX

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

LHR

OPEN

2015-09-30 17:07:39

USERSTEMP

2015-04-03 17:07:39

DEFAULT

 

 

MDDATA

EXPIRED & LOCKED

2011-09-17 10:21:08

USERSTEMP

2011-09-17 10:05:26

DEFAULT

 

 

MDSYS

EXPIRED & LOCKED

2011-09-17 10:00:09

SYSAUXTEMP

2011-09-17 10:00:09

DEFAULT

 

 

MGMT_VIEW

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSTEMTEMP

2011-09-17 10:12:38

DEFAULT

 

 

OE

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

OLAPSYS

EXPIRED & LOCKED

2011-09-17 10:04:19

SYSAUXTEMP

2011-09-17 10:04:19

DEFAULT

 

 

ORACLE_OCM

EXPIRED & LOCKED

2011-09-17 09:48:28

USERSTEMP

2011-09-17 09:48:28

DEFAULT

 

 

ORDDATA

EXPIRED & LOCKED

2011-09-17 10:00:09

SYSAUXTEMP

2011-09-17 10:00:09

DEFAULT

 

 

ORDPLUGINS

EXPIRED & LOCKED

2011-09-17 10:00:09

SYSAUXTEMP

2011-09-17 10:00:09

DEFAULT

 

 

ORDSYS

EXPIRED & LOCKED

2011-09-17 10:00:09

SYSAUXTEMP

2011-09-17 10:00:09

DEFAULT

 

 

OUTLN

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSTEMTEMP

2011-09-17 09:46:25

DEFAULT

 

 

OWBSYS

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 10:21:02

DEFAULT

 

 

OWBSYS_AUDIT

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 10:21:03

DEFAULT

 

 

PM

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

SCOTT

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2011-09-17 10:21:59

DEFAULT

 

 

SH

EXPIRED & LOCKED

2015-04-03 16:01:59

USERSTEMP

2015-04-03 15:59:12

DEFAULT

 

 

SI_INFORMTN_SCHEMA

EXPIRED & LOCKED

2011-09-17 10:00:09

SYSAUXTEMP

2011-09-17 10:00:09

DEFAULT

 

 

SPATIAL_CSW_ADMIN_USR

EXPIRED & LOCKED

2011-09-17 10:09:45

USERSTEMP

2011-09-17 10:09:45

DEFAULT

 

 

SPATIAL_WFS_ADMIN_USR

EXPIRED & LOCKED

2011-09-17 10:09:40

USERSTEMP

2011-09-17 10:09:40

DEFAULT

 

 

SYS

OPEN

2015-09-30 16:01:55

SYSTEMTEMP

2011-09-17 09:46:22

DEFAULT

TRUE

TRUE

SYSMAN

EXPIRED & LOCKED

2011-09-17 10:21:08

SYSAUXTEMP

2011-09-17 10:09:57

DEFAULT

 

 

SYSTEM

OPEN

2015-09-30 16:01:55

SYSTEMTEMP

2011-09-17 09:46:22

DEFAULT

 

 

WMSYS

EXPIRED & LOCKED

2011-09-17 09:53:14

SYSAUXTEMP

2011-09-17 09:53:14

DEFAULT

 

 

XDB

EXPIRED & LOCKED

2011-09-17 09:58:25

SYSAUXTEMP

2011-09-17 09:58:25

DEFAULT

 

 

XS$NULL

EXPIRED & LOCKED

2011-09-17 09:59:56

USERSTEMP

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
SYSTRUETRUEFALSE

 

[回到目录]



角色概况

 

Role NameGranteeAdmin Option?Default Role?
ADM_PARALLEL_EXECUTE_TASKSYS

YES

YES

APEX_ADMINISTRATOR_ROLESYS

YES

YES

AQ_ADMINISTRATOR_ROLEIX

NO

YES

 OWBSYS

NO

YES

 SYS

YES

YES

 SYSTEM

YES

YES

AQ_USER_ROLEIX

NO

YES

 OWBSYS

NO

YES

 SYS

YES

YES

AUTHENTICATEDUSERSYS

YES

YES

CONNECTAPEX_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_ROLESYS

YES

YES

CTXAPPCTXSYS

YES

YES

 SYS

YES

YES

 XDB

NO

YES

CWM_USEROWBSYS

YES

YES

 SH

NO

YES

 SYS

YES

YES

DATAPUMP_EXP_FULL_DATABASEDBA

NO

YES

 SYS

YES

YES

DATAPUMP_IMP_FULL_DATABASEDBA

NO

YES

 SYS

YES

YES

DBALHR

NO

YES

 SYS

YES

YES

 SYSTEM

YES

YES

DBFS_ROLESYS

YES

YES

DELETE_CATALOG_ROLEDBA

YES

YES

 SYS

YES

YES

EJBCLIENTSYS

YES

YES

EXECUTE_CATALOG_ROLEDBA

YES

YES

 EXP_FULL_DATABASE

NO

YES

 IMP_FULL_DATABASE

NO

YES

 SYS

YES

YES

EXP_FULL_DATABASEDATAPUMP_EXP_FULL_DATABASE

NO

YES

 DATAPUMP_IMP_FULL_DATABASE

NO

YES

 DBA

NO

YES

 SYS

YES

YES

GATHER_SYSTEM_STATISTICSDBA

NO

YES

 SYS

YES

YES

GLOBAL_AQ_USER_ROLE   
HS_ADMIN_EXECUTE_ROLEEXECUTE_CATALOG_ROLE

NO

YES

 HS_ADMIN_ROLE

NO

YES

 SYS

YES

YES

HS_ADMIN_ROLESYS

YES

YES

HS_ADMIN_SELECT_ROLEHS_ADMIN_ROLE

NO

YES

 SELECT_CATALOG_ROLE

NO

YES

 SYS

YES

YES

IMP_FULL_DATABASEDATAPUMP_IMP_FULL_DATABASE

NO

YES

 DBA

NO

YES

 SYS

YES

YES

JAVADEBUGPRIVSYS

YES

YES

JAVAIDPRIVSYS

YES

YES

JAVASYSPRIVSYS

YES

YES

JAVAUSERPRIVJAVASYSPRIV

NO

YES

 ORDSYS

NO

YES

 OWBSYS

NO

YES

 SYS

YES

YES

 XDB

NO

YES

JAVA_ADMINDBA

NO

YES

 OWBSYS

NO

YES

 SYS

YES

YES

JAVA_DEPLOYDBA

NO

YES

 SYS

YES

YES

JMXSERVERSYS

YES

YES

LOGSTDBY_ADMINISTRATORSYS

YES

YES

MGMT_USERMGMT_VIEW

NO

YES

 SYS

YES

YES

 SYSMAN

YES

YES

 SYSTEM

NO

YES

OEM_ADVISORSYS

YES

YES

OEM_MONITORDBSNMP

NO

YES

 SYS

YES

YES

OLAP_DBADBA

NO

YES

 OLAPSYS

NO

YES

 SYS

YES

YES

OLAP_USEROWBSYS

YES

YES

 SYS

YES

YES

OLAP_XS_ADMINDBA

NO

YES

 SYS

YES

YES

ORDADMINSYS

YES

YES

OWB$CLIENTOWBSYS

YES

YES

 SYS

YES

YES

OWB_DESIGNCENTER_VIEWOWBSYS

YES

YES

 SYS

YES

YES

OWB_USEROWBSYS

YES

YES

 SYS

YES

YES

RECOVERY_CATALOG_OWNERSYS

YES

YES

RESOURCEAPEX_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_ADMINDBA

YES

YES

 SYS

YES

YES

SELECT_CATALOG_ROLEDBA

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_ADMINSPATIAL_CSW_ADMIN_USR

YES

YES

 SYS

YES

YES

SPATIAL_WFS_ADMINSPATIAL_WFS_ADMIN_USR

YES

YES

 SYS

YES

YES

WFS_USR_ROLESYS

YES

YES

WM_ADMIN_ROLEDBA

NO

YES

 WMSYS

YES

YES

XDBADMINDBA

NO

YES

 OE

NO

YES

 SYS

YES

YES

XDB_SET_INVOKERDBA

NO

YES

 SYS

YES

YES

XDB_WEBSERVICESSYS

YES

YES

XDB_WEBSERVICES_OVER_HTTPSYS

YES

YES

XDB_WEBSERVICES_WITH_PUBLICSYS

YES

YES

 

[回到目录]



密码为系统默认值的用户

 

[回到目录]



整个用户有多大

 

OWNERsize(M)
SYS880.63
SH287.25
XDB157.69
SYSTEM116.44
APEX_03020085.44
MDSYS73.94
SYSMAN45.94
LHR34.31
ORDDATA13.56
PM12.25
OE9.06
OLAPSYS8.81
CTXSYS3.75
EXFSYS3.63
WMSYS3.5
IX1.75
HR1.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

INDEX04

OUTLN

LOBSEGMENT01

OUTLN

TABLE03

OUTLN

LOBINDEX01


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

 

OwnerSegment NameTypeTablespaceBytes 
Alloc		ExtentsInitial 
Ext		Next 
Ext		Pct 
Inc

OUTLN

OL$TABLESYSTEM65,536165,5361,048,576 
 OL$HINTSTABLESYSTEM65,536165,5361,048,576 
 OL$HNT_NUMINDEXSYSTEM65,536165,5361,048,576 
 OL$NAMEINDEXSYSTEM65,536165,5361,048,576 
 OL$NODESTABLESYSTEM65,536165,5361,048,576 
 OL$NODE_OL_NAMEINDEXSYSTEM65,536165,5361,048,576 
 OL$SIGNATUREINDEXSYSTEM65,536165,5361,048,576 
 SYS_IL0000000451C00021$$LOBINDEXSYSTEM65,536165,5361,048,576 
 SYS_LOB0000000451C00021$$LOBSEGMENTSYSTEM65,536165,5361,048,576 
***************************************************************************-----------------------------------------------------------------------------------------------------------------------------  --------------------    
Total Count:9       
Total Bytes:   589,824    

 

[回到目录]



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

 

TABLE_NAMEOWNERTABLESPACE_NAME
OL$NODESOUTLNSYSTEM
OL$HINTSOUTLNSYSTEM
OL$OUTLNSYSTEM
WWV_FLOW_FILE_OBJECTS$FLOWS_FILESSYSAUX

 

[回到目录]



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

 

INDEX_NAMEOWNERTABLESPACE_NAME
OL$NAMEOUTLNSYSTEM
OL$SIGNATUREOUTLNSYSTEM
SYS_IL0000000451C00021$$OUTLNSYSTEM
OL$HNT_NUMOUTLNSYSTEM
OL$NODE_OL_NAMEOUTLNSYSTEM
WWV_FLOW_FILE_OBJ_PKFLOWS_FILESSYSAUX
SYS_IL0000072495C00017$$FLOWS_FILESSYSAUX
SYS_C008628FLOWS_FILESSYSAUX
WWV_FLOW_FILES_SGID_FK_IDXFLOWS_FILESSYSAUX
WWV_FLOW_FILES_USER_IDXFLOWS_FILESSYSAUX

 

[回到目录]


数据库对象

 



段情况

 



对象汇总

 

OwnerObject TypeObject Count
APEX_030200FUNCTION12
 INDEX1,101
 LOB155
 PACKAGE189
 PACKAGE BODY181
 PROCEDURE19
 SEQUENCE4
 SYNONYM45
 TABLE360
 TRIGGER366
 TYPE4
 VIEW125
APPQOSSYSSYNONYM1
 TABLE4
BISYNONYM8
CTXSYSFUNCTION2
 INDEX63
 INDEXTYPE4
 LIBRARY1
 LOB2
 OPERATOR6
 PACKAGE74
 PACKAGE BODY63
 PROCEDURE2
 SEQUENCE3
 TABLE50
 TYPE35
 TYPE BODY6
 VIEW77
DBSNMPINDEX10
 PACKAGE4
 PACKAGE BODY4
 PROCEDURE1
 SEQUENCE2
 SYNONYM1
 TABLE20
 TYPE8
 VIEW7
EXFSYSFUNCTION26
 INDEX41
 INDEXTYPE1
 JAVA CLASS47
 JAVA RESOURCE1
 JOB2
 LIBRARY1
 LOB2
 OPERATOR1
 PACKAGE18
 PACKAGE BODY18
 PROCEDURE10
 SEQUENCE1
 TABLE47
 TRIGGER5
 TYPE30
 TYPE BODY5
 VIEW56
FLOWS_FILESINDEX5
 LOB1
 SYNONYM5
 TABLE1
 TRIGGER1
HRINDEX19
 PROCEDURE2
 SEQUENCE3
 TABLE7
 TRIGGER2
 VIEW1
IXEVALUATION CONTEXT2
 INDEX17
 LOB3
 QUEUE4
 RULE SET4
 SEQUENCE2
 TABLE17
 TYPE1
 VIEW8
LHRTABLE6
 VIEW1
MDSYSFUNCTION108
 INDEX367
 INDEXTYPE2
 JAVA CLASS535
 JAVA RESOURCE3
 LIBRARY18
 LOB214
 OPERATOR25
 PACKAGE70
 PACKAGE BODY66
 PROCEDURE2
 SEQUENCE15
 TABLE148
 TRIGGER64
 TYPE207
 TYPE BODY43
 VIEW86
OEFUNCTION1
 INDEX48
 LOB15
 SEQUENCE1
 SYNONYM6
 TABLE14
 TRIGGER4
 TYPE37
 TYPE BODY3
 VIEW13
OLAPSYSFUNCTION1
 INDEX137
 LOB2
 PACKAGE45
 PACKAGE BODY43
 SEQUENCE5
 TABLE126
 TRIGGER48
 TYPE7
 VIEW307
ORACLE_OCMJOB2
 PACKAGE3
 PACKAGE BODY3
ORDDATAINDEX138
 LOB9
 SEQUENCE12
 TABLE73
 VIEW25
ORDPLUGINSPACKAGE5
 PACKAGE BODY5
ORDSYSFUNCTION32
 INDEX4
 JAVA CLASS1,876
 JAVA RESOURCE72
 LIBRARY2
 PACKAGE28
 PACKAGE BODY20
 PROCEDURE7
 TABLE5
 TYPE446
 TYPE BODY15
 VIEW5
OUTLNINDEX5
 LOB1
 PROCEDURE1
 TABLE3
OWBSYSINDEX1
 TABLE1
OWBSYS_AUDITSYNONYM12
PMINDEX21
 LOB17
 TABLE3
 TYPE3
PUBLICSYNONYM28,027
SCOTTINDEX2
 TABLE4
SHDIMENSION5
 INDEX29
 INDEX PARTITION196
 LOB2
 MATERIALIZED VIEW2
 TABLE17
 TABLE PARTITION56
 VIEW1
SI_INFORMTN_SCHEMASYNONYM8
SYSCLUSTER10
 CONSUMER GROUP25
 CONTEXT7
 DESTINATION2
 DIRECTORY9
 EDITION1
 EVALUATION CONTEXT10
 FUNCTION100
 INDEX1,221
 INDEX PARTITION54
 JAVA CLASS20,707
 JAVA DATA328
 JAVA RESOURCE761
 JAVA SOURCE2
 JOB10
 JOB CLASS14
 LIBRARY147
 LOB189
 LOB PARTITION1
 OPERATOR7
 PACKAGE633
 PACKAGE BODY607
 PROCEDURE105
 PROGRAM19
 QUEUE18
 RESOURCE PLAN10
 RULE1
 RULE SET13
 SCHEDULE3
 SCHEDULER GROUP4
 SEQUENCE135
 SYNONYM9
 TABLE1,004
 TABLE PARTITION52
 TABLE SUBPARTITION32
 TRIGGER9
 TYPE1,347
 TYPE BODY113
 UNDEFINED11
 VIEW3,849
 WINDOW9
SYSMANEVALUATION CONTEXT2
 FUNCTION12
 INDEX1,028
 LOB75
 MATERIALIZED VIEW1
 PACKAGE193
 PACKAGE BODY193
 PROCEDURE3
 QUEUE12
 RULE SET4
 SEQUENCE13
 TABLE729
 TRIGGER97
 TYPE672
 TYPE BODY49
 VIEW471
SYSTEMINDEX241
 INDEX PARTITION104
 LOB25
 PACKAGE1
 PACKAGE BODY1
 PROCEDURE1
 QUEUE4
 SEQUENCE20
 SYNONYM8
 TABLE161
 TABLE PARTITION77
 TRIGGER2
 TYPE1
 VIEW14
WMSYSEVALUATION CONTEXT1
 FUNCTION4
 INDEX70
 LOB9
 OPERATOR9
 PACKAGE22
 PACKAGE BODY22
 PROCEDURE4
 QUEUE2
 RULE SET2
 SEQUENCE9
 TABLE46
 TRIGGER2
 TYPE18
 TYPE BODY1
 VIEW111
XDBFUNCTION7
 INDEX697
 INDEXTYPE2
 LIBRARY17
 LOB586
 OPERATOR7
 PACKAGE35
 PACKAGE BODY33
 PROCEDURE4
 SEQUENCE5
 TABLE94
 TRIGGER27
 TYPE97
 TYPE BODY5
 VIEW20
 XML SCHEMA54
************************************************************ ----------------
Total: 75,307

 

[回到目录]



段的汇总

 

OwnerSegment TypeSegment CountSize (in Bytes)
APEX_030200INDEX26239,976,960
 LOBINDEX503,276,800
 LOBSEGMENT5010,420,224
 TABLE10535,913,728
CTXSYSINDEX382,490,368
 LOBINDEX2131,072
 LOBSEGMENT2131,072
 TABLE171,179,648
DBSNMPINDEX5327,680
 TABLE3196,608
EXFSYSINDEX372,424,832
 LOBINDEX165,536
 LOBSEGMENT165,536
 TABLE191,245,184
HRINDEX191,245,184
 TABLE6393,216
IXINDEX14917,504
 LOBINDEX3196,608
 LOBSEGMENT3196,608
 TABLE8524,288
LHRTABLE635,979,264
MDSYSINDEX987,405,568
 LOBINDEX19712,976,128
 LOBSEGMENT19741,877,504
 NESTED TABLE161,048,576
 TABLE6414,221,312
OEINDEX332,949,120
 LOBINDEX15983,040
 LOBSEGMENT151,048,576
 NESTED TABLE4589,824
 TABLE103,932,160
OLAPSYSINDEX805,242,880
 TABLE613,997,696
ORDDATAINDEX956,946,816
 LOBINDEX6393,216
 LOBSEGMENT63,014,656
 NESTED TABLE2131,072
 TABLE513,735,552
ORDSYSINDEX3196,608
 TABLE4262,144
OUTLNINDEX4262,144
 LOBINDEX165,536
 LOBSEGMENT165,536
 TABLE3196,608
PMINDEX4262,144
 LOBINDEX171,114,112
 LOBSEGMENT1711,206,656
 NESTED TABLE165,536
 TABLE2196,608
SCOTTINDEX2131,072
 TABLE3196,608
SHINDEX192,490,368
 INDEX PARTITION11211,141,120
 LOBINDEX2131,072
 LOBSEGMENT2131,072
 TABLE1218,874,368
 TABLE PARTITION32268,435,456
SYSCLUSTER1053,805,056
 INDEX1,000185,729,024
 INDEX PARTITION544,521,984
 LOB PARTITION165,536
 LOBINDEX17811,665,408
 LOBSEGMENT17866,322,432
 NESTED TABLE161,048,576
 ROLLBACK1393,216
 TABLE833556,793,856
 TABLE PARTITION514,784,128
 TABLE SUBPARTITION322,097,152
 TYPE2 UNDO1036,175,872
SYSMANINDEX30124,969,216
 LOBINDEX432,818,048
 LOBSEGMENT433,407,872
 NESTED TABLE2131,072
 TABLE19016,842,752
SYSTEMINDEX16010,485,760
 INDEX PARTITION10423,199,744
 LOBINDEX221,638,400
 LOBSEGMENT225,570,560
 TABLE1147,471,104
 TABLE PARTITION7773,728,000
WMSYSINDEX301,966,080
 LOBINDEX5327,680
 LOBSEGMENT5327,680
 NESTED TABLE2131,072
 TABLE14917,504
XDBINDEX1099,502,720
 LOBINDEX58538,338,560
 LOBSEGMENT58595,223,808
 NESTED TABLE10655,360
 TABLE8321,626,880
************************************************** ------------------------------------
Total: 6,7121,825,898,496

 

[回到目录]



体积最大的10个段

 

OwnerSegment NamePartition NameSegment TypeTablespace NameSize (in bytes)Extents
SYSIDL_UB1$ TABLESYSTEM260,046,848102
SYSSOURCE$ TABLESYSTEM75,497,47280
XDBSYS_LOB0000057465C00025$$ LOBSEGMENTSYSAUX55,771,13655
LHRTEST TABLEUSERS35,651,58449
SYSIDL_UB2$ TABLESYSTEM32,505,85646
MDSYSSYS_LOB0000064008C00006$$ LOBSEGMENTSYSAUX27,262,97641
SYSC_TOID_VERSION# CLUSTERSYSTEM25,165,82439
SYSTEST1 TABLESYSTEM17,825,79232
SYSSYS_LOB0000065858C00004$$ LOBSEGMENTSYSAUX16,908,28817
SYSARGUMENT$ TABLESYSTEM12,582,91227
     ------------------------------------------------
Total    559,218,688488

 

OwnerSegment NameSegment TypeOBJECT_SIZE_M
SYSIDL_UB1$TABLE248
SHCOSTSTABLE PARTITION128
SHSALESTABLE PARTITION128
SYSSOURCE$TABLE72
XDBSYS_LOB0000057465C00025$$LOBSEGMENT53
LHRTESTTABLE34
SYSIDL_UB2$TABLE31
MDSYSSYS_LOB0000064008C00006$$LOBSEGMENT26
SYSC_TOID_VERSION#CLUSTER24
SYSTEST1TABLE17
   -------------
Total  761

 

[回到目录]



扩展最多的10个段

 

OwnerSegment NamePartition NameSegment TypeTablespace NameExtentsSize (in bytes)
SYSIDL_UB1$ TABLESYSTEM102260,046,848
SYSSOURCE$ TABLESYSTEM8075,497,472
XDBSYS_LOB0000057465C00025$$ LOBSEGMENTSYSAUX5555,771,136
LHRTEST TABLEUSERS4935,651,584
SYSIDL_UB2$ TABLESYSTEM4632,505,856
MDSYSSYS_LOB0000064008C00006$$ LOBSEGMENTSYSAUX4127,262,976
SYSC_TOID_VERSION# CLUSTERSYSTEM3925,165,824
SYSTEST1 TABLESYSTEM3217,825,792
SYSARGUMENT$ TABLESYSTEM2712,582,912
SHCUSTOMERS TABLEEXAMPLE2712,582,912
     ------------------------------------------------
Total    498554,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
SHSALES28
SHCOSTS28
SYSWRH$_ACTIVE_SESSION_HISTORY2
SYSTEMLOGMNR_LOBFRAG$2
SYSTEMLOGMNR_OPQTYPE$2
SYSWRH$_WAITSTAT2
SYSTEMLOGMNRC_GTCS2
SYSTEMLOGMNRP_CTAS_PART_MAP2
SYSTEMLOGMNR_ATTRCOL$2
SYSTEMLOGMNR_DICTSTATE$2

 

[回到目录]



分区个数超过100个的表

 

[回到目录]



无效对象

 



无效的对象

 

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

 

[回到目录]



无效的普通索引

 

[回到目录]



无效的分区索引



无效的触发器

 

OWNERTRIGGER_NAMETABLE_NAMESTATUS
HRSECURE_EMPLOYEESEMPLOYEESDISABLED

 

[回到目录]



索引情况

 



索引个数超过5个的表

 

OWNERTABLE_NAMECNT
PMONLINE_MEDIA11
OEPURCHASEORDER10
PMPRINT_MEDIA8
OECUSTOMERS7
HREMPLOYEES6
OEWAREHOUSES5
FLOWS_FILESWWV_FLOW_FILE_OBJECTS$5
SHSALES5

 

[回到目录]



大表未建索引


● 大于2G大表未建索引



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

 

[回到目录]



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

 

TABLE_OWNERTABLE_NAMECROSS_IDX_RATE
FLOWS_FILESWWV_FLOW_FILE_OBJECTS$.8
HRJOB_HISTORY.8
OEINVENTORIES.66
IXAQ$_STREAMS_QUEUE_TABLE_C.66
OEORDER_ITEMS.5

 

[回到目录]



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

 

TABLE_OWNERTABLE_NAMEINDEX_NAMECOUNT(*)
IXAQ$_STREAMS_QUEUE_TABLE_ISYS_IOT_TOP_762629
IXAQ$_ORDERS_QUEUETABLE_ISYS_IOT_TOP_762568
SHDR$SUP_TEXT_IDX$IDR$SUP_TEXT_IDX$X5
IXAQ$_STREAMS_QUEUE_TABLE_GSYS_IOT_TOP_762664
IXAQ$_STREAMS_QUEUE_TABLE_HSYS_IOT_TOP_762584
IXAQ$_ORDERS_QUEUETABLE_GSYS_IOT_TOP_762534
IXAQ$_ORDERS_QUEUETABLE_HSYS_IOT_TOP_762514

 

[回到目录]



位图索引和函数索引

 

OWNERTABLE_NAMEINDEX_NAMEINDEX_TYPESTATUSBLEVELLEAF_BLOCKS
OECUSTOMERSCUST_UPPER_NAME_IXFUNCTION-BASED NORMALVALID12
SHCOSTSCOSTS_PROD_BIXBITMAPN/A125
SHCUSTOMERSCUSTOMERS_GENDER_BIXBITMAPVALID13
SHCUSTOMERSCUSTOMERS_MARITAL_BIXBITMAPVALID15
SHCUSTOMERSCUSTOMERS_YOB_BIXBITMAPVALID119
SHFWEEK_PSCAT_SALES_MVFW_PSC_S_MV_SUBCAT_BIXBITMAPVALID13
SHFWEEK_PSCAT_SALES_MVFW_PSC_S_MV_CHAN_BIXBITMAPVALID01
SHFWEEK_PSCAT_SALES_MVFW_PSC_S_MV_PROMO_BIXBITMAPVALID01
SHFWEEK_PSCAT_SALES_MVFW_PSC_S_MV_WD_BIXBITMAPVALID14
SHPRODUCTSPRODUCTS_PROD_STATUS_BIXBITMAPVALID01
SHSALESSALES_PROD_BIXBITMAPN/A132
SHSALESSALES_CHANNEL_BIXBITMAPN/A147
SHSALESSALES_TIME_BIXBITMAPN/A157
SHSALESSALES_PROMO_BIXBITMAPN/A130
SHSALESSALES_CUST_BIXBITMAPN/A1452
SHCOSTSCOSTS_TIME_BIXBITMAPN/A134

 

[回到目录]



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

 

OWNERTABLE_NAMECONSTRAINT_NAMECOLUMNS
SHCUSTOMERSCUSTOMERS_COUNTRY_FKCOUNTRY_ID
SHCOSTSCOSTS_CHANNEL_FKCHANNEL_ID
SCOTTEMPFK_DEPTNODEPTNO
HRCOUNTRIESCOUNTR_REG_FKREGION_ID
HRLOCATIONSLOC_C_ID_FKPRODUCT_ID
SHCOSTSCOSTS_PROMO_FKPROMO_ID
HRDEPARTMENTSDEPT_MGR_FKMANAGER_ID
PMONLINE_MEDIALOC_C_ID_FKPRODUCT_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_DIRSHREAD

NO

DATA_PUMP_DIREXP_FULL_DATABASEREAD

NO

  WRITE

NO

 IMP_FULL_DATABASEREAD

NO

  WRITE

NO

DIR_ALERT_CHECKHELTH_LHR_1LHRREAD

YES

  WRITE

YES

LOG_FILE_DIRSHREAD

NO

  WRITE

NO

MEDIA_DIRPMREAD

NO

ORACLE_OCM_CONFIG_DIRORACLE_OCMREAD

NO

  WRITE

NO

SS_OE_XMLDIROEREAD

YES

  WRITE

YES

SUBDIROEREAD

YES

  WRITE

YES

 

[回到目录]



回收站情况


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

 

Owneroriginal_nameObject 
Type		object_nameTablespaceOperationcreatetimedroptimeCan 
Undrop?		Can 
Purge?		Bytes

LHR

TESTDGTABLEBIN$HfsE79K3Nl/gU4I7qMC29w==$0USERSDROP

2015-07-27:14:07:32

2015-08-23:20:55:45

YES

YES

65,536

 

[回到目录]


● 回收站中对象的大小

 

OwnerSUM(RECYB_SIZE_M)SUM(RECYB_CNT)
LHR.06251
合计.06251

 

[回到目录]



数据库链路

 

[回到目录]



外部表

 

OWNERTABLE_NAMETYPTYPE_NAMEDEFDEFAULT_DIRECTORY_NAMEREJECT_LIMITACCESS_ACCESS_PARAMETERSPROPERTY
SHSALES_TRANSACTIONS_EXTSYSORACLE_LOADERSYSDATA_FILE_DIR100CLOBRECORDS 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
LHRT_ALERT_CHECKHELTH_LHR_1SYSORACLE_LOADERSYSDIR_ALERT_CHECKHELTH_LHR_1UNLIMITEDCLOBrecords delimited by newline 　　ALL

 

[回到目录]



告警日志


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

 

INSTANCERNTEXT
instance1992NSA2 started with pid=25
instance1993Wed Aug 26 15:24:25 2015
instance1994NSA3 started with pid=26
instance1995Wed Aug 26 15:24:25 2015
instance1996NSA4 started with pid=27
instance1998Error 1034 received logging on to the standby
instance1999PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradglg'. Error is 1034.
instance11000Error 1034 received logging on to the standby
instance11001FAL[server
instance11002FAL[server
instance11003ARCH: FAL archive failed. Archiver continuing
instance11004ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance11005Error 1034 received logging on to the standby
instance11006PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradgphy'. Error is 1034.
instance11007Error 1034 received logging on to the standby
instance11008FAL[server
instance11009FAL[server
instance11010ARCH: FAL archive failed. Archiver continuing
instance11011ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance11012[58778] Successfully onlined Undo Tablespace 2.
instance11013Undo initialization finished serial:0 start:52945694 end:52946474 diff:780 (7 seconds)
instance11014Verifying file header compatibility for 11g tablespace encryption..
instance11015Verifying 11g file header compatibility for tablespace encryption completed
instance11016SMON: enabling tx recovery
instance11017Database Characterset is ZHS16GBK
instance11018No Resource Manager plan active
instance11019replication_dependency_tracking turned off (no async multimaster replication found)
instance11020Starting background process QMNC
instance11021Wed Aug 26 15:24:27 2015
instance11022QMNC started with pid=28
instance11023Error 1034 received logging on to the standby
instance11024FAL[server
instance11025FAL[server
instance11026ARCH: FAL archive failed. Archiver continuing
instance11027ORACLE Instance oradg11g - Archival Error. Archiver continuing.
instance11028Wed Aug 26 15:24:28 2015
instance11031Completed: ALTER DATABASE OPEN
instance11033Wed Aug 26 15:24:29 2015
instance11034Starting background process CJQ0
instance11035Wed Aug 26 15:24:29 2015
instance11036db_recovery_file_dest_size of 4122 MB is 3.37% used. This is a
instance11037user-specified limit on the amount of space that will be used by this
instance11038database for recovery-related files
instance11039space available in the underlying filesystem or ASM diskgroup.
instance11040Wed Aug 26 15:24:29 2015
instance11041CJQ0 started with pid=33
instance11042Wed Aug 26 15:28:56 2015
instance11045Wed Aug 26 15:28:56 2015
instance11047Wed Aug 26 15:29:26 2015
instance11050Wed Aug 26 15:29:26 2015
instance11051ARC2: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_2
instance11052Wed Aug 26 15:29:26 2015
instance11054Wed Aug 26 15:29:26 2015
instance11055******************************************************************
instance11056LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
instance11057******************************************************************
instance11058LNS: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_2
instance11059Wed Aug 26 15:29:27 2015
instance11060Starting background process SMCO
instance11061Wed Aug 26 15:29:29 2015
instance11062SMCO started with pid=29
instance11063ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_3
instance11064Wed Aug 26 15:29:35 2015
instance11065ARC0: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_2
instance11066Wed Aug 26 15:29:39 2015
instance11067ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_4
instance11068Wed Aug 26 15:30:23 2015
instance11069Time drift detected. Please check VKTM trace file for more details.
instance11070Wed Aug 26 15:30:42 2015
instance11071ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_4
instance11072ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_3
instance11073Wed Aug 26 15:54:33 2015
instance11076Wed Aug 26 15:54:33 2015
instance11077******************************************************************
instance11078LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_3
instance11079******************************************************************
instance11080Wed Aug 26 15:54:33 2015
instance11081******************************************************************
instance11082LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_4
instance11083******************************************************************
instance11084Wed Aug 26 15:54:33 2015
instance11085LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_2
instance11086Wed Aug 26 15:54:34 2015
instance11088LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_4
instance11089LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_3
instance11090Wed Aug 26 15:54:36 2015
instance11091ARC0: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_3
instance11092ARC3: 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
instance1334ORA-03135: connection lost contact
instance1368ORA-03135: connection lost contact
instance1430ORA-03135: connection lost contact
instance1450ORA-03135: connection lost contact
instance1470ORA-03135: connection lost contact
instance1515ORA-03135: connection lost contact
instance1552ORA-03135: connection lost contact
instance1564ORA-16439: Standby not ready to receive redo at this time
instance1738ORA-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_FILESWWV_BIU_FLOW_FILE_OBJECTSWWV_FLOW_FILE_OBJECTS$ENABLED
HRSECURE_EMPLOYEESEMPLOYEESDISABLED
HRUPDATE_JOB_HISTORYEMPLOYEESENABLED
OEINSERT_ORD_LINEORDER_ITEMSENABLED
OEPURCHASEORDER$xdPURCHASEORDERENABLED
OEORDERS_ITEMS_TRGOC_ORDERSENABLED
OEORDERS_TRGOC_ORDERSENABLED

 

[回到目录]



序列cache小于20


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

SEQUENCE_OWNERSEQUENCE_NAMECACHE_SIZEALTER_SEQUENCE
DBSNMPMGMT_RESPONSE_SNAPSHOT_ID20alter sequence DBSNMP.MGMT_RESPONSE_SNAPSHOT_ID cache 1000;
DBSNMPMGMT_RESPONSE_CAPTURE_ID20alter sequence DBSNMP.MGMT_RESPONSE_CAPTURE_ID cache 1000;
XDBCLIENTID_SEQUENCE10alter sequence XDB.CLIENTID_SEQUENCE cache 1000;
XDBSTATEID_RESTART_SEQUENCE20alter sequence XDB.STATEID_RESTART_SEQUENCE cache 1000;
XDBXDB$TYPEID_SEQ20alter sequence XDB.XDB$TYPEID_SEQ cache 1000;
XDBXDB$NAMESUFF_SEQ20alter sequence XDB.XDB$NAMESUFF_SEQ cache 1000;
XDBXDB$PROPNUM_SEQ20alter sequence XDB.XDB$PROPNUM_SEQ cache 1000;
ORDDATAORDDCM_CT_PRED_SET_SEQ0alter sequence ORDDATA.ORDDCM_CT_PRED_SET_SEQ cache 1000;
ORDDATAORDDCM_CT_PRED_SEQ0alter sequence ORDDATA.ORDDCM_CT_PRED_SEQ cache 1000;
ORDDATAORDDCM_DATA_MODEL_SEQ0alter sequence ORDDATA.ORDDCM_DATA_MODEL_SEQ cache 1000;
ORDDATAORDDCM_UID_DEFS_UDID_SEQ0alter sequence ORDDATA.ORDDCM_UID_DEFS_UDID_SEQ cache 1000;
ORDDATAORDDCM_RT_PREF_P_PPID_SEQ0alter sequence ORDDATA.ORDDCM_RT_PREF_P_PPID_SEQ cache 1000;
ORDDATAORDDCM_ANON_ATTRS_SEQ0alter sequence ORDDATA.ORDDCM_ANON_ATTRS_SEQ cache 1000;
ORDDATAORDDCM_MPD_P_MPID_SEQ0alter sequence ORDDATA.ORDDCM_MPD_P_MPID_SEQ cache 1000;
ORDDATAORDDCM_DICT_A_DA_ID_SEQ0alter sequence ORDDATA.ORDDCM_DICT_A_DA_ID_SEQ cache 1000;
ORDDATAORDDCM_PRV_A_PA_ID_SEQ0alter sequence ORDDATA.ORDDCM_PRV_A_PA_ID_SEQ cache 1000;
ORDDATAORDDCM_STD_A_SA_ID_SEQ0alter sequence ORDDATA.ORDDCM_STD_A_SA_ID_SEQ cache 1000;
ORDDATAORDDCM_DOCS_ID_SEQ0alter sequence ORDDATA.ORDDCM_DOCS_ID_SEQ cache 1000;
ORDDATAORDDCM_STOREDTAGS_STID_SEQ0alter sequence ORDDATA.ORDDCM_STOREDTAGS_STID_SEQ cache 1000;
APEX_030200WWV_FLOW_WORKSHEET_SEQ20alter sequence APEX_030200.WWV_FLOW_WORKSHEET_SEQ cache 1000;
APEX_030200WWV_FLOW_VERSION_SEQ20alter sequence APEX_030200.WWV_FLOW_VERSION_SEQ cache 1000;
APEX_030200WWV_FLOW_SESSION_SEQ20alter sequence APEX_030200.WWV_FLOW_SESSION_SEQ cache 1000;
APEX_030200WWV_SEQ20alter sequence APEX_030200.WWV_SEQ cache 1000;
HREMPLOYEES_SEQ0alter sequence HR.EMPLOYEES_SEQ cache 1000;
HRDEPARTMENTS_SEQ0alter sequence HR.DEPARTMENTS_SEQ cache 1000;
HRLOCATIONS_SEQ0alter sequence HR.LOCATIONS_SEQ cache 1000;
OEORDERS_SEQ0alter sequence OE.ORDERS_SEQ cache 1000;
IXAQ$_STREAMS_QUEUE_TABLE_N20alter sequence IX.AQ$_STREAMS_QUEUE_TABLE_N cache 1000;
IXAQ$_ORDERS_QUEUETABLE_N20alter sequence IX.AQ$_ORDERS_QUEUETABLE_N cache 1000;

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

[回到目录]



并行度

 



表带有并行度

 

OWNERTABLE_NAMEDEGREE
LHRT_ALERT_CHECKHELTH_LHR_18

 

[回到目录]



索引带有并行度

 

[回到目录]


数据库性能分析

 



AWR

 



AWR统计

 

实例 
名称		统计时间内存读(MB)磁盘读(MB)磁盘写(KB)日志量(KB)硬分析(个)分析(个)事务数CPU(秒)

1

2015-08-26 15:34:4200-1-100029
 2015-08-25 09:18:07001000012
 2015-08-24 00:01:0600110106
 2015-08-23 23:00:2600310005
 2015-08-23 22:00:4900110006
 2015-08-23 21:01:0700210007
 2015-08-23 20:00:2700210007
 2015-08-23 19:00:48104301032

 

[回到目录]



AWR参数配置状况

 

Database IDDatabase NameSnap IntervalRetention PeriodTop N SQL

1403587593

ORADG11G+00000 01:00:00.0+00008 00:00:00.0DEFAULT

 

[回到目录]



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-252015-08-24 00:01~2015-08-25 09:18111~11209:182015-08-23 17:35:191997.022.9933~321.09~.9652713324439.93304701.292179251.821259.6845023.38260.2535977.3207.966871.0639.722056.0211.881730
2015-08-242015-08-23 23:00~2015-08-24 00:01110~11100:012015-08-23 17:35:1960.67.0434~33.94~1.092074312569.8762857.944527212.441371.882039.5661.79110383.03334.481850.5156.06465.1314.0933.01
2015-08-232015-08-23 22:00~2015-08-23 23:00109~11023:002015-08-23 17:35:1959.62.0235~341.08~.942075428580.21610424388812.271290.821858.5254.6587092.43256.151265.3537.21430.1212.6534.01
2015-08-232015-08-23 21:01~2015-08-23 22:00108~10922:002015-08-23 17:35:1959.7.0831~351.19~1.082208704616.6166930.42338749.461026.481755.4953.1875852.12229.851177.3335.67379.1111.4833.01
2015-08-232015-08-23 20:00~2015-08-23 21:01107~10821:012015-08-23 17:35:1960.67.0637~311.05~1.193626028996.1695421.794548512.51196.972290.6360.2693502.57246.051382.3836.37447.1211.7638.01
2015-08-232015-08-23 19:00~2015-08-23 20:00106~10720:002015-08-23 17:35:1959.65.0538~371.13~1.052684040749.9476686.864980413.921422.973119.8789.11109483.06312.81568.4444.8528.1515.0935.01
2015-08-232015-08-23 17:46~2015-08-23 19:00105~10619:002015-08-23 17:35:1974.28.1433~381.33~1.13123634322773.94475516.6233047774.1512710.655148311.551980.12276286.21062.623689.83141.881288.2949.5426.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 collectionENABLED
auto space advisorENABLED
sql tuning advisorENABLED

 

WINDOW_NAMEWINDOW_NEXT_TIMEWINDOAUTOTASKOPTIMIZESEGMENT_SQL_TUNEHEALTH_M
MONDAY_WINDOW2015-08-31 22:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
TUESDAY_WINDOW2015-09-01 22:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
WEDNESDAY_WINDOW2015-08-26 22:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
THURSDAY_WINDOW2015-08-27 22:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
FRIDAY_WINDOW2015-08-28 22:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
SATURDAY_WINDOW2015-08-29 06:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED
SUNDAY_WINDOW2015-08-30 06:00:00FALSEENABLEDENABLEDENABLEDENABLEDDISABLED

 

[回到目录]



未收集或很久未收集的表



被收集统计信息的临时表

 

[回到目录]



会话

 



会话概况

 

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

4130

 

[回到目录]



登录时间最长的10个会话

 

INST_IDSIDSERIAL#SPIDPROGRAMSTATUSSQL_IDPREV_SQL_IDEVENTWAIT_CLASSLOGON_TIMETOTAL_H
1125558778sqlplus@rhel6_lhr (TNS V1-V3)INACTIVE gg5409ku2xk00SQL*Net message from clientIdle2015-08-26 15:24:23.71
1201159791plsqldev.exeINACTIVE 3nz260v5dwqnvSQL*Net message from clientIdle2015-08-26 15:32:23.57
11461159795plsqldev.exeINACTIVE 9m7787camwh4mSQL*Net message from clientIdle2015-08-26 15:32:25.57
1251159949sqlplus.exeINACTIVE ab6c4m41phxmfSQL*Net message from clientIdle2015-08-26 15:35:18.53
115413361557sqlplus.exeACTIVEf683w8x4kggjj9babjv8yq8ru3SQL*Net message to clientNetwork2015-08-26 16:05:39.02

 

[回到目录]



超过10小时无响应的会话

 

[回到目录]



提交次数最多的会话

 

[回到目录]



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

 

INST_IDUSERNAMEEVENTSECONDSSQL_IDSQLTEXTSIDSERIAL#MACHINEPROGRAMOSUSER
1LHRCpu + Wait For Cpu1fq128d6s13bx8SELECT '

' || l.owner || '

'		     
1LHRCpu + Wait For Cpu196ub5w77tu2acSELECT column_name,data_type_owner,data_type FROM dba_tab_columns where owner=:o and table_name=:t     
1LHRCpu + Wait For Cpu1duwq6t6ck11baselect * from (select owner, segment_name, segment_type,     
1LHRCpu + Wait For Cpu13nd96vy0fb1svSELECT j.instance_id, j.JOB_CREATOR, j.OWNER, j.job_name, j.state job_ST     
1SYSCpu + Wait For Cpu13c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1),     
1LHRCpu + Wait For Cpu12bmgd7b5y2x6tselect owner,table_name, count(*) cnt from dba_indexes where owner not in ('XDB',     
1LHRCpu + Wait For Cpu1cm4vhpunwknmzSELECT al.thread#, ads.dest_id, ads.DEST_NAME, (SELECT ads.TYPE || ' ' || ad.TA     

 

[回到目录]



锁

 



查看LOCK锁情况

 

INST_IDOS_USER_NAMEUSER_NAMELOCK_TYPEOBJECTLOCK_MODEOWNERSIDSERIAL_NUMID1ID2
1AdministratorLHR SDO_GEOR_DDL__TABLE$$Row ExclusiveMDSYS154133680641

 

[回到目录]



查看谁锁住了谁

 

[回到目录]



游标使用情况

 

[回到目录]



并行进程完成情况

 

[回到目录]



内存占用

 



查询共享内存占有率

 

COUNT(*)ROUND(SUM(SHARABLE_MEM)/1024/1024,2)
546741.34

 

[回到目录]



PGA占用最多的进程

 

INST_IDSPIDPIDSIDSERIAL#STATUSPGA_ALLOC_MEMUSERNAMEOSUSERPROGRAMSQL_ID
158780211353ACTIVE65055208 oracleoracle@rhel6_lhr (ARC0) 
15879024111ACTIVE58894824 oracleoracle@rhel6_lhr (ARC3) 
158788231363ACTIVE31361304 oracleoracle@rhel6_lhr (ARC2) 
158798251381ACTIVE29862376 oracleoracle@rhel6_lhr (NSA2) 
158802271391ACTIVE29862376 oracleoracle@rhel6_lhr (NSA4) 
15880026131ACTIVE29862376 oracleoracle@rhel6_lhr (NSA3) 
15878622101ACTIVE29534696 oracleoracle@rhel6_lhr (ARC1) 
158756111301ACTIVE12085064 oracleoracle@rhel6_lhr (LGWR) 
16155731154133ACTIVE4426040LHRAdministratorsqlplus.exe96rxbcbf0rw1x
1587541051ACTIVE4147048 oracleoracle@rhel6_lhr (DBW0) 
159949302511INACTIVE2787640LHRAdministratorsqlplus.exe 
1597955114611INACTIVE2573976LHRAdministratorplsqldev.exe 
158764151321ACTIVE2320200 oracleoracle@rhel6_lhr (MMON) 
158778191255INACTIVE2214552SYSoraclesqlplus@rhel6_lhr (TNS V1-V3) 
158760131311ACTIVE1935672 oracleoracle@rhel6_lhr (SMON) 
1588633313311ACTIVE1878504 oracleoracle@rhel6_lhr (CJQ0) 
159791502011INACTIVE1607992LHRAdministratorplsqldev.exe 
158750841ACTIVE1468232 oracleoracle@rhel6_lhr (DIA0) 
158906371445ACTIVE1345848 oracleoracle@rhel6_lhr (Q000) 
1587621471ACTIVE1149240 oracleoracle@rhel6_lhr (RECO) 

 

[回到目录]



buffer cache 命中率

 

PHYSICAL_READSDB_BLOCK_GETSCONSISTENT_GETSHit Ratio
588151452895145493.91%

 

[回到目录]



● librarycache 整体命中率

 

GETSGETHITSHit RatioPINSPINHITSHit Ratio
318032147367.52777426513983.79

 

[回到目录]



● librarycache 各namaspace 的命中率

 

NAMESPACEGETSGETHITSHit RatioPINSPINHITSHit Ratio
ACCOUNT_STATUS121191.67000
BODY24617269.921540145494.42
CLUSTER72271198.4875774698.55
DBINSTANCE100000
DBLINK161593.75000
DIRECTORY666496.97807492.5
EDITION373697.3524994.23
INDEX7456.767456.76
JAVA DATA200200
JAVA RESOURCE200200
JAVA SOURCE200200
OBJECT ID7000000
QUEUE42506233.33
RULESET1003266.67
SCHEMA5367534899.65000
SQL AREA6440316349.11479134227688.23
SQL AREA BUILD18521206.48000
SQL AREA STATS1825774.221825774.22
TABLE/PROCEDURE149991171378.09254332042980.32
TRIGGER754357.33754357.33

 

[回到目录]



● latch 的命中率

 

SUM(GETS)SUM(MISSES)ROUND(1-SUM(MISSES)/SUM(GETS),4)
57493731838.9997

 

[回到目录]



等待事件

 



等待事件


● 等待事件（当前）

 

INST_IDWAIT_CLASS#WAIT_CLASSEVENTCOUNTS
17NetworkSQL*Net message to client1

 

[回到目录]



● 等待事件（历史汇集）

 

INST_IDEVENTWAIT_CLASSTOTAL_WAITS
1direct path readUser I/O62530
1db file sequential readUser I/O36954
1control file sequential readSystem I/O16622
1SQL*Net message to clientNetwork6108
1LNS wait on SENDREQNetwork4072
1db file scattered readUser I/O3019
1log file parallel writeSystem I/O2906
1control file parallel writeSystem I/O2790
1ADR block file writeOther637
1ADR file lockOther590
1Disk file operations I/OUser I/O577
1ADR block file readOther397
1asynch descriptor resizeOther368
1db file async I/O submitSystem I/O239
1db file parallel readUser I/O221
1external table writeUser I/O176
1log file sequential readSystem I/O147
1PX Deq: Slave Session StatsOther128
1os thread startupConcurrency102
1flashback log file readSystem I/O88
1direct path write tempUser I/O87
1Parameter File I/OUser I/O84
1LGWR wait for redo copyOther70
1Log archive I/OSystem I/O69
1ARCH wait on SENDREQNetwork66
1PX Deq: Signal ACK RSGOther64
1PX Deq: Signal ACK EXTOther64
1flashback log file writeSystem I/O62
1latch: shared poolConcurrency59
1direct path read tempUser I/O54
1SQL*Net more data to clientNetwork38
1SQL*Net break/reset to clientApplication32
1db file single writeUser I/O30
1direct path writeUser I/O30
1latch freeOther28
1ARCH wait for archivelog lockOther28
1flashback log file syncUser I/O26
1external table openUser I/O24
1log file syncCommit22
1ARCH wait on ATTACHNetwork21
1enq: CF - contentionOther18
1ARCH wait on DETACHNetwork17
1rdbms ipc replyOther17
1library cache: mutex XConcurrency16
1log file single writeSystem I/O14
1library cache load lockConcurrency14
1CSS operation: queryOther12
1latch: enqueue hash chainsOther10
1external table readUser I/O8
1external table seekUser I/O8

 

[回到目录]

 

 

数据库巡检服务报告结束

 

 

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

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

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 于唐镇金唐公寓宿舍

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