我的oracle 健康检查报告

最新推荐文章于 2024-05-11 02:49:42 发布
最新推荐文章于 2024-05-11 02:49:42 发布
阅读量4w 收藏 2
点赞数
文章标签： oracle 数据库 sql ssh 运维
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lihuarongaini/article/details/127960754
版权


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

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

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

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

AiDBA宝典
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
HTMLTestRunner
weixin_30346033的博客
11-29 3万+
1 #-*- coding: utf-8 -*- 2 """ 3 A TestRunner for use with the Python unit testing framework. It 4 generates a HTML report to show the result at a glance. 5 6 The simplest wa...
中文汉字码表
weixin_38871988的博客
09-08 6万+
[PAD] [unused1] [unused2] [unused3] [unused4] [unused5] [unused6] [unused7] [unused8] [unused9] [unused10] [unused11] [unused12] [unused13] [unused14] [unused15] [unused16] [unused17] [unused18] [unused19] [unused20] [unused21] [unused22] [unused23] [unuse
【加量不加价，提供只读脚本】小麦苗健康检查脚本说明（Oracle巡检脚本）
coco3600的博客
12-04 234
小麦苗健康检查脚本说明 第一章 小麦苗健康检查脚本特点 ...
西瓜视频稳定性治理体系建设三：Sliver 原理及实践
最新发布
2401_84010326的博客
05-11 762
开发是面向对象。我们找工作应该更多是面向面试。哪怕进大厂真的只是去宁螺丝，但你要进去得先学会面试的时候造飞机不是么？作者13年java转Android开发，在小厂待过，也去过华为，OPPO等，去年四月份进了阿里一直到现在。等大厂待过也面试过很多人。深知大多数初中级Android工程师，想要提升技能，往往是自己摸索成长，不成体系的学习效果低效漫长且无助。这里附上上述的技术体系图相关的几十套腾讯、头条、阿里、美团等公司的面试题，把技术点整理成了视频和PDF（实际上比预期多花了不少精力），包含。
小白看完都学会了！Android---性能优化方案分享
m0_56144365的博客
06-12 247
前言 性能优化的过程分两部分： 发现性能瓶颈 制定方案，解决性能问题 解决性能问题的方案需要具体情况具体分析，并没有完全固定的路子，更多的是靠经验的积累，本文不做涉及。但是发现性能瓶颈确实有着固定的方法。本文主要介绍 如何找到性能瓶颈 。 如何找到性能瓶颈 常用的性能检测工具是traceview，集成于 Android Device Monitor 中。从Android Studio3.0开始， Android Device Monitor 被废弃，取而代之的是 Android Profiler ，其中
Android 平台下的 Method Trace 实现解析
1
06-10 745
对于开发者来说，Android的Java 层 提供了两种开发者可直接调用的 Method Trace 的API，一是 android.os.Debug类中的 startMethodTracing相关API，第二个 是android.os.Trace 类中的beginSection相关AP。 这两者的区别是 Debug类只能监控 Java函数调用， 而Trace类底层是使用 atrace 实现，其追踪的函数会包含了应用及系统的Java 和Native函数，并且底层基于ftrace还可以追踪cpu的详细活动信息
ORACLE系统健康检查脚本
05-12
3、检查报告包括服务器和LINUX系统的硬件信息和操作系统信息； 4、Database Patches报告； 5、Database Network Service信息； 6、Oracle Database Details 信息； 7、DB Alert log and Trace files 告警和追踪信息...
Oracle数据库健康检查报告
04-01
Oracle数据库健康检查报告是针对企业运行中的Oracle数据库系统进行的一项全面检查服务，旨在发现并解决潜在问题，确保数据库系统的稳定性和高效性。这份报告通常包括多个方面，如系统配置、性能指标、安全性、备份...
ORACLE 健康检查与性能分析报告
04-12
ORACLE 健康检查与性能分析报告,内容包括: 1: 报告综述..........................................................................................................3 1.1 目的说明................................
Oracle数据库RAC健康检查脚本
07-03
Oracle数据库RAC（Real Application Clusters）健康检查脚本是一种重要的工具，用于DBA（数据库管理员）对数据库系统进行全面的性能监控和问题排查。RAC是Oracle数据库的一个关键特性，它允许多个实例同时访问同一...
oracle 健康检查
02-05
进行Oracle健康检查时，通常使用Oracle自带的工具如`sqlplus`、`企业管理器`（EM）、`性能监视工具`（PMON）、`系统诊断工具`（SDU）等，以及第三方工具，如`Toad`、`OEM`等。通过收集和分析日志、性能视图数据，...
oracle 整库同步报错
gs80140的专栏
09-25 1677
报错1 ORA-39083: Object type TABLESPACE failed to create with error: ORA-02236: invalid file name Failing sql is: CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 26214400,SIZE 524288000 AUTOEXTEND ON ...
如何查看数据库中的job任务
weixin_33795833的博客
04-15 3630
在数据库的日常维护中会使用job来定期完成某些任务如何查看已经定义的job呢我们可以通过如下语句SQL> col interval format a10 SQL> col log_user format a10 SQL> col segment_user format a10 SQL> col what format a40 SQL...
UFT\QTP 12 新特性
软件质量优化
03-27 1万+
原文:http://www.learnqtp.com/uft-12-new-features-in-detail/UFT 12 was launched on March 20, 2014. This new version of UFT comes with a lot of new features and integrates all features that were incorpora
awrrpt.sqll生成awr报ORA-06502,ORA-06512
weixin_34364071的博客
03-06 439
客户环境SumOS操作系统，数据库版本11.2.0.3，rac两节点； 在节点2，执行awr报告，输出报错，有时候可以成功，有时候失败。 报错现象 SQL>@?/rdbms/admin/awrrpt.sql ORA-6502: PL/SQL: numeric or value error: character string buffer too small ORA-651...
MYSQL— perror 错误码详情
热门推荐
道行尚浅（老道）的博客
12-04 11万+
[root@localhost ~]# cat test_nothread.py import paramiko import threading import os def ssh2(ip,username,passwd,cmd): file_path='/root/perror.log' logfile=file(file_path,'a') try:
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

AiDBA宝典

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值