我的oracle 健康检查报告
最近一直想用sql来生成oracle的健康检查报告,这样看起来一目了然,经过网上搜资料加自己整理终于算是成型了,部分结果如下图所示, 具体参考附件,恳请广大网友看看是否还有需要添加的地方。 DB_healthcheck_by_lhr_ORADG11G_20150826160539.zip
ORADG11G 数据库巡检报告
Copyright (c) 2015-2100 (http://blog.itpub.net/26736162) lhrbest. All rights reserved.
巡检时间:2015-08-26 16:05:39
巡检人:lhr
巡检服务概要 | |||||
---|---|---|---|---|---|
数据库总体概况 | 数据库基本信息 | 所有的初始化参数 | 关键的初始化参数 | 数据库大小 | 资源使用情况 |
表空间情况 | 表空间状况信息 | 闪回空间使用情况 | 临时表空间使用情况 | undo表空间使用情况 | 表空间扩展状况 |
数据文件状况 | 表空间扩展状况 | 表空间所有者 | |||
JOB情况 | 作业运行状况 |
数据库安全 | |||||
---|---|---|---|---|---|
数据库用户 | 数据库用户一览 | 拥有DBA角色的用户 | 拥有SYS角色的用户 | 角色概况 | 密码为系统默认值的用户 |
整个用户有多大 | |||||
系统表空间用户 | 系统表空间作为缺省表空间的用户 | 系统表空间作为临时表空间的用户 | 系统表空间上的对象 |
巡检报告文件名称 | DB_healthcheck_by_lhr_ORADG11G_20150826160539.html |
---|---|
巡检时间 | 2015-08-26 (Wednesday) 16:05:39 PM 时区 +08:00 |
数据库服务器名称 | rhel6_lhr |
数据库服务器IP地址 | 192.168.59.130 |
数据库名称 | ORADG11G |
数据库ID(DBID) | 1403587593 |
数据库全局名 | ORADG11G |
操作系统信息 | Linux x86 64-bit / 13 |
是否RAC集群模式? | FALSE |
RAC实例数目 | 1 |
数据库创建时间 | 2015-04-03 15:59:05 |
实例启动时间 | 实例1:2015-08-26 15:24:16 |
数据库归档模式 | ARCHIVELOG |
数据库字符集 | ZHS16GBK |
数据库系统版本信息 |
---|
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
PL/SQL Release 11.2.0.3.0 - Production |
CORE 11.2.0.3.0 Production |
TNS for Linux: Version 11.2.0.3.0 - Production |
NLSRTL Version 11.2.0.3.0 - Production |
数据库实例名称 | 数据库实例号 | 线程号 | 主机名 | 数据库版本 | 实例启动时间 | 运行时间(天) | RAC模式 | 实例状态 | 是否可登录 | 是否可归档 |
---|---|---|---|---|---|---|---|---|---|---|
oradg11g
|
1
|
1
|
rhel6_lhr
|
11.2.0.3.0
|
2015-08-26 15:24:16
|
.03 |
NO
|
OPEN
|
ALLOWED
|
STARTED
|
INST_ID | 数据库名 | 数据库ID | 数据库 Unique Name | 创建时间 | 平台名称 | 当前SCN | 日志模式 | 打开模式 | 是否强制日志 | 是否Flashback? | 控制文件类型 | Last Open Incarnation Num | DATABASE_ROLE | SUPPLEME | SUP |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |
ORADG11G
|
1403587593
|
oradg11g
|
2015-04-03 15:59:05
|
Linux x86 64-bit
|
2282303
|
ARCHIVELOG
|
READ WRITE
|
YES
|
YES
|
CURRENT
|
4
|
PRIMARY | IMPLICIT | YES |
SNAP_ID | DB_NAME | DBID | INSTANCE_NAME | INSTANCE_NUMBER | STARTUP_TIME | RELEASE | RAC | HOST_NAME | PLATFORM_NAME | CPUS | CORES | SOCKETS | Memory (GB) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113 | ORADG11G | 1403587593 | oradg11g | 1 | 26-AUG-15 03.24.24.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
112 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
111 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
110 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
109 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
108 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
107 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
106 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
105 | ORADG11G | 1403587593 | oradg11g | 1 | 23-AUG-15 05.35.19.000 PM | 11.2.0.3.0 | NO | rhel6_lhr | Linux x86 64-bit | 2 | 2 | 1 | 7.68 |
SPFILE Usage |
---|
This database IS using an SPFILE. |
Parameter Name | Instance Name | Value | DISPLAY_VALUE | Is Default? | Is Dynamic? | ISDEPRECATED | DESCRIPTION |
---|---|---|---|---|---|---|---|
O7_DICTIONARY_ACCESSIBILITY | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | Version 7 Dictionary Accessibility Support |
active_instance_count | oradg11g |
TRUE
|
FALSE
|
TRUE | number of active instances in the cluster database | ||
aq_tm_processes | oradg11g | 1 | 1 |
TRUE
|
IMMEDIATE
|
FALSE | number of AQ Time Managers to start |
archive_lag_target | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Maximum number of seconds of redos the standby could lose |
asm_diskgroups | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | disk groups to mount automatically | ||
asm_diskstring | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | disk set locations for discovery | ||
asm_power_limit | oradg11g | 1 | 1 |
TRUE
|
IMMEDIATE
|
FALSE | number of parallel relocations for disk rebalancing |
asm_preferred_read_failure_groups | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | preferred read failure groups | ||
audit_file_dest | oradg11g | /u01/app/oracle/admin/oradg11g/adump | /u01/app/oracle/admin/oradg11g/adump |
FALSE
|
DEFERRED
|
FALSE | Directory in which auditing files are to reside |
audit_sys_operations | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | enable sys auditing |
audit_syslog_level | oradg11g |
TRUE
|
FALSE
|
FALSE | Syslog facility and level | ||
audit_trail | oradg11g | DB | DB |
FALSE
|
FALSE
|
FALSE | enable system auditing |
awr_snapshot_time_offset | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Setting for AWR Snapshot Time Offset |
background_core_dump | oradg11g | partial | partial |
TRUE
|
FALSE
|
FALSE | Core Size for Background Processes |
background_dump_dest | oradg11g | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace |
TRUE
|
IMMEDIATE
|
TRUE | Detached process dump directory |
backup_tape_io_slaves | oradg11g | FALSE | FALSE |
TRUE
|
DEFERRED
|
FALSE | BACKUP Tape I/O slaves |
bitmap_merge_area_size | oradg11g | 1048576 | 1048576 |
TRUE
|
FALSE
|
FALSE | maximum memory allow for BITMAP MERGE |
blank_trimming | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | blank trimming semantics parameter |
buffer_pool_keep | oradg11g |
TRUE
|
FALSE
|
TRUE | Number of database blocks/latches in keep buffer pool | ||
buffer_pool_recycle | oradg11g |
TRUE
|
FALSE
|
TRUE | Number of database blocks/latches in recycle buffer pool | ||
cell_offload_compaction | oradg11g | ADAPTIVE | ADAPTIVE |
TRUE
|
IMMEDIATE
|
FALSE | Cell packet compaction strategy |
cell_offload_decryption | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | enable SQL processing offload of encrypted data to cells |
cell_offload_parameters | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | Additional cell offload parameters | ||
cell_offload_plan_display | oradg11g | AUTO | AUTO |
TRUE
|
IMMEDIATE
|
FALSE | Cell offload explain plan display |
cell_offload_processing | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | enable SQL processing offload to cells |
circuits | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | max number of circuits | ||
client_result_cache_lag | oradg11g | 3000 | 3000 |
TRUE
|
FALSE
|
FALSE | client result cache maximum lag in milliseconds |
client_result_cache_size | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | client result cache max size in bytes |
clonedb | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | clone database |
cluster_database | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | if TRUE startup in cluster database mode |
cluster_database_instances | oradg11g | 1 | 1 |
TRUE
|
FALSE
|
FALSE | number of instances to use for sizing cluster db SGA structures |
cluster_interconnects | oradg11g |
TRUE
|
FALSE
|
FALSE | interconnects for RAC use | ||
commit_logging | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | transaction commit log write behaviour | ||
commit_point_strength | oradg11g | 1 | 1 |
TRUE
|
FALSE
|
FALSE | Bias this node has toward not preparing in a two-phase commit |
commit_wait | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | transaction commit log wait behaviour | ||
commit_write | oradg11g |
TRUE
|
IMMEDIATE
|
TRUE | transaction commit log write behaviour | ||
compatible | oradg11g | 11.2.0.0.0 | 11.2.0.0.0 |
FALSE
|
FALSE
|
FALSE | Database will be completely compatible with this software version |
control_file_record_keep_time | oradg11g | 7 | 7 |
TRUE
|
IMMEDIATE
|
FALSE | control file record keep time in days |
control_files | oradg11g | /u01/app/oracle/oradata/oradg11g/control01.ctl, /u 01/app/oracle/flash_recovery_area/oradg11g/control02.ctl | /u01/app/oracle/oradata/oradg11g/control01.ctl, /u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl |
FALSE
|
FALSE
|
FALSE | control file names list |
control_management_pack_access | oradg11g | DIAGNOSTIC+TUNING | DIAGNOSTIC+TUNING |
TRUE
|
IMMEDIATE
|
FALSE | declares which manageability packs are enabled |
core_dump_dest | oradg11g | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump |
TRUE
|
IMMEDIATE
|
FALSE | Core dump directory |
cpu_count | oradg11g | 2 | 2 |
TRUE
|
IMMEDIATE
|
FALSE | number of CPUs for this instance |
create_bitmap_area_size | oradg11g | 8388608 | 8388608 |
TRUE
|
FALSE
|
FALSE | size of create bitmap buffer for bitmap index |
create_stored_outlines | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | create stored outlines for DML statements | ||
cursor_bind_capture_destination | oradg11g | memory+disk | memory+disk |
TRUE
|
IMMEDIATE
|
FALSE | Allowed destination for captured bind variables |
cursor_sharing | oradg11g | EXACT | EXACT |
TRUE
|
IMMEDIATE
|
FALSE | cursor sharing mode |
cursor_space_for_time | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
TRUE | use more memory in order to get faster execution |
db_16k_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of cache for 16K buffers |
db_2k_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of cache for 2K buffers |
db_32k_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of cache for 32K buffers |
db_4k_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of cache for 4K buffers |
db_8k_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of cache for 8K buffers |
db_block_buffers | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | Number of database blocks cached in memory |
db_block_checking | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | header checking and data and index block checking |
db_block_checksum | oradg11g | TYPICAL | TYPICAL |
TRUE
|
IMMEDIATE
|
FALSE | store checksum in db blocks and check during reads |
db_block_size | oradg11g | 8192 | 8192 |
FALSE
|
FALSE
|
FALSE | Size of database block in bytes |
db_cache_advice | oradg11g | ON | ON |
TRUE
|
IMMEDIATE
|
FALSE | Buffer cache sizing advisory |
db_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of DEFAULT buffer pool for standard block size buffers |
db_create_file_dest | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | default database location | ||
db_create_online_log_dest_1 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | online log/controlfile destination #1 | ||
db_create_online_log_dest_2 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | online log/controlfile destination #2 | ||
db_create_online_log_dest_3 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | online log/controlfile destination #3 | ||
db_create_online_log_dest_4 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | online log/controlfile destination #4 | ||
db_create_online_log_dest_5 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | online log/controlfile destination #5 | ||
db_domain | oradg11g |
FALSE
|
FALSE
|
FALSE | directory part of global database name stored with CREATE DATABASE | ||
db_file_multiblock_read_count | oradg11g | 7 | 7 |
TRUE
|
IMMEDIATE
|
FALSE | db block to be read each IO |
db_file_name_convert | oradg11g | oradglg, oradg11g | oradglg, oradg11g |
FALSE
|
FALSE
|
FALSE | datafile name convert patterns and strings for standby/clone db |
db_files | oradg11g | 200 | 200 |
TRUE
|
FALSE
|
FALSE | max allowable # db files |
db_flash_cache_file | oradg11g |
TRUE
|
FALSE
|
FALSE | flash cache file for default block size | ||
db_flash_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | flash cache size for db_flash_cache_file |
db_flashback_retention_target | oradg11g | 1440 | 1440 |
TRUE
|
IMMEDIATE
|
FALSE | Maximum Flashback Database log retention time in minutes. |
db_keep_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of KEEP buffer pool for standard block size buffers |
db_lost_write_protect | oradg11g | NONE | NONE |
TRUE
|
IMMEDIATE
|
FALSE | enable lost write detection |
db_name | oradg11g | oradg11g | oradg11g |
FALSE
|
FALSE
|
FALSE | database name specified in CREATE DATABASE |
db_recovery_file_dest | oradg11g | /u01/app/oracle/flash_recovery_area | /u01/app/oracle/flash_recovery_area |
FALSE
|
IMMEDIATE
|
FALSE | default database recovery file location |
db_recovery_file_dest_size | oradg11g | 4322230272 | 4122M |
FALSE
|
IMMEDIATE
|
FALSE | database recovery files size limit |
db_recycle_cache_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Size of RECYCLE buffer pool for standard block size buffers |
db_securefile | oradg11g | PERMITTED | PERMITTED |
TRUE
|
IMMEDIATE
|
FALSE | permit securefile storage during lob creation |
db_ultra_safe | oradg11g | OFF | OFF |
TRUE
|
FALSE
|
FALSE | Sets defaults for other parameters that control protection levels |
db_unique_name | oradg11g | oradg11g | oradg11g |
FALSE
|
FALSE
|
FALSE | Database Unique Name |
db_unrecoverable_scn_tracking | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | Track nologging SCN in controlfile |
db_writer_processes | oradg11g | 1 | 1 |
TRUE
|
FALSE
|
FALSE | number of background database writer processes to start |
dbwr_io_slaves | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | DBWR I/O slaves |
ddl_lock_timeout | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | timeout to restrict the time that ddls wait for dml lock |
deferred_segment_creation | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | defer segment creation to first insert |
dg_broker_config_file1 | oradg11g | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat |
TRUE
|
IMMEDIATE
|
FALSE | data guard broker configuration file #1 |
dg_broker_config_file2 | oradg11g | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat |
TRUE
|
IMMEDIATE
|
FALSE | data guard broker configuration file #2 |
dg_broker_start | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | start Data Guard broker (DMON process) |
diagnostic_dest | oradg11g | /u01/app/oracle | /u01/app/oracle |
FALSE
|
IMMEDIATE
|
FALSE | diagnostic base directory |
disk_asynch_io | oradg11g | TRUE | TRUE |
TRUE
|
FALSE
|
FALSE | Use asynch I/O for random access devices |
dispatchers | oradg11g | (PROTOCOL=TCP) (SERVICE=oradg11gXDB) | (PROTOCOL=TCP) (SERVICE=oradg11gXDB) |
FALSE
|
IMMEDIATE
|
FALSE | specifications of dispatchers |
distributed_lock_timeout | oradg11g | 60 | 60 |
TRUE
|
FALSE
|
FALSE | number of seconds a distributed transaction waits for a lock |
dml_locks | oradg11g | 1088 | 1088 |
TRUE
|
FALSE
|
FALSE | dml locks - one for each table modified in a transaction |
dst_upgrade_insert_conv | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | Enables/Disables internal conversions during DST upgrade |
enable_ddl_logging | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | enable ddl logging |
event | oradg11g |
TRUE
|
FALSE
|
FALSE | debug event control - default null string | ||
fal_client | oradg11g | oradg11g | oradg11g |
FALSE
|
IMMEDIATE
|
FALSE | FAL client |
fal_server | oradg11g | oradglg | oradglg |
FALSE
|
IMMEDIATE
|
FALSE | FAL server list |
fast_start_io_target | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
TRUE | Upper bound on recovery reads |
fast_start_mttr_target | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | MTTR target in seconds |
fast_start_parallel_rollback | oradg11g | LOW | LOW |
TRUE
|
IMMEDIATE
|
FALSE | max number of parallel recovery slaves that may be used |
file_mapping | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | enable file mapping |
fileio_network_adapters | oradg11g |
TRUE
|
FALSE
|
FALSE | Network Adapters for File I/O | ||
filesystemio_options | oradg11g | none | none |
TRUE
|
FALSE
|
FALSE | IO operations on filesystem files |
fixed_date | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | fixed SYSDATE value | ||
gcs_server_processes | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | number of background gcs server processes to start |
global_context_pool_size | oradg11g |
TRUE
|
FALSE
|
TRUE | Global Application Context Pool Size in Bytes | ||
global_names | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | enforce that database links have same name as remote database |
global_txn_processes | oradg11g | 1 | 1 |
TRUE
|
IMMEDIATE
|
FALSE | number of background global transaction processes to start |
hash_area_size | oradg11g | 131072 | 131072 |
TRUE
|
FALSE
|
FALSE | size of in-memory hash work area |
hi_shared_memory_address | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | SGA starting address (high order 32-bits on 64-bit platforms) |
hs_autoregister | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | enable automatic server DD updates in HS agent self-registration |
ifile | oradg11g |
TRUE
|
FALSE
|
FALSE | include file in init.ora | ||
instance_groups | oradg11g |
TRUE
|
FALSE
|
TRUE | list of instance group names | ||
instance_name | oradg11g | oradg11g | oradg11g |
TRUE
|
FALSE
|
FALSE | instance name supported by the instance |
instance_number | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | instance number |
instance_type | oradg11g | RDBMS | RDBMS |
TRUE
|
FALSE
|
FALSE | type of instance to be executed |
java_jit_enabled | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | Java VM JIT enabled |
java_max_sessionspace_size | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | max allowed size in bytes of a Java sessionspace |
java_pool_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | size in bytes of java pool |
java_soft_sessionspace_limit | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | warning limit on size in bytes of a Java sessionspace |
job_queue_processes | oradg11g | 1000 | 1000 |
TRUE
|
IMMEDIATE
|
FALSE | maximum number of job queue slave processes |
large_pool_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | size in bytes of large pool |
ldap_directory_access | oradg11g | NONE | NONE |
TRUE
|
IMMEDIATE
|
FALSE | RDBMS's LDAP access option |
ldap_directory_sysauth | oradg11g | no | no |
TRUE
|
FALSE
|
FALSE | OID usage parameter |
license_max_sessions | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | maximum number of non-system user sessions allowed |
license_max_users | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | maximum number of named users that can be created in the database |
license_sessions_warning | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | warning level for number of non-system user sessions |
listener_networks | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | listener registration networks | ||
local_listener | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | local listener | ||
lock_name_space | oradg11g |
TRUE
|
FALSE
|
TRUE | lock name space used for generating lock names for standby/clone database | ||
lock_sga | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | Lock entire SGA in physical memory |
log_archive_config | oradg11g | DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font> | DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss) |
FALSE
|
IMMEDIATE
|
FALSE | log archive config parameter |
log_archive_dest | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination text string | ||
log_archive_dest_1 | oradg11g | LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) | LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #1 text string |
log_archive_dest_10 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #10 text string | ||
log_archive_dest_11 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #11 text string | ||
log_archive_dest_12 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #12 text string | ||
log_archive_dest_13 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #13 text string | ||
log_archive_dest_14 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #14 text string | ||
log_archive_dest_15 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #15 text string | ||
log_archive_dest_16 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #16 text string | ||
log_archive_dest_17 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #17 text string | ||
log_archive_dest_18 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #18 text string | ||
log_archive_dest_19 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #19 text string | ||
log_archive_dest_2 | oradg11g | SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=ora dgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) | SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #2 text string |
log_archive_dest_20 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #20 text string | ||
log_archive_dest_21 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #21 text string | ||
log_archive_dest_22 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #22 text string | ||
log_archive_dest_23 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #23 text string | ||
log_archive_dest_24 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #24 text string | ||
log_archive_dest_25 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #25 text string | ||
log_archive_dest_26 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #26 text string | ||
log_archive_dest_27 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #27 text string | ||
log_archive_dest_28 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #28 text string | ||
log_archive_dest_29 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #29 text string | ||
log_archive_dest_3 | oradg11g | SERVICE=tns_oradglg LGWR ASYNC db_unique_name=orad glg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) | SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #3 text string |
log_archive_dest_30 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #30 text string | ||
log_archive_dest_31 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #31 text string | ||
log_archive_dest_4 | oradg11g | SERVICE=tns_oradgss LGWR ASYNC db_unique_name=orad gss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) | SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #4 text string |
log_archive_dest_5 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #5 text string | ||
log_archive_dest_6 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #6 text string | ||
log_archive_dest_7 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #7 text string | ||
log_archive_dest_8 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #8 text string | ||
log_archive_dest_9 | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #9 text string | ||
log_archive_dest_state_1 | oradg11g | ENABLE | ENABLE |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #1 state text string |
log_archive_dest_state_10 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #10 state text string |
log_archive_dest_state_11 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #11 state text string |
log_archive_dest_state_12 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #12 state text string |
log_archive_dest_state_13 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #13 state text string |
log_archive_dest_state_14 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #14 state text string |
log_archive_dest_state_15 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #15 state text string |
log_archive_dest_state_16 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #16 state text string |
log_archive_dest_state_17 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #17 state text string |
log_archive_dest_state_18 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #18 state text string |
log_archive_dest_state_19 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #19 state text string |
log_archive_dest_state_2 | oradg11g | ENABLE | ENABLE |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #2 state text string |
log_archive_dest_state_20 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #20 state text string |
log_archive_dest_state_21 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #21 state text string |
log_archive_dest_state_22 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #22 state text string |
log_archive_dest_state_23 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #23 state text string |
log_archive_dest_state_24 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #24 state text string |
log_archive_dest_state_25 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #25 state text string |
log_archive_dest_state_26 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #26 state text string |
log_archive_dest_state_27 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #27 state text string |
log_archive_dest_state_28 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #28 state text string |
log_archive_dest_state_29 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #29 state text string |
log_archive_dest_state_3 | oradg11g | ENABLE | ENABLE |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #3 state text string |
log_archive_dest_state_30 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #30 state text string |
log_archive_dest_state_31 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #31 state text string |
log_archive_dest_state_4 | oradg11g | ENABLE | ENABLE |
FALSE
|
IMMEDIATE
|
FALSE | archival destination #4 state text string |
log_archive_dest_state_5 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #5 state text string |
log_archive_dest_state_6 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #6 state text string |
log_archive_dest_state_7 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #7 state text string |
log_archive_dest_state_8 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #8 state text string |
log_archive_dest_state_9 | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | archival destination #9 state text string |
log_archive_duplex_dest | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | duplex archival destination text string | ||
log_archive_format | oradg11g | %t_%s_%r.dbf | %t_%s_%r.dbf |
TRUE
|
FALSE
|
FALSE | archival destination format |
log_archive_local_first | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
TRUE | Establish EXPEDITE attribute default value |
log_archive_max_processes | oradg11g | 4 | 4 |
FALSE
|
IMMEDIATE
|
FALSE | maximum number of active ARCH processes |
log_archive_min_succeed_dest | oradg11g | 1 | 1 |
TRUE
|
IMMEDIATE
|
FALSE | minimum number of archive destinations that must succeed |
log_archive_start | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
TRUE | start archival process on SGA initialization |
log_archive_trace | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Establish archivelog operation tracing level |
log_buffer | oradg11g | 8110080 | 8110080 |
TRUE
|
FALSE
|
FALSE | redo circular buffer size |
log_checkpoint_interval | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | # redo blocks checkpoint threshold |
log_checkpoint_timeout | oradg11g | 1800 | 1800 |
TRUE
|
IMMEDIATE
|
FALSE | Maximum time interval between checkpoints in seconds |
log_checkpoints_to_alert | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | log checkpoint begin/end to alert file |
log_file_name_convert | oradg11g | oradglg, oradg11g | oradglg, oradg11g |
FALSE
|
FALSE
|
FALSE | logfile name convert patterns and strings for standby/clone db |
max_dispatchers | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | max number of dispatchers | ||
max_dump_file_size | oradg11g | unlimited | unlimited |
TRUE
|
IMMEDIATE
|
FALSE | Maximum size (in bytes) of dump file |
max_enabled_roles | oradg11g | 150 | 150 |
TRUE
|
FALSE
|
TRUE | max number of roles a user can have enabled |
max_shared_servers | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | max number of shared servers | ||
memory_max_target | oradg11g | 419430400 | 400M |
FALSE
|
FALSE
|
FALSE | Max size for Memory Target |
memory_target | oradg11g | 314572800 | 300M |
FALSE
|
IMMEDIATE
|
FALSE | Target size of Oracle SGA and PGA memory |
nls_calendar | oradg11g | GREGORIAN | GREGORIAN |
TRUE
|
FALSE
|
FALSE | NLS calendar system name |
nls_comp | oradg11g | BINARY | BINARY |
TRUE
|
FALSE
|
FALSE | NLS comparison |
nls_currency | oradg11g | ¥ | ¥ |
TRUE
|
FALSE
|
FALSE | NLS local currency symbol |
nls_date_format | oradg11g | YYYY-MM-DD HH24:mi:ss | YYYY-MM-DD HH24:mi:ss |
TRUE
|
FALSE
|
FALSE | NLS Oracle date format |
nls_date_language | oradg11g | AMERICAN | AMERICAN |
TRUE
|
FALSE
|
FALSE | NLS date language name |
nls_dual_currency | oradg11g | ¥ | ¥ |
TRUE
|
FALSE
|
FALSE | Dual currency symbol |
nls_iso_currency | oradg11g | CHINA | CHINA |
TRUE
|
FALSE
|
FALSE | NLS ISO currency territory name |
nls_language | oradg11g | AMERICAN | AMERICAN |
TRUE
|
FALSE
|
FALSE | NLS language name |
nls_length_semantics | oradg11g | BYTE | BYTE |
TRUE
|
IMMEDIATE
|
FALSE | create columns using byte or char semantics by default |
nls_nchar_conv_excp | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | NLS raise an exception instead of allowing implicit conversion |
nls_numeric_characters | oradg11g | ., | ., |
TRUE
|
FALSE
|
FALSE | NLS numeric characters |
nls_sort | oradg11g | BINARY | BINARY |
TRUE
|
FALSE
|
FALSE | NLS linguistic definition name |
nls_territory | oradg11g | CHINA | CHINA |
TRUE
|
FALSE
|
FALSE | NLS territory name |
nls_time_format | oradg11g | HH.MI.SSXFF AM | HH.MI.SSXFF AM |
TRUE
|
FALSE
|
FALSE | time format |
nls_time_tz_format | oradg11g | HH.MI.SSXFF AM TZR | HH.MI.SSXFF AM TZR |
TRUE
|
FALSE
|
FALSE | time with timezone format |
nls_timestamp_format | oradg11g | DD-MON-RR HH.MI.SSXFF AM | DD-MON-RR HH.MI.SSXFF AM |
TRUE
|
FALSE
|
FALSE | time stamp format |
nls_timestamp_tz_format | oradg11g | DD-MON-RR HH.MI.SSXFF AM TZR | DD-MON-RR HH.MI.SSXFF AM TZR |
TRUE
|
FALSE
|
FALSE | timestamp with timezone format |
object_cache_max_size_percent | oradg11g | 10 | 10 |
TRUE
|
DEFERRED
|
FALSE | percentage of maximum size over optimal of the user session's object cache |
object_cache_optimal_size | oradg11g | 102400 | 102400 |
TRUE
|
DEFERRED
|
FALSE | optimal size of the user session's object cache in bytes |
olap_page_pool_size | oradg11g | 0 | 0 |
TRUE
|
DEFERRED
|
FALSE | size of the olap page pool in bytes |
open_cursors | oradg11g | 300 | 300 |
FALSE
|
IMMEDIATE
|
FALSE | max # cursors per session |
open_links | oradg11g | 4 | 4 |
TRUE
|
FALSE
|
FALSE | max # open links per session |
open_links_per_instance | oradg11g | 4 | 4 |
TRUE
|
FALSE
|
FALSE | max # open links per instance |
optimizer_capture_sql_plan_baselines | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | automatic capture of SQL plan baselines for repeatable statements |
optimizer_dynamic_sampling | oradg11g | 2 | 2 |
TRUE
|
IMMEDIATE
|
FALSE | optimizer dynamic sampling |
optimizer_features_enable | oradg11g | 11.2.0.3 | 11.2.0.3 |
TRUE
|
IMMEDIATE
|
FALSE | optimizer plan compatibility parameter |
optimizer_index_caching | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | optimizer percent index caching |
optimizer_index_cost_adj | oradg11g | 100 | 100 |
TRUE
|
IMMEDIATE
|
FALSE | optimizer index cost adjustment |
optimizer_mode | oradg11g | ALL_ROWS | ALL_ROWS |
TRUE
|
IMMEDIATE
|
FALSE | optimizer mode |
optimizer_secure_view_merging | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | optimizer secure view merging and predicate pushdown/movearound |
optimizer_use_invisible_indexes | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | Usage of invisible indexes (TRUE/FALSE) |
optimizer_use_pending_statistics | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | Control whether to use optimizer pending statistics |
optimizer_use_sql_plan_baselines | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | use of SQL plan baselines for captured sql statements |
os_authent_prefix | oradg11g | ops$ | ops$ |
TRUE
|
FALSE
|
FALSE | prefix for auto-logon accounts |
os_roles | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | retrieve roles from the operating system |
parallel_adaptive_multi_user | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | enable adaptive setting of degree for multiple user streams |
parallel_automatic_tuning | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
TRUE | enable intelligent defaults for parallel execution parameters |
parallel_degree_limit | oradg11g | CPU | CPU |
TRUE
|
IMMEDIATE
|
FALSE | limit placed on degree of parallelism |
parallel_degree_policy | oradg11g | MANUAL | MANUAL |
TRUE
|
IMMEDIATE
|
FALSE | policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO) |
parallel_execution_message_size | oradg11g | 16384 | 16384 |
TRUE
|
FALSE
|
FALSE | message buffer size for parallel execution |
parallel_force_local | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | force single instance execution |
parallel_instance_group | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | instance group to use for all parallel operations | ||
parallel_io_cap_enabled | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
TRUE | enable capping DOP by IO bandwidth |
parallel_max_servers | oradg11g | 80 | 80 |
TRUE
|
IMMEDIATE
|
FALSE | maximum parallel query servers per instance |
parallel_min_percent | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | minimum percent of threads required for parallel query |
parallel_min_servers | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | minimum parallel query servers per instance |
parallel_min_time_threshold | oradg11g | AUTO | AUTO |
TRUE
|
IMMEDIATE
|
FALSE | threshold above which a plan is a candidate for parallelization (in seconds) |
parallel_server | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
TRUE | if TRUE startup in parallel server mode |
parallel_server_instances | oradg11g | 1 | 1 |
TRUE
|
FALSE
|
TRUE | number of instances to use for sizing OPS SGA structures |
parallel_servers_target | oradg11g | 32 | 32 |
TRUE
|
IMMEDIATE
|
FALSE | instance target in terms of number of parallel servers |
parallel_threads_per_cpu | oradg11g | 2 | 2 |
TRUE
|
IMMEDIATE
|
FALSE | number of parallel execution threads per CPU |
permit_92_wrap_format | oradg11g | TRUE | TRUE |
TRUE
|
FALSE
|
FALSE | allow 9.2 or older wrap format in PL/SQL |
pga_aggregate_target | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Target size for the aggregate PGA memory consumed by the instance |
plscope_settings | oradg11g | IDENTIFIERS:NONE | IDENTIFIERS:NONE |
TRUE
|
IMMEDIATE
|
FALSE | plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data |
plsql_ccflags | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | PL/SQL ccflags | ||
plsql_code_type | oradg11g | INTERPRETED | INTERPRETED |
TRUE
|
IMMEDIATE
|
FALSE | PL/SQL code-type |
plsql_debug | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
TRUE | PL/SQL debug |
plsql_optimize_level | oradg11g | 2 | 2 |
TRUE
|
IMMEDIATE
|
FALSE | PL/SQL optimize level |
plsql_v2_compatibility | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
TRUE | PL/SQL version 2.x compatibility flag |
plsql_warnings | oradg11g | DISABLE:ALL | DISABLE:ALL |
TRUE
|
IMMEDIATE
|
FALSE | PL/SQL compiler warnings settings |
pre_page_sga | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | pre-page sga for process |
processes | oradg11g | 150 | 150 |
FALSE
|
FALSE
|
FALSE | user processes |
processor_group_name | oradg11g |
TRUE
|
FALSE
|
FALSE | Name of the processor group that this instance should run in. | ||
query_rewrite_enabled | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | allow rewrite of queries using materialized views if enabled |
query_rewrite_integrity | oradg11g | enforced | enforced |
TRUE
|
IMMEDIATE
|
FALSE | perform rewrite using materialized views with desired integrity |
rdbms_server_dn | oradg11g |
TRUE
|
FALSE
|
FALSE | RDBMS's Distinguished Name | ||
read_only_open_delayed | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | if TRUE delay opening of read only files until first access |
recovery_parallelism | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | number of server processes to use for parallel recovery |
recyclebin | oradg11g | on | on |
TRUE
|
DEFERRED
|
FALSE | recyclebin processing |
redo_transport_user | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | Data Guard transport user when using password file | ||
remote_dependencies_mode | oradg11g | TIMESTAMP | TIMESTAMP |
TRUE
|
IMMEDIATE
|
FALSE | remote-procedure-call dependencies mode parameter |
remote_listener | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | remote listener | ||
remote_login_passwordfile | oradg11g | EXCLUSIVE | EXCLUSIVE |
FALSE
|
FALSE
|
FALSE | password file usage parameter |
remote_os_authent | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
TRUE | allow non-secure remote clients to use auto-logon accounts |
remote_os_roles | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | allow non-secure remote clients to use os roles |
replication_dependency_tracking | oradg11g | TRUE | TRUE |
TRUE
|
FALSE
|
FALSE | tracking dependency for Replication parallel propagation |
resource_limit | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | master switch for resource limit |
resource_manager_cpu_allocation | oradg11g | 2 | 2 |
TRUE
|
IMMEDIATE
|
TRUE | Resource Manager CPU allocation |
resource_manager_plan | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | resource mgr top plan | ||
result_cache_max_result | oradg11g | 5 | 5 |
TRUE
|
IMMEDIATE
|
FALSE | maximum result size as percent of cache size |
result_cache_max_size | oradg11g | 786432 | 768K |
TRUE
|
IMMEDIATE
|
FALSE | maximum amount of memory to be used by the cache |
result_cache_mode | oradg11g | MANUAL | MANUAL |
TRUE
|
IMMEDIATE
|
FALSE | result cache operator usage mode |
result_cache_remote_expiration | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | maximum life time (min) for any result using a remote object |
resumable_timeout | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | set resumable_timeout |
rollback_segments | oradg11g |
TRUE
|
FALSE
|
FALSE | undo segment list | ||
sec_case_sensitive_logon | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | case sensitive password enabled for logon |
sec_max_failed_login_attempts | oradg11g | 10 | 10 |
TRUE
|
FALSE
|
FALSE | maximum number of failed login attempts on a connection |
sec_protocol_error_further_action | oradg11g | CONTINUE | CONTINUE |
TRUE
|
IMMEDIATE
|
FALSE | TTC protocol error continue action |
sec_protocol_error_trace_action | oradg11g | TRACE | TRACE |
TRUE
|
IMMEDIATE
|
FALSE | TTC protocol error action |
sec_return_server_release_banner | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | whether the server retruns the complete version information |
serial_reuse | oradg11g | disable | disable |
TRUE
|
FALSE
|
TRUE | reuse the frame segments |
service_names | oradg11g | oradg11g | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | service names supported by the instance |
session_cached_cursors | oradg11g | 50 | 50 |
TRUE
|
FALSE
|
FALSE | Number of cursors to cache in a session. |
session_max_open_files | oradg11g | 10 | 10 |
TRUE
|
FALSE
|
FALSE | maximum number of open files allowed per session |
sessions | oradg11g | 248 | 248 |
TRUE
|
FALSE
|
FALSE | user and system sessions |
sga_max_size | oradg11g | 419430400 | 400M |
TRUE
|
FALSE
|
FALSE | max total SGA size |
sga_target | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Target size of SGA |
shadow_core_dump | oradg11g | partial | partial |
TRUE
|
FALSE
|
FALSE | Core Size for Shadow Processes |
shared_memory_address | oradg11g | 0 | 0 |
TRUE
|
FALSE
|
FALSE | SGA starting address (low order 32-bits on 64-bit platforms) |
shared_pool_reserved_size | oradg11g | 8178892 | 8178892 |
TRUE
|
FALSE
|
FALSE | size in bytes of reserved area of shared pool |
shared_pool_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | size in bytes of shared pool |
shared_server_sessions | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | max number of shared server sessions | ||
shared_servers | oradg11g | 1 | 1 |
TRUE
|
IMMEDIATE
|
FALSE | number of shared servers to start up |
skip_unusable_indexes | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | skip unusable indexes if set to TRUE |
smtp_out_server | oradg11g |
TRUE
|
IMMEDIATE
|
FALSE | utl_smtp server and port configuration parameter | ||
sort_area_retained_size | oradg11g | 0 | 0 |
TRUE
|
DEFERRED
|
FALSE | size of in-memory sort work area retained between fetch calls |
sort_area_size | oradg11g | 65536 | 65536 |
TRUE
|
DEFERRED
|
FALSE | size of in-memory sort work area |
spfile | oradg11g | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora |
TRUE
|
IMMEDIATE
|
FALSE | server parameter file |
sql92_security | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | require select privilege for searched update/delete |
sql_trace | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
TRUE | enable SQL trace |
sqltune_category | oradg11g | DEFAULT | DEFAULT |
TRUE
|
IMMEDIATE
|
FALSE | Category qualifier for applying hintsets |
standby_archive_dest | oradg11g | ?/dbs/arch | ?/dbs/arch |
TRUE
|
IMMEDIATE
|
TRUE | standby database archivelog destination text string |
standby_file_management | oradg11g | AUTO | AUTO |
FALSE
|
IMMEDIATE
|
FALSE | if auto then files are created/dropped automatically on standby |
star_transformation_enabled | oradg11g | FALSE | FALSE |
TRUE
|
IMMEDIATE
|
FALSE | enable the use of star transformation |
statistics_level | oradg11g | TYPICAL | TYPICAL |
TRUE
|
IMMEDIATE
|
FALSE | statistics level |
streams_pool_size | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | size in bytes of the streams pool |
tape_asynch_io | oradg11g | TRUE | TRUE |
TRUE
|
FALSE
|
FALSE | Use asynch I/O requests for tape devices |
thread | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | Redo thread to mount |
timed_os_statistics | oradg11g | 0 | 0 |
TRUE
|
IMMEDIATE
|
FALSE | internal os statistic gathering interval in seconds |
timed_statistics | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | maintain internal timing statistics |
trace_enabled | oradg11g | TRUE | TRUE |
TRUE
|
IMMEDIATE
|
FALSE | enable in memory tracing |
tracefile_identifier | oradg11g |
TRUE
|
FALSE
|
FALSE | trace file custom identifier | ||
transactions | oradg11g | 272 | 272 |
TRUE
|
FALSE
|
FALSE | max. number of concurrent active transactions |
transactions_per_rollback_segment | oradg11g | 5 | 5 |
TRUE
|
FALSE
|
FALSE | number of active transactions per rollback segment |
undo_management | oradg11g | AUTO | AUTO |
TRUE
|
FALSE
|
FALSE | instance runs in SMU mode if TRUE, else in RBU mode |
undo_retention | oradg11g | 900 | 900 |
TRUE
|
IMMEDIATE
|
FALSE | undo retention in seconds |
undo_tablespace | oradg11g | UNDOTBS1 | UNDOTBS1 |
FALSE
|
IMMEDIATE
|
FALSE | use/switch undo tablespace |
use_indirect_data_buffers | oradg11g | FALSE | FALSE |
TRUE
|
FALSE
|
FALSE | Enable indirect data buffers (very large SGA on 32-bit platforms) |
use_large_pages | oradg11g | TRUE | TRUE |
TRUE
|
FALSE
|
FALSE | Use large pages if available (TRUE/FALSE/ONLY) |
user_dump_dest | oradg11g | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace | /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace |
TRUE
|
IMMEDIATE
|
TRUE | User process dump directory |
utl_file_dir | oradg11g |
TRUE
|
FALSE
|
FALSE | utl_file accessible directories list | ||
workarea_size_policy | oradg11g | AUTO | AUTO |
TRUE
|
IMMEDIATE
|
FALSE | policy used to size SQL working areas (MANUAL/AUTO) |
xml_db_events | oradg11g | enable | enable |
TRUE
|
IMMEDIATE
|
FALSE | are XML DB events enabled |
参数名称 | 实例名称 | 参数值 |
---|---|---|
cpu_count | oradg11g | 2 |
cursor_sharing | oradg11g | EXACT |
db_block_size | oradg11g | 8192 |
db_cache_size | oradg11g | 0 |
db_file_multiblock_read_count | oradg11g | 7 |
instance_name | oradg11g | oradg11g |
instance_number | oradg11g | 0 |
java_pool_size | oradg11g | 0 |
job_queue_processes | oradg11g | 1000 |
large_pool_size | oradg11g | 0 |
local_listener | oradg11g | |
log_archive_dest_1 | oradg11g | LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) |
log_buffer | oradg11g | 8110080 |
open_cursors | oradg11g | 300 |
optimizer_index_caching | oradg11g | 0 |
optimizer_index_cost_adj | oradg11g | 100 |
optimizer_mode | oradg11g | ALL_ROWS |
pga_aggregate_target | oradg11g | 0 |
processes | oradg11g | 150 |
sessions | oradg11g | 248 |
sga_max_size | oradg11g | 419430400 |
sga_target | oradg11g | 0 |
shared_pool_size | oradg11g | 0 |
sort_area_size | oradg11g | 65536 |
spfile | oradg11g | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora |
thread | oradg11g | 0 |
dmp全备份约(G) | RMAN全备份约(G) | 数据文件容量(G) |
---|---|---|
2
|
2 | 3 |
资源名称 | 当前值 | 最大值 | 初始值 | 限制值 |
---|---|---|---|---|
processes | 37 | 52 | 150 | 150 |
sessions | 45 | 58 | 248 | 248 |
enqueue_locks | 28 | 55 | 3160 | 3160 |
enqueue_resources | 22 | 44 | 1308 | UNLIMITED |
ges_procs | 0 | 0 | 0 | 0 |
ges_ress | 0 | 0 | 0 | UNLIMITED |
ges_locks | 0 | 0 | 0 | UNLIMITED |
ges_cache_ress | 0 | 0 | 0 | UNLIMITED |
ges_reg_msgs | 0 | 0 | 0 | UNLIMITED |
ges_big_msgs | 0 | 0 | 0 | UNLIMITED |
ges_rsv_msgs | 0 | 0 | 0 | 0 |
gcs_resources | 0 | 0 | UNLIMITED | UNLIMITED |
gcs_shadows | 0 | 0 | UNLIMITED | UNLIMITED |
smartio_overhead_memory | 0 | 0 | 0 | UNLIMITED |
smartio_buffer_memory | 0 | 0 | 0 | UNLIMITED |
smartio_metadata_memory | 0 | 0 | 0 | UNLIMITED |
smartio_sessions | 0 | 0 | 0 | UNLIMITED |
dml_locks | 0 | 0 | 1088 | UNLIMITED |
temporary_table_locks | 0 | 0 | UNLIMITED | UNLIMITED |
transactions | 0 | 0 | 272 | UNLIMITED |
branches | 0 | 0 | 272 | UNLIMITED |
cmtcallbk | 0 | 1 | 272 | UNLIMITED |
max_rollback_segments | 11 | 11 | 272 | 65535 |
sort_segment_locks | 1 | 3 | UNLIMITED | UNLIMITED |
k2q_locks | 0 | 0 | 496 | UNLIMITED |
max_shared_servers | 1 | 1 | UNLIMITED | UNLIMITED |
parallel_max_servers | 0 | 16 | 80 | 3600 |
状态 | 表空间名称 | 表空间类型 | 扩展管理方 | 段管理方� | 表空间大小(MB) | 空闲(MB) | 使用(MB) | Pct. Used |
---|---|---|---|---|---|---|---|---|
ONLINE
|
EXAMPLE | PERMANENT | LOCAL | AUTO | 346 | 36 | 310 |
89 %
|
ONLINE
|
LOGMNRTBS | PERMANENT | LOCAL | AUTO | 355 | 255 | 100 |
28 %
|
ONLINE
|
SYSAUX | PERMANENT | LOCAL | AUTO | 580 | 50 | 530 |
91 %
|
ONLINE
|
SYSTEM | PERMANENT | LOCAL | MANUAL | 860 | 127 | 733 |
85 %
|
ONLINE
|
TEMP | TEMPORARY | LOCAL | MANUAL | 29 | 18 | 11 |
37 %
|
ONLINE
|
UNDOTBS1 | UNDO | LOCAL | MANUAL | 95 | 60 | 36 |
37 %
|
ONLINE
|
USERS | PERMANENT | LOCAL | AUTO | 41 | 3 | 38 |
92 %
|
-------------------- | -------------------- | -------------------- | ||||||
Total: | 2,306 | 548 | 1,758 |
TS# | TS_NAME | CONTENTS | TS_SIZE_M | FREE_SIZE_M | USED_SIZE_M | USED_PER | MAX_SIZE_G | MAX_SIZE_FREE_G | USED_PER_MAX | BLOCK_SIZE | LOGGING | 状态 | TS_DF_COUNT | DATA_FILE_NAME | FOR | EXTENT_MAN | SEGMEN | RETENTION | DEF_TAB_ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | SYSTEM | PERMANENT | 860 | 127 | 733 | 85.276 | 32 | 31.284 | 2.238 | 8192 | LOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/system01.dbf | NO | LOCAL | MANUAL | NOT APPLY | DISABLED |
1 | SYSAUX | PERMANENT | 580 | 50 | 530 | 91.369 | 32 | 31.482 | 1.617 | 8192 | LOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/sysaux01.dbf | NO | LOCAL | AUTO | NOT APPLY | DISABLED |
2 | UNDOTBS1 | UNDO | 95 | 60 | 36 | 37.368 | 32 | 31.965 | .108 | 8192 | LOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/undotbs01.dbf | NO | LOCAL | MANUAL | NOGUARANTEE | DISABLED |
3 | TEMP | TEMPORARY | 29 | 27 | 2 | 6.897 | 32 | 31.998 | .006 | 8192 | NOLOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/temp01.dbf | NO | LOCAL | MANUAL | NOT APPLY | DISABLED |
4 | USERS | PERMANENT | 41 | 3 | 38 | 92.879 | 32 | 31.963 | .117 | 8192 | LOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/users01.dbf | NO | LOCAL | AUTO | NOT APPLY | DISABLED |
6 | EXAMPLE | PERMANENT | 346 | 36 | 310 | 89.729 | 32 | 31.697 | .946 | 8192 | NOLOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/example01.dbf | NO | LOCAL | AUTO | NOT APPLY | DISABLED |
7 | LOGMNRTBS | PERMANENT | 355 | 255 | 100 | 28.169 | 1.953 | 1.855 | 5 | 8192 | LOGGING | ONLINE | 1 | /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | NO | LOCAL | AUTO | NOT APPLY | DISABLED |
所有表空间 | 2305.875 | 557 | 1749 | 75.861 | 194 | 192.245 |
● 数据库闪回空间总体使用情况
NAME | LIMIT_GB | USED_GB | USED% | RECLAIM_GB | FILE# |
---|---|---|---|---|---|
/u01/app/oracle/flash_recovery_area | 4.025 | .6 | 14.904 | .46 | 63 |
TYPE | USED_GB | USED% | RECLAIMABLE% | RECLAIM_GB | FILES# |
---|---|---|---|---|---|
ARCHIVED LOG | .091 | 2.26 | 0 | 0 | 45 |
BACKUP PIECE | 0 | 0 | 0 | 0 | 0 |
CONTROL FILE | 0 | 0 | 0 | 0 | 0 |
FLASHBACK LOG | .488 | 12.13 | 10.92 | .44 | 10 |
FOREIGN ARCHIVED LOG | .021 | .52 | .51 | .021 | 8 |
IMAGE COPY | 0 | 0 | 0 | 0 | 0 |
REDO LOG | 0 | 0 | 0 | 0 | 0 |
---------- | ---------- | ------------ | ---------- | ---------- | |
.6 | 14.91 | 11.43 | .461 | 63 |
Name | Size (M) | HWM (M) | HWM % | Using (M) | Using % |
---|---|---|---|---|---|
TEMP | 29.000 | 11.000 | 37.93 | 1.000 | 3.45 |
Tablespace Name / File Class | Filename | File Size | Autoextensible | Next | Max |
---|---|---|---|---|---|
EXAMPLE | /u01/app/oracle/oradata/oradg11g/example01.dbf | 362,414,080 |
YES
|
655,360 | 34,359,721,984 |
LOGMNRTBS | /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | 372,244,480 |
YES
|
5,242,880 | 2,097,152,000 |
SYSAUX | /u01/app/oracle/oradata/oradg11g/sysaux01.dbf | 608,174,080 |
YES
|
10,485,760 | 34,359,721,984 |
SYSTEM | /u01/app/oracle/oradata/oradg11g/system01.dbf | 901,775,360 |
YES
|
10,485,760 | 34,359,721,984 |
TEMP | /u01/app/oracle/oradata/oradg11g/temp01.dbf | 30,408,704 |
YES
|
655,360 | 34,359,721,984 |
UNDOTBS1 | /u01/app/oracle/oradata/oradg11g/undotbs01.dbf | 99,614,720 |
YES
|
5,242,880 | 34,359,721,984 |
USERS | /u01/app/oracle/oradata/oradg11g/users01.dbf | 43,253,760 |
YES
|
1,310,720 | 34,359,721,984 |
[ CONTROL FILE ] | /u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl | ||||
[ CONTROL FILE ] | /u01/app/oracle/oradata/oradg11g/control01.ctl | ||||
[ ONLINE REDO LOG ] | /u01/app/oracle/oradata/oradg11g/redo01.log | 52,428,800 | |||
[ ONLINE REDO LOG ] | /u01/app/oracle/oradata/oradg11g/redo02.log | 52,428,800 | |||
[ ONLINE REDO LOG ] | /u01/app/oracle/oradata/oradg11g/redo03.log | 52,428,800 | |||
-------------------- | |||||
Total: | 2,575,171,584 |
FILE_ID | TABLESPACE_NAME | TS_SIZE_M | FILE_NAME | FILE_SIZE_M | FILE_MAX_SIZE_G | Aut | INCREMENT_M | AUTOEXTEND_RATIO |
---|---|---|---|---|---|---|---|---|
5 | EXAMPLE | 345.63 | /u01/app/oracle/oradata/oradg11g/example01.dbf | 345.63 | 32 | YES | .63 | 1.05 |
6 | LOGMNRTBS | 355 | /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | 355 | 1.95 | YES | 5 | 17.75 |
2 | SYSAUX | 580 | /u01/app/oracle/oradata/oradg11g/sysaux01.dbf | 580 | 32 | YES | 10 | 1.77 |
1 | SYSTEM | 860 | /u01/app/oracle/oradata/oradg11g/system01.dbf | 860 | 32 | YES | 10 | 2.62 |
1 | TEMP | 29 | /u01/app/oracle/oradata/oradg11g/temp01.dbf | 29 | 32 | YES | .63 | .09 |
3 | UNDOTBS1 | 95 | /u01/app/oracle/oradata/oradg11g/undotbs01.dbf | 95 | 32 | YES | 5 | .29 |
4 | USERS | 41.25 | /u01/app/oracle/oradata/oradg11g/users01.dbf | 41.25 | 32 | YES | 1.25 | .13 |
Tablespace Name | Largest Extent | Smallest Extent | Total Free | Number of Free Extents |
---|---|---|---|---|
EXAMPLE | 34,668,544 | 589,824 | 37,224,448 | 3 |
LOGMNRTBS | 200,278,016 | 1,048,576 | 267,386,880 | 10 |
SYSAUX | 35,651,584 | 65,536 | 52,494,336 | 63 |
SYSTEM | 132,120,576 | 655,360 | 132,775,936 | 2 |
UNDOTBS1 | 24,117,248 | 65,536 | 62,390,272 | 26 |
USERS | 2,359,296 | 65,536 | 3,080,192 | 3 |
-------------------- | -------------------- | -------------------- | ---------------------- | |
Total: | 429,195,264 | 2,490,368 | 555,352,064 | 107 |
● 回滚段
FILE_NAME | TABLESPACE_NAME | SIZE_M | AUT | ONLINE_ |
---|---|---|---|---|
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf | UNDOTBS1 | 95 | YES | ONLINE |
● 临时段
FILE_NAME | SIZE_M | STATUS | AUT |
---|---|---|---|
/u01/app/oracle/oradata/oradg11g/temp01.dbf | 29 | ONLINE | YES |
● 普通段
FILE_NAME | TABLESPACE_NAME | STATUS | SIZE_M | AUT |
---|---|---|---|---|
/u01/app/oracle/oradata/oradg11g/users01.dbf | USERS | AVAILABLE | 41.25 | YES |
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf | UNDOTBS1 | AVAILABLE | 95 | YES |
/u01/app/oracle/oradata/oradg11g/sysaux01.dbf | SYSAUX | AVAILABLE | 580 | YES |
/u01/app/oracle/oradata/oradg11g/system01.dbf | SYSTEM | AVAILABLE | 860 | YES |
/u01/app/oracle/oradata/oradg11g/example01.dbf | EXAMPLE | AVAILABLE | 345.625 | YES |
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | LOGMNRTBS | AVAILABLE | 355 | YES |
● 所有段
FILE_ID | TABLESPACE_NAME | TS_SIZE_M | FILE_NAME | FILE_SIZE_M | FILE_MAX_SIZE | AUT | INCREMENT_BY | STATUS | INCREMENT_BY_BLOCK | BYTES | BLOCKS | MAXBYTES | MAXBLOCKS | USER_BYTES | USER_BLOCKS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | EXAMPLE | 345.625 | /u01/app/oracle/oradata/oradg11g/example01.dbf | 345.625 | 32767.984 | YES | .625 | AVAILABLE | 80 | 362414080 | 44240 | 3.4360E+10 | 4194302 | 361365504 | 44112 |
6 | LOGMNRTBS | 355 | /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | 355 | 2000 | YES | 5 | AVAILABLE | 640 | 372244480 | 45440 | 2097152000 | 256000 | 371195904 | 45312 |
2 | SYSAUX | 580 | /u01/app/oracle/oradata/oradg11g/sysaux01.dbf | 580 | 32767.984 | YES | 10 | AVAILABLE | 1280 | 608174080 | 74240 | 3.4360E+10 | 4194302 | 607125504 | 74112 |
1 | SYSTEM | 860 | /u01/app/oracle/oradata/oradg11g/system01.dbf | 860 | 32767.984 | YES | 10 | AVAILABLE | 1280 | 901775360 | 110080 | 3.4360E+10 | 4194302 | 900726784 | 109952 |
1 | TEMP | 29 | /u01/app/oracle/oradata/oradg11g/temp01.dbf | 29 | 32767.984 | YES | .625 | ONLINE | 80 | 30408704 | 3712 | 3.4360E+10 | 4194302 | 29360128 | 3584 |
3 | UNDOTBS1 | 95 | /u01/app/oracle/oradata/oradg11g/undotbs01.dbf | 95 | 32767.984 | YES | 5 | AVAILABLE | 640 | 99614720 | 12160 | 3.4360E+10 | 4194302 | 98566144 | 12032 |
4 | USERS | 41.25 | /u01/app/oracle/oradata/oradg11g/users01.dbf | 41.25 | 32767.984 | YES | 1.25 | AVAILABLE | 160 | 43253760 | 5280 | 3.4360E+10 | 4194302 | 42205184 | 5152 |
Tablespace Name | Owner | Segment Type | Size (in Bytes) | Segment Count |
---|---|---|---|---|
EXAMPLE |
HR
|
INDEX
|
1,245,184 | 19 |
HR
|
TABLE
|
393,216 | 6 | |
IX
|
INDEX
|
917,504 | 14 | |
IX
|
LOBINDEX
|
196,608 | 3 | |
IX
|
LOBSEGMENT
|
196,608 | 3 | |
IX
|
TABLE
|
524,288 | 8 | |
OE
|
INDEX
|
2,162,688 | 22 | |
OE
|
LOBINDEX
|
327,680 | 5 | |
OE
|
LOBSEGMENT
|
393,216 | 5 | |
OE
|
TABLE
|
3,735,552 | 8 | |
PM
|
INDEX
|
262,144 | 4 | |
PM
|
LOBINDEX
|
1,114,112 | 17 | |
PM
|
LOBSEGMENT
|
11,206,656 | 17 | |
PM
|
NESTED TABLE
|
65,536 | 1 | |
PM
|
TABLE
|
196,608 | 2 | |
SH
|
INDEX PARTITION
|
11,141,120 | 112 | |
SH
|
INDEX
|
2,490,368 | 19 | |
SH
|
LOBINDEX
|
131,072 | 2 | |
SH
|
LOBSEGMENT
|
131,072 | 2 | |
SH
|
TABLE PARTITION
|
268,435,456 | 32 | |
SH
|
TABLE
|
18,874,368 | 12 | |
LOGMNRTBS |
SYSTEM
|
INDEX PARTITION
|
23,199,744 | 104 |
SYSTEM
|
INDEX
|
917,504 | 14 | |
SYSTEM
|
LOBINDEX
|
589,824 | 6 | |
SYSTEM
|
LOBSEGMENT
|
4,521,984 | 6 | |
SYSTEM
|
TABLE PARTITION
|
73,662,464 | 76 | |
SYSTEM
|
TABLE
|
917,504 | 14 | |
SYSAUX |
APEX_030200
|
INDEX
|
39,976,960 | 262 |
APEX_030200
|
LOBINDEX
|
3,276,800 | 50 | |
APEX_030200
|
LOBSEGMENT
|
10,420,224 | 50 | |
APEX_030200
|
TABLE
|
35,913,728 | 105 | |
CTXSYS
|
INDEX
|
2,490,368 | 38 | |
CTXSYS
|
LOBINDEX
|
131,072 | 2 | |
CTXSYS
|
LOBSEGMENT
|
131,072 | 2 | |
CTXSYS
|
TABLE
|
1,179,648 | 17 | |
DBSNMP
|
INDEX
|
327,680 | 5 | |
DBSNMP
|
TABLE
|
196,608 | 3 | |
EXFSYS
|
INDEX
|
2,424,832 | 37 | |
EXFSYS
|
LOBINDEX
|
65,536 | 1 | |
EXFSYS
|
LOBSEGMENT
|
65,536 | 1 | |
EXFSYS
|
TABLE
|
1,245,184 | 19 | |
MDSYS
|
INDEX
|
7,405,568 | 98 | |
MDSYS
|
LOBINDEX
|
12,976,128 | 197 | |
MDSYS
|
LOBSEGMENT
|
41,877,504 | 197 | |
MDSYS
|
NESTED TABLE
|
1,048,576 | 16 | |
MDSYS
|
TABLE
|
14,221,312 | 64 | |
OLAPSYS
|
INDEX
|
5,242,880 | 80 | |
OLAPSYS
|
TABLE
|
3,997,696 | 61 | |
ORDDATA
|
INDEX
|
6,946,816 | 95 | |
ORDDATA
|
LOBINDEX
|
393,216 | 6 | |
ORDDATA
|
LOBSEGMENT
|
3,014,656 | 6 | |
ORDDATA
|
NESTED TABLE
|
131,072 | 2 | |
ORDDATA
|
TABLE
|
3,735,552 | 51 | |
ORDSYS
|
INDEX
|
196,608 | 3 | |
ORDSYS
|
TABLE
|
262,144 | 4 | |
SYS
|
CLUSTER
|
2,097,152 | 1 | |
SYS
|
INDEX PARTITION
|
4,521,984 | 54 | |
SYS
|
INDEX
|
37,355,520 | 358 | |
SYS
|
LOB PARTITION
|
65,536 | 1 | |
SYS
|
LOBINDEX
|
4,063,232 | 62 | |
SYS
|
LOBSEGMENT
|
45,744,128 | 62 | |
SYS
|
TABLE PARTITION
|
4,784,128 | 51 | |
SYS
|
TABLE SUBPARTITION
|
2,097,152 | 32 | |
SYS
|
TABLE
|
35,913,728 | 302 | |
SYSMAN
|
INDEX
|
24,969,216 | 301 | |
SYSMAN
|
LOBINDEX
|
2,818,048 | 43 | |
SYSMAN
|
LOBSEGMENT
|
3,407,872 | 43 | |
SYSMAN
|
NESTED TABLE
|
131,072 | 2 | |
SYSMAN
|
TABLE
|
16,842,752 | 190 | |
SYSTEM
|
INDEX
|
524,288 | 8 | |
SYSTEM
|
LOBINDEX
|
131,072 | 2 | |
SYSTEM
|
LOBSEGMENT
|
131,072 | 2 | |
SYSTEM
|
TABLE PARTITION
|
65,536 | 1 | |
SYSTEM
|
TABLE
|
655,360 | 10 | |
WMSYS
|
INDEX
|
1,966,080 | 30 | |
WMSYS
|
LOBINDEX
|
327,680 | 5 | |
WMSYS
|
LOBSEGMENT
|
327,680 | 5 | |
WMSYS
|
NESTED TABLE
|
131,072 | 2 | |
WMSYS
|
TABLE
|
917,504 | 14 | |
XDB
|
INDEX
|
9,502,720 | 109 | |
XDB
|
LOBINDEX
|
38,338,560 | 585 | |
XDB
|
LOBSEGMENT
|
95,223,808 | 585 | |
XDB
|
NESTED TABLE
|
655,360 | 10 | |
XDB
|
TABLE
|
21,626,880 | 83 | |
SYSTEM |
OUTLN
|
INDEX
|
262,144 | 4 |
OUTLN
|
LOBINDEX
|
65,536 | 1 | |
OUTLN
|
LOBSEGMENT
|
65,536 | 1 | |
OUTLN
|
TABLE
|
196,608 | 3 | |
SYS
|
CLUSTER
|
51,707,904 | 9 | |
SYS
|
INDEX
|
148,373,504 | 642 | |
SYS
|
LOBINDEX
|
7,602,176 | 116 | |
SYS
|
LOBSEGMENT
|
20,578,304 | 116 | |
SYS
|
NESTED TABLE
|
1,048,576 | 16 | |
SYS
|
ROLLBACK
|
393,216 | 1 | |
SYS
|
TABLE
|
520,880,128 | 531 | |
SYSTEM
|
INDEX
|
9,043,968 | 138 | |
SYSTEM
|
LOBINDEX
|
917,504 | 14 | |
SYSTEM
|
LOBSEGMENT
|
917,504 | 14 | |
SYSTEM
|
TABLE
|
5,898,240 | 90 | |
UNDOTBS1 |
SYS
|
TYPE2 UNDO
|
36,175,872 | 10 |
USERS |
LHR
|
TABLE
|
35,979,264 | 6 |
OE
|
INDEX
|
786,432 | 11 | |
OE
|
LOBINDEX
|
655,360 | 10 | |
OE
|
LOBSEGMENT
|
655,360 | 10 | |
OE
|
NESTED TABLE
|
589,824 | 4 | |
OE
|
TABLE
|
196,608 | 2 | |
SCOTT
|
INDEX
|
131,072 | 2 | |
SCOTT
|
TABLE
|
196,608 | 3 | |
*************************************************************************** | -------------------- | ---------------- | ||
Total: | 1,825,898,496 | 6,712 |
● dba_jobs
作业ID | 用户 | 作业内容 | 下一次运行时间 | 间隔 | 上一次运行时间 | 失败次数 | 是否损坏? |
---|---|---|---|---|---|---|---|
4001
|
SYS | wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24); |
2015-08-26 23:24:32
|
sysdate + 8/24 |
2015-08-26 15:24:32
|
0
|
N
|
4002
|
SYS | wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'),wwv_flow_platform.get_preference('SMTP_HOST_PORT')); |
2015-08-26 16:14:45
|
sysdate + 10/1440 |
2015-08-26 16:04:45
|
0
|
N
|
● dba_scheduler_jobs
INSTANCE_ID | JOB_CREATOR | OWNER | JOB_NAME | JOB_STATE | COMMENTS | I | JOB_TYPE | JOB_ACTION | JOB_STYLE | PROGRAM_OWNER | PROGRAM_NAME | SCHEDULE_TYP | REPEAT_INTERVAL | START_DATE | END_DATE | NEXT_RUN_DATE | LAST_START_DATE | LAST_RUN_DURATION | START_DATE | RUN_COUNT | NUMBER_OF_ARGUMENTS | ENABL | AUTO_ | MAX_RUN_DURATION | MAX_FAILURES | MAX_RUNS | LOGGING_LEV | IS_SY | RUNNING_INSTANCE | CPU_USED | USERNAME | SID | SERIAL# | SPID | STATUS | COMMAND | LOGON_TIME | OSUSER |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SYS | SYS | FGR$AUTOPURGE_JOB | DISABLED | file group auto-purge job | N | PLSQL_BLOCK | sys.dbms_file_group.purge_file_group(NULL); | REGULAR | CALENDAR | freq=daily;byhour=0;byminute=0;bysecond=0 | 0 | 0 | FALSE | TRUE | OFF | TRUE | ||||||||||||||||||||||
SYS | SYS | FILE_WATCHER | DISABLED | File watcher job | N | REGULAR | SYS | FILE_WATCHER_PROGRAM | NAMED | 0 | FALSE | FALSE | OFF | TRUE | ||||||||||||||||||||||||
SYS | SYS | HM_CREATE_OFFLINE_DICTIONARY | DISABLED | Create offline dictionary in ADR for DRA name translation | N | STORED_PROCEDURE | dbms_hm.create_offline_dictionary | REGULAR | WINDOW_GROUP | 0 | 0 | FALSE | FALSE | OFF | TRUE | |||||||||||||||||||||||
SYS | SYS | XMLDB_NFS_CLEANUP_JOB | DISABLED | N | STORED_PROCEDURE | xdb.dbms_xdbutil_int.cleanup_expired_nfsclients | REGULAR | CALENDAR | Freq=minutely;interval=5 | 0 | 0 | FALSE | TRUE | OFF | TRUE | |||||||||||||||||||||||
SYS | SYS | BSLN_MAINTAIN_STATS_JOB | SCHEDULED | Oracle defined automatic moving window baseline statistics computation job | N | REGULAR | SYS | BSLN_MAINTAIN_STATS_PROG | NAMED | 2011-09-18 00:00:00 | 2015-08-30 00:00:00 | 2015-08-23 02:35:47 | +000000000 00:00:05.752290 | 18-SEP-11 12.00.00.000000 AM -07:00 | 8 | TRUE | FALSE | OFF | TRUE | |||||||||||||||||||
SYS | SYS | DRA_REEVALUATE_OPEN_FAILURES | SCHEDULED | Reevaluate open failures for DRA | N | STORED_PROCEDURE | dbms_ir.reevaluateopenfailures | REGULAR | WINDOW_GROUP | 2015-08-02 00:50:42 | +000000000 00:00:00.994666 | 5 | 4 | TRUE | FALSE | OFF | TRUE | |||||||||||||||||||||
SYS | ORACLE_OCM | MGMT_CONFIG_JOB | SCHEDULED | Configuration collection job. | N | STORED_PROCEDURE | ORACLE_OCM.MGMT_CONFIG.collect_config | REGULAR | WINDOW_GROUP | 2015-08-02 00:50:42 | +000000000 00:00:01.888136 | 5 | 0 | TRUE | FALSE | OFF | FALSE | |||||||||||||||||||||
SYS | ORACLE_OCM | MGMT_STATS_CONFIG_JOB | SCHEDULED | OCM Statistics collection job. | N | STORED_PROCEDURE | ORACLE_OCM.MGMT_CONFIG.collect_stats | REGULAR | CALENDAR | freq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=01 | 2011-09-17 09:52:15 | 2015-09-01 01:01:01 | 2015-08-02 00:50:42 | +000000000 00:00:02.030012 | 17-SEP-11 09.52.15.221975 AM -07:00 | 3 | 0 | TRUE | FALSE | OFF | FALSE | |||||||||||||||||
SYS | SYS | ORA$AUTOTASK_CLEAN | SCHEDULED | Delete obsolete AUTOTASK repository data | N | REGULAR | SYS | ORA$AGE_AUTOTASK_DATA | NAMED | 2011-09-18 03:00:00 | 2015-08-26 03:00:00 | 2015-08-26 00:24:33 | +000000000 00:00:00.006193 | 18-SEP-11 03.00.00.000000 AM PST8PDT | 24 | TRUE | FALSE | OFF | TRUE | |||||||||||||||||||
SYS | SYS | PURGE_LOG | SCHEDULED | purge log job | N | REGULAR | SYS | PURGE_LOG_PROG | NAMED | 2011-09-18 03:00:00 | 2015-08-26 03:00:00 | 2015-08-26 00:24:33 | +000000000 00:00:00.244195 | 18-SEP-11 03.00.00.200000 AM PST8PDT | 24 | TRUE | FALSE | OFF | TRUE | |||||||||||||||||||
SYS | EXFSYS | RLM$EVTCLEANUP | SCHEDULED | N | PLSQL_BLOCK | begin dbms_rlmgr_dr.cleanup_events; end; | REGULAR | CALENDAR | FREQ = HOURLY; INTERVAL = 1 | 2011-09-17 10:00:15 | 2015-08-26 02:00:15 | 2015-08-26 01:00:25 | +000000000 00:00:00.033407 | 17-SEP-11 10.00.15.000000 AM -07:00 | 128 | 0 | TRUE | FALSE | OFF | FALSE | ||||||||||||||||||
SYS | EXFSYS | RLM$SCHDNEGACTION | SCHEDULED | N | PLSQL_BLOCK | begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end; | REGULAR | CALENDAR | FREQ=MINUTELY;INTERVAL=60 | 2015-08-26 16:22:08 | 2015-08-26 16:22:08 | 2015-08-26 15:24:32 | +000000000 00:00:00.183255 | 26-AUG-15 04.22.08.000000 PM +08:00 | 123 | 0 | TRUE | FALSE | OFF | FALSE | ||||||||||||||||||
SYS | SYS | RSE$CLEAN_RECOVERABLE_SCRIPT | SCHEDULED | auto clean job for recoverable script | N | PLSQL_BLOCK | sys.dbms_streams_auto_int.clean_recoverable_script; | REGULAR | CALENDAR | freq=daily;byhour=0;byminute=0;bysecond=0 | 2011-09-17 09:52:27 | 2015-08-27 00:00:00 | 2015-08-26 00:24:32 | +000000000 00:00:00.050735 | 17-SEP-11 09.52.27.122955 AM PST8PDT | 25 | 0 | TRUE | TRUE | OFF | TRUE | |||||||||||||||||
SYS | SYS | SM$CLEAN_AUTO_SPLIT_MERGE | SCHEDULED | auto clean job for auto split merge | N | PLSQL_BLOCK | sys.dbms_streams_auto_int.clean_auto_split_merge; | REGULAR | CALENDAR | freq=daily;byhour=0;byminute=0;bysecond=0 | 2011-09-17 09:52:27 | 2015-08-27 00:00:00 | 2015-08-26 00:24:32 | +000000000 00:00:00.025368 | 17-SEP-11 09.52.27.133715 AM PST8PDT | 25 | 0 | TRUE | TRUE | OFF | TRUE |
备份名称 | 开始时间 | 花费时间 | 状态 | 输入类型 | 输出设备 | 输入大小 | 输出大小 | 每秒钟输出率 |
---|---|---|---|---|---|---|---|---|
2015-08-23T23:42:45
|
2015-08-23 23:42:48
|
00:00:60
|
COMPLETED
|
DB FULL |
2.24G
|
13.30M
|
227.07K
|
|
2015-08-23T21:55:49
|
2015-08-23 21:55:54
|
00:05:02
|
COMPLETED
|
DB FULL |
2.24G
|
4.59M
|
15.55K
|
|
2015-07-27T00:26:45
|
2015-07-27 00:30:42
|
00:02:05
|
COMPLETED
|
DB FULL | DISK |
1.63G
|
1.17G
|
9.63M
|
All non-default RMAN configuration settings
BS Key | Backup Type | Device Type | Controlfile Included? | SPFILE Included? | Incremental Level | # of Pieces | Start Time | End Time | Elapsed Seconds | Tag | Block Size | Keep? | Keep Until | Keep Options |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
---------------- | -------------------- | |||||||||||||
Total: |
Available automatic control files within all available (and expired) backup sets
Available automatic SPFILE backups within all available (and expired) backup sets
Parameter Name | Parameter Value |
---|---|
log_archive_config | DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss) |
log_archive_dest | |
log_archive_dest_1 | LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) |
log_archive_dest_10 | |
log_archive_dest_11 | |
log_archive_dest_12 | |
log_archive_dest_13 | |
log_archive_dest_14 | |
log_archive_dest_15 | |
log_archive_dest_16 | |
log_archive_dest_17 | |
log_archive_dest_18 | |
log_archive_dest_19 | |
log_archive_dest_2 | SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_20 | |
log_archive_dest_21 | |
log_archive_dest_22 | |
log_archive_dest_23 | |
log_archive_dest_24 | |
log_archive_dest_25 | |
log_archive_dest_26 | |
log_archive_dest_27 | |
log_archive_dest_28 | |
log_archive_dest_29 | |
log_archive_dest_3 | SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_30 | |
log_archive_dest_31 | |
log_archive_dest_4 | SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_5 | |
log_archive_dest_6 | |
log_archive_dest_7 | |
log_archive_dest_8 | |
log_archive_dest_9 | |
log_archive_dest_state_1 | ENABLE |
log_archive_dest_state_10 | enable |
log_archive_dest_state_11 | enable |
log_archive_dest_state_12 | enable |
log_archive_dest_state_13 | enable |
log_archive_dest_state_14 | enable |
log_archive_dest_state_15 | enable |
log_archive_dest_state_16 | enable |
log_archive_dest_state_17 | enable |
log_archive_dest_state_18 | enable |
log_archive_dest_state_19 | enable |
log_archive_dest_state_2 | ENABLE |
log_archive_dest_state_20 | enable |
log_archive_dest_state_21 | enable |
log_archive_dest_state_22 | enable |
log_archive_dest_state_23 | enable |
log_archive_dest_state_24 | enable |
log_archive_dest_state_25 | enable |
log_archive_dest_state_26 | enable |
log_archive_dest_state_27 | enable |
log_archive_dest_state_28 | enable |
log_archive_dest_state_29 | enable |
log_archive_dest_state_3 | ENABLE |
log_archive_dest_state_30 | enable |
log_archive_dest_state_31 | enable |
log_archive_dest_state_4 | ENABLE |
log_archive_dest_state_5 | enable |
log_archive_dest_state_6 | enable |
log_archive_dest_state_7 | enable |
log_archive_dest_state_8 | enable |
log_archive_dest_state_9 | enable |
log_archive_duplex_dest | |
log_archive_format | %t_%s_%r.dbf |
log_archive_local_first | TRUE |
log_archive_max_processes | 4 |
log_archive_min_succeed_dest | 1 |
log_archive_start | FALSE |
log_archive_trace | 0 |
log_buffer | 8110080 |
log_checkpoint_interval | 0 |
log_checkpoint_timeout | 1800 |
log_checkpoints_to_alert | FALSE |
log_file_name_convert | oradglg, oradg11g |
实例名称 | 归档日期 | 每天归档日志量(MB) | 每小时平均归档日志量(MB) |
---|---|---|---|
1
|
2015-08-26
|
4
|
.18
|
2015-08-24
|
53
|
2.21
|
|
2015-08-23
|
36
|
1.48
|
|
2015-08-02
|
398
|
16.6
|
|
2015-07-27
|
38
|
1.58
|
|
2015-07-26
|
1
|
.04
|
实例名称 | 归档日期 | 每天归档日志量(MB) | 每小时平均归档日志量(MB) |
---|---|---|---|
1
|
2015-08-26
|
4
|
.18
|
2015-08-24
|
53
|
2.21
|
|
2015-08-23
|
36
|
1.48
|
● 进而观察DB_RECOVERY_FILE_DEST_SIZ参数,后续可以考虑crosscheck archivelog all; delete expired archivelog all;
NAME | SPACE_LIMIT_M | SPACE_USED_M | PERCENT_SPACE_USED | SPACE_RECLAIMABLE | PERCENT_SPACE_RECLAIMABLE | NUMBER_OF_FILES |
---|---|---|---|---|---|---|
/u01/app/oracle/flash_recovery_area | 4122 | 614.332031 | .15 | 471.23 | .11 | 63 |
CONTROL FILE | 4122 | 0 | 0 | 0 | 0 | 0 |
REDO LOG | 4122 | 0 | 0 | 0 | 0 | 0 |
ARCHIVED LOG | 4122 | 93.16 | 2.26 | 0 | 0 | 45 |
BACKUP PIECE | 4122 | 0 | 0 | 0 | 0 | 0 |
IMAGE COPY | 4122 | 0 | 0 | 0 | 0 | 0 |
FLASHBACK LOG | 4122 | 500 | 12.13 | 450.12 | 10.92 | 10 |
FOREIGN ARCHIVED LOG | 4122 | 21.43 | .52 | 21.02 | .51 | 8 |
---DISABLED | 4122 | 0 | 0 | 1 |
● 注意观察各行里first_time之间的时间差异会不会很短,很短就是切换过频繁
THREAD# | SEQUENCE# | FIRST_TIME | END_TIME | TOTAL_MIN | LOGSIZE_M |
---|---|---|---|---|---|
1 | 90 | 2015-08-26 15:29:26 | 2015-08-26 15:29:26 | 0 | 3.818 |
1 | 90 | 2015-08-26 15:29:26 | 2015-08-26 15:54:33 | 25.12 | 3.818 |
1 | 90 | 2015-08-26 15:29:26 | 2015-08-26 15:29:26 | 0 | 3.818 |
1 | 90 | 2015-08-26 15:29:26 | 2015-08-26 15:29:26 | 0 | 3.818 |
1 | 89 | 2015-08-26 15:28:56 | 2015-08-26 15:28:56 | 0 | .041 |
1 | 89 | 2015-08-26 15:28:56 | 2015-08-26 15:29:26 | .5 | .041 |
1 | 89 | 2015-08-26 15:28:56 | 2015-08-26 15:28:56 | 0 | .041 |
1 | 89 | 2015-08-26 15:28:56 | 2015-08-26 15:28:56 | 0 | .041 |
1 | 88 | 2015-08-26 15:24:28 | 2015-08-26 15:24:28 | 0 | .522 |
1 | 88 | 2015-08-26 15:24:28 | 2015-08-26 15:28:56 | 4.47 | .522 |
1 | 88 | 2015-08-26 15:24:28 | 2015-08-26 15:24:28 | 0 | .522 |
1 | 88 | 2015-08-26 15:24:28 | 2015-08-26 15:24:28 | 0 | .522 |
1 | 87 | 2015-08-26 15:24:24 | 2015-08-26 15:24:24 | 0 | .037 |
1 | 87 | 2015-08-26 15:24:24 | 2015-08-26 15:24:28 | .07 | .037 |
1 | 87 | 2015-08-26 15:24:24 | 2015-08-26 15:24:24 | 0 | .037 |
1 | 87 | 2015-08-26 15:24:24 | 2015-08-26 15:24:24 | 0 | .037 |
1 | 86 | 2015-08-24 00:51:26 | 2015-08-24 00:51:26 | 0 | 2.071 |
1 | 86 | 2015-08-24 00:51:26 | 2015-08-26 15:24:24 | 3752.97 | 2.071 |
1 | 86 | 2015-08-24 00:51:26 | 2015-08-24 00:51:26 | 0 | 2.071 |
1 | 86 | 2015-08-24 00:51:26 | 2015-08-24 00:51:26 | 0 | 2.071 |
1 | 85 | 2015-08-24 00:49:17 | 2015-08-24 00:49:17 | 0 | .052 |
1 | 85 | 2015-08-24 00:49:17 | 2015-08-24 00:51:26 | 2.15 | .052 |
1 | 85 | 2015-08-24 00:49:17 | 2015-08-24 00:49:17 | 0 | .052 |
1 | 85 | 2015-08-24 00:49:17 | 2015-08-24 00:49:17 | 0 | .052 |
1 | 84 | 2015-08-24 00:49:04 | 2015-08-24 00:49:04 | 0 | .007 |
1 | 84 | 2015-08-24 00:49:04 | 2015-08-24 00:49:17 | .22 | .007 |
1 | 84 | 2015-08-24 00:49:04 | 2015-08-24 00:49:04 | 0 | .007 |
1 | 84 | 2015-08-24 00:49:04 | 2015-08-24 00:49:04 | 0 | .007 |
1 | 83 | 2015-08-24 00:48:28 | 2015-08-24 00:48:28 | 0 | .019 |
1 | 83 | 2015-08-24 00:48:28 | 2015-08-24 00:49:04 | .6 | .019 |
1 | 83 | 2015-08-24 00:48:28 | 2015-08-24 00:48:28 | 0 | .019 |
1 | 83 | 2015-08-24 00:48:28 | 2015-08-24 00:48:28 | 0 | .019 |
1 | 82 | 2015-08-24 00:46:34 | 2015-08-24 00:46:34 | 0 | .088 |
1 | 82 | 2015-08-24 00:46:34 | 2015-08-24 00:48:28 | 1.9 | .088 |
1 | 82 | 2015-08-24 00:46:34 | 2015-08-24 00:46:34 | 0 | .088 |
1 | 82 | 2015-08-24 00:46:34 | 2015-08-24 00:46:34 | 0 | .088 |
1 | 81 | 2015-08-24 00:43:16 | 2015-08-24 00:43:16 | 0 | .114 |
1 | 81 | 2015-08-24 00:43:16 | 2015-08-24 00:46:34 | 3.3 | .114 |
1 | 81 | 2015-08-24 00:43:16 | 2015-08-24 00:43:16 | 0 | .114 |
1 | 81 | 2015-08-24 00:43:16 | 2015-08-24 00:43:16 | 0 | .114 |
1 | 80 | 2015-08-24 00:43:07 | 2015-08-24 00:43:07 | 0 | .009 |
1 | 80 | 2015-08-24 00:43:07 | 2015-08-24 00:43:07 | 0 | .009 |
1 | 80 | 2015-08-24 00:43:07 | 2015-08-24 00:43:16 | .15 | .009 |
1 | 80 | 2015-08-24 00:43:07 | 2015-08-24 00:43:07 | 0 | .009 |
1 | 80 | 2015-08-24 00:43:07 | 2015-08-24 00:43:07 | 0 | .009 |
1 | 79 | 2015-08-24 00:42:45 | 2015-08-24 00:42:45 | 0 | 15.935 |
1 | 79 | 2015-08-24 00:42:45 | 2015-08-24 00:42:45 | 0 | 15.935 |
1 | 79 | 2015-08-24 00:42:45 | 2015-08-24 00:43:07 | .37 | 15.935 |
1 | 79 | 2015-08-24 00:42:45 | 2015-08-24 00:42:45 | 0 | 15.935 |
1 | 79 | 2015-08-24 00:42:45 | 2015-08-24 00:42:45 | 0 | 15.935 |
1 | 78 | 2015-08-24 00:39:28 | 2015-08-24 00:39:28 | 0 | 34.147 |
1 | 78 | 2015-08-24 00:39:28 | 2015-08-24 00:42:45 | 3.28 | 34.147 |
1 | 78 | 2015-08-24 00:39:28 | 2015-08-24 00:39:28 | 0 | 34.147 |
1 | 78 | 2015-08-24 00:39:28 | 2015-08-24 00:39:28 | 0 | 34.147 |
1 | 77 | 2015-08-24 00:37:27 | 2015-08-24 00:37:27 | 0 | .059 |
1 | 77 | 2015-08-24 00:37:27 | 2015-08-24 00:39:28 | 2.02 | .059 |
1 | 77 | 2015-08-24 00:37:27 | 2015-08-24 00:37:27 | 0 | .059 |
1 | 77 | 2015-08-24 00:37:27 | 2015-08-24 00:37:27 | 0 | .059 |
1 | 76 | 2015-08-24 00:35:33 | 2015-08-24 00:35:33 | 0 | .063 |
1 | 76 | 2015-08-24 00:35:33 | 2015-08-24 00:37:27 | 1.9 | .063 |
1 | 76 | 2015-08-24 00:35:33 | 2015-08-24 00:35:33 | 0 | .063 |
1 | 76 | 2015-08-24 00:35:33 | 2015-08-24 00:35:33 | 0 | .063 |
1 | 75 | 2015-08-24 00:35:09 | 2015-08-24 00:35:09 | 0 | .013 |
1 | 75 | 2015-08-24 00:35:09 | 2015-08-24 00:35:33 | .4 | .013 |
1 | 75 | 2015-08-24 00:35:09 | 2015-08-24 00:35:09 | 0 | .013 |
1 | 75 | 2015-08-24 00:35:09 | 2015-08-24 00:35:09 | 0 | .013 |
1 | 74 | 2015-08-24 00:34:21 | 2015-08-24 00:34:21 | 0 | .026 |
1 | 74 | 2015-08-24 00:34:21 | 2015-08-24 00:35:09 | .8 | .026 |
1 | 74 | 2015-08-24 00:34:21 | 2015-08-24 00:34:21 | 0 | .026 |
1 | 74 | 2015-08-24 00:34:21 | 2015-08-24 00:34:21 | 0 | .026 |
1 | 73 | 2015-08-24 00:34:20 | 2015-08-24 00:34:20 | 0 | .001 |
1 | 73 | 2015-08-24 00:34:20 | 2015-08-24 00:34:21 | .02 | .001 |
1 | 73 | 2015-08-24 00:34:20 | 2015-08-24 00:34:20 | 0 | .001 |
1 | 73 | 2015-08-24 00:34:20 | 2015-08-24 00:34:20 | 0 | .001 |
1 | 72 | 2015-08-24 00:31:50 | 2015-08-24 00:31:50 | 0 | .073 |
1 | 72 | 2015-08-24 00:31:50 | 2015-08-24 00:34:20 | 2.5 | .073 |
1 | 72 | 2015-08-24 00:31:50 | 2015-08-24 00:31:50 | 0 | .073 |
1 | 72 | 2015-08-24 00:31:50 | 2015-08-24 00:31:50 | 0 | .073 |
1 | 71 | 2015-08-24 00:29:25 | 2015-08-24 00:29:25 | 0 | .056 |
1 | 71 | 2015-08-24 00:29:25 | 2015-08-24 00:31:50 | 2.42 | .056 |
1 | 71 | 2015-08-24 00:29:25 | 2015-08-24 00:29:25 | 0 | .056 |
1 | 71 | 2015-08-24 00:29:25 | 2015-08-24 00:29:25 | 0 | .056 |
1 | 70 | 2015-08-24 00:19:28 | 2015-08-24 00:19:28 | 0 | .359 |
1 | 70 | 2015-08-24 00:19:28 | 2015-08-24 00:29:25 | 9.95 | .359 |
1 | 70 | 2015-08-24 00:19:28 | 2015-08-24 00:19:28 | 0 | .359 |
1 | 69 | 2015-08-23 23:54:16 | 2015-08-23 23:54:16 | 0 | 2.235 |
1 | 69 | 2015-08-23 23:54:16 | 2015-08-23 23:54:16 | 0 | 2.235 |
1 | 69 | 2015-08-23 23:54:16 | 2015-08-24 00:19:28 | 25.2 | 2.235 |
1 | 68 | 2015-08-23 23:52:56 | 2015-08-23 23:52:56 | 0 | .039 |
1 | 68 | 2015-08-23 23:52:56 | 2015-08-23 23:54:16 | 1.33 | .039 |
1 | 68 | 2015-08-23 23:52:56 | 2015-08-23 23:52:56 | 0 | .039 |
1 | 68 | 2015-08-23 23:52:56 | 2015-08-23 23:52:56 | 0 | .039 |
1 | 67 | 2015-08-23 23:38:22 | 2015-08-23 23:38:22 | 0 | .494 |
1 | 67 | 2015-08-23 23:38:22 | 2015-08-23 23:52:56 | 14.57 | .494 |
1 | 67 | 2015-08-23 23:38:22 | 2015-08-23 23:38:22 | 0 | .494 |
1 | 67 | 2015-08-23 23:38:22 | 2015-08-23 23:38:22 | 0 | .494 |
1 | 66 | 2015-08-23 23:33:32 | 2015-08-23 23:33:32 | 0 | .148 |
1 | 66 | 2015-08-23 23:33:32 | 2015-08-23 23:38:22 | 4.83 | .148 |
1 | 66 | 2015-08-23 23:33:32 | 2015-08-23 23:33:32 | 0 | .148 |
1 | 66 | 2015-08-23 23:33:32 | 2015-08-23 23:33:32 | 0 | .148 |
1 | 65 | 2015-08-23 23:19:50 | 2015-08-23 23:19:50 | 0 | .444 |
1 | 65 | 2015-08-23 23:19:50 | 2015-08-23 23:33:32 | 13.7 | .444 |
1 | 65 | 2015-08-23 23:19:50 | 2015-08-23 23:19:50 | 0 | .444 |
1 | 65 | 2015-08-23 23:19:50 | 2015-08-23 23:19:50 | 0 | .444 |
1 | 64 | 2015-08-23 23:13:50 | 2015-08-23 23:13:50 | 0 | .178 |
1 | 64 | 2015-08-23 23:13:50 | 2015-08-23 23:19:50 | 6 | .178 |
1 | 64 | 2015-08-23 23:13:50 | 2015-08-23 23:13:50 | 0 | .178 |
1 | 64 | 2015-08-23 23:13:50 | 2015-08-23 23:13:50 | 0 | .178 |
1 | 63 | 2015-08-23 23:05:24 | 2015-08-23 23:05:24 | 0 | .528 |
1 | 63 | 2015-08-23 23:05:24 | 2015-08-23 23:13:50 | 8.43 | .528 |
1 | 63 | 2015-08-23 23:05:24 | 2015-08-23 23:05:24 | 0 | .528 |
1 | 63 | 2015-08-23 23:05:24 | 2015-08-23 23:05:24 | 0 | .528 |
1 | 62 | 2015-08-23 22:59:45 | 2015-08-23 22:59:45 | 0 | 1.363 |
1 | 62 | 2015-08-23 22:59:45 | 2015-08-23 23:05:24 | 5.65 | 1.363 |
1 | 62 | 2015-08-23 22:59:45 | 2015-08-23 22:59:45 | 0 | 1.363 |
1 | 62 | 2015-08-23 22:59:45 | 2015-08-23 22:59:45 | 0 | 1.363 |
1 | 61 | 2015-08-23 22:45:14 | 2015-08-23 22:45:14 | 0 | .44 |
1 | 61 | 2015-08-23 22:45:14 | 2015-08-23 22:59:45 | 14.52 | .44 |
1 | 61 | 2015-08-23 22:45:14 | 2015-08-23 22:45:14 | 0 | .44 |
1 | 61 | 2015-08-23 22:45:14 | 2015-08-23 22:45:14 | 0 | .44 |
1 | 60 | 2015-08-23 22:35:37 | 2015-08-23 22:35:37 | 0 | .304 |
1 | 60 | 2015-08-23 22:35:37 | 2015-08-23 22:45:14 | 9.62 | .304 |
1 | 60 | 2015-08-23 22:35:37 | 2015-08-23 22:35:37 | 0 | .304 |
1 | 60 | 2015-08-23 22:35:37 | 2015-08-23 22:35:37 | 0 | .304 |
1 | 59 | 2015-08-23 22:28:21 | 2015-08-23 22:28:21 | 0 | .204 |
1 | 59 | 2015-08-23 22:28:21 | 2015-08-23 22:35:37 | 7.27 | .204 |
1 | 59 | 2015-08-23 22:28:21 | 2015-08-23 22:28:21 | 0 | .204 |
1 | 59 | 2015-08-23 22:28:21 | 2015-08-23 22:28:21 | 0 | .204 |
1 | 58 | 2015-08-23 21:19:46 | 2015-08-23 21:19:46 | 0 | 3.721 |
1 | 58 | 2015-08-23 21:19:46 | 2015-08-23 22:28:21 | 68.58 | 3.721 |
1 | 58 | 2015-08-23 21:19:46 | 2015-08-23 21:19:46 | 0 | 3.721 |
1 | 58 | 2015-08-23 21:19:46 | 2015-08-23 21:19:46 | 0 | 3.721 |
1 | 57 | 2015-08-23 20:57:15 | 2015-08-23 20:57:15 | 0 | 2.45 |
1 | 57 | 2015-08-23 20:57:15 | 2015-08-23 21:19:46 | 22.52 | 2.45 |
1 | 57 | 2015-08-23 20:57:15 | 2015-08-23 20:57:15 | 0 | 2.45 |
1 | 57 | 2015-08-23 20:57:15 | 2015-08-23 20:57:15 | 0 | 2.45 |
1 | 56 | 2015-08-23 20:56:56 | 2015-08-23 20:56:56 | 0 | .012 |
1 | 56 | 2015-08-23 20:56:56 | 2015-08-23 20:57:15 | .32 | .012 |
1 | 56 | 2015-08-23 20:56:56 | 2015-08-23 20:56:56 | 0 | .012 |
1 | 56 | 2015-08-23 20:56:56 | 2015-08-23 20:56:56 | 0 | .012 |
1 | 55 | 2015-08-23 20:56:52 | 2015-08-23 20:56:56 | .07 | .002 |
1 | 54 | 2015-08-23 20:55:07 | 2015-08-23 20:56:52 | 1.75 | .091 |
1 | 53 | 2015-08-23 20:55:05 | 2015-08-23 20:55:05 | 0 | .001 |
1 | 53 | 2015-08-23 20:55:05 | 2015-08-23 20:55:07 | .03 | .001 |
1 | 53 | 2015-08-23 20:55:05 | 2015-08-23 20:55:05 | 0 | .001 |
1 | 53 | 2015-08-23 20:55:05 | 2015-08-23 20:55:05 | 0 | .001 |
1 | 52 | 2015-08-23 20:54:57 | 2015-08-23 20:54:57 | 0 | .004 |
1 | 52 | 2015-08-23 20:54:57 | 2015-08-23 20:55:05 | .13 | .004 |
1 | 52 | 2015-08-23 20:54:57 | 2015-08-23 20:54:57 | 0 | .004 |
1 | 52 | 2015-08-23 20:54:57 | 2015-08-23 20:54:57 | 0 | .004 |
1 | 51 | 2015-08-23 20:54:56 | 2015-08-23 20:54:56 | 0 | .001 |
1 | 51 | 2015-08-23 20:54:56 | 2015-08-23 20:54:57 | .02 | .001 |
1 | 51 | 2015-08-23 20:54:56 | 2015-08-23 20:54:56 | 0 | .001 |
1 | 51 | 2015-08-23 20:54:56 | 2015-08-23 20:54:56 | 0 | .001 |
1 | 50 | 2015-08-23 20:54:54 | 2015-08-23 20:54:54 | 0 | .001 |
1 | 50 | 2015-08-23 20:54:54 | 2015-08-23 20:54:56 | .03 | .001 |
1 | 50 | 2015-08-23 20:54:54 | 2015-08-23 20:54:54 | 0 | .001 |
1 | 50 | 2015-08-23 20:54:54 | 2015-08-23 20:54:54 | 0 | .001 |
1 | 49 | 2015-08-23 19:23:13 | 2015-08-23 19:23:13 | 0 | 5.976 |
1 | 49 | 2015-08-23 19:23:13 | 2015-08-23 20:54:54 | 91.68 | 5.976 |
1 | 49 | 2015-08-23 19:23:13 | 2015-08-23 19:23:13 | 0 | 5.976 |
1 | 49 | 2015-08-23 19:23:13 | 2015-08-23 19:23:13 | 0 | 5.976 |
1 | 48 | 2015-08-23 19:23:11 | 2015-08-23 19:23:11 | 0 | .001 |
1 | 48 | 2015-08-23 19:23:11 | 2015-08-23 19:23:13 | .03 | .001 |
1 | 48 | 2015-08-23 19:23:11 | 2015-08-23 19:23:11 | 0 | .001 |
1 | 48 | 2015-08-23 19:23:11 | 2015-08-23 19:23:11 | 0 | .001 |
1 | 47 | 2015-08-23 17:40:38 | 2015-08-23 17:40:38 | 0 | 16.55 |
1 | 47 | 2015-08-23 17:40:38 | 2015-08-23 19:23:11 | 102.55 | 16.55 |
1 | 47 | 2015-08-23 17:40:38 | 2015-08-23 17:40:38 | 0 | 16.55 |
1 | 47 | 2015-08-23 17:40:38 | 2015-08-23 17:40:38 | 0 | 16.55 |
1 | 46 | 2015-08-23 17:35:22 | 2015-08-23 17:35:22 | 0 | .402 |
1 | 46 | 2015-08-23 17:35:22 | 2015-08-23 17:40:38 | 5.27 | .402 |
1 | 46 | 2015-08-23 17:35:22 | 2015-08-23 17:35:22 | 0 | .402 |
1 | 46 | 2015-08-23 17:35:22 | 2015-08-23 17:35:22 | 0 | .402 |
1 | 45 | 2015-08-23 17:35:19 | 2015-08-23 17:35:22 | .05 | .001 |
1 | 45 | 2015-08-23 17:35:19 | 2015-08-23 17:35:19 | 0 | .001 |
● 即可分析10天的波度,又可分析24小时内,可很容易看出异常情况
THREAD# | DAY | H00 | H01 | H02 | H03 | H04 | H05 | H06 | H07 | H08 | H09 | H10 | H11 | H12 | H13 | H14 | H15 | H16 | H17 | H18 | H19 | H20 | H21 | H22 | H23 | TOTAL |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 08/26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 |
1 | 08/24 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 |
1 | 08/23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 8 | 1 | 4 | 7 | 25 |
GROUP# | THREAD# | SEQUENCE# | SIZE_M | STATUS | ARC | MEMBERS | MEMBER | TYPE |
---|---|---|---|---|---|---|---|---|
1 | 1 | 90 | 50 | INACTIVE | YES | 1 | /u01/app/oracle/oradata/oradg11g/redo01.log | ONLINE |
2 | 1 | 91 | 50 | CURRENT | NO | 1 | /u01/app/oracle/oradata/oradg11g/redo02.log | ONLINE |
3 | 1 | 89 | 50 | INACTIVE | YES | 1 | /u01/app/oracle/oradata/oradg11g/redo03.log | ONLINE |
实例名称 | 名称 | 值(MB) | 是否可调 |
---|---|---|---|
1 | Fixed SGA Size | 2 | No |
1 | Redo Buffers | 8 | No |
1 | Buffer Cache Size | 20 | Yes |
1 | Shared Pool Size | 152 | Yes |
1 | Large Pool Size | 4 | Yes |
1 | Java Pool Size | 4 | Yes |
1 | Streams Pool Size | 0 | Yes |
1 | Shared IO Pool Size | 0 | Yes |
1 | Granule Size | 4 | No |
1 | Maximum SGA Size | 398 | No |
1 | Startup overhead in Shared Pool | 64 | No |
1 | Free SGA Memory Available | 208 |
Instance Name | Pool Name | Bytes |
---|---|---|
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 |
Instance Name | Parameter Name | Value |
---|---|---|
oradg11g
|
sga_max_size |
419,430,400
|
sga_target |
0
|
Instance Name | SGA Size | SGA Size Factor | Estimated DB Time | Estimated DB Time Factor | Estimated Physical Reads |
---|---|---|---|---|---|
oradg11g
|
192 | 1 | 219 | 1 | 28,531 |
240 | 1 | 212 | 1 | 23,122 | |
288 | 2 | 209 | 1 | 23,122 | |
336 | 2 | 209 | 1 | 23,122 | |
384 | 2 | 209 | 1 | 23,122 |
Instance Name | Component Name | Current Size | Min Size | Max Size | User Specified Size | Oper. Count | Last Oper. Type | Last Oper. Mode | Last Oper. Time | Granule Size |
---|---|---|---|---|---|---|---|---|---|---|
oradg11g
|
streams pool | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | |
shared pool | 159,383,552 | 159,383,552 | 163,577,856 | 0 | 1 | SHRINK | DEFERRED |
2015-08-26 15:25:03
|
4,194,304 | |
large pool | 4,194,304 | 4,194,304 | 4,194,304 | 0 | 0 | STATIC |
|
4,194,304 | ||
java pool | 4,194,304 | 4,194,304 | 4,194,304 | 0 | 0 | STATIC |
|
4,194,304 | ||
Shared IO Pool | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
RECYCLE buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
KEEP buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
DEFAULT buffer cache | 20,971,520 | 16,777,216 | 20,971,520 | 0 | 1 | GROW | DEFERRED |
2015-08-26 15:25:03
|
4,194,304 | |
DEFAULT 8K buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
DEFAULT 4K buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
DEFAULT 32K buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
DEFAULT 2K buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
DEFAULT 16K buffer cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 | ||
ASM Buffer Cache | 0 | 0 | 0 | 0 | 0 | STATIC |
|
4,194,304 |
Instance Name | Parameter Name | Value |
---|---|---|
oradg11g
|
pga_aggregate_target |
0
|
workarea_size_policy |
AUTO
|
Instance Name | PGA Target for Estimate | Estimated Extra Bytes R/W | Estimated PGA Cache Hit % | ESTD_OVERALLOC_COUNT |
---|---|---|---|---|
oradg11g
|
14,155,776 | 116,457,472 | 75 | 12 |
28,311,552 | 116,457,472 | 75 | 12 | |
56,623,104 | 116,457,472 | 75 | 12 | |
84,934,656 | 116,457,472 | 75 | 12 | |
113,246,208 | 0 | 100 | 12 | |
135,895,040 | 0 | 100 | 11 | |
158,543,872 | 0 | 100 | 6 | |
181,193,728 | 0 | 100 | 6 | |
203,842,560 | 0 | 100 | 5 | |
226,492,416 | 0 | 100 | 2 | |
339,738,624 | 0 | 100 | 0 | |
452,984,832 | 0 | 100 | 0 | |
679,477,248 | 0 | 100 | 0 | |
905,969,664 | 0 | 100 | 0 |
Ordered by "Physical Reads" since last startup of the Oracle instance
Tablespace | File Name | Physical Reads | Read Pct. | Physical Writes | Write Pct. | Total I/O |
---|---|---|---|---|---|---|
SYSTEM | /u01/app/oracle/oradata/oradg11g/system01.dbf | 59,179 |
80.61%
|
92 |
14.02%
|
59,271 |
SYSAUX | /u01/app/oracle/oradata/oradg11g/sysaux01.dbf | 12,683 |
17.28%
|
397 |
60.52%
|
13,080 |
EXAMPLE | /u01/app/oracle/oradata/oradg11g/example01.dbf | 669 |
.91%
|
0 |
0%
|
669 |
LOGMNRTBS | /u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | 455 |
.62%
|
0 |
0%
|
455 |
UNDOTBS1 | /u01/app/oracle/oradata/oradg11g/undotbs01.dbf | 258 |
.35%
|
152 |
23.17%
|
410 |
USERS | /u01/app/oracle/oradata/oradg11g/users01.dbf | 153 |
.21%
|
0 |
0%
|
153 |
TEMP | /u01/app/oracle/oradata/oradg11g/temp01.dbf | 20 |
.03%
|
15 |
2.29%
|
35 |
-------------------- | -------------------- | -------------------- | ||||
Total: | 73,417 | 656 | 74,073 |
Average time (in milliseconds) for an I/O call per datafile since last startup of the Oracle instance - (ordered by Physical Reads)
File Name | Physical Reads | Average Read Time (milliseconds per read) | Physical Writes | Average Write Time (milliseconds per write) |
---|---|---|---|---|
/u01/app/oracle/oradata/oradg11g/system01.dbf | 59,179 | .03 | 92 | .43 |
/u01/app/oracle/oradata/oradg11g/sysaux01.dbf | 12,683 | .13 | 397 | .11 |
/u01/app/oracle/oradata/oradg11g/example01.dbf | 669 | .22 | 0 | .00 |
/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf | 455 | .07 | 0 | .00 |
/u01/app/oracle/oradata/oradg11g/undotbs01.dbf | 258 | .26 | 152 | .27 |
/u01/app/oracle/oradata/oradg11g/users01.dbf | 153 | .06 | 0 | .00 |
/u01/app/oracle/oradata/oradg11g/temp01.dbf | 20 | .05 | 15 | .27 |
-------------------- | -------------------------------------------- | -------------------- | ---------------------------------------------- | |
Average: | .12 | .15 | ||
Total: | 73,417 | 656 |
Large Table Scans | Small Table Scans | Pct. Large Scans |
---|---|---|
131 | 1,586 |
7.63%
|
Disk Sorts | Memory Sorts | Pct. Disk Sorts |
---|---|---|
0 | 10,877 |
0%
|
NAME | CNT | Hit Ratio |
---|---|---|
workarea executions - optimal | 6566 | 100 |
workarea executions - onepass | 0 | 0 |
workarea executions - multipass | 0 | 0 |
Top 100 SQL statements with buffer gets greater than 1000
INST_ID | Username | Buffer Gets | Executions | Buffer Gets / Execution | SQL Text |
---|---|---|---|---|---|
1 | LHR | 36,670 | 1 | 36,670 | select '
' || c.sum3|| '
' sum3,a.sum1 sum1,b.sum2 sum2 from (SELECT ceil(SUM(BYTES)/1024/1024/1024) sum1 FROM DBA_se gments) a,(select ceil(sum(bytes)/1024/1024/1024) sum2 from v$datafile) b,(select ceil(sum(bytes)/1024/1024/1024) sum3 from dba_extents where segment_type not like 'INDEX%' an d segment_type not in('ROLLBACK','CACHE','LOBINDEX','TYPE2 UNDO')) c |
1 | LHR | 23,169 | 56 | 414 | select col.*, com.Comments from sys.all_tab_columns col, sys.all_col_comments com where col.owner = 'SYS' and col.table_name = 'GV_$DATABASE' and com.Owner (+) = 'SYS' an d com.Table_Name (+) = 'GV_$DATABASE' and com.Column_Name (+) = col.Column_Name order by col.column_id |
1 | LHR | 12,845 | 61 | 211 | select constraint_name from sys.all_constraints where owner = :object_owner and table_name = :object_name and constraint_type = 'V' and constraint_name not like 'SYS_%' |
1 | LHR | 8,331 | 1 | 8,331 | SELECT '
' || r.command_id || '
' backup_name , '
' || TO_CHAR(r.start_time, 'yyyy-mm-dd HH24:MI:SS') || '
' start_time , '
' || r.time_taken_display || '
' elapsed_time , DECODE( r.status , 'COMPLETED' , '
' || r.status || '
' , 'RUNNING' , '
' || r.status || '
' , 'FAILED' , '
' || r.status || '
' , '
' || r.status || '
' ) status , r.input_ |
1 | LHR | 7,469 | 1 | 7,469 | SELECT '' || tablespace_name || '' tablespace_name , '
' || owner || '
' owner , '' || segment_type || '' segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY tablespace_name , owner , segment_type ORDER BY tablespace_name , owner , s egment_type |
1 | APEX_030200 | 2,637 | 5 | 527 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'),w wv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
1 | APEX_030200 | 1,513 | 1 | 1,513 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24); :mydate := nex t_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
1 | MDSYS | 1,141 | 4 | 285 | declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar 2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); P RAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_typ e='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event ; m_stmt:='select SYS_CONTEXT(''USERENV'',''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'',''CURRENT_USER'') fr om dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execu |
1 | LHR | 1,060 | 61 | 17 | select * from sys.all_views where owner = :owner and view_name = :view_name |
Top 100 SQL statements with disk reads greater than 1000
INST_ID | Username | Disk Reads | Executions | Reads / Execution | SQL Text |
---|---|---|---|---|---|
1 | LHR | 20,903 | 1 | 20,903 | select '
' || c.sum3|| '
' sum3,a.sum1 sum1,b.sum2 sum2 from (SELECT ceil(SUM(BYTES)/1024/1024/1024) sum1 FROM DBA_se gments) a,(select ceil(sum(bytes)/1024/1024/1024) sum2 from v$datafile) b,(select ceil(sum(bytes)/1024/1024/1024) sum3 from dba_extents where segment_type not like 'INDEX%' an d segment_type not in('ROLLBACK','CACHE','LOBINDEX','TYPE2 UNDO')) c |
1 | LHR | 11,160 | 61 | 183 | select constraint_name from sys.all_constraints where owner = :object_owner and table_name = :object_name and constraint_type = 'V' and constraint_name not like 'SYS_%' |
1 | LHR | 7,323 | 1 | 7,323 | SELECT '' || tablespace_name || '' tablespace_name , '
' || owner || '
' owner , '' || segment_type || '' segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY tablespace_name , owner , segment_type ORDER BY tablespace_name , owner , s egment_type |
INST_ID | SQL_ID | SQL_TEXT | EXECUTIONS | LAST_LOAD_TIME | FIRST_LOAD_TIME | DISK_READS | BUFFER_GETS | PARSE_CALLS |
---|---|---|---|---|---|---|---|---|
1 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist _head$ where obj#=:1 and intcol#=:2 | 4671 | 2015-08-26 15:24:26 | 2015-08-26/15:24:26 | 304 | 12330 | 39 |
1 | 53saa2zkr6wc3 | select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 | 1776 | 2015-08-26 15:24:33 | 2015-08-26/15:24:26 | 45 | 8023 | 29 |
1 | 3nkd3g3ju5ph1 | select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null | 1766 | 2015-08-26 15:24:26 | 2015-08-26/15:24:25 | 265 | 6885 | 33 |
1 | 32hbap2vtmf53 | select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_sub name,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc | 1522 | 2015-08-26 15:24:28 | 2015-08-26/15:24:28 | 211 | 24391 | 18 |
1 | 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), n onequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + decode(bitand(:flag,16),0,0,1), null_preds = null_preds + decode(bitand(:flag,32),0,0,1), timestamp = :time where obj# = :objn and intcol# = :coln | 1387 | 2015-08-26 15:39:44 | 2015-08-26/15:39:44 | 73 | 4550 | 4 |
1 | db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket | 1035 | 2015-08-26 15:24:26 | 2015-08-26/15:24:26 | 412 | 3152 | 24 |
1 | grwydz59pu6mc | select text from view$ where rowid=:1 | 803 | 2015-08-26 15:24:33 | 2015-08-26/15:24:26 | 68 | 1622 | 21 |
1 | 83taa7kaw59c1 | select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale, 0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol# | 709 | 2015-08-26 15:24:33 | 2015-08-26/15:24:25 | 220 | 2348 | 33 |
1 | 5n1fs4m2n2y0r | select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 | 699 | 2015-08-26 15:24:33 | 2015-08-26/15:24:25 | 34 | 4330 | 31 |
1 | 9tgj4g8y4rwy8 | select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0 ) from seg$ where ts#=:1 and file#=:2 and block#=:3 | 686 | 2015-08-26 15:24:33 | 2015-08-26/15:24:26 | 62 | 2091 | 22 |
INST_ID | SQL_ID | SQL_TEXT | EXECUTIONS | LAST_LOAD_TIME | FIRST_LOAD_TIME | DISK_READS | BUFFER_GETS | PARSE_CALLS |
---|---|---|---|---|---|---|---|---|
1 | b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait | 519 | 2015-08-26 15:39:44 | 2015-08-26/15:39:44 | 1 | 26 | 519 |
1 | 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait | 107 | 2015-08-26 15:39:44 | 2015-08-26/15:39:44 | 1 | 21 | 107 |
1 | 3ktacv9r56b51 | select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# | 640 | 2015-08-26 15:24:33 | 2015-08-26/15:24:25 | 577 | 8039 | 43 |
1 | 8swypbbr0m372 | select order#,columns,types from access$ where d_obj#=:1 | 640 | 2015-08-26 15:24:33 | 2015-08-26/15:24:25 | 337 | 6271 | 43 |
1 | 83cq1aqjw5gmg | select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# | 0 | 2015-08-26 15:24:28 | 2015-08-26/15:24:28 | 0 | 0 | 42 |
1 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist _head$ where obj#=:1 and intcol#=:2 | 4671 | 2015-08-26 15:24:26 | 2015-08-26/15:24:26 | 304 | 12330 | 39 |
1 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# | 225 | 2015-08-26 15:24:33 | 2015-08-26/15:24:27 | 966 | 2851 | 36 |
1 | 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# | 225 | 2015-08-26 15:24:33 | 2015-08-26/15:24:27 | 423 | 1433 | 36 |
1 | ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# | 225 | 2015-08-26 15:24:33 | 2015-08-26/15:24:26 | 212 | 1369 | 36 |
1 | c6awqs517jpj0 | select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# | 225 | 2015-08-26 15:24:33 | 2015-08-26/15:24:27 | 139 | 805 | 36 |
NAME | PATH | STATE | TOTAL_MB | FREE_MB | CREATE_DATE | MOUNT_DATE |
---|---|---|---|---|---|---|
DATA_0000 | /dev/asm-diskb | NORMAL | 5120 | 669 | 2014-06-14 22:45:25 | 2015-08-23 17:33:07 |
FRA_0000 | /dev/asm-diske | NORMAL | 10240 | 7184 | 2014-06-14 22:50:19 | 2015-08-23 17:33:07 |
DATA_0001 | /dev/asm-diskc | NORMAL | 5120 | 664 | 2014-06-14 22:45:25 | 2015-08-23 17:33:07 |
DATA_0002 | /dev/asm-diskd | NORMAL | 5120 | 670 | 2014-06-14 22:45:25 | 2015-08-23 17:33:07 |
DATA_0003 | /dev/raw/raw1 | NORMAL | 2000 | 0 | 2015-05-19 18:00:59 | 2015-08-23 17:33:07 |
/dev/raw/raw2 | NORMAL | 0 | 0 | |||
---------- | ---------- | |||||
Total | 27600 | 9187 |
NAME | BLOCK_SIZE | STATE | TYPE | TOTAL_MB | FREE_MB |
---|---|---|---|---|---|
DATA | 4096 | MOUNTED | NORMAL | 17360 | 2003 |
FRA | 4096 | MOUNTED | EXTERN | 10240 | 7184 |
---------- | ---------- | ||||
Total | 27600 | 9187 |
NAME | VALUE | GROUP_NUMBER | ATTRIBUTE_INDEX | ATTRIBUTE_INCARNATION | READ_ON | SYSTEM_ |
---|---|---|---|---|---|---|
access_control.enabled | FALSE | 1 | 40 | 1 | N | Y |
access_control.umask | 066 | 1 | 41 | 1 | N | Y |
au_size | 1048576 | 1 | 5 | 1 | Y | Y |
cell.smart_scan_capable | FALSE | 1 | 30 | 1 | N | N |
compatible.asm | 11.2.0.0.0 | 1 | 20 | 1 | N | Y |
compatible.rdbms | 10.1.0.0.0 | 1 | 21 | 1 | N | Y |
disk_repair_time | 3.6h | 1 | 0 | 1 | N | Y |
sector_size | 512 | 1 | 6 | 1 | Y | Y |
template_version | 186646528 | 1 | 50 | 1 | N | Y |
access_control.enabled | FALSE | 2 | 40 | 1 | N | Y |
access_control.umask | 066 | 2 | 41 | 1 | N | Y |
au_size | 1048576 | 2 | 5 | 1 | Y | Y |
cell.smart_scan_capable | FALSE | 2 | 30 | 1 | N | N |
compatible.asm | 11.2.0.0.0 | 2 | 20 | 1 | N | Y |
compatible.rdbms | 10.1.0.0.0 | 2 | 21 | 1 | N | Y |
disk_repair_time | 3.6h | 2 | 0 | 1 | N | Y |
sector_size | 512 | 2 | 6 | 1 | Y | Y |
template_version | 186646528 | 2 | 50 | 1 | N | Y |
参数名称 | 实例名称 | 参数值 |
---|---|---|
db_file_name_convert | oradg11g | oradglg, oradg11g |
fal_client | oradg11g | oradg11g |
fal_server | oradg11g | oradglg |
log_archive_config | oradg11g | DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font> |
log_archive_dest_1 | oradg11g | LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) |
log_archive_dest_2 | oradg11g | SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=ora dgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_3 | oradg11g | SERVICE=tns_oradglg LGWR ASYNC db_unique_name=orad glg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_4 | oradg11g | SERVICE=tns_oradgss LGWR ASYNC db_unique_name=orad gss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) |
log_archive_dest_state_1 | oradg11g | ENABLE |
log_archive_dest_state_2 | oradg11g | ENABLE |
log_archive_dest_state_3 | oradg11g | ENABLE |
log_archive_dest_state_4 | oradg11g | ENABLE |
log_file_name_convert | oradg11g | oradglg, oradg11g |
standby_file_management | oradg11g | AUTO |
INST_ID | NAME | LOG_MODE | OPEN_MODE | DATABASE_ROLE | SWITCHOVER_STATUS | DB_UNIQUE_NAME | FLASHBACK_ON | PROTECTION_MODE | PROTECTION_LEVEL | REMOTE_A | SWITCHOVER# | SWITCHOVER_STATUS | DATAGUAR | GUARD_S | SUPPLEME | SUP | SUP | FOR | SUP | SUP | STANDBY_BECAME_PRIMARY_SCN | FS_FAILOVER_STATUS | FS_FAILOVER_CURRENT_TARGET | FS_FAILOVER_THRESHOLD | FS_FAIL | FS_FAILOVER_OBSERVER_HOST | CON | PRIMARY_DB_UNIQUE_NAME | SUP | MIN_REQUIRED_CAPTURE_CHANGE# |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ORADG11G | ARCHIVELOG | READ WRITE | PRIMARY | TO STANDBY | oradg11g | YES | MAXIMUM PERFORMANCE | MAXIMUM PERFORMANCE | ENABLED | 1414208659 | TO STANDBY | DISABLED | NONE | IMPLICIT | YES | YES | YES | NO | NO | 2076848 | DISABLED | 0 | NO | oradglg | YES |
THREAD# | DEST_ID | DEST_NAME | TARGET | DATABASE_MODE | STATUS | ERROR | RECOVERY_MODE | DB_UNIQUE_NAME | DESTINATION | GAP_STATUS | CURRENT_SEQ# | LAST_ARCHIVED | APPLIED_SEQ# | APPLIED_SCN |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | LOG_ARCHIVE_DEST_1 | LOCAL PRIMARY | OPEN | VALID | IDLE | oradg11g | 91 | 90 | 8 | 0 | |||
1 | 2 | LOG_ARCHIVE_DEST_2 | PHYSICAL STANDBY | OPEN_READ-ONLY | VALID | MANAGED REAL TIME APPLY | oradgphy | tns_oradgphy | NO GAP | 91 | 90 | 89 | 2282617 | |
1 | 3 | LOG_ARCHIVE_DEST_3 | LOGICAL STANDBY | OPEN | VALID | LOGICAL REAL TIME APPLY | oradglg | tns_oradglg | NO GAP | 91 | 90 | 90 | 2282614 | |
1 | 4 | LOG_ARCHIVE_DEST_4 | PHYSICAL STANDBY | OPEN_READ-ONLY | VALID | MANAGED REAL TIME APPLY | oradgss | tns_oradgss | NO GAP | 91 | 90 | 89 | 2282617 |
INSTANCE_NAME | PROCESS | CLIENT_P | CLIENT_PID | STATUS | GROUP_# | THREAD# | SEQUENCE# | DELAY_MINS | RESETLOG_ID | SID | SERIAL# | SPID |
---|---|---|---|---|---|---|---|---|---|---|---|---|
oradg11g | ARCH | ARCH | 58780 | CLOSING | N/A | 1 | 90 | 0 | 886695024 | 135 | 3 | 58780 |
oradg11g | ARCH | ARCH | 58786 | CLOSING | 3 | 1 | 89 | 0 | 886695024 | 10 | 1 | 58786 |
oradg11g | ARCH | ARCH | 58788 | CLOSING | N/A | 1 | 87 | 0 | 886695024 | 136 | 3 | 58788 |
oradg11g | LNS | LNS | 58800 | WRITING | 2 | 1 | 91 | 0 | 886695024 | 13 | 1 | 58800 |
oradg11g | LNS | LNS | 58798 | WRITING | 2 | 1 | 91 | 0 | 886695024 | 138 | 1 | 58798 |
oradg11g | LNS | LNS | 58802 | WRITING | 2 | 1 | 91 | 0 | 886695024 | 139 | 1 | 58802 |
oradg11g | ARCH | ARCH | 58790 | CLOSING | N/A | 1 | 90 | 0 | 886695024 | 11 | 1 | 58790 |
GROUP# | DB_ID | THREAD# | SEQUENCE# | BYTES | USED | ARC | STATUS | FIRST_CHANGE# | NEXT_CHANGE# | LAST_CHANGE# |
---|---|---|---|---|---|---|---|---|---|---|
4 | UNASSIGNED | 1 | 0 | 52428800 | 0 | YES | UNASSIGNED | |||
5 | UNASSIGNED | 1 | 0 | 52428800 | 0 | YES | UNASSIGNED | |||
6 | UNASSIGNED | 1 | 0 | 52428800 | 0 | YES | UNASSIGNED | |||
7 | UNASSIGNED | 1 | 0 | 52428800 | 0 | YES | UNASSIGNED |
Username | Account Status | Expire Date | Default Tbs. | Temp Tbs. | Created On | Profile | SYSDBA | SYSOPER |
---|---|---|---|---|---|---|---|---|
ANONYMOUS |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 09:58:25
|
DEFAULT |
|
|
APEX_030200 |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 10:13:33
|
DEFAULT |
|
|
APEX_PUBLIC_USER |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
USERS | TEMP |
2011-09-17 10:13:33
|
DEFAULT |
|
|
APPQOSSYS |
EXPIRED & LOCKED
|
2011-09-17 09:52:28
|
SYSAUX | TEMP |
2011-09-17 09:52:28
|
DEFAULT |
|
|
BI |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
CTXSYS |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 09:58:00
|
DEFAULT |
|
|
DBSNMP |
EXPIRED & LOCKED
|
2011-09-17 09:52:27
|
SYSAUX | TEMP |
2011-09-17 09:52:27
|
MONITORING_PROFILE |
|
|
DIP |
EXPIRED & LOCKED
|
2011-09-17 09:47:52
|
USERS | TEMP |
2011-09-17 09:47:52
|
DEFAULT |
|
|
EXFSYS |
EXPIRED & LOCKED
|
2011-09-17 09:57:46
|
SYSAUX | TEMP |
2011-09-17 09:57:46
|
DEFAULT |
|
|
FLOWS_FILES |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 10:13:33
|
DEFAULT |
|
|
HR |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
IX |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
LHR |
OPEN
|
2015-09-30 17:07:39
|
USERS | TEMP |
2015-04-03 17:07:39
|
DEFAULT |
|
|
MDDATA |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
USERS | TEMP |
2011-09-17 10:05:26
|
DEFAULT |
|
|
MDSYS |
EXPIRED & LOCKED
|
2011-09-17 10:00:09
|
SYSAUX | TEMP |
2011-09-17 10:00:09
|
DEFAULT |
|
|
MGMT_VIEW |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSTEM | TEMP |
2011-09-17 10:12:38
|
DEFAULT |
|
|
OE |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
OLAPSYS |
EXPIRED & LOCKED
|
2011-09-17 10:04:19
|
SYSAUX | TEMP |
2011-09-17 10:04:19
|
DEFAULT |
|
|
ORACLE_OCM |
EXPIRED & LOCKED
|
2011-09-17 09:48:28
|
USERS | TEMP |
2011-09-17 09:48:28
|
DEFAULT |
|
|
ORDDATA |
EXPIRED & LOCKED
|
2011-09-17 10:00:09
|
SYSAUX | TEMP |
2011-09-17 10:00:09
|
DEFAULT |
|
|
ORDPLUGINS |
EXPIRED & LOCKED
|
2011-09-17 10:00:09
|
SYSAUX | TEMP |
2011-09-17 10:00:09
|
DEFAULT |
|
|
ORDSYS |
EXPIRED & LOCKED
|
2011-09-17 10:00:09
|
SYSAUX | TEMP |
2011-09-17 10:00:09
|
DEFAULT |
|
|
OUTLN |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSTEM | TEMP |
2011-09-17 09:46:25
|
DEFAULT |
|
|
OWBSYS |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 10:21:02
|
DEFAULT |
|
|
OWBSYS_AUDIT |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 10:21:03
|
DEFAULT |
|
|
PM |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
SCOTT |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2011-09-17 10:21:59
|
DEFAULT |
|
|
SH |
EXPIRED & LOCKED
|
2015-04-03 16:01:59
|
USERS | TEMP |
2015-04-03 15:59:12
|
DEFAULT |
|
|
SI_INFORMTN_SCHEMA |
EXPIRED & LOCKED
|
2011-09-17 10:00:09
|
SYSAUX | TEMP |
2011-09-17 10:00:09
|
DEFAULT |
|
|
SPATIAL_CSW_ADMIN_USR |
EXPIRED & LOCKED
|
2011-09-17 10:09:45
|
USERS | TEMP |
2011-09-17 10:09:45
|
DEFAULT |
|
|
SPATIAL_WFS_ADMIN_USR |
EXPIRED & LOCKED
|
2011-09-17 10:09:40
|
USERS | TEMP |
2011-09-17 10:09:40
|
DEFAULT |
|
|
SYS |
OPEN
|
2015-09-30 16:01:55
|
SYSTEM | TEMP |
2011-09-17 09:46:22
|
DEFAULT |
TRUE
|
TRUE
|
SYSMAN |
EXPIRED & LOCKED
|
2011-09-17 10:21:08
|
SYSAUX | TEMP |
2011-09-17 10:09:57
|
DEFAULT |
|
|
SYSTEM |
OPEN
|
2015-09-30 16:01:55
|
SYSTEM | TEMP |
2011-09-17 09:46:22
|
DEFAULT |
|
|
WMSYS |
EXPIRED & LOCKED
|
2011-09-17 09:53:14
|
SYSAUX | TEMP |
2011-09-17 09:53:14
|
DEFAULT |
|
|
XDB |
EXPIRED & LOCKED
|
2011-09-17 09:58:25
|
SYSAUX | TEMP |
2011-09-17 09:58:25
|
DEFAULT |
|
|
XS$NULL |
EXPIRED & LOCKED
|
2011-09-17 09:59:56
|
USERS | TEMP |
2011-09-17 09:59:56
|
DEFAULT |
|
|
Grantee | Granted Role | Admin. Option? | Default Role? |
---|---|---|---|
LHR |
DBA
|
NO
|
YES
|
SYS |
DBA
|
YES
|
YES
|
SYSTEM |
DBA
|
YES
|
YES
|
USERNAME | SYSDB | SYSOP | SYSAS |
---|---|---|---|
SYS | TRUE | TRUE | FALSE |
Role Name | Grantee | Admin Option? | Default Role? |
---|---|---|---|
ADM_PARALLEL_EXECUTE_TASK | SYS |
YES
|
YES
|
APEX_ADMINISTRATOR_ROLE | SYS |
YES
|
YES
|
AQ_ADMINISTRATOR_ROLE | IX |
NO
|
YES
|
OWBSYS |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
SYSTEM |
YES
|
YES
|
|
AQ_USER_ROLE | IX |
NO
|
YES
|
OWBSYS |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
AUTHENTICATEDUSER | SYS |
YES
|
YES
|
CONNECT | APEX_030200 |
YES
|
YES
|
IX |
NO
|
YES
|
|
MDDATA |
NO
|
YES
|
|
MDSYS |
NO
|
YES
|
|
OWBSYS |
YES
|
YES
|
|
PM |
NO
|
YES
|
|
SCOTT |
NO
|
YES
|
|
SPATIAL_CSW_ADMIN_USR |
NO
|
YES
|
|
SPATIAL_WFS_ADMIN_USR |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
WMSYS |
NO
|
YES
|
|
CSW_USR_ROLE | SYS |
YES
|
YES
|
CTXAPP | CTXSYS |
YES
|
YES
|
SYS |
YES
|
YES
|
|
XDB |
NO
|
YES
|
|
CWM_USER | OWBSYS |
YES
|
YES
|
SH |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
DATAPUMP_EXP_FULL_DATABASE | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
DATAPUMP_IMP_FULL_DATABASE | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
DBA | LHR |
NO
|
YES
|
SYS |
YES
|
YES
|
|
SYSTEM |
YES
|
YES
|
|
DBFS_ROLE | SYS |
YES
|
YES
|
DELETE_CATALOG_ROLE | DBA |
YES
|
YES
|
SYS |
YES
|
YES
|
|
EJBCLIENT | SYS |
YES
|
YES
|
EXECUTE_CATALOG_ROLE | DBA |
YES
|
YES
|
EXP_FULL_DATABASE |
NO
|
YES
|
|
IMP_FULL_DATABASE |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
EXP_FULL_DATABASE | DATAPUMP_EXP_FULL_DATABASE |
NO
|
YES
|
DATAPUMP_IMP_FULL_DATABASE |
NO
|
YES
|
|
DBA |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
GATHER_SYSTEM_STATISTICS | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
GLOBAL_AQ_USER_ROLE | |||
HS_ADMIN_EXECUTE_ROLE | EXECUTE_CATALOG_ROLE |
NO
|
YES
|
HS_ADMIN_ROLE |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
HS_ADMIN_ROLE | SYS |
YES
|
YES
|
HS_ADMIN_SELECT_ROLE | HS_ADMIN_ROLE |
NO
|
YES
|
SELECT_CATALOG_ROLE |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
IMP_FULL_DATABASE | DATAPUMP_IMP_FULL_DATABASE |
NO
|
YES
|
DBA |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
JAVADEBUGPRIV | SYS |
YES
|
YES
|
JAVAIDPRIV | SYS |
YES
|
YES
|
JAVASYSPRIV | SYS |
YES
|
YES
|
JAVAUSERPRIV | JAVASYSPRIV |
NO
|
YES
|
ORDSYS |
NO
|
YES
|
|
OWBSYS |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
XDB |
NO
|
YES
|
|
JAVA_ADMIN | DBA |
NO
|
YES
|
OWBSYS |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
JAVA_DEPLOY | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
JMXSERVER | SYS |
YES
|
YES
|
LOGSTDBY_ADMINISTRATOR | SYS |
YES
|
YES
|
MGMT_USER | MGMT_VIEW |
NO
|
YES
|
SYS |
YES
|
YES
|
|
SYSMAN |
YES
|
YES
|
|
SYSTEM |
NO
|
YES
|
|
OEM_ADVISOR | SYS |
YES
|
YES
|
OEM_MONITOR | DBSNMP |
NO
|
YES
|
SYS |
YES
|
YES
|
|
OLAP_DBA | DBA |
NO
|
YES
|
OLAPSYS |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
OLAP_USER | OWBSYS |
YES
|
YES
|
SYS |
YES
|
YES
|
|
OLAP_XS_ADMIN | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
ORDADMIN | SYS |
YES
|
YES
|
OWB$CLIENT | OWBSYS |
YES
|
YES
|
SYS |
YES
|
YES
|
|
OWB_DESIGNCENTER_VIEW | OWBSYS |
YES
|
YES
|
SYS |
YES
|
YES
|
|
OWB_USER | OWBSYS |
YES
|
YES
|
SYS |
YES
|
YES
|
|
RECOVERY_CATALOG_OWNER | SYS |
YES
|
YES
|
RESOURCE | APEX_030200 |
YES
|
YES
|
BI |
NO
|
YES
|
|
CTXSYS |
NO
|
YES
|
|
EXFSYS |
NO
|
YES
|
|
HR |
NO
|
YES
|
|
IX |
NO
|
YES
|
|
LOGSTDBY_ADMINISTRATOR |
NO
|
YES
|
|
MDDATA |
NO
|
YES
|
|
MDSYS |
NO
|
YES
|
|
OE |
NO
|
YES
|
|
OLAPSYS |
NO
|
YES
|
|
OUTLN |
NO
|
YES
|
|
PM |
NO
|
YES
|
|
SCOTT |
NO
|
YES
|
|
SH |
NO
|
YES
|
|
SPATIAL_CSW_ADMIN_USR |
NO
|
YES
|
|
SPATIAL_WFS_ADMIN_USR |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
SYSMAN |
NO
|
YES
|
|
WMSYS |
NO
|
YES
|
|
XDB |
NO
|
YES
|
|
SCHEDULER_ADMIN | DBA |
YES
|
YES
|
SYS |
YES
|
YES
|
|
SELECT_CATALOG_ROLE | DBA |
YES
|
YES
|
EXP_FULL_DATABASE |
NO
|
YES
|
|
IMP_FULL_DATABASE |
NO
|
YES
|
|
IX |
NO
|
YES
|
|
OEM_MONITOR |
NO
|
YES
|
|
SH |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
SYSMAN |
YES
|
YES
|
|
SPATIAL_CSW_ADMIN | SPATIAL_CSW_ADMIN_USR |
YES
|
YES
|
SYS |
YES
|
YES
|
|
SPATIAL_WFS_ADMIN | SPATIAL_WFS_ADMIN_USR |
YES
|
YES
|
SYS |
YES
|
YES
|
|
WFS_USR_ROLE | SYS |
YES
|
YES
|
WM_ADMIN_ROLE | DBA |
NO
|
YES
|
WMSYS |
YES
|
YES
|
|
XDBADMIN | DBA |
NO
|
YES
|
OE |
NO
|
YES
|
|
SYS |
YES
|
YES
|
|
XDB_SET_INVOKER | DBA |
NO
|
YES
|
SYS |
YES
|
YES
|
|
XDB_WEBSERVICES | SYS |
YES
|
YES
|
XDB_WEBSERVICES_OVER_HTTP | SYS |
YES
|
YES
|
XDB_WEBSERVICES_WITH_PUBLIC | SYS |
YES
|
YES
|
OWNER | size(M) |
---|---|
SYS | 880.63 |
SH | 287.25 |
XDB | 157.69 |
SYSTEM | 116.44 |
APEX_030200 | 85.44 |
MDSYS | 73.94 |
SYSMAN | 45.94 |
LHR | 34.31 |
ORDDATA | 13.56 |
PM | 12.25 |
OE | 9.06 |
OLAPSYS | 8.81 |
CTXSYS | 3.75 |
EXFSYS | 3.63 |
WMSYS | 3.5 |
IX | 1.75 |
HR | 1.56 |
OUTLN | .56 |
DBSNMP | .5 |
ORDSYS | .44 |
SCOTT | .31 |
Username | Default Tablespace | Temporary Tablespace | Created | Account 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
|
OWNER | SEGMENT_TYPE | SIZE_G | COUNTS |
---|---|---|---|
OUTLN
|
INDEX | 0 | 4 |
OUTLN
|
LOBSEGMENT | 0 | 1 |
OUTLN
|
TABLE | 0 | 3 |
OUTLN
|
LOBINDEX | 0 | 1 |
Owner | Segment Name | Type | Tablespace | Bytes Alloc | Extents | Initial Ext | Next Ext | Pct Inc |
---|---|---|---|---|---|---|---|---|
OUTLN
|
OL$ | TABLE | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | |
OL$HINTS | TABLE | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
OL$HNT_NUM | INDEX | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
OL$NAME | INDEX | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
OL$NODES | TABLE | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
OL$NODE_OL_NAME | INDEX | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
OL$SIGNATURE | INDEX | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
SYS_IL0000000451C00021$$ | LOBINDEX | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
SYS_LOB0000000451C00021$$ | LOBSEGMENT | SYSTEM | 65,536 | 1 | 65,536 | 1,048,576 | ||
*************************************************************************** | ----------------------------------------------------------------------------------------------------------------------------- | -------------------- | ||||||
Total Count: | 9 | |||||||
Total Bytes: | 589,824 |
TABLE_NAME | OWNER | TABLESPACE_NAME |
---|---|---|
OL$NODES | OUTLN | SYSTEM |
OL$HINTS | OUTLN | SYSTEM |
OL$ | OUTLN | SYSTEM |
WWV_FLOW_FILE_OBJECTS$ | FLOWS_FILES | SYSAUX |
INDEX_NAME | OWNER | TABLESPACE_NAME |
---|---|---|
OL$NAME | OUTLN | SYSTEM |
OL$SIGNATURE | OUTLN | SYSTEM |
SYS_IL0000000451C00021$$ | OUTLN | SYSTEM |
OL$HNT_NUM | OUTLN | SYSTEM |
OL$NODE_OL_NAME | OUTLN | SYSTEM |
WWV_FLOW_FILE_OBJ_PK | FLOWS_FILES | SYSAUX |
SYS_IL0000072495C00017$$ | FLOWS_FILES | SYSAUX |
SYS_C008628 | FLOWS_FILES | SYSAUX |
WWV_FLOW_FILES_SGID_FK_IDX | FLOWS_FILES | SYSAUX |
WWV_FLOW_FILES_USER_IDX | FLOWS_FILES | SYSAUX |
Owner | Object Type | Object Count |
---|---|---|
APEX_030200 | FUNCTION | 12 |
INDEX | 1,101 | |
LOB | 155 | |
PACKAGE | 189 | |
PACKAGE BODY | 181 | |
PROCEDURE | 19 | |
SEQUENCE | 4 | |
SYNONYM | 45 | |
TABLE | 360 | |
TRIGGER | 366 | |
TYPE | 4 | |
VIEW | 125 | |
APPQOSSYS | SYNONYM | 1 |
TABLE | 4 | |
BI | SYNONYM | 8 |
CTXSYS | FUNCTION | 2 |
INDEX | 63 | |
INDEXTYPE | 4 | |
LIBRARY | 1 | |
LOB | 2 | |
OPERATOR | 6 | |
PACKAGE | 74 | |
PACKAGE BODY | 63 | |
PROCEDURE | 2 | |
SEQUENCE | 3 | |
TABLE | 50 | |
TYPE | 35 | |
TYPE BODY | 6 | |
VIEW | 77 | |
DBSNMP | INDEX | 10 |
PACKAGE | 4 | |
PACKAGE BODY | 4 | |
PROCEDURE | 1 | |
SEQUENCE | 2 | |
SYNONYM | 1 | |
TABLE | 20 | |
TYPE | 8 | |
VIEW | 7 | |
EXFSYS | FUNCTION | 26 |
INDEX | 41 | |
INDEXTYPE | 1 | |
JAVA CLASS | 47 | |
JAVA RESOURCE | 1 | |
JOB | 2 | |
LIBRARY | 1 | |
LOB | 2 | |
OPERATOR | 1 | |
PACKAGE | 18 | |
PACKAGE BODY | 18 | |
PROCEDURE | 10 | |
SEQUENCE | 1 | |
TABLE | 47 | |
TRIGGER | 5 | |
TYPE | 30 | |
TYPE BODY | 5 | |
VIEW | 56 | |
FLOWS_FILES | INDEX | 5 |
LOB | 1 | |
SYNONYM | 5 | |
TABLE | 1 | |
TRIGGER | 1 | |
HR | INDEX | 19 |
PROCEDURE | 2 | |
SEQUENCE | 3 | |
TABLE | 7 | |
TRIGGER | 2 | |
VIEW | 1 | |
IX | EVALUATION CONTEXT | 2 |
INDEX | 17 | |
LOB | 3 | |
QUEUE | 4 | |
RULE SET | 4 | |
SEQUENCE | 2 | |
TABLE | 17 | |
TYPE | 1 | |
VIEW | 8 | |
LHR | TABLE | 6 |
VIEW | 1 | |
MDSYS | FUNCTION | 108 |
INDEX | 367 | |
INDEXTYPE | 2 | |
JAVA CLASS | 535 | |
JAVA RESOURCE | 3 | |
LIBRARY | 18 | |
LOB | 214 | |
OPERATOR | 25 | |
PACKAGE | 70 | |
PACKAGE BODY | 66 | |
PROCEDURE | 2 | |
SEQUENCE | 15 | |
TABLE | 148 | |
TRIGGER | 64 | |
TYPE | 207 | |
TYPE BODY | 43 | |
VIEW | 86 | |
OE | FUNCTION | 1 |
INDEX | 48 | |
LOB | 15 | |
SEQUENCE | 1 | |
SYNONYM | 6 | |
TABLE | 14 | |
TRIGGER | 4 | |
TYPE | 37 | |
TYPE BODY | 3 | |
VIEW | 13 | |
OLAPSYS | FUNCTION | 1 |
INDEX | 137 | |
LOB | 2 | |
PACKAGE | 45 | |
PACKAGE BODY | 43 | |
SEQUENCE | 5 | |
TABLE | 126 | |
TRIGGER | 48 | |
TYPE | 7 | |
VIEW | 307 | |
ORACLE_OCM | JOB | 2 |
PACKAGE | 3 | |
PACKAGE BODY | 3 | |
ORDDATA | INDEX | 138 |
LOB | 9 | |
SEQUENCE | 12 | |
TABLE | 73 | |
VIEW | 25 | |
ORDPLUGINS | PACKAGE | 5 |
PACKAGE BODY | 5 | |
ORDSYS | FUNCTION | 32 |
INDEX | 4 | |
JAVA CLASS | 1,876 | |
JAVA RESOURCE | 72 | |
LIBRARY | 2 | |
PACKAGE | 28 | |
PACKAGE BODY | 20 | |
PROCEDURE | 7 | |
TABLE | 5 | |
TYPE | 446 | |
TYPE BODY | 15 | |
VIEW | 5 | |
OUTLN | INDEX | 5 |
LOB | 1 | |
PROCEDURE | 1 | |
TABLE | 3 | |
OWBSYS | INDEX | 1 |
TABLE | 1 | |
OWBSYS_AUDIT | SYNONYM | 12 |
PM | INDEX | 21 |
LOB | 17 | |
TABLE | 3 | |
TYPE | 3 | |
PUBLIC | SYNONYM | 28,027 |
SCOTT | INDEX | 2 |
TABLE | 4 | |
SH | DIMENSION | 5 |
INDEX | 29 | |
INDEX PARTITION | 196 | |
LOB | 2 | |
MATERIALIZED VIEW | 2 | |
TABLE | 17 | |
TABLE PARTITION | 56 | |
VIEW | 1 | |
SI_INFORMTN_SCHEMA | SYNONYM | 8 |
SYS | CLUSTER | 10 |
CONSUMER GROUP | 25 | |
CONTEXT | 7 | |
DESTINATION | 2 | |
DIRECTORY | 9 | |
EDITION | 1 | |
EVALUATION CONTEXT | 10 | |
FUNCTION | 100 | |
INDEX | 1,221 | |
INDEX PARTITION | 54 | |
JAVA CLASS | 20,707 | |
JAVA DATA | 328 | |
JAVA RESOURCE | 761 | |
JAVA SOURCE | 2 | |
JOB | 10 | |
JOB CLASS | 14 | |
LIBRARY | 147 | |
LOB | 189 | |
LOB PARTITION | 1 | |
OPERATOR | 7 | |
PACKAGE | 633 | |
PACKAGE BODY | 607 | |
PROCEDURE | 105 | |
PROGRAM | 19 | |
QUEUE | 18 | |
RESOURCE PLAN | 10 | |
RULE | 1 | |
RULE SET | 13 | |
SCHEDULE | 3 | |
SCHEDULER GROUP | 4 | |
SEQUENCE | 135 | |
SYNONYM | 9 | |
TABLE | 1,004 | |
TABLE PARTITION | 52 | |
TABLE SUBPARTITION | 32 | |
TRIGGER | 9 | |
TYPE | 1,347 | |
TYPE BODY | 113 | |
UNDEFINED | 11 | |
VIEW | 3,849 | |
WINDOW | 9 | |
SYSMAN | EVALUATION CONTEXT | 2 |
FUNCTION | 12 | |
INDEX | 1,028 | |
LOB | 75 | |
MATERIALIZED VIEW | 1 | |
PACKAGE | 193 | |
PACKAGE BODY | 193 | |
PROCEDURE | 3 | |
QUEUE | 12 | |
RULE SET | 4 | |
SEQUENCE | 13 | |
TABLE | 729 | |
TRIGGER | 97 | |
TYPE | 672 | |
TYPE BODY | 49 | |
VIEW | 471 | |
SYSTEM | INDEX | 241 |
INDEX PARTITION | 104 | |
LOB | 25 | |
PACKAGE | 1 | |
PACKAGE BODY | 1 | |
PROCEDURE | 1 | |
QUEUE | 4 | |
SEQUENCE | 20 | |
SYNONYM | 8 | |
TABLE | 161 | |
TABLE PARTITION | 77 | |
TRIGGER | 2 | |
TYPE | 1 | |
VIEW | 14 | |
WMSYS | EVALUATION CONTEXT | 1 |
FUNCTION | 4 | |
INDEX | 70 | |
LOB | 9 | |
OPERATOR | 9 | |
PACKAGE | 22 | |
PACKAGE BODY | 22 | |
PROCEDURE | 4 | |
QUEUE | 2 | |
RULE SET | 2 | |
SEQUENCE | 9 | |
TABLE | 46 | |
TRIGGER | 2 | |
TYPE | 18 | |
TYPE BODY | 1 | |
VIEW | 111 | |
XDB | FUNCTION | 7 |
INDEX | 697 | |
INDEXTYPE | 2 | |
LIBRARY | 17 | |
LOB | 586 | |
OPERATOR | 7 | |
PACKAGE | 35 | |
PACKAGE BODY | 33 | |
PROCEDURE | 4 | |
SEQUENCE | 5 | |
TABLE | 94 | |
TRIGGER | 27 | |
TYPE | 97 | |
TYPE BODY | 5 | |
VIEW | 20 | |
XML SCHEMA | 54 | |
************************************************************ | ---------------- | |
Total: | 75,307 |
Owner | Segment Type | Segment Count | Size (in Bytes) |
---|---|---|---|
APEX_030200 | INDEX | 262 | 39,976,960 |
LOBINDEX | 50 | 3,276,800 | |
LOBSEGMENT | 50 | 10,420,224 | |
TABLE | 105 | 35,913,728 | |
CTXSYS | INDEX | 38 | 2,490,368 |
LOBINDEX | 2 | 131,072 | |
LOBSEGMENT | 2 | 131,072 | |
TABLE | 17 | 1,179,648 | |
DBSNMP | INDEX | 5 | 327,680 |
TABLE | 3 | 196,608 | |
EXFSYS | INDEX | 37 | 2,424,832 |
LOBINDEX | 1 | 65,536 | |
LOBSEGMENT | 1 | 65,536 | |
TABLE | 19 | 1,245,184 | |
HR | INDEX | 19 | 1,245,184 |
TABLE | 6 | 393,216 | |
IX | INDEX | 14 | 917,504 |
LOBINDEX | 3 | 196,608 | |
LOBSEGMENT | 3 | 196,608 | |
TABLE | 8 | 524,288 | |
LHR | TABLE | 6 | 35,979,264 |
MDSYS | INDEX | 98 | 7,405,568 |
LOBINDEX | 197 | 12,976,128 | |
LOBSEGMENT | 197 | 41,877,504 | |
NESTED TABLE | 16 | 1,048,576 | |
TABLE | 64 | 14,221,312 | |
OE | INDEX | 33 | 2,949,120 |
LOBINDEX | 15 | 983,040 | |
LOBSEGMENT | 15 | 1,048,576 | |
NESTED TABLE | 4 | 589,824 | |
TABLE | 10 | 3,932,160 | |
OLAPSYS | INDEX | 80 | 5,242,880 |
TABLE | 61 | 3,997,696 | |
ORDDATA | INDEX | 95 | 6,946,816 |
LOBINDEX | 6 | 393,216 | |
LOBSEGMENT | 6 | 3,014,656 | |
NESTED TABLE | 2 | 131,072 | |
TABLE | 51 | 3,735,552 | |
ORDSYS | INDEX | 3 | 196,608 |
TABLE | 4 | 262,144 | |
OUTLN | INDEX | 4 | 262,144 |
LOBINDEX | 1 | 65,536 | |
LOBSEGMENT | 1 | 65,536 | |
TABLE | 3 | 196,608 | |
PM | INDEX | 4 | 262,144 |
LOBINDEX | 17 | 1,114,112 | |
LOBSEGMENT | 17 | 11,206,656 | |
NESTED TABLE | 1 | 65,536 | |
TABLE | 2 | 196,608 | |
SCOTT | INDEX | 2 | 131,072 |
TABLE | 3 | 196,608 | |
SH | INDEX | 19 | 2,490,368 |
INDEX PARTITION | 112 | 11,141,120 | |
LOBINDEX | 2 | 131,072 | |
LOBSEGMENT | 2 | 131,072 | |
TABLE | 12 | 18,874,368 | |
TABLE PARTITION | 32 | 268,435,456 | |
SYS | CLUSTER | 10 | 53,805,056 |
INDEX | 1,000 | 185,729,024 | |
INDEX PARTITION | 54 | 4,521,984 | |
LOB PARTITION | 1 | 65,536 | |
LOBINDEX | 178 | 11,665,408 | |
LOBSEGMENT | 178 | 66,322,432 | |
NESTED TABLE | 16 | 1,048,576 | |
ROLLBACK | 1 | 393,216 | |
TABLE | 833 | 556,793,856 | |
TABLE PARTITION | 51 | 4,784,128 | |
TABLE SUBPARTITION | 32 | 2,097,152 | |
TYPE2 UNDO | 10 | 36,175,872 | |
SYSMAN | INDEX | 301 | 24,969,216 |
LOBINDEX | 43 | 2,818,048 | |
LOBSEGMENT | 43 | 3,407,872 | |
NESTED TABLE | 2 | 131,072 | |
TABLE | 190 | 16,842,752 | |
SYSTEM | INDEX | 160 | 10,485,760 |
INDEX PARTITION | 104 | 23,199,744 | |
LOBINDEX | 22 | 1,638,400 | |
LOBSEGMENT | 22 | 5,570,560 | |
TABLE | 114 | 7,471,104 | |
TABLE PARTITION | 77 | 73,728,000 | |
WMSYS | INDEX | 30 | 1,966,080 |
LOBINDEX | 5 | 327,680 | |
LOBSEGMENT | 5 | 327,680 | |
NESTED TABLE | 2 | 131,072 | |
TABLE | 14 | 917,504 | |
XDB | INDEX | 109 | 9,502,720 |
LOBINDEX | 585 | 38,338,560 | |
LOBSEGMENT | 585 | 95,223,808 | |
NESTED TABLE | 10 | 655,360 | |
TABLE | 83 | 21,626,880 | |
************************************************** | ---------------- | -------------------- | |
Total: | 6,712 | 1,825,898,496 |
Owner | Segment Name | Partition Name | Segment Type | Tablespace Name | Size (in bytes) | Extents |
---|---|---|---|---|---|---|
SYS | IDL_UB1$ | TABLE | SYSTEM | 260,046,848 | 102 | |
SYS | SOURCE$ | TABLE | SYSTEM | 75,497,472 | 80 | |
XDB | SYS_LOB0000057465C00025$$ | LOBSEGMENT | SYSAUX | 55,771,136 | 55 | |
LHR | TEST | TABLE | USERS | 35,651,584 | 49 | |
SYS | IDL_UB2$ | TABLE | SYSTEM | 32,505,856 | 46 | |
MDSYS | SYS_LOB0000064008C00006$$ | LOBSEGMENT | SYSAUX | 27,262,976 | 41 | |
SYS | C_TOID_VERSION# | CLUSTER | SYSTEM | 25,165,824 | 39 | |
SYS | TEST1 | TABLE | SYSTEM | 17,825,792 | 32 | |
SYS | SYS_LOB0000065858C00004$$ | LOBSEGMENT | SYSAUX | 16,908,288 | 17 | |
SYS | ARGUMENT$ | TABLE | SYSTEM | 12,582,912 | 27 | |
------------------------ | ------------------------ | |||||
Total | 559,218,688 | 488 |
Owner | Segment Name | Segment Type | OBJECT_SIZE_M |
---|---|---|---|
SYS | IDL_UB1$ | TABLE | 248 |
SH | COSTS | TABLE PARTITION | 128 |
SH | SALES | TABLE PARTITION | 128 |
SYS | SOURCE$ | TABLE | 72 |
XDB | SYS_LOB0000057465C00025$$ | LOBSEGMENT | 53 |
LHR | TEST | TABLE | 34 |
SYS | IDL_UB2$ | TABLE | 31 |
MDSYS | SYS_LOB0000064008C00006$$ | LOBSEGMENT | 26 |
SYS | C_TOID_VERSION# | CLUSTER | 24 |
SYS | TEST1 | TABLE | 17 |
------------- | |||
Total | 761 |
Owner | Segment Name | Partition Name | Segment Type | Tablespace Name | Extents | Size (in bytes) |
---|---|---|---|---|---|---|
SYS | IDL_UB1$ | TABLE | SYSTEM | 102 | 260,046,848 | |
SYS | SOURCE$ | TABLE | SYSTEM | 80 | 75,497,472 | |
XDB | SYS_LOB0000057465C00025$$ | LOBSEGMENT | SYSAUX | 55 | 55,771,136 | |
LHR | TEST | TABLE | USERS | 49 | 35,651,584 | |
SYS | IDL_UB2$ | TABLE | SYSTEM | 46 | 32,505,856 | |
MDSYS | SYS_LOB0000064008C00006$$ | LOBSEGMENT | SYSAUX | 41 | 27,262,976 | |
SYS | C_TOID_VERSION# | CLUSTER | SYSTEM | 39 | 25,165,824 | |
SYS | TEST1 | TABLE | SYSTEM | 32 | 17,825,792 | |
SYS | ARGUMENT$ | TABLE | SYSTEM | 27 | 12,582,912 | |
SH | CUSTOMERS | TABLE | EXAMPLE | 27 | 12,582,912 | |
------------------------ | ------------------------ | |||||
Total | 498 | 554,893,312 |
Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)
Owner | Table Name | Column Name | LOB Segment Name | Tablespace Name | Segment Size | LOB Index Name | In 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
NOTE: Tables must have statistics gathered
TABLE_OWNER | TABLE_NAME | CNT |
---|---|---|
SH | SALES | 28 |
SH | COSTS | 28 |
SYS | WRH$_ACTIVE_SESSION_HISTORY | 2 |
SYSTEM | LOGMNR_LOBFRAG$ | 2 |
SYSTEM | LOGMNR_OPQTYPE$ | 2 |
SYS | WRH$_WAITSTAT | 2 |
SYSTEM | LOGMNRC_GTCS | 2 |
SYSTEM | LOGMNRP_CTAS_PART_MAP | 2 |
SYSTEM | LOGMNR_ATTRCOL$ | 2 |
SYSTEM | LOGMNR_DICTSTATE$ | 2 |
Owner | Object Name | Object Type | Status | HANDS_ON |
---|---|---|---|---|
************************************************************************************* | ------------------------------ | |||
Grand Total: | 0 |
OWNER | TRIGGER_NAME | TABLE_NAME | STATUS |
---|---|---|---|
HR | SECURE_EMPLOYEES | EMPLOYEES | DISABLED |
OWNER | TABLE_NAME | CNT |
---|---|---|
PM | ONLINE_MEDIA | 11 |
OE | PURCHASEORDER | 10 |
PM | PRINT_MEDIA | 8 |
OE | CUSTOMERS | 7 |
HR | EMPLOYEES | 6 |
OE | WAREHOUSES | 5 |
FLOWS_FILES | WWV_FLOW_FILE_OBJECTS$ | 5 |
SH | SALES | 5 |
● 大于2G大表未建索引
TABLE_OWNER | TABLE_NAME | CROSS_IDX_RATE |
---|---|---|
FLOWS_FILES | WWV_FLOW_FILE_OBJECTS$ | .8 |
HR | JOB_HISTORY | .8 |
OE | INVENTORIES | .66 |
IX | AQ$_STREAMS_QUEUE_TABLE_C | .66 |
OE | ORDER_ITEMS | .5 |
TABLE_OWNER | TABLE_NAME | INDEX_NAME | COUNT(*) |
---|---|---|---|
IX | AQ$_STREAMS_QUEUE_TABLE_I | SYS_IOT_TOP_76262 | 9 |
IX | AQ$_ORDERS_QUEUETABLE_I | SYS_IOT_TOP_76256 | 8 |
SH | DR$SUP_TEXT_IDX$I | DR$SUP_TEXT_IDX$X | 5 |
IX | AQ$_STREAMS_QUEUE_TABLE_G | SYS_IOT_TOP_76266 | 4 |
IX | AQ$_STREAMS_QUEUE_TABLE_H | SYS_IOT_TOP_76258 | 4 |
IX | AQ$_ORDERS_QUEUETABLE_G | SYS_IOT_TOP_76253 | 4 |
IX | AQ$_ORDERS_QUEUETABLE_H | SYS_IOT_TOP_76251 | 4 |
OWNER | TABLE_NAME | INDEX_NAME | INDEX_TYPE | STATUS | BLEVEL | LEAF_BLOCKS |
---|---|---|---|---|---|---|
OE | CUSTOMERS | CUST_UPPER_NAME_IX | FUNCTION-BASED NORMAL | VALID | 1 | 2 |
SH | COSTS | COSTS_PROD_BIX | BITMAP | N/A | 1 | 25 |
SH | CUSTOMERS | CUSTOMERS_GENDER_BIX | BITMAP | VALID | 1 | 3 |
SH | CUSTOMERS | CUSTOMERS_MARITAL_BIX | BITMAP | VALID | 1 | 5 |
SH | CUSTOMERS | CUSTOMERS_YOB_BIX | BITMAP | VALID | 1 | 19 |
SH | FWEEK_PSCAT_SALES_MV | FW_PSC_S_MV_SUBCAT_BIX | BITMAP | VALID | 1 | 3 |
SH | FWEEK_PSCAT_SALES_MV | FW_PSC_S_MV_CHAN_BIX | BITMAP | VALID | 0 | 1 |
SH | FWEEK_PSCAT_SALES_MV | FW_PSC_S_MV_PROMO_BIX | BITMAP | VALID | 0 | 1 |
SH | FWEEK_PSCAT_SALES_MV | FW_PSC_S_MV_WD_BIX | BITMAP | VALID | 1 | 4 |
SH | PRODUCTS | PRODUCTS_PROD_STATUS_BIX | BITMAP | VALID | 0 | 1 |
SH | SALES | SALES_PROD_BIX | BITMAP | N/A | 1 | 32 |
SH | SALES | SALES_CHANNEL_BIX | BITMAP | N/A | 1 | 47 |
SH | SALES | SALES_TIME_BIX | BITMAP | N/A | 1 | 57 |
SH | SALES | SALES_PROMO_BIX | BITMAP | N/A | 1 | 30 |
SH | SALES | SALES_CUST_BIX | BITMAP | N/A | 1 | 452 |
SH | COSTS | COSTS_TIME_BIX | BITMAP | N/A | 1 | 34 |
OWNER | TABLE_NAME | CONSTRAINT_NAME | COLUMNS |
---|---|---|---|
SH | CUSTOMERS | CUSTOMERS_COUNTRY_FK | COUNTRY_ID |
SH | COSTS | COSTS_CHANNEL_FK | CHANNEL_ID |
SCOTT | EMP | FK_DEPTNO | DEPTNO |
HR | COUNTRIES | COUNTR_REG_FK | REGION_ID |
HR | LOCATIONS | LOC_C_ID_FK | PRODUCT_ID |
SH | COSTS | COSTS_PROMO_FK | PROMO_ID |
HR | DEPARTMENTS | DEPT_MGR_FK | MANAGER_ID |
PM | ONLINE_MEDIA | LOC_C_ID_FK | PRODUCT_ID |
● 数据库目录概览
Owner | Directory Name | Directory 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 Name | Grantee | Privilege | Grantable? |
---|---|---|---|
DATA_FILE_DIR | SH | READ |
NO
|
DATA_PUMP_DIR | EXP_FULL_DATABASE | READ |
NO
|
WRITE |
NO
|
||
IMP_FULL_DATABASE | READ |
NO
|
|
WRITE |
NO
|
||
DIR_ALERT_CHECKHELTH_LHR_1 | LHR | READ |
YES
|
WRITE |
YES
|
||
LOG_FILE_DIR | SH | READ |
NO
|
WRITE |
NO
|
||
MEDIA_DIR | PM | READ |
NO
|
ORACLE_OCM_CONFIG_DIR | ORACLE_OCM | READ |
NO
|
WRITE |
NO
|
||
SS_OE_XMLDIR | OE | READ |
YES
|
WRITE |
YES
|
||
SUBDIR | OE | READ |
YES
|
WRITE |
YES
|
● 回收站中最早的10个对象
Owner | original_name | Object Type | object_name | Tablespace | Operation | createtime | droptime | Can Undrop? | Can Purge? | Bytes |
---|---|---|---|---|---|---|---|---|---|---|
LHR
|
TESTDG | TABLE | BIN$HfsE79K3Nl/gU4I7qMC29w==$0 | USERS | DROP |
2015-07-27:14:07:32
|
2015-08-23:20:55:45
|
YES
|
YES
|
65,536 |
● 回收站中对象的大小
Owner | SUM(RECYB_SIZE_M) | SUM(RECYB_CNT) |
---|---|---|
LHR | .0625 | 1 |
合计 | .0625 | 1 |
OWNER | TABLE_NAME | TYP | TYPE_NAME | DEF | DEFAULT_DIRECTORY_NAME | REJECT_LIMIT | ACCESS_ | ACCESS_PARAMETERS | PROPERTY |
---|---|---|---|---|---|---|---|---|---|
SH | SALES_TRANSACTIONS_EXT | SYS | ORACLE_LOADER | SYS | DATA_FILE_DIR | 100 | CLOB | RECORDS DELIMITED BY NEWLINE CHARACTERSE T US7ASCII TERRITORY AMERICAN BA DFILE log_file_dir:'ext_1v3.bad' LOG FILE log_file_dir:'ext_1v3.log' FIEL DS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '^' LDRTRIM ( PROD_ID , CUST_ID , TIME_ID DATE(10) "YYYY-MM-DD", CHANN EL_ID , PROMO_ID , QUANTITY_SOLD , AMOUNT_SOLD , UNIT_COST , UNIT_ PRICE ) | ALL |
LHR | T_ALERT_CHECKHELTH_LHR_1 | SYS | ORACLE_LOADER | SYS | DIR_ALERT_CHECKHELTH_LHR_1 | UNLIMITED | CLOB | records delimited by newline | ALL |
● 查看最新的100行告警日志记录(排除日志切换)
INSTANCE | RN | TEXT |
---|---|---|
instance1 | 992 | NSA2 started with pid=25 |
instance1 | 993 | Wed Aug 26 15:24:25 2015 |
instance1 | 994 | NSA3 started with pid=26 |
instance1 | 995 | Wed Aug 26 15:24:25 2015 |
instance1 | 996 | NSA4 started with pid=27 |
instance1 | 998 | Error 1034 received logging on to the standby |
instance1 | 999 | PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradglg'. Error is 1034. |
instance1 | 1000 | Error 1034 received logging on to the standby |
instance1 | 1001 | FAL[server |
instance1 | 1002 | FAL[server |
instance1 | 1003 | ARCH: FAL archive failed. Archiver continuing |
instance1 | 1004 | ORACLE Instance oradg11g - Archival Error. Archiver continuing. |
instance1 | 1005 | Error 1034 received logging on to the standby |
instance1 | 1006 | PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradgphy'. Error is 1034. |
instance1 | 1007 | Error 1034 received logging on to the standby |
instance1 | 1008 | FAL[server |
instance1 | 1009 | FAL[server |
instance1 | 1010 | ARCH: FAL archive failed. Archiver continuing |
instance1 | 1011 | ORACLE Instance oradg11g - Archival Error. Archiver continuing. |
instance1 | 1012 | [58778] Successfully onlined Undo Tablespace 2. |
instance1 | 1013 | Undo initialization finished serial:0 start:52945694 end:52946474 diff:780 (7 seconds) |
instance1 | 1014 | Verifying file header compatibility for 11g tablespace encryption.. |
instance1 | 1015 | Verifying 11g file header compatibility for tablespace encryption completed |
instance1 | 1016 | SMON: enabling tx recovery |
instance1 | 1017 | Database Characterset is ZHS16GBK |
instance1 | 1018 | No Resource Manager plan active |
instance1 | 1019 | replication_dependency_tracking turned off (no async multimaster replication found) |
instance1 | 1020 | Starting background process QMNC |
instance1 | 1021 | Wed Aug 26 15:24:27 2015 |
instance1 | 1022 | QMNC started with pid=28 |
instance1 | 1023 | Error 1034 received logging on to the standby |
instance1 | 1024 | FAL[server |
instance1 | 1025 | FAL[server |
instance1 | 1026 | ARCH: FAL archive failed. Archiver continuing |
instance1 | 1027 | ORACLE Instance oradg11g - Archival Error. Archiver continuing. |
instance1 | 1028 | Wed Aug 26 15:24:28 2015 |
instance1 | 1031 | Completed: ALTER DATABASE OPEN |
instance1 | 1033 | Wed Aug 26 15:24:29 2015 |
instance1 | 1034 | Starting background process CJQ0 |
instance1 | 1035 | Wed Aug 26 15:24:29 2015 |
instance1 | 1036 | db_recovery_file_dest_size of 4122 MB is 3.37% used. This is a |
instance1 | 1037 | user-specified limit on the amount of space that will be used by this |
instance1 | 1038 | database for recovery-related files |
instance1 | 1039 | space available in the underlying filesystem or ASM diskgroup. |
instance1 | 1040 | Wed Aug 26 15:24:29 2015 |
instance1 | 1041 | CJQ0 started with pid=33 |
instance1 | 1042 | Wed Aug 26 15:28:56 2015 |
instance1 | 1045 | Wed Aug 26 15:28:56 2015 |
instance1 | 1047 | Wed Aug 26 15:29:26 2015 |
instance1 | 1050 | Wed Aug 26 15:29:26 2015 |
instance1 | 1051 | ARC2: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_2 |
instance1 | 1052 | Wed Aug 26 15:29:26 2015 |
instance1 | 1054 | Wed Aug 26 15:29:26 2015 |
instance1 | 1055 | ****************************************************************** |
instance1 | 1056 | LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2 |
instance1 | 1057 | ****************************************************************** |
instance1 | 1058 | LNS: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_2 |
instance1 | 1059 | Wed Aug 26 15:29:27 2015 |
instance1 | 1060 | Starting background process SMCO |
instance1 | 1061 | Wed Aug 26 15:29:29 2015 |
instance1 | 1062 | SMCO started with pid=29 |
instance1 | 1063 | ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_3 |
instance1 | 1064 | Wed Aug 26 15:29:35 2015 |
instance1 | 1065 | ARC0: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_2 |
instance1 | 1066 | Wed Aug 26 15:29:39 2015 |
instance1 | 1067 | ARC2: Standby redo logfile selected for thread 1 sequence 89 for destination LOG_ARCHIVE_DEST_4 |
instance1 | 1068 | Wed Aug 26 15:30:23 2015 |
instance1 | 1069 | Time drift detected. Please check VKTM trace file for more details. |
instance1 | 1070 | Wed Aug 26 15:30:42 2015 |
instance1 | 1071 | ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_4 |
instance1 | 1072 | ARC3: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_3 |
instance1 | 1073 | Wed Aug 26 15:54:33 2015 |
instance1 | 1076 | Wed Aug 26 15:54:33 2015 |
instance1 | 1077 | ****************************************************************** |
instance1 | 1078 | LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_3 |
instance1 | 1079 | ****************************************************************** |
instance1 | 1080 | Wed Aug 26 15:54:33 2015 |
instance1 | 1081 | ****************************************************************** |
instance1 | 1082 | LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_4 |
instance1 | 1083 | ****************************************************************** |
instance1 | 1084 | Wed Aug 26 15:54:33 2015 |
instance1 | 1085 | LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_2 |
instance1 | 1086 | Wed Aug 26 15:54:34 2015 |
instance1 | 1088 | LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_4 |
instance1 | 1089 | LNS: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_3 |
instance1 | 1090 | Wed Aug 26 15:54:36 2015 |
instance1 | 1091 | ARC0: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_3 |
instance1 | 1092 | ARC3: Standby redo logfile selected for thread 1 sequence 90 for destination LOG_ARCHIVE_DEST_4 |
FROM T_ALERT_CHECKHELTH_LHR_2 t) a *
ERROR at line 8:
ORA-00942: table or view does not exist
● 查看最新的10条ora告警日志记录
INSTANCE | RN | TEXT |
---|---|---|
instance1 | 334 | ORA-03135: connection lost contact |
instance1 | 368 | ORA-03135: connection lost contact |
instance1 | 430 | ORA-03135: connection lost contact |
instance1 | 450 | ORA-03135: connection lost contact |
instance1 | 470 | ORA-03135: connection lost contact |
instance1 | 515 | ORA-03135: connection lost contact |
instance1 | 552 | ORA-03135: connection lost contact |
instance1 | 564 | ORA-16439: Standby not ready to receive redo at this time |
instance1 | 738 | ORA-03135: connection lost contact |
FROM T_ALERT_CHECKHELTH_LHR_2 t) a *
ERROR at line 8:
ORA-00942: table or view does not exist
OWNER | TRIGGER_NAME | TABLE_NAME | STATUS |
---|---|---|---|
FLOWS_FILES | WWV_BIU_FLOW_FILE_OBJECTS | WWV_FLOW_FILE_OBJECTS$ | ENABLED |
HR | SECURE_EMPLOYEES | EMPLOYEES | DISABLED |
HR | UPDATE_JOB_HISTORY | EMPLOYEES | ENABLED |
OE | INSERT_ORD_LINE | ORDER_ITEMS | ENABLED |
OE | PURCHASEORDER$xd | PURCHASEORDER | ENABLED |
OE | ORDERS_ITEMS_TRG | OC_ORDERS | ENABLED |
OE | ORDERS_TRG | OC_ORDERS | ENABLED |
● 序列cache小于20,一般情况下将其增至1000左右,序列默认的20太小了
SEQUENCE_OWNER | SEQUENCE_NAME | CACHE_SIZE | ALTER_SEQUENCE |
---|---|---|---|
DBSNMP | MGMT_RESPONSE_SNAPSHOT_ID | 20 | alter sequence DBSNMP.MGMT_RESPONSE_SNAPSHOT_ID cache 1000; |
DBSNMP | MGMT_RESPONSE_CAPTURE_ID | 20 | alter sequence DBSNMP.MGMT_RESPONSE_CAPTURE_ID cache 1000; |
XDB | CLIENTID_SEQUENCE | 10 | alter sequence XDB.CLIENTID_SEQUENCE cache 1000; |
XDB | STATEID_RESTART_SEQUENCE | 20 | alter sequence XDB.STATEID_RESTART_SEQUENCE cache 1000; |
XDB | XDB$TYPEID_SEQ | 20 | alter sequence XDB.XDB$TYPEID_SEQ cache 1000; |
XDB | XDB$NAMESUFF_SEQ | 20 | alter sequence XDB.XDB$NAMESUFF_SEQ cache 1000; |
XDB | XDB$PROPNUM_SEQ | 20 | alter sequence XDB.XDB$PROPNUM_SEQ cache 1000; |
ORDDATA | ORDDCM_CT_PRED_SET_SEQ | 0 | alter sequence ORDDATA.ORDDCM_CT_PRED_SET_SEQ cache 1000; |
ORDDATA | ORDDCM_CT_PRED_SEQ | 0 | alter sequence ORDDATA.ORDDCM_CT_PRED_SEQ cache 1000; |
ORDDATA | ORDDCM_DATA_MODEL_SEQ | 0 | alter sequence ORDDATA.ORDDCM_DATA_MODEL_SEQ cache 1000; |
ORDDATA | ORDDCM_UID_DEFS_UDID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_UID_DEFS_UDID_SEQ cache 1000; |
ORDDATA | ORDDCM_RT_PREF_P_PPID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_RT_PREF_P_PPID_SEQ cache 1000; |
ORDDATA | ORDDCM_ANON_ATTRS_SEQ | 0 | alter sequence ORDDATA.ORDDCM_ANON_ATTRS_SEQ cache 1000; |
ORDDATA | ORDDCM_MPD_P_MPID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_MPD_P_MPID_SEQ cache 1000; |
ORDDATA | ORDDCM_DICT_A_DA_ID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_DICT_A_DA_ID_SEQ cache 1000; |
ORDDATA | ORDDCM_PRV_A_PA_ID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_PRV_A_PA_ID_SEQ cache 1000; |
ORDDATA | ORDDCM_STD_A_SA_ID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_STD_A_SA_ID_SEQ cache 1000; |
ORDDATA | ORDDCM_DOCS_ID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_DOCS_ID_SEQ cache 1000; |
ORDDATA | ORDDCM_STOREDTAGS_STID_SEQ | 0 | alter sequence ORDDATA.ORDDCM_STOREDTAGS_STID_SEQ cache 1000; |
APEX_030200 | WWV_FLOW_WORKSHEET_SEQ | 20 | alter sequence APEX_030200.WWV_FLOW_WORKSHEET_SEQ cache 1000; |
APEX_030200 | WWV_FLOW_VERSION_SEQ | 20 | alter sequence APEX_030200.WWV_FLOW_VERSION_SEQ cache 1000; |
APEX_030200 | WWV_FLOW_SESSION_SEQ | 20 | alter sequence APEX_030200.WWV_FLOW_SESSION_SEQ cache 1000; |
APEX_030200 | WWV_SEQ | 20 | alter sequence APEX_030200.WWV_SEQ cache 1000; |
HR | EMPLOYEES_SEQ | 0 | alter sequence HR.EMPLOYEES_SEQ cache 1000; |
HR | DEPARTMENTS_SEQ | 0 | alter sequence HR.DEPARTMENTS_SEQ cache 1000; |
HR | LOCATIONS_SEQ | 0 | alter sequence HR.LOCATIONS_SEQ cache 1000; |
OE | ORDERS_SEQ | 0 | alter sequence OE.ORDERS_SEQ cache 1000; |
IX | AQ$_STREAMS_QUEUE_TABLE_N | 20 | alter sequence IX.AQ$_STREAMS_QUEUE_TABLE_N cache 1000; |
IX | AQ$_ORDERS_QUEUETABLE_N | 20 | alter sequence IX.AQ$_ORDERS_QUEUETABLE_N cache 1000; |
● 历史等待事件中是否有序列等待
OWNER | TABLE_NAME | DEGREE |
---|---|---|
LHR | T_ALERT_CHECKHELTH_LHR_1 | 8 |
实例 名称 | 统计时间 | 内存读(MB) | 磁盘读(MB) | 磁盘写(KB) | 日志量(KB) | 硬分析(个) | 分析(个) | 事务数 | CPU(秒) |
---|---|---|---|---|---|---|---|---|---|
1
|
2015-08-26 15:34:42 | 0 | 0 | -1 | -1 | 0 | 0 | 0 | 29 |
2015-08-25 09:18:07 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | |
2015-08-24 00:01:06 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 6 | |
2015-08-23 23:00:26 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 5 | |
2015-08-23 22:00:49 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 6 | |
2015-08-23 21:01:07 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 7 | |
2015-08-23 20:00:27 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 7 | |
2015-08-23 19:00:48 | 1 | 0 | 4 | 3 | 0 | 1 | 0 | 32 |
Database ID | Database Name | Snap Interval | Retention Period | Top N SQL |
---|---|---|---|---|
1403587593
|
ORADG11G | +00000 01:00:00.0 | +00008 00:00:00.0 | DEFAULT |
● 近7天以来AWR视图中的load profile信息
SNAP_DATE | SNAP_TIME_RANGE | SNAP_ID_RANGE | TIME | STARTUP_TIME | elapse(min) | DB time(min) | SESSIONS | Cursors/Session | REDO | redo/s | redo/t | LOGICAL | logical/s | logical/t | PHYSICAL | phy/s | phy/t | EXECS | execs/s | execs/t | PARSE | parse/s | parse/t | HARDPARSE | hardparse/s | hardparse/t | TRANS | trans/s |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2015-08-25 | 2015-08-24 00:01~2015-08-25 09:18 | 111~112 | 09:18 | 2015-08-23 17:35:19 | 1997.02 | 2.99 | 33~32 | 1.09~.96 | 52713324 | 439.93 | 304701.29 | 217925 | 1.82 | 1259.68 | 45023 | .38 | 260.25 | 35977 | .3 | 207.96 | 6871 | .06 | 39.72 | 2056 | .02 | 11.88 | 173 | 0 |
2015-08-24 | 2015-08-23 23:00~2015-08-24 00:01 | 110~111 | 00:01 | 2015-08-23 17:35:19 | 60.67 | .04 | 34~33 | .94~1.09 | 2074312 | 569.87 | 62857.94 | 45272 | 12.44 | 1371.88 | 2039 | .56 | 61.79 | 11038 | 3.03 | 334.48 | 1850 | .51 | 56.06 | 465 | .13 | 14.09 | 33 | .01 |
2015-08-23 | 2015-08-23 22:00~2015-08-23 23:00 | 109~110 | 23:00 | 2015-08-23 17:35:19 | 59.62 | .02 | 35~34 | 1.08~.94 | 2075428 | 580.21 | 61042 | 43888 | 12.27 | 1290.82 | 1858 | .52 | 54.65 | 8709 | 2.43 | 256.15 | 1265 | .35 | 37.21 | 430 | .12 | 12.65 | 34 | .01 |
2015-08-23 | 2015-08-23 21:01~2015-08-23 22:00 | 108~109 | 22:00 | 2015-08-23 17:35:19 | 59.7 | .08 | 31~35 | 1.19~1.08 | 2208704 | 616.61 | 66930.42 | 33874 | 9.46 | 1026.48 | 1755 | .49 | 53.18 | 7585 | 2.12 | 229.85 | 1177 | .33 | 35.67 | 379 | .11 | 11.48 | 33 | .01 |
2015-08-23 | 2015-08-23 20:00~2015-08-23 21:01 | 107~108 | 21:01 | 2015-08-23 17:35:19 | 60.67 | .06 | 37~31 | 1.05~1.19 | 3626028 | 996.16 | 95421.79 | 45485 | 12.5 | 1196.97 | 2290 | .63 | 60.26 | 9350 | 2.57 | 246.05 | 1382 | .38 | 36.37 | 447 | .12 | 11.76 | 38 | .01 |
2015-08-23 | 2015-08-23 19:00~2015-08-23 20:00 | 106~107 | 20:00 | 2015-08-23 17:35:19 | 59.65 | .05 | 38~37 | 1.13~1.05 | 2684040 | 749.94 | 76686.86 | 49804 | 13.92 | 1422.97 | 3119 | .87 | 89.11 | 10948 | 3.06 | 312.8 | 1568 | .44 | 44.8 | 528 | .15 | 15.09 | 35 | .01 |
2015-08-23 | 2015-08-23 17:46~2015-08-23 19:00 | 105~106 | 19:00 | 2015-08-23 17:35:19 | 74.28 | .14 | 33~38 | 1.33~1.13 | 12363432 | 2773.94 | 475516.62 | 330477 | 74.15 | 12710.65 | 51483 | 11.55 | 1980.12 | 27628 | 6.2 | 1062.62 | 3689 | .83 | 141.88 | 1288 | .29 | 49.54 | 26 | .01 |
● 热块(汇总)
FROM x$bh *
ERROR at line 6:
ORA-00942: table or view does not exist
● 热块(展开,未汇总)
FROM x$bh *
ERROR at line 6:
ORA-00942: table or view does not exist
CLIENT_NAME | STATUS |
---|---|
auto optimizer stats collection | ENABLED |
auto space advisor | ENABLED |
sql tuning advisor | ENABLED |
WINDOW_NAME | WINDOW_NEXT_TIME | WINDO | AUTOTASK | OPTIMIZE | SEGMENT_ | SQL_TUNE | HEALTH_M |
---|---|---|---|---|---|---|---|
MONDAY_WINDOW | 2015-08-31 22:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
TUESDAY_WINDOW | 2015-09-01 22:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
WEDNESDAY_WINDOW | 2015-08-26 22:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
THURSDAY_WINDOW | 2015-08-27 22:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
FRIDAY_WINDOW | 2015-08-28 22:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
SATURDAY_WINDOW | 2015-08-29 06:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
SUNDAY_WINDOW | 2015-08-30 06:00:00 | FALSE | ENABLED | ENABLED | ENABLED | ENABLED | DISABLED |
Instance Name | Thread Number | Current No. of Processes | Max No. of Processes | % Usage |
---|---|---|---|---|
oradg11g
|
1
|
34
|
150
|
22.67%
|
User sessions (excluding SYS and background processes)
Instance Name | Thread Number | Oracle User | Total Number of Logins | Active Logins | Inactive Logins | Killed Logins |
---|---|---|---|---|---|---|
oradg11g
|
1
|
LHR
|
4 | 1 | 3 | 0 |
INST_ID | SID | SERIAL# | SPID | PROGRAM | STATUS | SQL_ID | PREV_SQL_ID | EVENT | WAIT_CLASS | LOGON_TIME | TOTAL_H |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 125 | 5 | 58778 | sqlplus@rhel6_lhr (TNS V1-V3) | INACTIVE | gg5409ku2xk00 | SQL*Net message from client | Idle | 2015-08-26 15:24:23 | .71 | |
1 | 20 | 11 | 59791 | plsqldev.exe | INACTIVE | 3nz260v5dwqnv | SQL*Net message from client | Idle | 2015-08-26 15:32:23 | .57 | |
1 | 146 | 11 | 59795 | plsqldev.exe | INACTIVE | 9m7787camwh4m | SQL*Net message from client | Idle | 2015-08-26 15:32:25 | .57 | |
1 | 25 | 11 | 59949 | sqlplus.exe | INACTIVE | ab6c4m41phxmf | SQL*Net message from client | Idle | 2015-08-26 15:35:18 | .53 | |
1 | 154 | 133 | 61557 | sqlplus.exe | ACTIVE | f683w8x4kggjj | 9babjv8yq8ru3 | SQL*Net message to client | Network | 2015-08-26 16:05:39 | .02 |
INST_ID | USERNAME | EVENT | SECONDS | SQL_ID | SQLTEXT | SID | SERIAL# | MACHINE | PROGRAM | OSUSER |
---|---|---|---|---|---|---|---|---|---|---|
1 | LHR | Cpu + Wait For Cpu | 1 | fq128d6s13bx8 | SELECT '
' || l.owner || '
' |
|||||
1 | LHR | Cpu + Wait For Cpu | 1 | 96ub5w77tu2ac | SELECT column_name,data_type_owner,data_type FROM dba_tab_columns where owner=:o and table_name=:t | |||||
1 | LHR | Cpu + Wait For Cpu | 1 | duwq6t6ck11ba | select * from (select owner, segment_name, segment_type, | |||||
1 | LHR | Cpu + Wait For Cpu | 1 | 3nd96vy0fb1sv | SELECT j.instance_id, j.JOB_CREATOR, j.OWNER, j.job_name, j.state job_ST | |||||
1 | SYS | Cpu + Wait For Cpu | 1 | 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), | |||||
1 | LHR | Cpu + Wait For Cpu | 1 | 2bmgd7b5y2x6t | select owner,table_name, count(*) cnt from dba_indexes where owner not in ('XDB', | |||||
1 | LHR | Cpu + Wait For Cpu | 1 | cm4vhpunwknmz | SELECT al.thread#, ads.dest_id, ads.DEST_NAME, (SELECT ads.TYPE || ' ' || ad.TA |
INST_ID | OS_USER_NAME | USER_NAME | LOCK_TYPE | OBJECT | LOCK_MODE | OWNER | SID | SERIAL_NUM | ID1 | ID2 |
---|---|---|---|---|---|---|---|---|---|---|
1 | Administrator | LHR | SDO_GEOR_DDL__TABLE$$ | Row Exclusive | MDSYS | 154 | 133 | 68064 | 1 |
COUNT(*) | ROUND(SUM(SHARABLE_MEM)/1024/1024,2) |
---|---|
5467 | 41.34 |
INST_ID | SPID | PID | SID | SERIAL# | STATUS | PGA_ALLOC_MEM | USERNAME | OSUSER | PROGRAM | SQL_ID |
---|---|---|---|---|---|---|---|---|---|---|
1 | 58780 | 21 | 135 | 3 | ACTIVE | 65055208 | oracle | oracle@rhel6_lhr (ARC0) | ||
1 | 58790 | 24 | 11 | 1 | ACTIVE | 58894824 | oracle | oracle@rhel6_lhr (ARC3) | ||
1 | 58788 | 23 | 136 | 3 | ACTIVE | 31361304 | oracle | oracle@rhel6_lhr (ARC2) | ||
1 | 58798 | 25 | 138 | 1 | ACTIVE | 29862376 | oracle | oracle@rhel6_lhr (NSA2) | ||
1 | 58802 | 27 | 139 | 1 | ACTIVE | 29862376 | oracle | oracle@rhel6_lhr (NSA4) | ||
1 | 58800 | 26 | 13 | 1 | ACTIVE | 29862376 | oracle | oracle@rhel6_lhr (NSA3) | ||
1 | 58786 | 22 | 10 | 1 | ACTIVE | 29534696 | oracle | oracle@rhel6_lhr (ARC1) | ||
1 | 58756 | 11 | 130 | 1 | ACTIVE | 12085064 | oracle | oracle@rhel6_lhr (LGWR) | ||
1 | 61557 | 31 | 154 | 133 | ACTIVE | 4426040 | LHR | Administrator | sqlplus.exe | 96rxbcbf0rw1x |
1 | 58754 | 10 | 5 | 1 | ACTIVE | 4147048 | oracle | oracle@rhel6_lhr (DBW0) | ||
1 | 59949 | 30 | 25 | 11 | INACTIVE | 2787640 | LHR | Administrator | sqlplus.exe | |
1 | 59795 | 51 | 146 | 11 | INACTIVE | 2573976 | LHR | Administrator | plsqldev.exe | |
1 | 58764 | 15 | 132 | 1 | ACTIVE | 2320200 | oracle | oracle@rhel6_lhr (MMON) | ||
1 | 58778 | 19 | 125 | 5 | INACTIVE | 2214552 | SYS | oracle | sqlplus@rhel6_lhr (TNS V1-V3) | |
1 | 58760 | 13 | 131 | 1 | ACTIVE | 1935672 | oracle | oracle@rhel6_lhr (SMON) | ||
1 | 58863 | 33 | 133 | 11 | ACTIVE | 1878504 | oracle | oracle@rhel6_lhr (CJQ0) | ||
1 | 59791 | 50 | 20 | 11 | INACTIVE | 1607992 | LHR | Administrator | plsqldev.exe | |
1 | 58750 | 8 | 4 | 1 | ACTIVE | 1468232 | oracle | oracle@rhel6_lhr (DIA0) | ||
1 | 58906 | 37 | 144 | 5 | ACTIVE | 1345848 | oracle | oracle@rhel6_lhr (Q000) | ||
1 | 58762 | 14 | 7 | 1 | ACTIVE | 1149240 | oracle | oracle@rhel6_lhr (RECO) |
PHYSICAL_READS | DB_BLOCK_GETS | CONSISTENT_GETS | Hit Ratio |
---|---|---|---|
58815 | 14528 | 951454 | 93.91% |
GETS | GETHITS | Hit Ratio | PINS | PINHITS | Hit Ratio |
---|---|---|---|---|---|
31803 | 21473 | 67.52 | 77742 | 65139 | 83.79 |
● librarycache 各namaspace 的命中率
NAMESPACE | GETS | GETHITS | Hit Ratio | PINS | PINHITS | Hit Ratio |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 12 | 11 | 91.67 | 0 | 0 | 0 |
BODY | 246 | 172 | 69.92 | 1540 | 1454 | 94.42 |
CLUSTER | 722 | 711 | 98.48 | 757 | 746 | 98.55 |
DBINSTANCE | 1 | 0 | 0 | 0 | 0 | 0 |
DBLINK | 16 | 15 | 93.75 | 0 | 0 | 0 |
DIRECTORY | 66 | 64 | 96.97 | 80 | 74 | 92.5 |
EDITION | 37 | 36 | 97.3 | 52 | 49 | 94.23 |
INDEX | 74 | 5 | 6.76 | 74 | 5 | 6.76 |
JAVA DATA | 2 | 0 | 0 | 2 | 0 | 0 |
JAVA RESOURCE | 2 | 0 | 0 | 2 | 0 | 0 |
JAVA SOURCE | 2 | 0 | 0 | 2 | 0 | 0 |
OBJECT ID | 70 | 0 | 0 | 0 | 0 | 0 |
QUEUE | 4 | 2 | 50 | 6 | 2 | 33.33 |
RULESET | 1 | 0 | 0 | 3 | 2 | 66.67 |
SCHEMA | 5367 | 5348 | 99.65 | 0 | 0 | 0 |
SQL AREA | 6440 | 3163 | 49.11 | 47913 | 42276 | 88.23 |
SQL AREA BUILD | 1852 | 120 | 6.48 | 0 | 0 | 0 |
SQL AREA STATS | 1825 | 77 | 4.22 | 1825 | 77 | 4.22 |
TABLE/PROCEDURE | 14999 | 11713 | 78.09 | 25433 | 20429 | 80.32 |
TRIGGER | 75 | 43 | 57.33 | 75 | 43 | 57.33 |
SUM(GETS) | SUM(MISSES) | ROUND(1-SUM(MISSES)/SUM(GETS),4) |
---|---|---|
5749373 | 1838 | .9997 |
● 等待事件(当前)
INST_ID | WAIT_CLASS# | WAIT_CLASS | EVENT | COUNTS |
---|---|---|---|---|
1 | 7 | Network | SQL*Net message to client | 1 |
INST_ID | EVENT | WAIT_CLASS | TOTAL_WAITS |
---|---|---|---|
1 | direct path read | User I/O | 62530 |
1 | db file sequential read | User I/O | 36954 |
1 | control file sequential read | System I/O | 16622 |
1 | SQL*Net message to client | Network | 6108 |
1 | LNS wait on SENDREQ | Network | 4072 |
1 | db file scattered read | User I/O | 3019 |
1 | log file parallel write | System I/O | 2906 |
1 | control file parallel write | System I/O | 2790 |
1 | ADR block file write | Other | 637 |
1 | ADR file lock | Other | 590 |
1 | Disk file operations I/O | User I/O | 577 |
1 | ADR block file read | Other | 397 |
1 | asynch descriptor resize | Other | 368 |
1 | db file async I/O submit | System I/O | 239 |
1 | db file parallel read | User I/O | 221 |
1 | external table write | User I/O | 176 |
1 | log file sequential read | System I/O | 147 |
1 | PX Deq: Slave Session Stats | Other | 128 |
1 | os thread startup | Concurrency | 102 |
1 | flashback log file read | System I/O | 88 |
1 | direct path write temp | User I/O | 87 |
1 | Parameter File I/O | User I/O | 84 |
1 | LGWR wait for redo copy | Other | 70 |
1 | Log archive I/O | System I/O | 69 |
1 | ARCH wait on SENDREQ | Network | 66 |
1 | PX Deq: Signal ACK RSG | Other | 64 |
1 | PX Deq: Signal ACK EXT | Other | 64 |
1 | flashback log file write | System I/O | 62 |
1 | latch: shared pool | Concurrency | 59 |
1 | direct path read temp | User I/O | 54 |
1 | SQL*Net more data to client | Network | 38 |
1 | SQL*Net break/reset to client | Application | 32 |
1 | db file single write | User I/O | 30 |
1 | direct path write | User I/O | 30 |
1 | latch free | Other | 28 |
1 | ARCH wait for archivelog lock | Other | 28 |
1 | flashback log file sync | User I/O | 26 |
1 | external table open | User I/O | 24 |
1 | log file sync | Commit | 22 |
1 | ARCH wait on ATTACH | Network | 21 |
1 | enq: CF - contention | Other | 18 |
1 | ARCH wait on DETACH | Network | 17 |
1 | rdbms ipc reply | Other | 17 |
1 | library cache: mutex X | Concurrency | 16 |
1 | log file single write | System I/O | 14 |
1 | library cache load lock | Concurrency | 14 |
1 | CSS operation: query | Other | 12 |
1 | latch: enqueue hash chains | Other | 10 |
1 | external table read | User I/O | 8 |
1 | external table seek | User I/O | 8 |
...........................................................................................................................................................................................
本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用
ITPUB BLOG:http://blog.itpub.net/26736162
本文地址:http://blog.itpub.net/26736162/viewspace-1783297/
本文pdf版:http://yunpan.cn/cdEQedhCs2kFz (提取码:ed9b)
QQ:642808185 若加QQ请注明你所正在读的文章标题
创作时间地点:2015-05-15 10:00~ 2015-08-26 19:00 于唐镇金唐公寓宿舍
<版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任!>
...........................................................................................................................................................................................
............................................................................................ ● 小麦苗的微店:https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ............................................................................................ 使用微信客户端扫描下面的二维码来关注小麦苗的微信公众号(DB宝),学习最实用的数据库技术。
|