Snapshot Database 9i
Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved. (www.idevelopment.info)



Report Index











Database and Instance Information
Report Header Version Options Database Registry
Instance Overview Database Overview Initialization Parameters Control Files
Control File Records Online Redo Logs Redo Log Switches
Jobs
Jobs


Storage
Tablespaces Data Files Database Growth Tablespace Extents
Tablespace to Owner Owner to Tablespace

UNDO Segments
UNDO Segments UNDO Segment Contention

Archiving
Archiving Mode Archiving Parameters Archiving History
Recovery Manager - (RMAN)
RMAN Configuration Backup Sets Backup Pieces Backup Control Files
Backup SPFILE


Performance
SGA Information DB Buffer Cache Hit Ratio Dictionary Cache Hit Ratio Library Cache Hit Ratio
Latch Contention System Wait Statistics System Statistics System Event Statistics
File I/O Statistics File I/O Timings Average Overall I/O per Second Redo Log Contention
Full Table Scans Sorts Outlines Outline Hints
SQL Statements With Most Buffer Gets SQL Statements With Most Disk Reads Top 10 Tables Top 10 Procedures
Statspack
List Parameters

Sessions
Current Sessions User Session Matrix

Security
User Accounts Users With DBA Privileges Roles Default Passwords
DB Links


Objects
Object Summary Segment Summary Top 200 Segments (by size) Top 200 Segments (by number of extents)
Directories Libraries Types Type Attributes
Type Methods Collections LOB Segments Objects Unable to Extend
Objects Which Are Nearing MAXEXTENTS Invalid Objects Procedural Object Errors Objects Without Statistics
Tables Suffering From Row Chaining/Migration Users With Default Tablespace - (SYSTEM) Users With Default Temp Tablespace - (SYSTEM) Objects in the SYSTEM Tablespace
Online Analytical Processing - (OLAP)
Dimensions Dimension Levels Dimension Attributes Dimension Hierarchies
Cubes Materialized Views Materialized View Logs
Networking
MTS Dispatcher Statistics MTS Dispatcher Response Queue Wait Stats MTS Shared Server Wait Statistics
Replication
Replication Summary Deferred Transactions Administrative Request Jobs Initialization Parameters
(Schedule) - Purge Jobs (Schedule) - Push Jobs (Schedule) - Refresh Jobs (Multi-Master) - Master Groups
(Multi-Master) - Master Groups and Sites (Materialized View) - Master Site Summary (Materialized View) - Master Site Logs (Materialized View) - Master Site Templates
(Materialized View) - Summary (Materialized View) - Groups (Materialized View) - Materialized Views (Materialized View) - Refresh Groups




Report Header


Report Namedba_snapshot_database_9i_ORA920_20080327.html
Snapshot Database Version3.5
Date / Time03/27/2008 19:25:38
Host Namealex
Database NameORA920
Global Database NameORA920.IDEVELOPMENT.INFO
Clustered Database?FALSE
Clustered Database Instances1
Database Startup Time03/17/2008 13:46:39
Database Block Size8192
Report Run UserSYS
Statspack UserPERFSTAT

[Top]



Version


Banner
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

[Top]



Options


Option Name Installed?
Advanced replication
TRUE
Application Role
TRUE
Bit-mapped indexes
TRUE
Block Media Recovery
TRUE
Change Data Capture
TRUE
Coalesce Index
TRUE
Connection multiplexing
TRUE
Connection pooling
TRUE
Database queuing
TRUE
Database resource manager
TRUE
Duplexed backups
TRUE
Enterprise User Security
TRUE
Export transportable tablespaces
TRUE
Fast-Start Fault Recovery
TRUE
File Mapping
TRUE
Fine-grained Auditing
TRUE
Fine-grained access control
TRUE
Heap segment compression
TRUE
Incremental backup and recovery
TRUE
Instead-of triggers
TRUE
Java
TRUE
Join index
TRUE
Managed Standby
TRUE
Materialized view rewrite
TRUE
Materialized view warehouse refresh
TRUE
OLAP Window Functions
TRUE
OLAP
TRUE
Objects
TRUE
Online Index Build
TRUE
Online Redefinition
TRUE
Oracle Data Guard
TRUE
Oracle Data Mining
TRUE
Oracle Label Security
TRUE
Parallel backup and recovery
TRUE
Parallel execution
TRUE
Parallel load
TRUE
Partitioning
TRUE
Plan Stability
TRUE
Point-in-time tablespace recovery
TRUE
Proxy authentication/authorization
TRUE
Real Application Clusters
FALSE
Sample Scan
TRUE
Spatial
TRUE
Streams
TRUE
Transparent Application Failover
TRUE
Trial Recovery
TRUE
Visual Information Retrieval
TRUE

[Top]



Database Registry


Component ID Component Name Version Status Modified Control Schema Procedure
AMD
OLAP Catalog
 9.2.0.8.0
VALID
15-MAR-2008 02:19:41
 SYS OLAPSYS CWM2_OLAP_INSTALLER.VALIDATE_CWM2_INSTALL
APS
OLAP Analytic Workspace
 9.2.0.8.0
LOADED
15-MAR-2008 01:46:46
 SYS SYS  
CATALOG
Oracle9i Catalog Views
 9.2.0.8.0
VALID
15-MAR-2008 02:19:36
 SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATALOG
CATJAVA
Oracle9i Java Packages
 9.2.0.8.0
VALID
15-MAR-2008 02:19:37
 SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
CATPROC
Oracle9i Packages and Types
 9.2.0.8.0
VALID
15-MAR-2008 02:19:36
 SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATPROC
CONTEXT
Oracle Text
 9.2.0.8.0
VALID
15-MAR-2008 01:30:37
 CTXSYS CTXSYS  
JAVAVM
JServer JAVA Virtual Machine
 9.2.0.8.0
VALID
15-MAR-2008 01:03:14
 SYS SYS  
ODM
Oracle Data Mining
 9.2.0.8.0
VALID
15-MAR-2008 01:46:04
 SYS ODM  
OLS
Oracle Label Security
 9.2.0.8.0
VALID
15-MAR-2008 02:19:39
 SYS LBACSYS VALIDATE_OLS
ORDIM
Oracle interMedia
 9.2.0.8.0
VALID
15-MAR-2008 01:28:01
 SYS ORDSYS  
OWM
Oracle Workspace Manager
 9.2.0.1.0
VALID
15-MAR-2008 00:55:48
 SYS WMSYS OWM_VALIDATE
SDO
Spatial
 9.2.0.8.0
VALID
15-MAR-2008 01:36:29
 SYS MDSYS  
WK
Oracle Ultra Search
 9.2.0.8.0
INVALID
15-MAR-2008 01:39:14
 WKSYS WKSYS VALIDATE_WK
XDB
Oracle XML Database
 9.2.0.8.0
VALID
15-MAR-2008 02:19:38
 SYS XDB DBMS_REGXDB.VALIDATEXDB
XML
Oracle XDK for Java
 9.2.0.10.0
VALID
15-MAR-2008 02:19:37
 SYS SYS XMLVALIDATE
XOQ
Oracle OLAP API
 9.2.0.8.0
LOADED
15-MAR-2008 01:47:37
 SYS SYS  

[Top]



Instance Overview


Instance
Name 		Instance
Number 		Host
Name 		Oracle
Version 		Start
Time 		Uptime
(in days) 		Parallel - (RAC) Instance
Status 		Logins Archiver
ORA920
1
alex
9.2.0.8.0
03/17/2008 13:46:39
 10.24
NO
OPEN
ALLOWED
STARTED

[Top]



Database Overview


Database Name Database ID Creation Date Log Mode Open Mode Force Logging Controlfile Type
ORA920
2656136476
03/15/2008 00:38:52
ARCHIVELOG
READ WRITE
NO
CURRENT

[Top]



Initialization Parameters


SPFILE Usage
This database IS using an SPFILE.

Parameter Name Value Is Default? Is Dynamic?
O7_DICTIONARY_ACCESSIBILITY FALSE
TRUE
FALSE
active_instance_count  
TRUE
FALSE
aq_tm_processes 1
FALSE
IMMEDIATE
archive_lag_target 0
TRUE
IMMEDIATE
audit_file_dest ?/rdbms/audit
TRUE
FALSE
audit_sys_operations FALSE
TRUE
FALSE
audit_trail NONE
TRUE
FALSE
background_core_dump partial
TRUE
FALSE
background_dump_dest /u01/app/oracle/admin/ORA920/bdump
FALSE
IMMEDIATE
backup_tape_io_slaves FALSE
TRUE
DEFERRED
bitmap_merge_area_size 1048576
TRUE
FALSE
blank_trimming FALSE
TRUE
FALSE
buffer_pool_keep  
TRUE
FALSE
buffer_pool_recycle  
TRUE
FALSE
circuits 940
TRUE
FALSE
cluster_database FALSE
TRUE
FALSE
cluster_database_instances 1
TRUE
FALSE
cluster_interconnects  
TRUE
FALSE
commit_point_strength 1
TRUE
FALSE
compatible 9.2.0.8.0
FALSE
FALSE
control_file_record_keep_time 7
TRUE
IMMEDIATE
control_files /u02/oradata/ORA920/controlfile/o1_mf_ci2w8ddh_.ct l, /u02/oradata/ORA920/controlfile/o1_mf_cwq9iq1a_.ctl, /u02/oradata/ORA920 /controlfile/o1_mf_9qaj1wpa_.ctl
FALSE
FALSE
core_dump_dest /u01/app/oracle/admin/ORA920/cdump
FALSE
IMMEDIATE
cpu_count 1
TRUE
FALSE
create_bitmap_area_size 8388608
TRUE
FALSE
cursor_sharing EXACT
TRUE
IMMEDIATE
cursor_space_for_time FALSE
TRUE
FALSE
db_16k_cache_size 0
TRUE
IMMEDIATE
db_2k_cache_size 0
TRUE
IMMEDIATE
db_32k_cache_size 0
TRUE
IMMEDIATE
db_4k_cache_size 0
TRUE
IMMEDIATE
db_8k_cache_size 0
TRUE
IMMEDIATE
db_block_buffers 0
TRUE
FALSE
db_block_checking FALSE
TRUE
IMMEDIATE
db_block_checksum TRUE
TRUE
IMMEDIATE
db_block_size 8192
FALSE
FALSE
db_cache_advice ON
TRUE
IMMEDIATE
db_cache_size 134217728
FALSE
IMMEDIATE
db_create_file_dest /u02/oradata/ORA920/datafile
FALSE
IMMEDIATE
db_create_online_log_dest_1 /u02/oradata/ORA920/onlinelog
FALSE
IMMEDIATE
db_create_online_log_dest_2 /u02/oradata/ORA920/onlinelog
FALSE
IMMEDIATE
db_create_online_log_dest_3 /u02/oradata/ORA920/onlinelog
FALSE
IMMEDIATE
db_create_online_log_dest_4  
TRUE
IMMEDIATE
db_create_online_log_dest_5  
TRUE
IMMEDIATE
db_domain IDEVELOPMENT.INFO
FALSE
FALSE
db_file_multiblock_read_count 16
FALSE
IMMEDIATE
db_file_name_convert  
TRUE
FALSE
db_files 200
TRUE
FALSE
db_keep_cache_size 0
TRUE
IMMEDIATE
db_name ORA920
FALSE
FALSE
db_recycle_cache_size 0
TRUE
IMMEDIATE
db_writer_processes 1
TRUE
FALSE
dblink_encrypt_login FALSE
TRUE
FALSE
dbwr_io_slaves 0
TRUE
FALSE
dg_broker_config_file1 ?/dbs/dr1@.dat
TRUE
IMMEDIATE
dg_broker_config_file2 ?/dbs/dr2@.dat
TRUE
IMMEDIATE
dg_broker_start FALSE
TRUE
IMMEDIATE
disk_asynch_io TRUE
TRUE
FALSE
dispatchers (PROTOCOL=TCP) (SERVICE=ORA920XDB)
FALSE
IMMEDIATE
distributed_lock_timeout 60
TRUE
FALSE
dml_locks 4136
TRUE
FALSE
drs_start FALSE
TRUE
IMMEDIATE
enqueue_resources 4356
TRUE
FALSE
event  
TRUE
FALSE
fal_client  
TRUE
IMMEDIATE
fal_server  
TRUE
IMMEDIATE
fast_start_io_target 0
TRUE
IMMEDIATE
fast_start_mttr_target 300
FALSE
IMMEDIATE
fast_start_parallel_rollback LOW
TRUE
IMMEDIATE
file_mapping FALSE
TRUE
IMMEDIATE
filesystemio_options asynch
TRUE
IMMEDIATE
fixed_date  
TRUE
IMMEDIATE
gc_files_to_locks  
TRUE
FALSE
global_context_pool_size  
TRUE
FALSE
global_names FALSE
TRUE
IMMEDIATE
hash_area_size 1048576
TRUE
FALSE
hash_join_enabled TRUE
FALSE
FALSE
hi_shared_memory_address 0
TRUE
FALSE
hs_autoregister TRUE
TRUE
IMMEDIATE
ifile  
TRUE
FALSE
instance_groups  
TRUE
FALSE
instance_name ORA920
FALSE
FALSE
instance_number 0
TRUE
FALSE
java_max_sessionspace_size 0
TRUE
FALSE
java_pool_size 117440512
FALSE
FALSE
java_soft_sessionspace_limit 0
TRUE
FALSE
job_queue_processes 10
FALSE
IMMEDIATE
large_pool_size 16777216
FALSE
IMMEDIATE
license_max_sessions 0
TRUE
IMMEDIATE
license_max_users 0
TRUE
IMMEDIATE
license_sessions_warning 0
TRUE
IMMEDIATE
local_listener  
TRUE
IMMEDIATE
lock_name_space  
TRUE
FALSE
lock_sga FALSE
TRUE
FALSE
log_archive_dest  
TRUE
IMMEDIATE
log_archive_dest_1 LOCATION=/u02/oraarchive/ORA920 MANDATORY
FALSE
IMMEDIATE
log_archive_dest_10  
TRUE
IMMEDIATE
log_archive_dest_2 service=ORA920_STBY OPTIONAL REOPEN=30
FALSE
IMMEDIATE
log_archive_dest_3  
TRUE
IMMEDIATE
log_archive_dest_4  
TRUE
IMMEDIATE
log_archive_dest_5  
TRUE
IMMEDIATE
log_archive_dest_6  
TRUE
IMMEDIATE
log_archive_dest_7  
TRUE
IMMEDIATE
log_archive_dest_8  
TRUE
IMMEDIATE
log_archive_dest_9  
TRUE
IMMEDIATE
log_archive_dest_state_1 enable
TRUE
IMMEDIATE
log_archive_dest_state_10 enable
TRUE
IMMEDIATE
log_archive_dest_state_2 DEFER
FALSE
IMMEDIATE
log_archive_dest_state_3 enable
TRUE
IMMEDIATE
log_archive_dest_state_4 enable
TRUE
IMMEDIATE
log_archive_dest_state_5 enable
TRUE
IMMEDIATE
log_archive_dest_state_6 enable
TRUE
IMMEDIATE
log_archive_dest_state_7 enable
TRUE
IMMEDIATE
log_archive_dest_state_8 enable
TRUE
IMMEDIATE
log_archive_dest_state_9 enable
TRUE
IMMEDIATE
log_archive_duplex_dest  
TRUE
IMMEDIATE
log_archive_format arch_t%t_s%s.dbf
FALSE
FALSE
log_archive_max_processes 2
TRUE
IMMEDIATE
log_archive_min_succeed_dest 1
TRUE
IMMEDIATE
log_archive_start TRUE
FALSE
FALSE
log_archive_trace 0
TRUE
IMMEDIATE
log_buffer 524288
TRUE
FALSE
log_checkpoint_interval 0
TRUE
IMMEDIATE
log_checkpoint_timeout 1800
TRUE
IMMEDIATE
log_checkpoints_to_alert FALSE
TRUE
IMMEDIATE
log_file_name_convert  
TRUE
FALSE
log_parallelism 1
TRUE
FALSE
logmnr_max_persistent_sessions 1
TRUE
FALSE
max_commit_propagation_delay 700
TRUE
FALSE
max_dispatchers 5
TRUE
FALSE
max_dump_file_size UNLIMITED
TRUE
IMMEDIATE
max_enabled_roles 30
TRUE
FALSE
max_rollback_segments 206
TRUE
FALSE
max_shared_servers 20
TRUE
FALSE
mts_circuits 940
TRUE
FALSE
mts_dispatchers (PROTOCOL=TCP) (SERVICE=ORA920XDB)
TRUE
IMMEDIATE
mts_listener_address  
TRUE
FALSE
mts_max_dispatchers 5
TRUE
FALSE
mts_max_servers 20
TRUE
FALSE
mts_multiple_listeners FALSE
TRUE
FALSE
mts_servers 1
TRUE
IMMEDIATE
mts_service ORA920
TRUE
FALSE
mts_sessions 935
TRUE
FALSE
nls_calendar  
TRUE
FALSE
nls_comp  
TRUE
FALSE
nls_currency  
TRUE
FALSE
nls_date_format  
TRUE
FALSE
nls_date_language  
TRUE
FALSE
nls_dual_currency  
TRUE
FALSE
nls_iso_currency  
TRUE
FALSE
nls_language AMERICAN
TRUE
FALSE
nls_length_semantics BYTE
TRUE
IMMEDIATE
nls_nchar_conv_excp FALSE
TRUE
IMMEDIATE
nls_numeric_characters  
TRUE
FALSE
nls_sort  
TRUE
FALSE
nls_territory AMERICA
TRUE
FALSE
nls_time_format  
TRUE
FALSE
nls_time_tz_format  
TRUE
FALSE
nls_timestamp_format  
TRUE
FALSE
nls_timestamp_tz_format  
TRUE
FALSE
object_cache_max_size_percent 10
TRUE
DEFERRED
object_cache_optimal_size 102400
TRUE
DEFERRED
olap_page_pool_size 33554432
TRUE
DEFERRED
open_cursors 1500
FALSE
IMMEDIATE
open_links 4
TRUE
FALSE
open_links_per_instance 4
TRUE
FALSE
optimizer_dynamic_sampling 1
TRUE
IMMEDIATE
optimizer_features_enable 9.2.0
TRUE
FALSE
optimizer_index_caching 0
TRUE
FALSE
optimizer_index_cost_adj 100
TRUE
FALSE
optimizer_max_permutations 2000
TRUE
FALSE
optimizer_mode CHOOSE
TRUE
FALSE
oracle_trace_collection_name  
TRUE
FALSE
oracle_trace_collection_path ?/otrace/admin/cdf
TRUE
FALSE
oracle_trace_collection_size 5242880
TRUE
FALSE
oracle_trace_enable FALSE
TRUE
IMMEDIATE
oracle_trace_facility_name oracled
TRUE
FALSE
oracle_trace_facility_path ?/otrace/admin/fdf
TRUE
FALSE
os_authent_prefix ops$
TRUE
FALSE
os_roles FALSE
TRUE
FALSE
parallel_adaptive_multi_user FALSE
TRUE
IMMEDIATE
parallel_automatic_tuning FALSE
TRUE
FALSE
parallel_execution_message_size 2152
TRUE
FALSE
parallel_instance_group  
TRUE
IMMEDIATE
parallel_max_servers 5
TRUE
FALSE
parallel_min_percent 0
TRUE
FALSE
parallel_min_servers 0
TRUE
FALSE
parallel_server FALSE
TRUE
FALSE
parallel_server_instances 1
TRUE
FALSE
parallel_threads_per_cpu 2
TRUE
IMMEDIATE
partition_view_enabled FALSE
TRUE
FALSE
pga_aggregate_target 25165824
FALSE
IMMEDIATE
plsql_compiler_flags INTERPRETED
TRUE
IMMEDIATE
plsql_native_c_compiler  
TRUE
IMMEDIATE
plsql_native_library_dir  
TRUE
IMMEDIATE
plsql_native_library_subdir_count 0
TRUE
IMMEDIATE
plsql_native_linker  
TRUE
IMMEDIATE
plsql_native_make_file_name  
TRUE
IMMEDIATE
plsql_native_make_utility  
TRUE
IMMEDIATE
plsql_v2_compatibility FALSE
TRUE
IMMEDIATE
pre_page_sga TRUE
FALSE
FALSE
processes 850
FALSE
FALSE
query_rewrite_enabled FALSE
FALSE
IMMEDIATE
query_rewrite_integrity enforced
TRUE
IMMEDIATE
rdbms_server_dn  
TRUE
FALSE
read_only_open_delayed FALSE
TRUE
FALSE
recovery_parallelism 0
TRUE
FALSE
remote_archive_enable true
TRUE
FALSE
remote_dependencies_mode TIMESTAMP
TRUE
IMMEDIATE
remote_listener  
TRUE
IMMEDIATE
remote_login_passwordfile EXCLUSIVE
FALSE
FALSE
remote_os_authent FALSE
TRUE
FALSE
remote_os_roles FALSE
TRUE
FALSE
replication_dependency_tracking TRUE
TRUE
FALSE
resource_limit FALSE
TRUE
IMMEDIATE
resource_manager_plan  
TRUE
IMMEDIATE
rollback_segments  
TRUE
FALSE
row_locking always
TRUE
FALSE
serial_reuse DISABLE
TRUE
FALSE
serializable FALSE
TRUE
FALSE
service_names ORA920.IDEVELOPMENT.INFO
TRUE
IMMEDIATE
session_cached_cursors 0
TRUE
FALSE
session_max_open_files 10
TRUE
FALSE
sessions 940
TRUE
FALSE
sga_max_size 437747952
TRUE
FALSE
shadow_core_dump PARTIAL
TRUE
FALSE
shared_memory_address 0
TRUE
FALSE
shared_pool_reserved_size 5872025
TRUE
FALSE
shared_pool_size 117440512
FALSE
IMMEDIATE
shared_server_sessions 935
TRUE
FALSE
shared_servers 1
TRUE
IMMEDIATE
sort_area_retained_size 0
TRUE
DEFERRED
sort_area_size 524288
FALSE
DEFERRED
spfile ?/dbs/spfile@.ora
TRUE
FALSE
sql92_security FALSE
TRUE
FALSE
sql_trace FALSE
TRUE
FALSE
sql_version NATIVE
TRUE
FALSE
standby_archive_dest ?/dbs/arch
TRUE
IMMEDIATE
standby_file_management MANUAL
TRUE
IMMEDIATE
star_transformation_enabled FALSE
FALSE
FALSE
statistics_level TYPICAL
TRUE
IMMEDIATE
tape_asynch_io TRUE
TRUE
FALSE
thread 0
TRUE
FALSE
timed_os_statistics 0
TRUE
IMMEDIATE
timed_statistics TRUE
FALSE
IMMEDIATE
trace_enabled TRUE
TRUE
IMMEDIATE
tracefile_identifier  
TRUE
FALSE
transaction_auditing TRUE
TRUE
DEFERRED
transactions 1034
TRUE
FALSE
transactions_per_rollback_segment 5
TRUE
FALSE
undo_management AUTO
FALSE
FALSE
undo_retention 43200
FALSE
IMMEDIATE
undo_suppress_errors FALSE
TRUE
IMMEDIATE
undo_tablespace UNDOTBS1
FALSE
IMMEDIATE
use_indirect_data_buffers FALSE
TRUE
FALSE
user_dump_dest /u01/app/oracle/admin/ORA920/udump
FALSE
IMMEDIATE
utl_file_dir  
TRUE
FALSE
workarea_size_policy AUTO
TRUE
IMMEDIATE

[Top]



Control Files


Controlfile Name Status
/u02/oradata/ORA920/controlfile/o1_mf_9qaj1wpa_.ctl
VALID
/u02/oradata/ORA920/controlfile/o1_mf_ci2w8ddh_.ctl
VALID
/u02/oradata/ORA920/controlfile/o1_mf_cwq9iq1a_.ctl
VALID

[Top]



Control File Records


Record Section Type Record Size
(in bytes) 		Records Allocated Bytes Allocated Records Used Bytes Used % Used First Index Last Index Last RecID
ARCHIVED LOG
 584 97 56,648 92 53,728 95 1 92 92
BACKUP CORRUPTION
 44 185 8,140 0 0   0 0 0
BACKUP DATAFILE
 116 211 24,476 86 9,976 41 1 86 86
BACKUP PIECE
 736 210 154,560 48 35,328 23 1 48 48
BACKUP REDOLOG
 76 107 8,132 22 1,672 21 1 22 22
BACKUP SET
 40 204 8,160 36 1,440 18 1 36 36
BACKUP SPFILE
 36 226 8,136 19 684 8 1 19 19
CKPT PROGRESS
 4,084 4 16,336 0 0   0 0 0
COPY CORRUPTION
 40 204 8,160 0 0   0 0 0
DATABASE INCARNATION
 56 145 8,120 1 56 1 1 1 1
DATABASE
 192 1 192 1 192 100 0 0 0
DATAFILE COPY
 660 210 138,600 0 0   0 0 0
DATAFILE
 180 100 18,000 16 2,880 16 0 0 150
DELETED OBJECT
 20 408 8,160 42 840 10 1 42 42
FILENAME
 524 116 60,784 26 13,624 22 0 0 0
LOG HISTORY
 36 226 8,136 109 3,924 48 1 109 109
OFFLINE RANGE
 56 145 8,120 0 0   0 0 0
PROXY COPY
 852 210 178,920 0 0   0 0 0
REDO LOG
 72 5 360 3 216 60 0 0 9
REDO THREAD
 104 1 104 1 104 100 0 0 0
RMAN CONFIGURATION
 1,108 50 55,400 5 5,540 10 0 0 6
TABLESPACE
 68 100 6,800 16 1,088 16 0 0 17
TEMPORARY FILENAME
 56 100 5,600 1 56 1 0 0 2
  ----------- ----------------- --------------- ------------ ------------ ------      
Average:           26      
Total: 9,740 3,265 790,044 524 131,348        

[Top]



Online Redo Logs


Group Number Member Redo Type Log Status Bytes Archived?
1
 /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwztlmz_.log ONLINE
INACTIVE
 262,144,000
YES
  /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwztth8_.log ONLINE
INACTIVE
 262,144,000
YES
  /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwzv54w_.log ONLINE
INACTIVE
 262,144,000
YES
2
 /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzx9hq_.log ONLINE
CURRENT
 262,144,000
NO
  /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzxkbz_.log ONLINE
CURRENT
 262,144,000
NO
  /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzxttp_.log ONLINE
CURRENT
 262,144,000
NO
3
 /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzz12f_.log ONLINE
INACTIVE
 262,144,000
YES
  /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzz943_.log ONLINE
INACTIVE
 262,144,000
YES
  /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzzl51_.log ONLINE
INACTIVE
 262,144,000
YES

[Top]



Redo Log Switches


Day / Time 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Total
03/15
 4 6 1                                         1 12
03/17
           1         5 5 2 2 2 1 3 1 1 1 1 4 3 4 36
03/18
 2                                               2
03/20
 3 2   1   1   1   1   2   1 1 1     1   1 1   1 18
03/21
 1   1   1   1     1   1     1   1     1   1     10
03/22
 1     1                               1         3
03/23
                             1     1       1     3
03/24
 1     1       1     1       1     1       1     7
03/25
 1       1     1       1     1       1     1     7
03/26
   1       1     1       1       1     1       1 7
03/27
       1       1     1       1                   4
                                                  ------------
Average:                                                 10
Total:                                                 109

[Top]



Jobs


Job ID User What Next Run Date Interval Last Run Date Failures Broken?
1
 		PERFSTAT statspack_custom.snap;
03/27/2008 19:30:00
 TRUNC(sysdate,'HH24')+((FLOOR(TO_NUMBER(TO_CHAR(sysdate,'MI'))/30)+1)*30)/( 24*60)
03/27/2008 19:00:07
0
N
2
 		PERFSTAT statspack_custom.purge(30);
03/28/2008 00:00:36
 SYSDATE+1
03/27/2008 00:00:36
0
N
3
 		SCOTT CALCULATE_NDS_COSTS;
01/01/4000 00:00:00
 TRUNC(sysdate,'HH24')+((FLOOR(TO_NUMBER(TO_CHAR(sy sdate,'MI'))/5)+1)*5)/(24*60)

16
Y
5
 		SCOTT dbms_refresh.refresh('"SCOTT"."EMP_RGROUP"');
03/28/2008 00:51:11
 /*24:Hr*/ sysdate + 24/24
03/27/2008 00:51:10
0
N

[Top]



Tablespaces


Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Free (in bytes) Used (in bytes) Pct. Used
ONLINE
 CWMLITE PERMANENT LOCAL AUTO 104,857,600 89,128,960 15,728,640
15 %
ONLINE
 DRSYS PERMANENT LOCAL AUTO 20,971,520 10,813,440 10,158,080
48 %
ONLINE
 EXAMPLE PERMANENT LOCAL AUTO 262,144,000 117,768,192 144,375,808
55 %
ONLINE
 INDX PERMANENT LOCAL AUTO 26,214,400 26,148,864 65,536
0 %
ONLINE
 ODM PERMANENT LOCAL AUTO 20,971,520 10,944,512 10,027,008
47 %
ONLINE
 OEM_REPOSITORY PERMANENT LOCAL MANUAL 36,708,352 3,145,728 33,562,624
91 %
ONLINE
 PERFSTAT PERMANENT LOCAL MANUAL 314,572,800 118,685,696 195,887,104
62 %
OFFLINE
 REPORTS PERMANENT LOCAL AUTO 0 0 0
0 %
ONLINE
 SOE PERMANENT LOCAL AUTO 1,399,930,880 4,579,328 1,395,351,552
99 %
ONLINE
 SOEINDEX PERMANENT LOCAL AUTO 3,093,381,120 30,031,872 3,063,349,248
99 %
ONLINE
 SYSTEM PERMANENT LOCAL MANUAL 734,003,200 318,767,104 415,236,096
56 %
ONLINE
 TEMP TEMPORARY LOCAL MANUAL 524,288,000 22,020,096 502,267,904
95 %
ONLINE
 UNDOTBS1 UNDO LOCAL MANUAL 1,073,741,824 477,560,832 596,180,992
55 %
ONLINE
 USERS PERMANENT LOCAL AUTO 1,493,172,224 775,684,096 717,488,128
48 %
ONLINE
 XDB PERMANENT LOCAL AUTO 104,857,600 57,933,824 46,923,776
44 %
          -------------------- -------------------- --------------------  
Total:         9,209,815,040 2,063,212,544 7,146,602,496  

[Top]



Data Files


Tablespace Name / File Class Filename File Size Autoextensible Next Max
CWMLITE /u02/oradata/ORA920/datafile/o1_mf_cwmlite_8euqb33r_.dbf 104,857,600
YES
 104,857,600 34,359,721,984
DRSYS /u02/oradata/ORA920/datafile/o1_mf_drsys_q9oqmcjd_.dbf 20,971,520
YES
 104,857,600 34,359,721,984
EXAMPLE /u02/oradata/ORA920/datafile/o1_mf_example_ss9iwj2z_.dbf 262,144,000
YES
 104,857,600 34,359,721,984
INDX /u02/oradata/ORA920/datafile/o1_mf_indx_aoqpm1x8_.dbf 26,214,400
YES
 104,857,600 34,359,721,984
ODM /u02/oradata/ORA920/datafile/o1_mf_odm_7y76ejdi_.dbf 20,971,520
YES
 104,857,600 34,359,721,984
OEM_REPOSITORY /u02/oradata/ORA920/datafile/oem_repository.dbf 36,708,352
YES
 104,857,600 34,359,721,984
PERFSTAT /u02/oradata/ORA920/datafile/o1_mf_perfstat_3xx3rzkm_.dbf 314,572,800
YES
 104,857,600 34,359,721,984
REPORTS /u02/oradata/ORA920/datafile/o1_mf_reports_3xy7gfnv_.dbf  

   
SOE /u02/oradata/ORA920/datafile/soe.dbf 1,399,930,880
YES
 104,857,600 34,359,721,984
SOEINDEX /u02/oradata/ORA920/datafile/soeindex.dbf 3,093,381,120
YES
 104,857,600 34,359,721,984
SYSTEM /u02/oradata/ORA920/datafile/o1_mf_system_olqasi2v_.dbf 734,003,200
YES
 104,857,600 34,359,721,984
TEMP /u02/oradata/ORA920/datafile/o1_mf_temp_3xx2cwqb_.tmp 524,288,000
YES
 104,857,600 34,359,721,984
UNDOTBS1 /u02/oradata/ORA920/datafile/o1_mf_undotbs1_p2xnm3aa_.dbf 1,073,741,824
YES
 104,857,600 34,359,721,984
USERS /u02/oradata/ORA920/datafile/o1_mf_users_3xwzdjl6_.dbf 1,073,741,824
YES
 104,857,600 34,359,721,984
USERS /u02/oradata/ORA920/datafile/o1_mf_users_8euw2qs0_.dbf 419,430,400
YES
 104,857,600 34,359,721,984
XDB /u02/oradata/ORA920/datafile/o1_mf_xdb_w8iq0kms_.dbf 104,857,600
YES
 104,857,600 34,359,721,984
[ CONTROL FILE ] /u02/oradata/ORA920/controlfile/o1_mf_9qaj1wpa_.ctl        
[ CONTROL FILE ] /u02/oradata/ORA920/controlfile/o1_mf_ci2w8ddh_.ctl        
[ CONTROL FILE ] /u02/oradata/ORA920/controlfile/o1_mf_cwq9iq1a_.ctl        
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwztlmz_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwztth8_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_1_3xwzv54w_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzx9hq_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzxkbz_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_2_3xwzxttp_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzz12f_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzz943_.log 262,144,000      
[ ONLINE REDO LOG ] /u02/oradata/ORA920/onlinelog/o1_mf_3_3xwzzl51_.log 262,144,000      
    --------------------      
Total:   11,569,111,040      

[Top]



Database Growth


Month Growth (bytes)
2008-03
 8,685,527,040
  --------------------
Total: 8,685,527,040

[Top]



Tablespace Extents


Tablespace Name Largest Extent Smallest Extent Total Free Number of Free Extents
CWMLITE 89,128,960 89,128,960 89,128,960 1
DRSYS 10,813,440 10,813,440 10,813,440 1
EXAMPLE 117,768,192 117,768,192 117,768,192 1
INDX 26,148,864 26,148,864 26,148,864 1
ODM 10,944,512 10,944,512 10,944,512 1
OEM_REPOSITORY 3,145,728 3,145,728 3,145,728 1
PERFSTAT 118,423,552 262,144 118,685,696 2
SOE 4,579,328 4,579,328 4,579,328 1
SOEINDEX 30,031,872 30,031,872 30,031,872 1
SYSTEM 318,701,568 65,536 318,767,104 2
UNDOTBS1 68,157,440 65,536 477,560,832 138
USERS 714,014,720 61,669,376 775,684,096 2
XDB 57,933,824 57,933,824 57,933,824 1
  -------------------- -------------------- -------------------- ----------------------
Total: 1,569,792,000 412,557,312 2,041,192,448 153

[Top]



Tablespace to Owner


Tablespace Name Owner Segment Type Size (in Bytes) Segment Count
CWMLITE
OLAPSYS
INDEX
 8,519,680 130
 
OLAPSYS
TABLE
 7,143,424 109
DRSYS
CTXSYS
INDEX
 3,014,656 46
 
CTXSYS
LOBINDEX
 131,072 2
 
CTXSYS
LOBSEGMENT
 131,072 2
 
CTXSYS
TABLE
 1,703,936 26
 
WKSYS
INDEX
 3,342,336 51
 
WKSYS
TABLE
 1,769,472 27
EXAMPLE
HR
INDEX
 1,245,184 19
 
HR
TABLE
 393,216 6
 
OE
INDEX
 2,424,832 26
 
OE
LOBINDEX
 327,680 5
 
OE
LOBSEGMENT
 327,680 5
 
OE
NESTED TABLE
 131,072 2
 
OE
TABLE
 3,735,552 8
 
PM
INDEX
 196,608 3
 
PM
LOBINDEX
 1,114,112 17
 
PM
LOBSEGMENT
 1,835,008 17
 
PM
NESTED TABLE
 65,536 1
 
PM
TABLE
 131,072 2
 
QS
INDEX
 983,040 15
 
QS
LOBINDEX
 65,536 1
 
QS
LOBSEGMENT
 65,536 1
 
QS
TABLE
 458,752 7
 
QS_CBADM
INDEX
 589,824 9
 
QS_CBADM
TABLE
 262,144 4
 
QS_CS
INDEX
 393,216 6
 
QS_CS
TABLE
 262,144 4
 
QS_ES
INDEX
 786,432 12
 
QS_ES
TABLE
 393,216 6
 
QS_OS
INDEX
 786,432 12
 
QS_OS
TABLE
 393,216 6
 
QS_WS
INDEX
 786,432 12
 
QS_WS
TABLE
 393,216 6
 
SH
INDEX PARTITION
 20,512,768 104
 
SH
INDEX
 11,730,944 18
 
SH
TABLE PARTITION
 72,613,888 28
 
SH
TABLE
 20,905,984 12
ODM
ODM
INDEX
 2,949,120 45
 
ODM
LOBINDEX
 458,752 7
 
ODM
LOBSEGMENT
 458,752 7
 
ODM
TABLE
 1,835,008 27
 
ODM_MTR
TABLE
 4,259,840 12
OEM_REPOSITORY
OEM
INDEX
 17,301,504 264
 
OEM
LOBINDEX
 131,072 2
 
OEM
LOBSEGMENT
 131,072 2
 
OEM
TABLE
 15,925,248 236
PERFSTAT
PERFSTAT
INDEX
 92,667,904 42
 
PERFSTAT
TABLE
 103,153,664 41
SOE
SOE
INDEX
 532,480 2
 
SOE
TABLE
 1,394,671,616 8
SOEINDEX
SOE
INDEX
 3,063,250,944 21
SYSTEM
LBACSYS
INDEX
 1,703,936 26
 
LBACSYS
LOBINDEX
 65,536 1
 
LBACSYS
LOBSEGMENT
 65,536 1
 
LBACSYS
TABLE
 1,048,576 16
 
MDSYS
INDEX
 1,114,112 17
 
MDSYS
LOBINDEX
 786,432 12
 
MDSYS
LOBSEGMENT
 786,432 12
 
MDSYS
TABLE
 1,703,936 18
 
ORDSYS
INDEX
 131,072 2
 
ORDSYS
TABLE
 327,680 5
 
OUTLN
INDEX
 196,608 3
 
OUTLN
TABLE
 196,608 3
 
SYS
CACHE
 65,536 1
 
SYS
CLUSTER
 15,466,496 10
 
SYS
DEFERRED ROLLBACK
 65,536 1
 
SYS
INDEX
 56,688,640 314
 
SYS
LOBINDEX
 2,097,152 32
 
SYS
LOBSEGMENT
 8,060,928 32
 
SYS
ROLLBACK
 393,216 1
 
SYS
TABLE
 298,516,480 285
 
SYSTEM
INDEX PARTITION
 1,638,400 25
 
SYSTEM
INDEX
 8,847,360 135
 
SYSTEM
LOBINDEX
 1,376,256 21
 
SYSTEM
LOBSEGMENT
 1,376,256 21
 
SYSTEM
TABLE PARTITION
 1,769,472 27
 
SYSTEM
TABLE
 6,815,744 104
 
WMSYS
INDEX
 2,162,688 33
 
WMSYS
LOBINDEX
 131,072 2
 
WMSYS
LOBSEGMENT
 131,072 2
 
WMSYS
NESTED TABLE
 65,536 1
 
WMSYS
TABLE
 1,376,256 21
UNDOTBS1
SYS
TYPE2 UNDO
 595,951,616 20
USERS
APPS
LOBINDEX
 131,072 2
 
APPS
LOBSEGMENT
 131,072 2
 
APPS
TABLE
 65,536 1
 
JHUNTER
TABLE
 32,505,856 1
 
SCOTT
INDEX
 33,619,968 2
 
SCOTT
LOBINDEX
 131,072 2
 
SCOTT
LOBSEGMENT
 131,072 2
 
SCOTT
TABLE
 650,641,408 13
XDB
XDB
INDEX
 2,228,224 34
 
XDB
LOBINDEX
 21,299,200 325
 
XDB
LOBSEGMENT
 21,299,200 325
 
XDB
TABLE
 2,031,616 28
***************************************************************************     -------------------- ----------------
Total:     6,643,130,368 3,424

[Top]



Owner to Tablespace


Owner Tablespace Name Segment Type Size (in Bytes) Segment Count
APPS
USERS
LOBINDEX
 131,072 2
 
USERS
LOBSEGMENT
 131,072 2
 
USERS
TABLE
 65,536 1
CTXSYS
DRSYS
INDEX
 3,014,656 46
 
DRSYS
LOBINDEX
 131,072 2
 
DRSYS
LOBSEGMENT
 131,072 2
 
DRSYS
TABLE
 1,703,936 26
HR
EXAMPLE
INDEX
 1,245,184 19
 
EXAMPLE
TABLE
 393,216 6
JHUNTER
USERS
TABLE
 32,505,856 1
LBACSYS
SYSTEM
INDEX
 1,703,936 26
 
SYSTEM
LOBINDEX
 65,536 1
 
SYSTEM
LOBSEGMENT
 65,536 1
 
SYSTEM
TABLE
 1,048,576 16
MDSYS
SYSTEM
INDEX
 1,114,112 17
 
SYSTEM
LOBINDEX
 786,432 12
 
SYSTEM
LOBSEGMENT
 786,432 12
 
SYSTEM
TABLE
 1,703,936 18
ODM
ODM
INDEX
 2,949,120 45
 
ODM
LOBINDEX
 458,752 7
 
ODM
LOBSEGMENT
 458,752 7
 
ODM
TABLE
 1,835,008 27
ODM_MTR
ODM
TABLE
 4,259,840 12
OE
EXAMPLE
INDEX
 2,424,832 26
 
EXAMPLE
LOBINDEX
 327,680 5
 
EXAMPLE
LOBSEGMENT
 327,680 5
 
EXAMPLE
NESTED TABLE
 131,072 2
 
EXAMPLE
TABLE
 3,735,552 8
OEM
OEM_REPOSITORY
INDEX
 17,301,504 264
 
OEM_REPOSITORY
LOBINDEX
 131,072 2
 
OEM_REPOSITORY
LOBSEGMENT
 131,072 2
 
OEM_REPOSITORY
TABLE
 15,925,248 236
OLAPSYS
CWMLITE
INDEX
 8,519,680 130
 
CWMLITE
TABLE
 7,143,424 109
ORDSYS
SYSTEM
INDEX
 131,072 2
 
SYSTEM
TABLE
 327,680 5
OUTLN
SYSTEM
INDEX
 196,608 3
 
SYSTEM
TABLE
 196,608 3
PERFSTAT
PERFSTAT
INDEX
 92,667,904 42
 
PERFSTAT
TABLE
 103,153,664 41
PM
EXAMPLE
INDEX
 196,608 3
 
EXAMPLE
LOBINDEX
 1,114,112 17
 
EXAMPLE
LOBSEGMENT
 1,835,008 17
 
EXAMPLE
NESTED TABLE
 65,536 1
 
EXAMPLE
TABLE
 131,072 2
QS
EXAMPLE
INDEX
 983,040 15
 
EXAMPLE
LOBINDEX
 65,536 1
 
EXAMPLE
LOBSEGMENT
 65,536 1
 
EXAMPLE
TABLE
 458,752 7
QS_CBADM
EXAMPLE
INDEX
 589,824 9
 
EXAMPLE
TABLE
 262,144 4
QS_CS
EXAMPLE
INDEX
 393,216 6
 
EXAMPLE
TABLE
 262,144 4
QS_ES
EXAMPLE
INDEX
 786,432 12
 
EXAMPLE
TABLE
 393,216 6
QS_OS
EXAMPLE
INDEX
 786,432 12
 
EXAMPLE
TABLE
 393,216 6
QS_WS
EXAMPLE
INDEX
 786,432 12
 
EXAMPLE
TABLE
 393,216 6
SCOTT
USERS
INDEX
 33,619,968 2
 
USERS
LOBINDEX
 131,072 2
 
USERS
LOBSEGMENT
 131,072 2
 
USERS
TABLE
 650,641,408 13
SH
EXAMPLE
INDEX PARTITION
 20,512,768 104
 
EXAMPLE
INDEX
 11,730,944 18
 
EXAMPLE
TABLE PARTITION
 72,613,888 28
 
EXAMPLE
TABLE
 20,905,984 12
SOE
SOE
INDEX
 532,480 2
 
SOE
TABLE
 1,394,671,616 8
 
SOEINDEX
INDEX
 3,063,250,944 21
SYS
SYSTEM
CACHE
 65,536 1
 
SYSTEM
CLUSTER
 15,466,496 10
 
SYSTEM
DEFERRED ROLLBACK
 65,536 1
 
SYSTEM
INDEX
 56,688,640 314
 
SYSTEM
LOBINDEX
 2,097,152 32
 
SYSTEM
LOBSEGMENT
 8,060,928 32
 
SYSTEM
ROLLBACK
 393,216 1
 
SYSTEM
TABLE
 298,516,480 285
 
UNDOTBS1
TYPE2 UNDO
 595,951,616 20
SYSTEM
SYSTEM
INDEX PARTITION
 1,638,400 25
 
SYSTEM
INDEX
 8,847,360 135
 
SYSTEM
LOBINDEX
 1,376,256 21
 
SYSTEM
LOBSEGMENT
 1,376,256 21
 
SYSTEM
TABLE PARTITION
 1,769,472 27
 
SYSTEM
TABLE
 6,815,744 104
WKSYS
DRSYS
INDEX
 3,342,336 51
 
DRSYS
TABLE
 1,769,472 27
WMSYS
SYSTEM
INDEX
 2,162,688 33
 
SYSTEM
LOBINDEX
 131,072 2
 
SYSTEM
LOBSEGMENT
 131,072 2
 
SYSTEM
NESTED TABLE
 65,536 1
 
SYSTEM
TABLE
 1,376,256 21
XDB
XDB
INDEX
 2,228,224 34
 
XDB
LOBINDEX
 21,299,200 325
 
XDB
LOBSEGMENT
 21,299,200 325
 
XDB
TABLE
 2,031,616 28
***************************************************************************     -------------------- ----------------
Total:     6,643,130,368 3,424

[Top]



UNDO Segments


UNDO Segment Name Tablspace Init/Next Extents Min/Max Extents Status Bytes Extents Shrinks Wraps Opt. Size
SYS.SYSTEM SYSTEM
114688 /
1 / 32765
ONLINE
 393,216 6 0 0  
PUBLIC._SYSSMU1$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 34,725,888 28 52 577  
PUBLIC._SYSSMU10$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 32,628,736 26 48 575  
PUBLIC._SYSSMU11$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 25,288,704 26 0 11  
PUBLIC._SYSSMU12$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 27,385,856 28      
PUBLIC._SYSSMU13$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 27,254,784 41      
PUBLIC._SYSSMU14$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 28,303,360 42      
PUBLIC._SYSSMU15$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 29,351,936 43      
PUBLIC._SYSSMU16$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 27,254,784 41      
PUBLIC._SYSSMU17$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 25,157,632 39      
PUBLIC._SYSSMU18$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 27,254,784 41      
PUBLIC._SYSSMU19$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 26,206,208 40      
PUBLIC._SYSSMU2$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 34,725,888 28 48 579  
PUBLIC._SYSSMU20$ UNDOTBS1
131072 /
2 / 32765
OFFLINE
 27,254,784 41      
PUBLIC._SYSSMU3$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 33,677,312 27 48 577  
PUBLIC._SYSSMU4$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 34,725,888 21 50 419  
PUBLIC._SYSSMU5$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 33,677,312 27 52 580  
PUBLIC._SYSSMU6$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 34,725,888 28 52 574  
PUBLIC._SYSSMU7$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 33,677,312 27 56 574  
PUBLIC._SYSSMU8$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 26,337,280 27 49 611  
PUBLIC._SYSSMU9$ UNDOTBS1
131072 /
2 / 32765
ONLINE
 26,337,280 25 52 663  
          ---------------- ------------ ------------ ------------  
Total:         596,344,832 652 507 5,740  

[Top]



UNDO Segment Contention


UNDO statistics from V$ROLLSTAT - (ordered by waits)

UNDO Segment Name Gets Waits Hit Ratio
_SYSSMU10$ 2,250,742 84
100%
_SYSSMU6$ 2,197,027 78
100%
_SYSSMU4$ 2,242,222 77
100%
_SYSSMU1$ 2,228,805 69
100%
_SYSSMU5$ 2,225,852 67
100%
_SYSSMU3$ 2,217,940 64
100%
_SYSSMU2$ 2,208,869 61
100%
_SYSSMU9$ 2,235,075 55
100%
_SYSSMU8$ 2,224,981 50
100%
_SYSSMU7$ 2,236,777 49
100%
_SYSSMU11$ 310,302 3
100%
SYSTEM 5,831 0
100%
  ------------ ------------  
Total: 22,584,423 657  


Wait Statistics

Class Wait Ratio
undo block
.00038879%
undo header
.00053675%
system undo block
0%
system undo header
0%

[Top]



Archiving Mode


Database Log Mode Automatic Archival Current Log Sequence Oldest Online Log Sequence
Archive Mode
Enabled
 110 108

[Top]



Archiving Parameters


Parameter Name Parameter Value
log_archive_dest  
log_archive_dest_1 LOCATION=/u02/oraarchive/ORA920 MANDATORY
log_archive_dest_10  
log_archive_dest_2 service=ORA920_STBY OPTIONAL REOPEN=30
log_archive_dest_3  
log_archive_dest_4  
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_2 DEFER
log_archive_dest_state_3 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 arch_t%t_s%s.dbf
log_archive_max_processes 2
log_archive_min_succeed_dest 1
log_archive_start TRUE
log_archive_trace 0
log_buffer 524288
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert  
log_parallelism 1
logmnr_max_persistent_sessions 1

[Top]



Archiving History


Sequence# Name First
Change # 		First
Time 		Next
Change # 		Next
Time 		Size (in bytes) Archived? Applied? Deleted? Status
100
 /u02/oraarchive/ORA920/arch_t1_s100.dbf 43797853
03/26/2008 05:08:54
 44183319
03/26/2008 08:49:55
 262,142,976
YES
NO
NO
Available
101
 /u02/oraarchive/ORA920/arch_t1_s101.dbf 44183319
03/26/2008 08:49:55
 44567770
03/26/2008 12:30:19
 262,139,392
YES
NO
NO
Available
102
 /u02/oraarchive/ORA920/arch_t1_s102.dbf 44567770
03/26/2008 12:30:19
 44951226
03/26/2008 16:10:24
 262,142,976
YES
NO
NO
Available
103
 /u02/oraarchive/ORA920/arch_t1_s103.dbf 44951226
03/26/2008 16:10:24
 45331688
03/26/2008 19:49:38
 262,142,976
YES
NO
NO
Available
104
 /u02/oraarchive/ORA920/arch_t1_s104.dbf 45331688
03/26/2008 19:49:38
 45711836
03/26/2008 23:33:39
 262,142,976
YES
NO
NO
Available
105
 /u02/oraarchive/ORA920/arch_t1_s105.dbf 45711836
03/26/2008 23:33:39
 46092240
03/27/2008 03:16:43
 262,142,976
YES
NO
NO
Available
106
 /u02/oraarchive/ORA920/arch_t1_s106.dbf 46092240
03/27/2008 03:16:43
 46471231
03/27/2008 07:00:02
 262,142,976
YES
NO
NO
Available
107
 /u02/oraarchive/ORA920/arch_t1_s107.dbf 46471231
03/27/2008 07:00:02
 46846917
03/27/2008 10:39:06
 262,142,464
YES
NO
NO
Available
108
 /u02/oraarchive/ORA920/arch_t1_s108.dbf 46846917
03/27/2008 10:39:06
 47228019
03/27/2008 14:19:58
 262,142,976
YES
NO
NO
Available
109
 /u02/oraarchive/ORA920/arch_t1_s109.dbf 47228019
03/27/2008 14:19:58
 47608038
03/27/2008 18:12:24
 262,142,976
YES
NO
NO
Available
44
 /u02/oraarchive/ORA920/arch_t1_s44.dbf 28701632
03/17/2008 22:55:46
 28747018
03/17/2008 23:20:08
 45,245,440
YES
NO
NO
Available
45
 /u02/oraarchive/ORA920/arch_t1_s45.dbf 28747018
03/17/2008 23:20:08
 28748406
03/17/2008 23:21:02
 7,469,568
YES
NO
NO
Available
46
 /u02/oraarchive/ORA920/arch_t1_s46.dbf 28748406
03/17/2008 23:21:02
 28764603
03/17/2008 23:29:08
 22,185,984
YES
NO
NO
Available
47
 /u02/oraarchive/ORA920/arch_t1_s47.dbf 28764603
03/17/2008 23:29:08
 28819399
03/17/2008 23:53:44
 60,364,288
YES
NO
NO
Available
48
 /u02/oraarchive/ORA920/arch_t1_s48.dbf 28819399
03/17/2008 23:53:44
 28846858
03/18/2008 00:06:38
 27,313,664
YES
NO
NO
Available
49
 /u02/oraarchive/ORA920/arch_t1_s49.dbf 28846858
03/18/2008 00:06:38
 28902707
03/18/2008 00:59:32
 66,667,008
YES
NO
NO
Available
50
 /u02/oraarchive/ORA920/arch_t1_s50.dbf 28902707
03/18/2008 00:59:32
 29401378
03/20/2008 00:10:07
 262,142,976
YES
NO
NO
Available
51
 /u02/oraarchive/ORA920/arch_t1_s51.dbf 29401378
03/20/2008 00:10:07
 29408022
03/20/2008 00:50:34
 3,088,384
YES
NO
NO
Available
52
 /u02/oraarchive/ORA920/arch_t1_s52.dbf 29408022
03/20/2008 00:50:34
 29408035
03/20/2008 00:50:38
 16,384
YES
NO
NO
Available
53
 /u02/oraarchive/ORA920/arch_t1_s53.dbf 29408035
03/20/2008 00:50:38
 29410038
03/20/2008 01:02:06
 2,215,936
YES
NO
NO
Available
54
 /u02/oraarchive/ORA920/arch_t1_s54.dbf 29410038
03/20/2008 01:02:06
 29476583
03/20/2008 01:36:05
 66,307,072
YES
NO
NO
Available
55
 /u02/oraarchive/ORA920/arch_t1_s55.dbf 29476583
03/20/2008 01:36:05
 29712212
03/20/2008 03:23:48
 262,142,976
YES
NO
NO
Available
56
 /u02/oraarchive/ORA920/arch_t1_s56.dbf 29712212
03/20/2008 03:23:48
 29962140
03/20/2008 05:17:47
 262,142,976
YES
NO
NO
Available
57
 /u02/oraarchive/ORA920/arch_t1_s57.dbf 29962140
03/20/2008 05:17:47
 30222358
03/20/2008 07:15:32
 262,142,976
YES
NO
NO
Available
58
 /u02/oraarchive/ORA920/arch_t1_s58.dbf 30222358
03/20/2008 07:15:32
 30482408
03/20/2008 09:13:47
 262,142,976
YES
NO
NO
Available
59
 /u02/oraarchive/ORA920/arch_t1_s59.dbf 30482408
03/20/2008 09:13:47
 30742269
03/20/2008 11:12:52
 262,142,976
YES
NO
NO
Available
60
 /u02/oraarchive/ORA920/arch_t1_s60.dbf 30742269
03/20/2008 11:12:52
 30802955
03/20/2008 11:41:26
 61,854,208
YES
NO
NO
Available
61
 /u02/oraarchive/ORA920/arch_t1_s61.dbf 30802955
03/20/2008 11:41:26
 31057187
03/20/2008 13:38:54
 262,142,976
YES
NO
NO
Available
62
 /u02/oraarchive/ORA920/arch_t1_s62.dbf 31057187
03/20/2008 13:38:54
 31202606
03/20/2008 14:46:45
 262,142,976
YES
NO
NO
Available
63
 /u02/oraarchive/ORA920/arch_t1_s63.dbf 31202606
03/20/2008 14:46:45
 31342598
03/20/2008 15:55:13
 262,142,976
YES
NO
NO
Available
64
 /u02/oraarchive/ORA920/arch_t1_s64.dbf 31342598
03/20/2008 15:55:13
 31591885
03/20/2008 18:12:13
 262,142,976
YES
NO
NO
Available
65
 /u02/oraarchive/ORA920/arch_t1_s65.dbf 31591885
03/20/2008 18:12:13
 31840838
03/20/2008 20:05:29
 262,142,976
YES
NO
NO
Available
66
 /u02/oraarchive/ORA920/arch_t1_s66.dbf 31840838
03/20/2008 20:05:29
 32088868
03/20/2008 21:44:29
 262,142,976
YES
NO
NO
Available
67
 /u02/oraarchive/ORA920/arch_t1_s67.dbf 32088868
03/20/2008 21:44:29
 32323413
03/20/2008 23:19:56
 262,142,976
YES
NO
NO
Available
68
 /u02/oraarchive/ORA920/arch_t1_s68.dbf 32323413
03/20/2008 23:19:56
 32566758
03/21/2008 00:58:48
 262,142,976
YES
NO
NO
Available
69
 /u02/oraarchive/ORA920/arch_t1_s69.dbf 32566758
03/21/2008 00:58:48
 32805047
03/21/2008 02:35:37
 262,140,928
YES
NO
NO
Available
70
 /u02/oraarchive/ORA920/arch_t1_s70.dbf 32805047
03/21/2008 02:35:37
 33072449
03/21/2008 04:25:10
 262,142,976
YES
NO
NO
Available
71
 /u02/oraarchive/ORA920/arch_t1_s71.dbf 33072449
03/21/2008 04:25:10
 33395399
03/21/2008 06:39:10
 262,142,976
YES
NO
NO
Available
72
 /u02/oraarchive/ORA920/arch_t1_s72.dbf 33395399
03/21/2008 06:39:10
 33717263
03/21/2008 09:05:20
 262,142,976
YES
NO
NO
Available
73
 /u02/oraarchive/ORA920/arch_t1_s73.dbf 33717263
03/21/2008 09:05:20
 34042264
03/21/2008 11:32:55
 262,142,976
YES
NO
NO
Available
74
 /u02/oraarchive/ORA920/arch_t1_s74.dbf 34042264
03/21/2008 11:32:55
 34371103
03/21/2008 14:03:26
 262,142,976
YES
NO
NO
Available
75
 /u02/oraarchive/ORA920/arch_t1_s75.dbf 34371103
03/21/2008 14:03:26
 34707411
03/21/2008 16:37:34
 262,142,976
YES
NO
NO
Available
76
 /u02/oraarchive/ORA920/arch_t1_s76.dbf 34707411
03/21/2008 16:37:34
 35053467
03/21/2008 19:17:19
 262,142,976
YES
NO
NO
Available
77
 /u02/oraarchive/ORA920/arch_t1_s77.dbf 35053467
03/21/2008 19:17:19
 35410119
03/21/2008 21:59:31
 262,142,976
YES
NO
NO
Available
78
 /u02/oraarchive/ORA920/arch_t1_s78.dbf 35410119
03/21/2008 21:59:31
 35776382
03/22/2008 00:46:14
 262,142,976
YES
NO
NO
Available
79
 /u02/oraarchive/ORA920/arch_t1_s79.dbf 35776382
03/22/2008 00:46:14
 36151321
03/22/2008 03:37:09
 262,142,976
YES
NO
NO
Available
80
 /u02/oraarchive/ORA920/arch_t1_s80.dbf 36151321
03/22/2008 03:37:09
 36612324
03/22/2008 19:27:54
 262,142,976
YES
NO
NO
Available
81
 /u02/oraarchive/ORA920/arch_t1_s81.dbf 36612324
03/22/2008 19:27:54
 36931190
03/23/2008 14:18:22
 172,291,584
YES
NO
NO
Available
82
 /u02/oraarchive/ORA920/arch_t1_s82.dbf 36931190
03/23/2008 14:18:22
 37297242
03/23/2008 17:49:54
 262,142,976
YES
NO
NO
Available
83
 /u02/oraarchive/ORA920/arch_t1_s83.dbf 37297242
03/23/2008 17:49:54
 37664260
03/23/2008 21:05:39
 262,142,976
YES
NO
NO
Available
84
 /u02/oraarchive/ORA920/arch_t1_s84.dbf 37664260
03/23/2008 21:05:39
 38037941
03/24/2008 00:26:32
 262,142,976
YES
NO
NO
Available
85
 /u02/oraarchive/ORA920/arch_t1_s85.dbf 38037941
03/24/2008 00:26:32
 38415518
03/24/2008 03:50:34
 262,142,976
YES
NO
NO
Available
86
 /u02/oraarchive/ORA920/arch_t1_s86.dbf 38415518
03/24/2008 03:50:34
 38794039
03/24/2008 07:14:57
 262,142,464
YES
NO
NO
Available
87
 /u02/oraarchive/ORA920/arch_t1_s87.dbf 38794039
03/24/2008 07:14:57
 39174737
03/24/2008 10:40:35
 262,142,976
YES
NO
NO
Available
88
 /u02/oraarchive/ORA920/arch_t1_s88.dbf 39174737
03/24/2008 10:40:35
 39558315
03/24/2008 14:10:02
 262,142,976
YES
NO
NO
Available
89
 /u02/oraarchive/ORA920/arch_t1_s89.dbf 39558315
03/24/2008 14:10:02
 39941574
03/24/2008 17:38:20
 262,142,976
YES
NO
NO
Available
90
 /u02/oraarchive/ORA920/arch_t1_s90.dbf 39941574
03/24/2008 17:38:20
 40326365
03/24/2008 21:08:07
 262,142,976
YES
NO
NO
Available
91
 /u02/oraarchive/ORA920/arch_t1_s91.dbf 40326365
03/24/2008 21:08:07
 40710884
03/25/2008 00:38:18
 262,142,976
YES
NO
NO
Available
92
 /u02/oraarchive/ORA920/arch_t1_s92.dbf 40710884
03/25/2008 00:38:18
 41094395
03/25/2008 04:07:50
 262,142,976
YES
NO
NO
Available
93
 /u02/oraarchive/ORA920/arch_t1_s93.dbf 41094395
03/25/2008 04:07:50
 41479145
03/25/2008 07:36:26
 262,142,976
YES
NO
NO
Available
94
 /u02/oraarchive/ORA920/arch_t1_s94.dbf 41479145
03/25/2008 07:36:26
 41864840
03/25/2008 11:07:39
 262,142,976
YES
NO
NO
Available
95
 /u02/oraarchive/ORA920/arch_t1_s95.dbf 41864840
03/25/2008 11:07:39
 42249468
03/25/2008 14:38:25
 262,142,976
YES
NO
NO
Available
96
 /u02/oraarchive/ORA920/arch_t1_s96.dbf 42249468
03/25/2008 14:38:25
 42636035
03/25/2008 18:13:19
 262,142,976
YES
NO
NO
Available
97
 /u02/oraarchive/ORA920/arch_t1_s97.dbf 42636035
03/25/2008 18:13:19
 43022786
03/25/2008 21:50:59
 262,142,976
YES
NO
NO
Available
98
 /u02/oraarchive/ORA920/arch_t1_s98.dbf 43022786
03/25/2008 21:50:59
 43409721
03/26/2008 01:27:25
 262,142,976
YES
NO
NO
Available
99
 /u02/oraarchive/ORA920/arch_t1_s99.dbf 43409721
03/26/2008 01:27:25
 43797853
03/26/2008 05:08:54
 262,142,976
YES
NO
NO
Available

[Top]



RMAN Configuration


All non-default RMAN configuration settings

Name Value
CHANNEL
 DEVICE TYPE DISK FORMAT '/u02/orabackup/ORA920/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE
 DISK TO '/u02/orabackup/ORA920/%F'
CONTROLFILE AUTOBACKUP
 ON
DEFAULT DEVICE TYPE TO
 DISK

[Top]



Backup Sets


Available backup sets contained in the control file including available and expired backup sets

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
10
Datafile Full Backup
DISK
-
-
   2
03/17/2008 14:07:24
03/17/2008 14:20:30
 786 TAG20080317T140723 8,192
NO

 
11
Archived Redo Logs
DISK
-
-
   1
03/17/2008 14:20:35
03/17/2008 14:20:35
 0 TAG20080317T142035 512
NO

 
14
Datafile Full Backup
DISK
YES
YES
   1
03/17/2008 14:57:08
03/17/2008 14:57:09
 1   8,192
NO

 
15
Archived Redo Logs
DISK
-
-
   2
03/17/2008 18:30:33
03/17/2008 18:35:07
 274 TAG20080317T183033 512
NO

 
16
Datafile Full Backup
DISK
-
-
   5
03/17/2008 18:35:18
03/17/2008 19:03:03
 1,665 TAG20080317T183517 8,192
NO

 
17
Archived Redo Logs
DISK
-
-
   1
03/17/2008 19:03:06
03/17/2008 19:03:06
 0 TAG20080317T190306 512
NO

 
18
Datafile Full Backup
DISK
YES
YES
   1
03/17/2008 19:03:07
03/17/2008 19:03:09
 2   8,192
NO

 
19
Datafile Full Backup
DISK
YES
YES
   1
03/17/2008 21:41:46
03/17/2008 21:41:48
 2   8,192
NO

 
20
Datafile Full Backup
DISK
YES
YES
   1
03/17/2008 21:41:59
03/17/2008 21:42:00
 1   8,192
NO

 
21
Archived Redo Logs
DISK
-
-
   2
03/17/2008 22:14:46
03/17/2008 22:20:23
 337 TAG20080317T221444 512
NO

 
22
Datafile Full Backup
DISK
-
-
   5
03/17/2008 22:21:08
03/17/2008 22:55:37
 2,069 TAG20080317T222033 8,192
NO

 
23
Archived Redo Logs
DISK
-
-
   1
03/17/2008 22:55:54
03/17/2008 22:55:57
 3 TAG20080317T225554 512
NO

 
24
Datafile Full Backup
DISK
YES
YES
   1
03/17/2008 22:55:58
03/17/2008 22:56:01
 3   8,192
NO

 
25
Datafile Full Backup
DISK
YES
YES
   1
03/18/2008 00:10:14
03/18/2008 00:10:16
 2   8,192
NO

 
26
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:03:05
03/20/2008 19:03:06
 1   8,192
NO

 
27
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:03:18
03/20/2008 19:03:19
 1   8,192
NO

 
28
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:03:28
03/20/2008 19:03:29
 1   8,192
NO

 
29
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:04:24
03/20/2008 19:04:25
 1   8,192
NO

 
30
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:04:54
03/20/2008 19:04:54
 0   8,192
NO

 
31
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:07:13
03/20/2008 19:07:13
 0   8,192
NO

 
32
Datafile Full Backup
DISK
YES
YES
   1
03/20/2008 19:08:52
03/20/2008 19:08:52
 0   8,192
NO

 
33
Datafile Full Backup
DISK
YES
-
   1
03/27/2008 16:35:39
03/27/2008 16:35:43
 4 TAG20080327T163538 8,192
NO

 
34
Datafile Full Backup
DISK
YES
YES
   1
03/27/2008 16:35:45
03/27/2008 16:35:47
 2   8,192
NO

 
35
Datafile Full Backup
DISK
SBY
-
   1
03/27/2008 16:35:56
03/27/2008 16:35:58
 2 TAG20080327T163556 8,192
NO

 
36
Datafile Full Backup
DISK
YES
YES
   1
03/27/2008 16:35:58
03/27/2008 16:35:59
 1   8,192
NO

 
            ----------------     --------------------          
Total:           36     5,158          

[Top]



Backup Pieces


Available backup pieces contained in the control file including available and expired backup sets

BS Key Piece # Copy # BP Key Status Handle Start Time End Time Elapsed Seconds
10
 1 1 11
Expired
 /u02/orabackup/ORA920/backup_db_ORA920_S_10_P_1_T_649606044
03/17/2008 14:07:25
03/17/2008 14:12:17
 292
  2 1 12
Expired
 /u02/orabackup/ORA920/backup_db_ORA920_S_10_P_2_T_649606044
03/17/2008 14:12:19
03/17/2008 14:20:30
 491
11
 1 1 13
Expired
 /u02/orabackup/ORA920/backup_db_ORA920_S_11_P_1_T_649606835
03/17/2008 14:20:35
03/17/2008 14:20:35
 0
14
 1 1 16
Expired
 /u02/orabackup/ORA920/c-2656136476-20080317-04
03/17/2008 14:57:09
03/17/2008 14:57:09
 0
15
 1 1 17
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_15_P_1_T_649621833
03/17/2008 18:30:34
03/17/2008 18:33:52
 198
  2 1 18
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_15_P_2_T_649621833
03/17/2008 18:33:59
03/17/2008 18:35:07
 68
16
 1 1 19
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_16_P_1_T_649622118
03/17/2008 18:35:32
03/17/2008 18:39:19
 227
  2 1 20
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_16_P_2_T_649622118
03/17/2008 18:39:23
03/17/2008 18:45:11
 348
  3 1 21
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_16_P_3_T_649622118
03/17/2008 18:45:19
03/17/2008 18:54:30
 551
  4 1 22
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_16_P_4_T_649622118
03/17/2008 18:54:34
03/17/2008 18:59:55
 321
  5 1 23
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_16_P_5_T_649622118
03/17/2008 19:00:00
03/17/2008 19:03:03
 183
17
 1 1 24
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_17_P_1_T_649623786
03/17/2008 19:03:06
03/17/2008 19:03:06
 0
18
 1 1 25
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-05
03/17/2008 19:03:08
03/17/2008 19:03:09
 1
19
 1 1 26
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-06
03/17/2008 21:41:48
03/17/2008 21:41:48
 0
20
 1 1 27
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-07
03/17/2008 21:42:00
03/17/2008 21:42:00
 0
21
 1 1 28
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_21_P_1_T_649635286
03/17/2008 22:14:47
03/17/2008 22:18:54
 247
  2 1 29
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_21_P_2_T_649635286
03/17/2008 22:19:02
03/17/2008 22:20:23
 81
22
 1 1 30
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_22_P_1_T_649635668
03/17/2008 22:22:53
03/17/2008 22:27:39
 286
  2 1 31
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_22_P_2_T_649635668
03/17/2008 22:27:44
03/17/2008 22:32:35
 291
  3 1 32
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_22_P_3_T_649635668
03/17/2008 22:32:39
03/17/2008 22:40:25
 466
  4 1 33
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_22_P_4_T_649635668
03/17/2008 22:40:25
03/17/2008 22:49:14
 529
  5 1 34
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_22_P_5_T_649635668
03/17/2008 22:49:21
03/17/2008 22:55:37
 376
23
 1 1 35
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_23_P_1_T_649637754
03/17/2008 22:55:55
03/17/2008 22:55:57
 2
24
 1 1 36
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-08
03/17/2008 22:56:00
03/17/2008 22:56:01
 1
25
 1 1 37
Available
 /u02/orabackup/ORA920/c-2656136476-20080318-00
03/18/2008 00:10:15
03/18/2008 00:10:16
 1
26
 1 1 38
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-00
03/20/2008 19:03:06
03/20/2008 19:03:06
 0
27
 1 1 39
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-01
03/20/2008 19:03:19
03/20/2008 19:03:19
 0
28
 1 1 40
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-02
03/20/2008 19:03:28
03/20/2008 19:03:29
 1
29
 1 1 41
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-03
03/20/2008 19:04:25
03/20/2008 19:04:25
 0
30
 1 1 42
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-04
03/20/2008 19:04:54
03/20/2008 19:04:54
 0
31
 1 1 43
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-05
03/20/2008 19:07:13
03/20/2008 19:07:13
 0
32
 1 1 44
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-06
03/20/2008 19:08:52
03/20/2008 19:08:52
 0
33
 1 1 45
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_33_P_1_T_650478939
03/27/2008 16:35:42
03/27/2008 16:35:43
 1
34
 1 1 46
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-00
03/27/2008 16:35:46
03/27/2008 16:35:47
 1
35
 1 1 47
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_35_P_1_T_650478956
03/27/2008 16:35:57
03/27/2008 16:35:58
 1
36
 1 1 48
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-01
03/27/2008 16:35:59
03/27/2008 16:35:59
 0

[Top]



Backup Control Files


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

BS Key Piece # Copy # BP Key Controlfile Included? Status Handle
14
 1 1 16
YES
Expired
 /u02/orabackup/ORA920/c-2656136476-20080317-04
18
 1 1 25
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-05
19
 1 1 26
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-06
20
 1 1 27
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-07
24
 1 1 36
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-08
25
 1 1 37
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080318-00
26
 1 1 38
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-00
27
 1 1 39
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-01
28
 1 1 40
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-02
29
 1 1 41
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-03
30
 1 1 42
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-04
31
 1 1 43
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-05
32
 1 1 44
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-06
33
 1 1 45
YES
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_33_P_1_T_650478939
34
 1 1 46
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-00
35
 1 1 47
SBY
Available
 /u02/orabackup/ORA920/backup_db_ORA920_S_35_P_1_T_650478956
36
 1 1 48
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-01

[Top]



Backup SPFILE


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

BS Key Piece # Copy # BP Key SPFILE Included? Status Handle
14
 1 1 16
YES
Expired
 /u02/orabackup/ORA920/c-2656136476-20080317-04
18
 1 1 25
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-05
19
 1 1 26
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-06
20
 1 1 27
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-07
24
 1 1 36
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080317-08
25
 1 1 37
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080318-00
26
 1 1 38
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-00
27
 1 1 39
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-01
28
 1 1 40
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-02
29
 1 1 41
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-03
30
 1 1 42
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-04
31
 1 1 43
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-05
32
 1 1 44
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080320-06
34
 1 1 46
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-00
36
 1 1 48
YES
Available
 /u02/orabackup/ORA920/c-2656136476-20080327-01

[Top]



SGA Information


Pool Name Bytes
Fixed Size
 729,328
Variable Size
 301,989,888
Database Buffers
 134,217,728
Redo Buffers
 811,008
  ----------------
Total: 437,747,952

[Top]



DB Buffer Cache Hit Ratio


Consistent Gets DB Block Gets Physical Reads Hit Ratio
953,104,117 112,760,883 95,648,165
91.03%

[Top]



Dictionary Cache Hit Ratio


Misses Gets Hit Ratio
226,965,643 194,505
99.91%

[Top]



Library Cache Hit Ratio


Pins - (Executions) Reloads - (Cache Miss) Hit Ratio
357,043,565 1,353
100%

[Top]



Latch Contention


Latches with "gets", "misses", "sleeps", "immediate gets", or "immediate misses" greater than 0 - (ordered by misses)

Latch Name Gets Misses Sleeps Willing to Wait Ratio Immediate Gets Immediate Misses Immediate Ratio
library cache 937,381,550 424,907 425,497
.0453%
 3,157 110
3.4843%
row cache objects 454,205,588 114,725 114,735
.0253%
 11,975 0
0%
library cache pin 714,942,187 114,066 114,072
.016%
 0 0
0%
cache buffers chains 2,451,659,579 89,737 273,165
.0037%
 44,621,738 15,706
.0352%
cache buffers lru chain 58,639,943 44,536 44,536
.0759%
 4,522,496 1,546
.0342%
session idle bit 290,615,813 44,024 91,386
.0151%
 0 0
0%
library cache pin allocation 151,769,245 19,901 19,903
.0131%
 0 0
0%
enqueue hash chains 69,427,843 10,681 10,681
.0154%
 0 0
0%
redo allocation 65,880,880 7,873 7,880
.012%
 0 0
0%
row cache enqueue latch 453,054,456 7,568 7,568
.0017%
 0 0
0%
SQL memory manager latch 776,326 6,558 6,573
.8447%
 289,039 114
.0394%
session allocation 50,804,925 6,107 6,108
.012%
 0 0
0%
enqueues 30,523,946 5,831 5,832
.0191%
 0 0
0%
dml lock allocation 40,802,801 5,727 5,758
.014%
 0 0
0%
undo global data 38,382,794 2,864 2,863
.0075%
 12 0
0%
sort extent pool 9,921,212 1,678 1,745
.0169%
 0 0
0%
redo copy 23,015 1,280 1,281
5.5616%
 52,251,710 122,452
.2344%
SQL memory manager workarea list latch 89,372,322 1,046 1,046
.0012%
 0 0
0%
simulator lru latch 2,315,320 887 887
.0383%
 2,720,379 1,936
.0712%
mostly latch-free SCN 6,834,988 739 739
.0108%
 0 0
0%
messages 23,933,924 536 536
.0022%
 0 0
0%
channel operations parent latch 9,175,359 504 1,566
.0055%
 0 0
0%
channel handle pool latch 2,459,840 460 1,686
.0187%
 0 0
0%
shared pool 24,798,818 418 418
.0017%
 0 0
0%
sequence cache 26,041,786 309 309
.0012%
 0 0
0%
archive process latch 26,017 237 237
.9109%
 0 0
0%
redo writing 21,576,372 146 146
.0007%
 0 0
0%
loader state object freelist 1,673,955 136 136
.0081%
 0 0
0%
checkpoint queue latch 39,508,893 132 132
.0003%
 7,301,874 440
.006%
archive control 30,761 93 93
.3023%
 0 0
0%
message pool operations parent latch 2,456,327 79 282
.0032%
 0 0
0%
post/wait queue 8,106,090 36 36
.0004%
 3,273,562 73
.0022%
Consistent RBA 6,792,267 31 31
.0005%
 0 0
0%
simulator hash latch 67,236,177 15 15
0%
 0 0
0%
transaction allocation 170,060,398 3 3
0%
 0 0
0%
lgwr LWN SCN 6,833,546 1 1
0%
 0 0
0%
multiblock read objects 516,022 1 1
.0002%
 6 0
0%
event range base latch 1 0 0
0%
 0 0
0%
instance enqueue 1 0 0
0%
 0 0
0%
FOB s.o list latch 683,485 0 0
0%
 0 0
0%
child cursor hash table 50,944 0 0
0%
 0 0
0%
job workq parent latch 0 0 0
0%
 1,030 0
0%
job_queue_processes parameter latch 15,206 0 0
0%
 2 0
0%
kmcpvec latch 0 0 0
0%
 58 0
0%
kmcptab latch 58 0 0
0%
 0 0
0%
address list 2 0 0
0%
 0 0
0%
parameter list 2 0 0
0%
 0 0
0%
session timer 300,260 0 0
0%
 0 0
0%
dispatcher configuration 0 0 0
0%
 1 0
0%
RSM SQL latch 0 0 0
0%
 1 0
0%
qm_init_sga 1 0 0
0%
 0 0
0%
kwqit: protect wakeup time 28,732 0 0
0%
 0 0
0%
spilled msgs queues list latch 28,735 0 0
0%
 0 0
0%
non-pers queues instances 0 0 0
0%
 2 0
0%
NLS data objects 2 0 0
0%
 0 0
0%
ncodef allocation latch 24,051 0 0
0%
 0 0
0%
internal temp table object number alloca 3 0 0
0%
 0 0
0%
temporary table state object allocation 8 0 0
0%
 0 0
0%
device information 123 0 0
0%
 0 0
0%
constraint object allocation 28 0 0
0%
 0 0
0%
hash table column usage latch 2,733 0 0
0%
 117,874 0
0%
hash table modification latch 18 0 0
0%
 2 0
0%
QMT 1 0 0
0%
 0 0
0%
Direct I/O Adaptor 2 0 0
0%
 0 0
0%
Token Manager 2 0 0
0%
 2 0
0%
library cache load lock 12,222 0 0
0%
 0 0
0%
global tx hash mapping 9 0 0
0%
 0 0
0%
user lock 1,984 0 0
0%
 0 0
0%
dictionary lookup 970 0 0
0%
 0 0
0%
OS file lock latch 2 0 0
0%
 0 0
0%
alert log latch 13,726 0 0
0%
 2 0
0%
FAL request queue 14,978 0 0
0%
 0 0
0%
FAL subheap alocation 0 0 0
0%
 2 0
0%
managed standby latch 2 0 0
0%
 0 0
0%
state object free list 4 0 0
0%
 0 0
0%
sim partition latch 0 0 0
0%
 16,928 0
0%
cache buffer handles 555,846 0 0
0%
 0 0
0%
active checkpoint queue latch 589,790 0 0
0%
 2 0
0%
ktm global data 1,218,060 0 0
0%
 0 0
0%
commit callback allocation 972 0 0
0%
 0 0
0%
transaction branch allocation 24,057 0 0
0%
 0 0
0%
dummy allocation 4,920 0 0
0%
 0 0
0%
list of block allocation 30,510 0 0
0%
 0 0
0%
begin backup scn array 44,071 0 0
0%
 0 0
0%
file number translation table 18 0 0
0%
 0 0
0%
name-service namespace objects 0 0 0
0%
 2 0
0%
granule operation 2 0 0
0%
 0 0
0%
vecio buf des 0 0 0
0%
 2 0
0%
ksfv messages 0 0 0
0%
 4 0
0%
i/o slave adaptor 0 0 0
0%
 2 0
0%
X$KSFQP 218 0 0
0%
 0 0
0%
FIB s.o chain latch 671,723 0 0
0%
 0 0
0%
trace latch 82 0 0
0%
 0 0
0%
longop free list parent 51,077 0 0
0%
 2,728 0
0%
event group latch 1,970 0 0
0%
 0 0
0%
object stats modification 1,541 0 0
0%
 2 0
0%
process group creation 3,893 0 0
0%
 0 0
0%
session switching 24,051 0 0
0%
 0 0
0%
process allocation 3,893 0 0
0%
 1,970 0
0%

[Top]



System Wait Statistics


Classes with counts greater than 0

Class Count
file header block 124031
data block 17641
undo header 5721
undo block 4144
segment header 538
1st level bmb 8
2nd level bmb 6

[Top]



System Statistics


Statistics with values greater than 0

Name Value
session uga memory 2,211,964,770,808
redo size 15,541,089,928
bytes received via SQL*Net from client 6,925,694,949
buffer is pinned count 6,395,998,813
sorts (rows) 4,100,829,591
bytes sent via SQL*Net to client 3,918,815,246
table fetch by rowid 3,407,239,821
table scan rows gotten 2,927,047,686
redo wastage 1,606,823,700
session pga memory max 1,326,477,288
process last non-idle time 1,206,646,011
session connect time 1,205,813,733
session pga memory 1,093,765,456
session logical reads 1,065,865,110
session uga memory max 981,505,048
consistent gets 953,104,384
no work - consistent read gets 748,590,209
buffer is not pinned count 710,983,036
recursive calls 305,179,968
table scan blocks gotten 150,322,112
consistent gets - examination 148,747,311
calls to get snapshot scn: kcmgss 144,260,046
db block gets 112,760,945
SQL*Net roundtrips to/from client 105,029,688
db block changes 100,686,640
physical reads 95,648,218
execute count 88,027,834
index fetch by key 85,092,342
user calls 83,909,760
physical writes 79,542,808
physical writes non checkpoint 79,406,100
physical writes direct 72,088,024
index scans kdiixs1 65,243,512
physical reads direct 56,165,239
redo entries 52,248,535
CPU used by this session 43,617,984
CPU used when call started 43,489,712
free buffer requested 43,055,538
redo blocks written 34,575,778
enqueue requests 34,269,717
enqueue releases 34,269,445
DBWR buffers scanned 34,128,278
DBWR summed scan depth 34,128,278
recursive cpu usage 31,518,493
rows fetched via callback 30,661,435
shared hash latch upgrades - no wait 29,410,146
DBWR free buffers found 27,858,149
commit cleanouts 27,509,074
commit cleanouts successfully completed 27,496,451
parse count (total) 25,676,635
opened cursors cumulative 24,916,526
redo synch time 24,825,295
table scans (short tables) 23,377,131
redo write time 22,742,373
user rollbacks 19,730,645
cluster key scan block gets 17,223,201
deferred (CURRENT) block cleanout applications 14,277,202
calls to kcmgas 12,560,678
cluster key scans 11,261,605
hot buffers moved to head of LRU 9,603,003
user commits 9,176,818
summed dirty queue length 7,527,755
messages received 7,105,530
messages sent 7,105,525
redo writes 6,792,105
sorts (memory) 6,334,109
redo synch writes 6,332,128
workarea executions - optimal 6,035,452
consistent changes 3,036,319
data blocks consistent reads - undo records applied 3,027,212
prefetched blocks 2,157,180
active txn count during cleanout 2,128,244
parse time elapsed 1,819,047
cleanout - number of ktugct calls 1,576,578
index crx upgrade (positioned) 1,351,986
CR blocks created 1,218,626
immediate (CR) block cleanout applications 1,142,707
cleanouts and rollbacks - consistent read gets 1,111,230
background timeouts 1,052,923
change write time 1,029,808
free buffer inspected 950,925
dirty buffers inspected 933,999
DBWR undo block writes 837,937
index fast full scans (full) 773,482
parse time cpu 754,361
workarea executions - onepass 715,676
switch current to new buffer 620,446
calls to kcmgcs 585,922
sorts (disk) 584,354
immediate (CURRENT) block cleanout applications 468,147
enqueue waits 374,986
rollback changes - undo records applied 319,927
commit txn count during cleanout 298,668
DBWR checkpoint buffers written 249,964
rollbacks only - consistent read gets 221,571
DBWR lru scans 216,754
DBWR make free requests 216,754
enqueue conversions 212,678
transaction rollbacks 188,136
leaf node splits 95,644
redo writer latching time 95,072
workarea executions - multipass 81,138
cleanouts only - consistent read gets 31,477
no buffer to keep pinned count 17,032
leaf node 90-10 splits 13,586
redo log space wait time 10,147
commit cleanout failures: callback failure 6,999
bytes received via SQL*Net from dblink 6,815
Cached Commit SCN referenced 6,783
workarea memory allocated 5,830
parse count (hard) 5,687
redo buffer allocation retries 5,514
DBWR transaction table writes 5,243
commit cleanout failures: cannot pin 4,907
table scans (long tables) 4,684
write clones created in foreground 3,988
bytes sent via SQL*Net to dblink 3,729
logons cumulative 2,482
redo ordering marks 1,952
cursor authentications 1,631
pinned buffers inspected 1,175
table fetch continued row 952
opened cursors current 638
branch node splits 590
redo log space requests 541
commit cleanout failures: buffer being written 388
commit cleanout failures: block lost 329
DBWR revisited being-written buffer 258
enqueue timeouts 251
prefetched blocks aged out before use 245
parse count (failures) 179
transaction tables consistent reads - undo records applied 158
shared hash latch upgrades - wait 125
failed probes on index block reclamation 107
DBWR checkpoints 94
background checkpoints completed 83
background checkpoints started 83
logons current 45
Commit SCN cached 23
write clones created in background 15
SQL*Net roundtrips to/from dblink 13
index crx upgrade (found) 9
prefetch clients - default 6
exchange deadlocks 3
number of auto extends on undo tablespace 3
transaction tables consistent read rollbacks 2
number of drop segment calls under space pressure 1

[Top]



System Event Statistics


Non-idle events with total waits greater than 0 - (ordered by "Time Waited")

EVENT: The name of the wait event.
TOTAL_WAITS: The total number of waits for this event.
TOTAL_TIMEOUTS: The total number of timeouts for this event.
TIME_WAITED: The total amount of time waited for this event, in hundredths of a second.
AVERAGE_WAIT: The average amount of time waited for this event, in hundredths of a second.

Event Total Waits Total Timeouts Time Waited Average Wait
PL/SQL lock timer 16,369,173 16,368,717 143,604,641 9
enqueue 635,570 260,129 110,839,690 174
db file sequential read 37,300,872 0 104,709,037 3
direct path write 8,004,389 0 98,150,735 12
wakeup time manager 28,732 28,727 82,875,263 2,884
log file sync 3,264,637 5,875 24,150,402 7
log file parallel write 13,378,797 0 22,195,423 2
direct path read 6,063,020 0 12,166,005 2
jobq slave wait 33,418 32,185 9,689,490 290
async disk IO 5,104,545 0 8,686,276 2
db file parallel write 191,311 0 6,959,397 36
latch free 1,147,884 368,209 4,726,738 4
buffer busy waits 152,089 6,042 3,820,355 25
control file parallel write 303,030 0 1,440,179 5
log file sequential read 38,451 0 545,389 14
db file scattered read 207,928 0 476,120 2
log buffer space 5,101 489 175,994 35
switch logfile command 2,192 9 124,516 57
LGWR wait for redo copy 99,479 44,178 94,362 1
process startup 1,820 309 80,101 44
control file sequential read 1,907,604 0 37,831 0
log file switch completion 528 0 9,934 19
free buffer waits 177 60 6,409 36
rdbms ipc reply 1,508 16 4,401 3
library cache pin 42 0 2,780 66
SQL*Net more data from client 100,486 0 803 0
local write wait 1,322 0 751 1
wait list latch free 285 0 662 2
log file single write 510 0 611 1
library cache load lock 33 0 504 15
db file parallel read 7 0 393 56
control file heartbeat 1 1 391 391
SQL*Net break/reset to client 613 0 286 0
row cache lock 25 0 207 8
db file single write 69 0 93 1
control file single write 95 0 68 1
SQL*Net message from dblink 13 0 49 4
undo segment extension 89 89 35 0
buffer deadlock 3 3 6 2
single-task message 1 0 6 6
refresh controlfile command 4 0 2 1
library cache lock 1 0 1 1
SQL*Net message to dblink 13 0 0 0
SQL*Net more data from dblink 2 0 0 0

[Top]



File I/O Statistics


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
SOE /u02/oradata/ORA920/datafile/soe.dbf 19,478,562
44.7%
 925,562
5.04%
 20,404,124
SOEINDEX /u02/oradata/ORA920/datafile/soeindex.dbf 17,498,860
40.16%
 5,590,515
30.43%
 23,089,375
TEMP /u02/oradata/ORA920/datafile/o1_mf_temp_3xx2cwqb_.tmp 6,245,025
14.33%
 10,874,880
59.19%
 17,119,905
SYSTEM /u02/oradata/ORA920/datafile/o1_mf_system_olqasi2v_.dbf 212,500
.49%
 7,670
.04%
 220,170
PERFSTAT /u02/oradata/ORA920/datafile/o1_mf_perfstat_3xx3rzkm_.dbf 95,121
.22%
 56,636
.31%
 151,757
UNDOTBS1 /u02/oradata/ORA920/datafile/o1_mf_undotbs1_p2xnm3aa_.dbf 10,932
.03%
 844,214
4.59%
 855,146
OEM_REPOSITORY /u02/oradata/ORA920/datafile/oem_repository.dbf 9,074
.02%
 4,736
.03%
 13,810
USERS /u02/oradata/ORA920/datafile/o1_mf_users_3xwzdjl6_.dbf 9,013
.02%
 34,137
.19%
 43,150
USERS /u02/oradata/ORA920/datafile/o1_mf_users_8euw2qs0_.dbf 9,012
.02%
 34,588
.19%
 43,600
CWMLITE /u02/oradata/ORA920/datafile/o1_mf_cwmlite_8euqb33r_.dbf 1,893
0%
 157
0%
 2,050
EXAMPLE /u02/oradata/ORA920/datafile/o1_mf_example_ss9iwj2z_.dbf 597
0%
 84
0%
 681
XDB /u02/oradata/ORA920/datafile/o1_mf_xdb_w8iq0kms_.dbf 439
0%
 84
0%
 523
ODM /u02/oradata/ORA920/datafile/o1_mf_odm_7y76ejdi_.dbf 370
0%
 119
0%
 489
DRSYS /u02/oradata/ORA920/datafile/o1_mf_drsys_q9oqmcjd_.dbf 355
0%
 84
0%
 439
INDX /u02/oradata/ORA920/datafile/o1_mf_indx_aoqpm1x8_.dbf 224
0%
 84
0%
 308
REPORTS /u02/oradata/ORA920/datafile/o1_mf_reports_3xy7gfnv_.dbf 0
0%
 7
0%
 7
    --------------------   --------------------   --------------------
Total:   43,571,977   18,373,557   61,945,534

[Top]



File I/O Timings


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)
/u02/oradata/ORA920/datafile/soe.dbf 19,478,603 2.69 925,562 60.71
/u02/oradata/ORA920/datafile/soeindex.dbf 17,498,896 3.10 5,590,515 55.83
/u02/oradata/ORA920/datafile/o1_mf_temp_3xx2cwqb_.tmp 6,245,076 3.08 10,874,962 32.52
/u02/oradata/ORA920/datafile/o1_mf_system_olqasi2v_.dbf 212,500 2.16 7,670 27.53
/u02/oradata/ORA920/datafile/o1_mf_perfstat_3xx3rzkm_.dbf 95,121 3.85 56,636 40.34
/u02/oradata/ORA920/datafile/o1_mf_undotbs1_p2xnm3aa_.dbf 10,932 .47 844,214 51.55
/u02/oradata/ORA920/datafile/oem_repository.dbf 9,074 1.40 4,736 24.07
/u02/oradata/ORA920/datafile/o1_mf_users_3xwzdjl6_.dbf 9,013 6.12 34,137 538.90
/u02/oradata/ORA920/datafile/o1_mf_users_8euw2qs0_.dbf 9,012 6.91 34,588 666.62
/u02/oradata/ORA920/datafile/o1_mf_cwmlite_8euqb33r_.dbf 1,893 2.94 157 4.89
/u02/oradata/ORA920/datafile/o1_mf_example_ss9iwj2z_.dbf 597 3.27 84 6.67
/u02/oradata/ORA920/datafile/o1_mf_xdb_w8iq0kms_.dbf 439 5.85 84 8.01
/u02/oradata/ORA920/datafile/o1_mf_odm_7y76ejdi_.dbf 370 4.14 119 5.36
/u02/oradata/ORA920/datafile/o1_mf_drsys_q9oqmcjd_.dbf 355 3.38 84 6.10
/u02/oradata/ORA920/datafile/o1_mf_indx_aoqpm1x8_.dbf 224 6.23 84 6.83
/u02/oradata/ORA920/datafile/o1_mf_reports_3xy7gfnv_.dbf 0 .00 7 .71
  -------------------- -------------------------------------------- -------------------- ----------------------------------------------
Average:   3.47   96.04
Total: 43,572,105   18,373,639  

[Top]



Average Overall I/O per Second


Average overall I/O calls (physical read/write calls) since last startup of the Oracle instance





Elapsed Time (in seconds) 884,373
Datafile I/O Calls per Second 51
Tempfile I/O Calls per Second 19
Total I/O Calls per Second 70

[Top]



Redo Log Contention


All latches like redo% - (ordered by misses)

Latch Name Gets Misses Sleeps Immediate Gets Immediate Misses
Redo Allocation
 65,881,278 7,873 7,880 0 0
Redo Copy
 23,015 1,280 1,281 52,252,025 122,452
Redo On-Disk Scn
 0 0 0 0 0
Redo Writing
 21,576,501 146 146 0 0
  ------------------------ ---------------- ---------------- ------------------------ ----------------
Total: 87,480,794 9,299 9,307 52,252,025 122,452


System statistics like redo%

Statistics Name Value
Redo Blocks Written
 34,575,962
Redo Buffer Allocation Retries
 5,514
Redo Entries
 52,248,852
Redo Log Space Requests
 541
Redo Log Space Wait Time
 10,147
Redo Log Switch Interrupts
 0
Redo Ordering Marks
 1,952
Redo Size
 15,541,167,508
Redo Synch Time
 24,825,478
Redo Synch Writes
 6,332,163
Redo Wastage
 1,606,834,880
Redo Write Time
 22,742,533
Redo Writer Latching Time
 95,072
Redo Writes
 6,792,151

[Top]



Full Table Scans


Large Table Scans Small Table Scans Pct. Large Scans
4,684 23,377,278
.02%

[Top]



Sorts


Disk Sorts Memory Sorts Pct. Disk Sorts
584,365 6,334,184
8.45%

[Top]



Outlines


Category Owner Name Used? Time Stamp Version SQL Text
DEFAULT
 SCOTT EXTENTS_OUTLN1 UNUSED
03/17/2008 23:00:53
 9.2.0.8.0 select count(*), a.owner, a.segment_type from extents a, segments b where a.owne r = b.owner and a.segment_type = b.segment_type group by a.owner, a.segment_type
DEFAULT
 SCOTT SEGMENTS_OUTLN1 UNUSED
03/17/2008 23:24:16
 9.2.0.8.0 select count(*) from segments where owner = 'PUBLIC'

[Top]



Outline Hints


Category Owner Name Node Join Position Hint
DEFAULT
 SCOTT EXTENTS_OUTLN1
1
0
 NO_EXPAND
     
1
0
 PQ_DISTRIBUTE(B NONE NONE)
     
1
0
 ORDERED
     
1
0
 NO_FACT(A)
     
1
1
 FULL(A)
     
1
0
 NOREWRITE
     
1
0
 ORDERED
     
1
1
 FULL(SEGMENTS)
     
1
0
 NOREWRITE
     
1
0
 NOREWRITE
     
1
0
 NO_FACT(SEGMENTS)
     
1
0
 NO_EXPAND
     
1
0
 NOREWRITE
     
1
2
 FULL(B)
     
1
0
 NO_FACT(B)
     
1
0
 USE_MERGE(B)
    SEGMENTS_OUTLN1
1
0
 NO_EXPAND
     
1
0
 NOREWRITE
     
1
0
 NOREWRITE
     
1
1
 FULL(SEGMENTS)
     
1
0
 NO_FACT(SEGMENTS)
     
1
0
 ORDERED
     
1
0
 NO_EXPAND
     
1
0
 NOREWRITE
     
1
0
 NOREWRITE
     
1
0
 PQ_DISTRIBUTE(B NONE NONE)
     
1
0
 ORDERED
     
1
0
 NO_FACT(A)
     
1
1
 FULL(A)
     
1
2
 FULL(B)
     
1
0
 NO_FACT(B)
     
1
0
 USE_MERGE(B)

[Top]



SQL Statements With Most Buffer Gets


Top 100 SQL statements with buffer gets greater than 1000

Username Buffer Gets Executions Buffer Gets / Execution SQL Text
SOE 705,089,188 6,364,221 111 BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
SOE 634,130,520 5,734,450 111 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID ORDER BY INVENTORIES.WAREHOUSE_ID
SOE 86,681,759 21,192,092 4 SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B1
SOE 84,704,415 2,546,614 33 BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7); END;
SOE 60,345,710 6,368,446 9 BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
SOE 56,457,692 1,270,765 44 BEGIN :1 := orderentry.processorders(:2,:3); END;
SOE 53,214,671 1,249,239 43 SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ O.ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, ORDER_MODE, ORDER_STATUS, O RDER_TOTAL, SALES_REP_ID, PROMOTION_ID, C.CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT, CUST_EMAIL, ORDER_DATE FROM ORDERS O , ORDER_ITEMS OI, CUSTOMERS C WHERE O.ORDER_ID = OI.ORDER_ID AND O.CUSTOMER_ID = C.CUSTOMER_ID AND O.ORDER_STATUS <= 4
SOE 46,945,969 2,503,079 19 INSERT INTO CUSTOMERS(CUSTOMER_ID ,CUST_FIRST_NAME ,CUST_LAST_NAME ,NLS_LANGUAGE ,NLS_TERRITORY ,CREDIT_LIMIT ,CUST_EMAIL ,ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
SOE 46,612,856 6,365,052 7 BEGIN :1 := orderentry.browseandupdateorders(:2,:3,:4); END;
SOE 26,514,946 2,655,593 10 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID
SOE 17,749,794 5,916,646 3 SELECT SYSDATE FROM DUAL
SOE 14,716,727 5,806,297 3 INSERT INTO LOGON VALUES (:B2 , :B1 )
SOE 11,089,862 622,117 18 INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)
SOE 7,652,752 2,546,628 3 SELECT CUSTOMER_SEQ.NEXTVAL FROM DUAL
SOE 5,864,256 1,093,491 5 SELECT ORDER_ID, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID FROM ORDERS WHERE CUSTOMER_ID = :B1
OEM 3,865,043 770,732 5 /* OracleOEM */ SELECT /*+ ORDERED USE_NL(o) INDEX(o pk_SMP_VDD_OP_TABLE) */ o.rowid, o.request_id, o.request_subtype, o.request_type, o.target, o.node, o.user_n ame, o.callback FROM (SELECT /*+ INDEX_FFS(optbl) */ optbl.sequence_num FROM SMP_VDD_OPERATIONS_TABLE optbl, (SELECT region_name FROM smp_vdp_oms_region_map WHERE oms = :1) oms_region_map WHERE optbl.owner='OP_UNALLOCATED' AND ( (optbl.outgoing = 'N') OR ( optbl.outgoing = 'Y' AND ( optbl.node IN (SELECT node_rgn_map.node FROM SMP_VDP_NODES node_rgn_map, SMP_VDP_NODE_I NFO_VDD node_info WHERE node_rgn_map.region_name = oms_region_map.region_name AND node_rgn_map.nod e = node_info.node AND node_info.status = 'Y' ) )
SOE 3,608,248 360,771 10 SELECT ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY FROM ORDER_ITEMS WHERE ORDER_ID = :B1
SOE 2,592,657 1,091,116 2 INSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID) VALUES (ORDERS_SEQ.NEXTVAL , SYSDATE , :B1 ) RETURNING ORDER_ID INTO :B0
SOE 2,507,854 1,249,235 2 UPDATE /*+ index(orders, order_pk) */ ORDERS SET ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(:B3 + 1, :B2 )) WHERE ORDER_ID = :B1
SOE 2,483,202 620,796 4 SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1
SOE 1,893,084 172,802 11 UPDATE ORDERS SET ORDER_MODE = 'online', ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(0, :B3 )), ORDER_TOTAL = :B2 WHERE ORDER_ID = :B1
SOE 1,811,250 360,771 5 UPDATE ORDER_ITEMS SET QUANTITY = QUANTITY + 1 WHERE ORDER_ITEMS.ORDER_ID = :B2 AND ORDER_ITEMS.LINE_ITEM_ID = :B1
SOE 1,557,308 172,440 9 UPDATE INVENTORIES SET QUANTITY_ON_HAND = QUANTITY_ON_HAND - :B1 WHERE PRODUCT_ID = :B3 AND WAREHOUSE_ID = :B2
SOE 1,443,501 360,868 4 UPDATE ORDERS SET ORDER_TOTAL = ORDER_TOTAL + :B2 WHERE ORDER_ID = :B1
PERFSTAT 1,240,635 491 2,527 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack_custom.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
PERFSTAT 787,459 491 1,604 INSERT INTO STATS$SQLTEXT ( HASH_VALUE , TEXT_SUBSET , PIECE , SQL_TEXT , ADDRESS , COMMAND_TYPE , LAST_SNAP_ID ) SELECT /*+ ordered use_nl(vst) */ VST.HASH_VALUE , NEW_SQL.TE XT_SUBSET , VST.PIECE , VST.SQL_TEXT , VST.ADDRESS , VST.COMMAND_TYPE , NEW_SQL.SNAP_ID FROM (SELECT HASH_VALUE , ADDRESS , TEXT_SUBSET , SNAP_ID FROM STATS$SQL_SUMMARY SS WHE RE SS.SNAP_ID = :B3 AND SS.DBID = :B2 AND SS.INSTANCE_NUMBER = :B1 AND NOT EXISTS (SELECT 1 FROM STATS$SQLTEXT SST WHERE SST.HASH_VALUE = SS.HASH_VALUE AND SST.TEXT_SUBSET = S S.TEXT_SUBSET AND SST.PIECE = 0 ) ) NEW_SQL , V$SQLTEXT VST WHERE VST.HASH_VALUE = NEW_SQL.HASH_VALUE AND VST.ADDRESS = NEW_SQL.ADDRESS ORDER BY VST.HASH_VALUE, NEW_SQL.TEXT_S UBSET , VST.PIECE
SCOTT 275,537 3 91,846 select distinct(directory_name) DIRECTORY_NAME from all_directories d, all_tab_privs p where d.directory_name = p.table_name(+) and (( privilege = 'READ ' and grantee = :SCHEMA ) or ( user = 'SYS'))
SCOTT 172,030 8 21,504 /* OracleOEM */ SELECT owner, object_name, NLS_INITCAP(status) FROM sys.dba_objects WHERE object_type = 'DIMENSION' ORDER BY 1, 2
OEM 70,270 14,054 5 /* OracleOEM */ select nodename, status, processing, agentstate, agenttz, (sysdate-timestamp)*24*60*60 as pingingSince, agentname, agentversion from smp_vdg_node _list where (nodename IN (select node from smp_vdp_node_oms_map where oms = :1)) and (agentstate != 'BAD') order by (sysdate-timestamp) desc
SCOTT 67,987 1 67,987 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attribute' am , a.attr_name name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype FROM dba_types t , (select owner, type_name, attr_name, attr_type_name, length from dba_type_attrs order by attr_no) a WHERE t.owner = a.owner AND t.type_name = a .type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') UNION SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Met hod ' || m.method_no torder , m.method_name name , null FROM dba_types t , dba_type_methods m WHERE t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY 1,2,3,4
SCOTT 67,987 1 67,987 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attribute ' || a.attr_no torder , a.attr_name name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype FROM d ba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') UNION SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Method ' || m.method_no torder , m.method_name name , null FROM dba_types t , dba_type_methods m WHERE t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY 1 ,2,3,4
SCOTT 67,750 1 67,750 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attributes' attribute_or_method , a.attr_na me attribute_or_method_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attrib ute_datatype , a.attr_no , null FROM dba_types t , (select 1 torder , owner , type_name , attr_name , attr_type_name , length , attr_no from dba_type_attrs order by owner , type_name , attr_no) a , (select 2 torder , owner , type_name , method_name , method_no from dba_type_methods order by owner , type_name , method_no) m WH ERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name = m.ty
SCOTT 67,750 1 67,750 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attributes' attribute_or_method , a.attr_na me attribute_or_method_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attrib ute_datatype , a.attr_no , null FROM dba_types t , (select 'A' torder , owner , type_name , attr_name , attr_type_name , length , attr_no from dba_type_attrs order by owner , type_name , attr_no) a , (select 'B' torder , owner , type_name , method_name , method_no from dba_type_methods order by owner , type_name , method_no) m WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name =
SCOTT 65,400 1 65,400 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , a.attr_name attribute_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype , m.method_name FROM dba_types t , dba_type _attrs a , dba_type_methods m WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name , a.attr_no , m.method_no
SCOTT 63,519 1 63,519 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , a.attr_name attribute_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') datatype , a.* FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
SCOTT 45,050 1 45,050 SELECT l.owner , l.table_name , l.column_name , l.segment_name , s.segment_type , s.TABLESPACE_NAME , s.BYTES , l.index_name , l.in_row FROM dba_lobs l , dba_segments s WHERE l.owner = s.owner and l.segment_name = s.segment_name ORDER BY l.owner , l.table_name
SCOTT 44,457 10 4,446 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SCOTT"."EMP_RGROUP"'); :mydate := next_date; IF broken TH EN :b := 1; ELSE :b := 0; END IF; END;
OEM 43,998 14,054 3 /* OracleOEM */ UPDATE smp_vdp_node_info_vdd SET status = 'Y' WHERE node IN ('alex')
OEM 43,898 14,075 3 /* OracleOEM */ UPDATE smp_vdp_node_info SET last_checked = SYSDATE WHERE (node = :1)
OEM 43,863 14,054 3 /* OracleOEM */ UPDATE smp_vdp_nodes SET timestamp = SYSDATE WHERE node IN ('alex')
SCOTT 38,149 1 38,149 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attributes' attribute_or_method , a.attr_na me attribute_or_method_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attrib ute_datatype , a.attr_no , null FROM dba_types t , (select 1 torder , owner , type_name , attr_name , attr_type_name , length , attr_no from dba_type_attrs order by owner , type_name , attr_no) a , (select 2 torder , owner , type_name , method_name , method_no from dba_type_methods order by owner , type_name , method_no) m WH ERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY
PERFSTAT 38,025 491 77 INSERT INTO STATS$LATCH_MISSES_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , PARENT_NAME , WHERE_IN_CODE , NWFAIL_COUNT , SLEEP_COUNT , WTR_SLP_COUNT ) SELECT :B3 , :B2 , :B1 , PARENT_NAME , "WHERE" , SUM(NWFAIL_COUNT) , SUM(SLEEP_COUNT) , SUM(WTR_SLP_COUNT) FROM V$LATCH_MISSES WHERE SLEEP_COUNT > 0 GROUP BY :B3 , :B2 , :B1 , PARENT_NAME, "WHERE"
SCOTT 35,085 1 35,085 /* OracleOEM */ SELECT object_name "Object", object_type "Object Type" FROM sys.dba_objects WHERE owner = 'SYS' and (object_type not like '%JAVA%' AND object_type not in ('DATABASE LINK', 'SYNONYM')) UNION SELECT NVL(l.longname, s.object_name) "Object", s.object_type "Object Type " FROM sys.dba_objects s, javasnm l WHERE s.object_name = l.sho rt(+) and s.owner = 'SYS' and (s.object_type like '%JAVA%' OR s.object_type = 'SYNONYM') ORDER BY 1, 2
SCOTT 35,040 2 17,520 SELECT l.owner owner , l.table_name table_name , l.column_name column_name , l.segment_name segment_name , s1.tablesp ace_name tablespace_name , s1.bytes lob_segment_bytes , l.index_name index_name , l.in_row in_row FROM dba_lobs l , (select owner, segment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBSEGMENT') s1 WHERE l.owner = s1.owner AND l.segment_name = s1.segme nt_name ORDER BY l.owner , l.table_name , l.column_name
SCOTT 16,058 3 5,353 select * from ( SELECT OBJECT_NAME, OBJECT_ID ,'' short_name, 'TRUE' partition, OWNER OBJECT_OWNER, CREATED, LAST_DDL_TIME FROM SYS.ALL_OBJECTS O WHERE O.OWNER = :SCHEMA AND O.OBJECT_TYPE = 'TABLE' AND O.GENERATED = 'N' AND NOT EXISTS (SELECT 1 FROM SYS.ALL_MVIEWS WHERE MVIEW_NAME = O.OBJECT_NAME AND OWNER = O.OWNER) unio n all SELECT OBJECT_NAME, OBJECT_ID , syn.SYNONYM_NAME short_NAME, 'TRUE' partition, SYN.TABLE_OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME FROM SYS .ALL_OBJECTS O, sys.user_synonyms syn WHERE syn.table_owner = o.owner and syn.TABLE_NAME = o.object_NAME and o.object_type = ' TABLE' and :INCLUDE_SYNS = 1 and :SCHEMA = USER )
SOE 13,150 1 13,150 select min(customer_id), max(customer_id) from customers
SCOTT 11,824 1 11,824 /* OracleOEM */ SELECT type_name FROM sys.dba_coll_types WHERE owner = :1 and coll_type = 'TABLE' ORDER BY 1
SCOTT 11,408 3 3,803 /* OracleOEM */ SELECT /*+ ALL_ROWS */ type_name FROM sys.dba_types WHERE owner = :1 and typecode = 'OBJECT' ORDER BY 1
SCOTT 11,298 1 11,298 SELECT l.owner , l.table_name , l.column_name , l.segment_name , l.index_name , l.in_row FROM dba_lobs l ORDER BY l.owner , l.table_name
PERFSTAT 10,786 491 22 INSERT INTO STATS$SYSTEM_EVENT ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO ) SELECT :B3 , :B2 , :B1 , EVENT , TOTAL_WAITS , T OTAL_TIMEOUTS , TIME_WAITED_MICRO FROM V$SYSTEM_EVENT
SCOTT 10,574 1 10,574 SELECT l.owner , l.table_name FROM dba_lobs l ORDER BY l.owner , l.table_name
PERFSTAT 9,749 491 20 INSERT INTO STATS$ROLLSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHR INK , AVEACTIVE ) SELECT :B3 , :B2 , :B1 , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHRINK , AVEACTIVE FROM V$ROLLSTAT
PERFSTAT 9,685 491 20 INSERT INTO STATS$SGASTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , POOL , NAME , BYTES ) SELECT :B3 , :B2 , :B1 , POOL , NAME , BYTES FROM V$SGASTAT
SCOTT 7,203 1 7,203 select * from dba_types
SCOTT 7,195 1 7,195 select * from ( select * from dba_types ) sub1 order by 10 asc
PERFSTAT 7,031 491 14 INSERT INTO STATS$ROWCACHE_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , PARAMETER , TOTAL_USAGE , USAGE , GETS , GETMISSES , SCANS , SCANMISSES , SCANCOMPLETES , MODIFICATIONS , FLUSHES , DLM_REQUESTS , DLM_CONFLICTS , DLM_RELEASES ) SELECT :B3 , :B2 , :B1 , PARAMETER , SUM("COUNT") , SUM(USAGE) , SUM(GETS) , SUM(GETMISSES) , SUM(SCANS) , SUM(SCANM ISSES) , SUM(SCANCOMPLETES) , SUM(MODIFICATIONS) , SUM(FLUSHES) , SUM(DLM_REQUESTS) , SUM(DLM_CONFLICTS) , SUM(DLM_RELEASES) FROM V$ROWCACHE GROUP BY :B3 , :B2 , :B1 , PARAMET ER
SCOTT 6,593 1 6,593 /* OracleOEM */ select /*+ cost all_rows */ Attr_name,Attr_type_owner,Attr_type_name,Typecode,ATTR_TYPE_MOD from sys.dba_type_attrs a, sys.dba_types b where a.attr_type_name = b.type_name and (a.attr_type_owner = b.owner or (a.attr_type_owner is null and b.owner is null)) and a.type_name = 'SDO_GEOMETRY' and a.owner = 'MDSYS'
SCOTT 6,424 1 6,424 /* OracleOEM */ select /*+ cost all_rows */ Attr_name,Attr_type_owner,Attr_type_name,Typecode,ATTR_TYPE_MOD from sys.dba_type_attrs a, sys.dba_types b where a.attr_type_name = b.type_name and (a.attr_type_owner = b.owner or (a.attr_type_owner is null and b.owner is null)) and a.type_name = 'SDO_POINT_TYPE' and a.owner = 'MDSYS'
PERFSTAT 6,381 491 13 INSERT INTO STATS$BG_EVENT_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO ) SELECT :B3 , :B2 , :B1 , E.EVENT , SUM(E.TOT AL_WAITS) , SUM(E.TOTAL_TIMEOUTS) , SUM(E.TIME_WAITED_MICRO) FROM V$SESSION_EVENT E WHERE E.SID IN (SELECT S.SID FROM V$SESSION S WHERE S.TYPE = 'BACKGROUND') GROUP BY :B3 , : B2 , :B1 , E.EVENT
PERFSTAT 6,148 491 13 INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP_TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_READS_TH , BUFFE R_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR_BKS_SD_TH, SEG_CU_BKS_SD_TH , SERIAL#, ALL_INIT) VALUES ( :B22 , :B21 , :B20 , SYSDATE, :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
PERFSTAT 5,772 491 12 INSERT INTO STATS$ENQUEUE_STAT ( SNAP_ID , DBID , INSTANCE_NUMBER , EQ_TYPE , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME ) SELECT :B3 , :B2 , :B1 , EQ_ TYPE , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME FROM V$ENQUEUE_STAT WHERE TOTAL_REQ# != 0
PERFSTAT 4,464 491 9 INSERT INTO STATS$LIBRARYCACHE ( SNAP_ID , DBID , INSTANCE_NUMBER , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOCK_REQUESTS , DLM_PIN_REQUEST S , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS ) SELECT :B3 , :B2 , :B1 , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOC K_REQUESTS , DLM_PIN_REQUESTS , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS FROM V$LIBRARYCACHE
SCOTT 4,231 1 4,231 select owner , type_name , method_name , method_no from dba_type_methods order by owner , type_name , m ethod_no
SCOTT 4,231 1 4,231 select owner, type_name, method_name, method_no from dba_type_methods order by owner, type_name, method_no
SCOTT 4,231 1 4,231 select owner, type_name, method_name, method_no from dba_type_methods order by method_no
PERFSTAT 4,082 491 8 INSERT INTO STATS$PGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTES_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT ) SELECT :B3 , :B2 , :B1 , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTE S_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT FROM V$PGA_TARGET_ADVICE WHERE ADVICE_STATUS = 'ON'
PERFSTAT 4,033 491 8 INSERT INTO STATS$RESOURCE_LIMIT ( SNAP_ID , DBID , INSTANCE_NUMBER , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE ) SELECT :B3 , : B2 , :B1 , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE FROM V$RESOURCE_LIMIT WHERE LIMIT_VALUE != ' UNLIMITED' AND MAX_UTILIZATION > 0
SCOTT 4,015 1 4,015 INSERT /*+ APPEND */ INTO "SCOTT"."EMP_MV"("COUNT(*)") SELECT COUNT(*) FROM "EMP" "EMP"
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name = 'VARCHAR2' OR c.elem_t ype_name = 'CHAR') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c.scale IS NOT NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c.scale IS NULL)) THEN c.elem_type_name || '(' || c.precision || ')' ELSE c.elem_type_name END) elem_datatype , TO_CHAR(c.prec ision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_name
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name = 'VARCHAR2' OR c.elem_t ype_name = 'CHAR') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c.scale IS NOT NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c.scale IS NULL)) THEN c.elem_type_name || '(' || c.precision || ')' ELSE c.elem_type_name END) elem_datatype , c.length , T O_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_nam
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name='VARCHAR2' OR c.elem_typ e_name='CHAR' OR c.elem_type_name='RAW') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c .scale IS NOT NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision IS NOT NULL and c.scale IS NULL)) THEN c.elem_type_name || '(' || c.precision || ')' ELSE c.elem_type_name END) elem_datat ype , c.length , TO_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.length IS NOT NULL) THEN c.e lem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name='NUMBER' AND (c.precision IS NOT NULL and c.scale IS NOT NULL)) THEN c.elem_type_name || '(' | | c.precision || ',' || c.scale || ')' WHEN (c.elem_type_name='NUMBER' AND (c.precision IS NOT NULL and c.scale IS NULL)) THEN c.elem_type_name || '(' || c.p recision || ')' ELSE c.elem_type_name END) elem_datatype , c.character_set_name character_set_n ame , c.elem_storage elem_storage , c.nulls_stored nulls_stored FROM
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name = 'VARCHAR2' OR c.elem_t ype_name = 'CHAR') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision is not NULL and c.scale is not NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' END) elem_datatype , TO_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_name character_set_name , c.elem_storage elem_storage , c.nulls_stored nulls_stored FROM dba_coll_types c ORDER BY c.owner
SCOTT 3,992 1 3,992 select * from dba_coll_types order by owner, type_name
SCOTT 3,992 1 3,992 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name='VARCHAR2' OR c.elem_typ e_name='CHAR' OR c.elem_type_name='RAW') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name='NUMBER' AND (c.precision IS NOT NULL and c.s cale IS NOT NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' WHEN (c.elem_type_name='NUMBER' AND (c.precision IS NOT NULL and c.sc ale IS NULL)) THEN c.elem_type_name || '(' || c.precision || ')' ELSE c.elem_type_name END) elem_datatype , c.length , TO_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c
PERFSTAT 3,953 491 8 INSERT INTO STATS$SHARED_POOL_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , EST D_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS ) SELECT :B3 , :B2 , :B1 , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ES TD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS FROM V$SHARED_POOL_ADVICE
PERFSTAT 3,745 491 8 INSERT INTO STATS$SGA ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , VALUE ) SELECT :B3 , :B2 , :B1 , NAME , VALUE FROM V$SGA
PERFSTAT 3,372 203 17 INSERT INTO STATS$FILESTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLK WRT , WAIT_COUNT , TIME ) SELECT :B3 , :B2 , :B1 , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUN T , TIME FROM STATS$V$FILESTATXS
SCOTT 2,368 6 395 /* OracleOEM */ SELECT u.name FROM ( SELECT DISTINCT o.owner# FROM sys.obj$ o WHERE o.linkname IS NULL AND (o.type# NOT IN (1,10) OR (o.type#=1 AND 1=(SELECT 1 FROM sys.i nd$ i WHERE i.obj#=o.obj# AND i.type# IN (1,2,3,4,6,7,9))) ) AND o.name != '_NEXT_OBJECT' AND o.name != '_default_auditing_options_' AND o.type# = :1 ) o, sys.user$ u WHER E u.user# = o.owner# order by 1
PERFSTAT 2,310 491 5 INSERT INTO STATS$UNDOSTAT ( BEGIN_TIME , END_TIME , DBID , INSTANCE_NUMBER , SNAP_ID , UNDOTSN , UNDOBLKS , TXNCOUNT , MAXQUERYLEN , MAXCONCURRENCY , UNXPSTEALCNT , UNXPBLKRE LCNT , UNXPBLKREUCNT , EXPSTEALCNT , EXPBLKRELCNT , EXPBLKREUCNT , SSOLDERRCNT , NOSPACEERRCNT ) SELECT BEGIN_TIME , END_TIME , MAX(:B4 ) , MAX(:B3 ) , MAX(:B2 ) , MAX(UNDOTSN ) , SUM(UNDOBLKS) , SUM(TXNCOUNT) , MAX(MAXQUERYLEN) , MAX(MAXCONCURRENCY) , SUM(UNXPSTEALCNT) , SUM(UNXPBLKRELCNT) , SUM(UNXPBLKREUCNT) , SUM(EXPSTEALCNT) , SUM(EXPBLKRELCNT) , SUM(EXPBLKREUCNT) , SUM(SSOLDERRCNT) , SUM(NOSPACEERRCNT) FROM V$UNDOSTAT WHERE BEGIN_TIME > :B1 AND BEGIN_TIME + (1/(24*6)) <= END_TIME GROUP BY BEGIN_TIME, END_TIME
SCOTT 2,134 8 267 SELECT d.status status , d.tablespace_name name , d.contents type , d.extent_management extent_mgt , d.segment_space_management segment_mgt , NVL(a.bytes, 0) ts_size , NVL(a.bytes - NVL(f.bytes, 0), 0) used -- , NVL(f.bytes, 0) free , NVL(( a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0) pct_used FROM sys.dba_tablespaces d , ( select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name ) a , ( select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name ) f WHERE d.tablespace_name = a.table space_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT ( d.extent_management like 'LOCAL' AND d.
OEM 1,928 939 2 /* OracleOEM */ BEGIN smp_vdm_notification_pkg.purge_ui_notification; END;
SCOTT 1,766 3 589 /* OracleOEM */ SELECT table_name, iot_type FROM sys.dba_all_tables WHERE owner = :1 and nested <> 'YES' AND (iot_type is null or iot_type = 'IOT') ORDER BY 1
PERFSTAT 1,686 491 3 SELECT STATS$SNAPSHOT_ID.NEXTVAL FROM DUAL WHERE ROWNUM = 1
PERFSTAT 1,476 491 3 select TRUNC(sysdate,'HH24')+((FLOOR(TO_NUMBER(TO_CHAR(sysdate,'MI'))/30)+1)*30)/(24*60) from dual
PERFSTAT 1,209 491 2 SELECT NVL(:B21 , SESSION_ID) , NVL(:B20 , SNAP_LEVEL) , NVL(:B19 , UCOMMENT) , NVL(:B18 , NUM_SQL) , NVL(:B17 , EXECUTIONS_TH) , NVL(:B16 , PARSE_CALLS_TH) , NVL(:B15 , DISK_ READS_TH) , NVL(:B14 , BUFFER_GETS_TH) , NVL(:B13 , SHARABLE_MEM_TH) , NVL(:B12 , VERSION_COUNT_TH) , NVL(:B11 , SEG_PHY_READS_TH) , NVL(:B10 , SEG_LOG_READS_TH) , NVL(:B9 , S EG_BUFF_BUSY_TH) , NVL(:B8 , SEG_ROWLOCK_W_TH) , NVL(:B7 , SEG_ITL_WAITS_TH) , NVL(:B6 , SEG_CR_BKS_SD_TH) , NVL(:B5 , SEG_CU_BKS_SD_TH) , NVL(:B4 , ALL_INIT) , NVL(:B3 , PIN_ STATSPACK) FROM STATS$STATSPACK_PARAMETER WHERE INSTANCE_NUMBER = :B2 AND DBID = :B1
SCOTT 1,196 3 399 select table_owner ,table_name from all_synonyms where synonym_name = 'DBA_COLL_TYPES' and ( owner = 'PUBLIC' OR UPPER(owner)= UPPER(sys_context('USERENV', 'CURRENT_SCHEMA') ) )
SCOTT 1,196 3 399 select table_owner ,table_name from all_synonyms where synonym_name = 'DBA_MVIEW_LOGS' and ( owner = 'PUBLIC' OR UPPER(owner)= UPPER(sys_context('USERENV', 'CURRENT_SCHEMA') ) )
SCOTT 1,196 3 399 select table_owner ,table_name from all_synonyms where synonym_name = 'DBA_TYPE_ATTRS' and ( owner = 'PUBLIC' OR UPPER(owner)= UPPER(sys_context('USERENV', 'CURRENT_SCHEMA') ) )
SCOTT 1,192 2 596 select object_name from dba_objects where object_name like '%LOB%'
SCOTT 1,121 2 561 /* OracleOEM */ SELECT fl.dimension_alias, fl.dimension_name, kc.column_name, kc.position, fl.level_name FROM dba_olap_fact_level_uses fl, dba_olap_key_column_uses kc WHERE fl .owner = 'SH' AND fl.cube_name = 'COST_CUBE' AND fl.fact_table_owner = kc.owner AND fl.fact_table_name = kc.table_name AND fl.foreign_key_name = kc.key_name ORDER BY dimension _alias, dimension_name, position
SCOTT 1,106 2 553 /* OracleOEM */ SELECT tablespace_name, cache, iot_type, cluster_name, partitioned FROM sys.dba_tables WHERE owner = 'CTXSYS' AND table_name = 'DR$PART_STATS' UNION SELECT tab lespace_name, null, 'IOT', null, null FROM sys.dba_indexes WHERE owner = 'CTXSYS' AND table_name = 'DR$PART_STATS' and index_type = 'IOT - TOP'
SCOTT 1,068 2 534 /* OracleOEM */ SELECT dl.dimension_alias, dl.dimension_name, dl.level_name, dl.level_table_owner, dl.level_table_name, cc.column_name, cc.position FROM dba_olap_level_key_col umn_uses cc, (SELECT cd.dimension_alias, l.dimension_name, l.owner, l.level_name, l.level_table_owner, l.level_table_name FROM dba_olap_dim_levels l, dba_olap_cube_dim_uses cd WHERE cd.owner = 'SH' AND cd.cube_name = 'COST_CUBE' AND cd.dimension_owner = l.owner AND cd.dimension_name = l.dimension_name) dl WHERE dl.owner = cc.owner AND dl.dimension_ name = cc.dimension_name AND dl.level_name = cc.level_name ORDER BY dl.dimension_alias, dl.dimension_name, dl.level_name, cc.position
SCOTT 1,018 2 509 /* OracleOEM */ SELECT column_name, constraint_name, position FROM sys.dba_cons_columns WHERE position is not null AND owner = 'CTXSYS' AND table_name = 'DR$PART_STATS'
SCOTT 1,016 3 339 /* OracleOEM */ SELECT DISTINCT u.name FROM sys.obj$ o, sys.user$ u WHERE o.owner# = u.user#
SCOTT 1,014 2 507 /* OracleOEM */ SELECT constraint_name, count(*) FROM sys.dba_cons_columns WHERE position is not NULL AND owner = 'CTXSYS' AND table_name = 'DR$PART_STATS' group by constraint _name

[Top]



SQL Statements With Most Disk Reads


Top 100 SQL statements with disk reads greater than 1000

Username Disk Reads Executions Reads / Execution SQL Text
SOE 64,270,315 6,364,333 10 BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
SOE 54,427,323 5,734,546 9 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID ORDER BY INVENTORIES.WAREHOUSE_ID
SOE 26,844,885 21,192,470 1 SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B1
SOE 12,635,293 6,365,180 2 BEGIN :1 := orderentry.browseandupdateorders(:2,:3,:4); END;
SOE 9,187,506 6,368,544 1 BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
SOE 4,969,655 2,546,668 2 BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7); END;
SOE 4,877,239 2,503,133 2 INSERT INTO CUSTOMERS(CUSTOMER_ID ,CUST_FIRST_NAME ,CUST_LAST_NAME ,NLS_LANGUAGE ,NLS_TERRITORY ,CREDIT_LIMIT ,CUST_EMAIL ,ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
SOE 2,345,569 1,093,516 2 SELECT ORDER_ID, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID FROM ORDERS WHERE CUSTOMER_ID = :B1
SOE 747,358 360,778 2 SELECT ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY FROM ORDER_ITEMS WHERE ORDER_ID = :B1
PERFSTAT 670,629 491 1,366 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack_custom.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
PERFSTAT 511,546 491 1,042 INSERT INTO STATS$SQLTEXT ( HASH_VALUE , TEXT_SUBSET , PIECE , SQL_TEXT , ADDRESS , COMMAND_TYPE , LAST_SNAP_ID ) SELECT /*+ ordered use_nl(vst) */ VST.HASH_VALUE , NEW_SQL.TE XT_SUBSET , VST.PIECE , VST.SQL_TEXT , VST.ADDRESS , VST.COMMAND_TYPE , NEW_SQL.SNAP_ID FROM (SELECT HASH_VALUE , ADDRESS , TEXT_SUBSET , SNAP_ID FROM STATS$SQL_SUMMARY SS WHE RE SS.SNAP_ID = :B3 AND SS.DBID = :B2 AND SS.INSTANCE_NUMBER = :B1 AND NOT EXISTS (SELECT 1 FROM STATS$SQLTEXT SST WHERE SST.HASH_VALUE = SS.HASH_VALUE AND SST.TEXT_SUBSET = S S.TEXT_SUBSET AND SST.PIECE = 0 ) ) NEW_SQL , V$SQLTEXT VST WHERE VST.HASH_VALUE = NEW_SQL.HASH_VALUE AND VST.ADDRESS = NEW_SQL.ADDRESS ORDER BY VST.HASH_VALUE, NEW_SQL.TEXT_S UBSET , VST.PIECE
SOE 358,495 360,876 1 UPDATE ORDERS SET ORDER_TOTAL = ORDER_TOTAL + :B2 WHERE ORDER_ID = :B1
SOE 200,035 622,117 0 INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)
SOE 187,478 1,091,134 0 INSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID) VALUES (ORDERS_SEQ.NEXTVAL , SYSDATE , :B1 ) RETURNING ORDER_ID INTO :B0
SOE 114,141 1,270,791 0 BEGIN :1 := orderentry.processorders(:2,:3); END;
PERFSTAT 109,025 491 222 INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS , FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS , DISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRESS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTLINE_SID , OUTLINE_CATEGORY , C HILD_LATCH ) SELECT :B9 , :B8 , :B7 , SUBSTRB(SQL_TEXT,1,31) , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS , FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS , D ISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRESS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTLINE_SID , OUTLINE_CATEGORY , CHILD_LATCH FROM ST ATS$V$SQLXS WHERE IS_OBSOLETE = 'N' AND ( BUFFER_GETS > :B6 OR DISK_READS > :B5 OR PARSE_CALLS > :B4 OR EXECUTIONS > :B3 OR SHARABLE_MEM > :B2 OR VERSION_COUNT > :B1 )
SOE 105,855 1,249,266 0 SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ O.ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, ORDER_MODE, ORDER_STATUS, O RDER_TOTAL, SALES_REP_ID, PROMOTION_ID, C.CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT, CUST_EMAIL, ORDER_DATE FROM ORDERS O , ORDER_ITEMS OI, CUSTOMERS C WHERE O.ORDER_ID = OI.ORDER_ID AND O.CUSTOMER_ID = C.CUSTOMER_ID AND O.ORDER_STATUS <= 4
SOE 64,640 2,655,623 0 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID
SCOTT 40,661 10 4,066 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SCOTT"."EMP_RGROUP"'); :mydate := next_date; IF broken TH EN :b := 1; ELSE :b := 0; END IF; END;
SCOTT 16,249 120 135 select object_type,owner,object_name,rank from ( select object_type,owner,object_name,0 rank from all_objects where object_name = :NAME and UPPER(owner) = nvl(:OWN ER,UPPER(sys_context('USERENV', 'CURRENT_SCHEMA'))) and object_type not in ( 'SYNONYM' ) union all select ao.object_type,ao.owner,ao.object_name,decode(UPPER(syn.own er), nvl(:OWNER,UPPER(sys_context('USERENV', 'CURRENT_SCHEMA'))),10,20) from all_objects ao,all_synonyms syn where ao.owner = syn.table_owner and ao.object_name = s yn.table_name and syn.synonym_name = :NAME ) where object_type not in ('PACKAGE BODY') order by rank
SOE 6,319 1 6,319 select min(customer_id), max(customer_id) from customers
OEM 6,234 770,744 0 /* OracleOEM */ SELECT /*+ ORDERED USE_NL(o) INDEX(o pk_SMP_VDD_OP_TABLE) */ o.rowid, o.request_id, o.request_subtype, o.request_type, o.target, o.node, o.user_n ame, o.callback FROM (SELECT /*+ INDEX_FFS(optbl) */ optbl.sequence_num FROM SMP_VDD_OPERATIONS_TABLE optbl, (SELECT region_name FROM smp_vdp_oms_region_map WHERE oms = :1) oms_region_map WHERE optbl.owner='OP_UNALLOCATED' AND ( (optbl.outgoing = 'N') OR ( optbl.outgoing = 'Y' AND ( optbl.node IN (SELECT node_rgn_map.node FROM SMP_VDP_NODES node_rgn_map, SMP_VDP_NODE_I NFO_VDD node_info WHERE node_rgn_map.region_name = oms_region_map.region_name AND node_rgn_map.nod e = node_info.node AND node_info.status = 'Y' ) )
SCOTT 4,962 10 496 /* OracleOEM */ select dl.level_name, dl.detailobj_owner, dl.detailobj_name, dlk.key_position, dlk.column_name from dba_dim_levels dl, dba_dim_level_key dlk where dl.owner = ' SCOTT' and dl.dimension_name = 'TEST_DIM' and dl.owner = dlk.owner(+) and dl.dimension_name = dlk.dimension_name(+) and dl.level_name = dlk.level_name(+) order by dl.level_nam e, dlk.key_position
SOE 4,533 5,806,407 0 INSERT INTO LOGON VALUES (:B2 , :B1 )
LBACSYS 4,248 936 5 BEGIN LBACSYS.lbac_events.logon(dbms_standard.login_user); END;
SOE 4,036 5,916,764 0 SELECT SYSDATE FROM DUAL
SCOTT 3,997 1 3,997 INSERT /*+ APPEND */ INTO "SCOTT"."EMP_MV"("COUNT(*)") SELECT COUNT(*) FROM "EMP" "EMP"
PERFSTAT 3,656 491 7 INSERT INTO STATS$SYSSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , STATISTIC# , NAME , VALUE ) SELECT :B3 , :B2 , :B1 , STATISTIC# , NAME , VALUE FROM V$SYSSTAT
SCOTT 3,633 1 3,633 SELECT l.owner owner , l.table_name table_name , l.column_name column_name , l.segment_name segment_name , s1.tablesp ace_name tablespace_name , s1.bytes lob_segment_bytes , l.index_name index_name , s2.bytes lob_index_bytes , l.in_row in_row FROM dba_lobs l , (select owner, segment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBSEGMENT') s1 , (select owner, s egment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBINDEX') s2 WHERE l.owner = s1.owner AND l.segment_name = s1.segment_name AND s1.owne r = s2.owner AND l.column_name = s2.segment_name ORDER BY l.owner , l.table_name , l.column_name
PERFSTAT 3,353 491 7 INSERT INTO STATS$PARAMETER ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , VALUE , ISDEFAULT , ISMODIFIED ) SELECT :B3 , :B2 , :B1 , NAME , VALUE , ISDEFAULT , ISMODIFIED FROM V$ SYSTEM_PARAMETER
PERFSTAT 3,339 491 7 INSERT INTO STATS$LATCH ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_GETS , IMMEDIATE_MISSES , SPIN_GETS , SLEEP1 , SLEEP2 , SLEEP3 , SLEEP4 , WAIT_TIME ) SELECT :B3 , :B2 , :B1 , NAME , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_GETS , IMMEDIATE_MISSES , SPIN_GETS , SLEEP1 , SLEEP2 , SL EEP3 , SLEEP4 , WAIT_TIME FROM V$LATCH
PERFSTAT 3,049 491 6 INSERT INTO STATS$LATCH_MISSES_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , PARENT_NAME , WHERE_IN_CODE , NWFAIL_COUNT , SLEEP_COUNT , WTR_SLP_COUNT ) SELECT :B3 , :B2 , :B1 , PARENT_NAME , "WHERE" , SUM(NWFAIL_COUNT) , SUM(SLEEP_COUNT) , SUM(WTR_SLP_COUNT) FROM V$LATCH_MISSES WHERE SLEEP_COUNT > 0 GROUP BY :B3 , :B2 , :B1 , PARENT_NAME, "WHERE"
SCOTT 2,944 1 2,944 /* OracleOEM */ select /*+ cost all_rows */ Attr_name,Attr_type_owner,Attr_type_name,Typecode,ATTR_TYPE_MOD from sys.dba_type_attrs a, sys.dba_types b where a.attr_type_name = b.type_name and (a.attr_type_owner = b.owner or (a.attr_type_owner is null and b.owner is null)) and a.type_name = 'SDO_GEOMETRY' and a.owner = 'MDSYS'
SCOTT 2,127 1 2,127 SELECT t.owner , t.type_name , t.typecode , a.attr_name , m.method_name FROM dba_types t , dba_type_attrs a , dba_type_methods m WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name = m.type_name AND a.owner = m.owner AND a.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
SCOTT 2,118 1 2,118 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , a.attr_name attribute_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype , m.method_name FROM dba_types t , dba_type _attrs a , dba_type_methods m WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name , a.attr_no , m.method_no
SOE 2,115 1,249,264 0 UPDATE /*+ index(orders, order_pk) */ ORDERS SET ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(:B3 + 1, :B2 )) WHERE ORDER_ID = :B1
SCOTT 2,060 1 2,060 SELECT t.owner , t.type_name , t.typecode , a.attr_name FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
PERFSTAT 2,031 491 4 SELECT NVL(MAX(BEGIN_TIME), TO_DATE('01011900','DDMMYYYY')) FROM STATS$UNDOSTAT WHERE DBID = :B2 AND INSTANCE_NUMBER = :B1
PERFSTAT 1,998 491 4 INSERT INTO STATS$SYSTEM_EVENT ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO ) SELECT :B3 , :B2 , :B1 , EVENT , TOTAL_WAITS , T OTAL_TIMEOUTS , TIME_WAITED_MICRO FROM V$SYSTEM_EVENT
SCOTT 1,992 1 1,992 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , a.attr_name attribute_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') datatype FROM dba_types t , dba_type_attrs a WHERE t.ow ner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name , a.attr_no
SCOTT 1,956 1 1,956 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attribute ' || a.attr_no torder , a.attr_name name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype FROM d ba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') UNION SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Method ' || m.method_no torder , m.method_name name , null FROM dba_types t , dba_type_methods m WHERE t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY 1 ,2,3,4
SCOTT 1,903 1 1,903 SELECT t.owner , t.type_name , t.typecode , a.* FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type _name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
PERFSTAT 1,901 491 4 INSERT INTO STATS$SGASTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , POOL , NAME , BYTES ) SELECT :B3 , :B2 , :B1 , POOL , NAME , BYTES FROM V$SGASTAT
SOE 1,873 2,546,679 0 SELECT CUSTOMER_SEQ.NEXTVAL FROM DUAL
SCOTT 1,784 1 1,784 select * from ( select * from dba_types ) sub1 order by 10 asc
PERFSTAT 1,744 491 4 INSERT INTO STATS$ROWCACHE_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , PARAMETER , TOTAL_USAGE , USAGE , GETS , GETMISSES , SCANS , SCANMISSES , SCANCOMPLETES , MODIFICATIONS , FLUSHES , DLM_REQUESTS , DLM_CONFLICTS , DLM_RELEASES ) SELECT :B3 , :B2 , :B1 , PARAMETER , SUM("COUNT") , SUM(USAGE) , SUM(GETS) , SUM(GETMISSES) , SUM(SCANS) , SUM(SCANM ISSES) , SUM(SCANCOMPLETES) , SUM(MODIFICATIONS) , SUM(FLUSHES) , SUM(DLM_REQUESTS) , SUM(DLM_CONFLICTS) , SUM(DLM_RELEASES) FROM V$ROWCACHE GROUP BY :B3 , :B2 , :B1 , PARAMET ER
SCOTT 1,732 1 1,732 select * from dba_types
PERFSTAT 1,671 491 3 INSERT INTO STATS$BG_EVENT_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO ) SELECT :B3 , :B2 , :B1 , E.EVENT , SUM(E.TOT AL_WAITS) , SUM(E.TOTAL_TIMEOUTS) , SUM(E.TIME_WAITED_MICRO) FROM V$SESSION_EVENT E WHERE E.SID IN (SELECT S.SID FROM V$SESSION S WHERE S.TYPE = 'BACKGROUND') GROUP BY :B3 , : B2 , :B1 , E.EVENT
PERFSTAT 1,642 491 3 INSERT INTO STATS$ENQUEUE_STAT ( SNAP_ID , DBID , INSTANCE_NUMBER , EQ_TYPE , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME ) SELECT :B3 , :B2 , :B1 , EQ_ TYPE , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME FROM V$ENQUEUE_STAT WHERE TOTAL_REQ# != 0
PERFSTAT 1,619 491 3 INSERT INTO STATS$PGASTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , VALUE ) SELECT :B3 , :B2 , :B1 , NAME , VALUE FROM V$PGASTAT WHERE VALUE > 0
PERFSTAT 1,612 491 3 INSERT INTO STATS$WAITSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , CLASS , WAIT_COUNT , TIME ) SELECT :B3 , :B2 , :B1 , CLASS , "COUNT" , TIME FROM V$WAITSTAT
SCOTT 1,603 2 802 SELECT l.owner owner , l.table_name table_name , l.column_name column_name , l.segment_name segment_name , s1.tablesp ace_name tablespace_name , s1.bytes lob_segment_bytes , l.index_name index_name , l.in_row in_row FROM dba_lobs l , (select owner, segment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBSEGMENT') s1 WHERE l.owner = s1.owner AND l.segment_name = s1.segme nt_name ORDER BY l.owner , l.table_name , l.column_name
PERFSTAT 1,577 491 3 INSERT INTO STATS$DB_CACHE_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , ID , NAME , BLOCK_SIZE , BUFFERS_FOR_ESTIMATE , ADVICE_STATUS , SIZE_FOR_ESTIMATE , SIZE_FACTOR , ESTD_P HYSICAL_READ_FACTOR , ESTD_PHYSICAL_READS ) SELECT :B3 , :B2 , :B1 , ID , NAME , BLOCK_SIZE , BUFFERS_FOR_ESTIMATE , ADVICE_STATUS , SIZE_FOR_ESTIMATE , SIZE_FACTOR , ESTD_PHY SICAL_READ_FACTOR , ESTD_PHYSICAL_READS FROM V$DB_CACHE_ADVICE WHERE ADVICE_STATUS = 'ON'
SCOTT 1,554 1 1,554 SELECT l.owner owner , l.table_name table_name , l.column_name column_name , l.segment_name segment_name , s1.tablesp ace_name tablespace_name , s1.bytes lob_segment_bytes , l.index_name index_name , s2.bytes lob_index_bytes , l.in_row in_row FROM dba_lobs l , (select owner, segment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBSEGMENT') s1 , (select owner, s egment_name, tablespace_name, bytes from dba_segments where segment_type = 'LOBINDEX') s2 WHERE l.owner = s1.owner AND l.segment_name = s1.segment_name AND s1.owner = s2.owner AND l.index_name = s2.segment_name ORDER BY l.owner , l.table_name , l.column_name
SCOTT 1,548 1 1,548 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , a.attr_name attribute_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') datatype , a.* FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
PERFSTAT 1,543 491 3 INSERT INTO STATS$SQL_WORKAREA_HISTOGRAM ( SNAP_ID , DBID , INSTANCE_NUMBER , LOW_OPTIMAL_SIZE , HIGH_OPTIMAL_SIZE , OPTIMAL_EXECUTIONS , ONEPASS_EXECUTIONS , MULTIPASSES_EXEC UTIONS , TOTAL_EXECUTIONS ) SELECT :B3 , :B2 , :B1 , LOW_OPTIMAL_SIZE , HIGH_OPTIMAL_SIZE , OPTIMAL_EXECUTIONS , ONEPASS_EXECUTIONS , MULTIPASSES_EXECUTIONS , TOTAL_EXECUTIONS FROM V$SQL_WORKAREA_HISTOGRAM WHERE TOTAL_EXECUTIONS > 0
PERFSTAT 1,542 491 3 INSERT INTO STATS$LIBRARYCACHE ( SNAP_ID , DBID , INSTANCE_NUMBER , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOCK_REQUESTS , DLM_PIN_REQUEST S , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS ) SELECT :B3 , :B2 , :B1 , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOC K_REQUESTS , DLM_PIN_REQUESTS , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS FROM V$LIBRARYCACHE
PERFSTAT 1,533 491 3 INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP_TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_READS_TH , BUFFE R_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR_BKS_SD_TH, SEG_CU_BKS_SD_TH , SERIAL#, ALL_INIT) VALUES ( :B22 , :B21 , :B20 , SYSDATE, :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
PERFSTAT 1,509 491 3 INSERT INTO STATS$SHARED_POOL_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , EST D_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS ) SELECT :B3 , :B2 , :B1 , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ES TD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS FROM V$SHARED_POOL_ADVICE
PERFSTAT 1,503 491 3 INSERT INTO STATS$PGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTES_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT ) SELECT :B3 , :B2 , :B1 , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTE S_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT FROM V$PGA_TARGET_ADVICE WHERE ADVICE_STATUS = 'ON'
PERFSTAT 1,503 491 3 INSERT INTO STATS$ROLLSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHR INK , AVEACTIVE ) SELECT :B3 , :B2 , :B1 , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHRINK , AVEACTIVE FROM V$ROLLSTAT
PERFSTAT 1,487 491 3 INSERT INTO STATS$RESOURCE_LIMIT ( SNAP_ID , DBID , INSTANCE_NUMBER , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE ) SELECT :B3 , : B2 , :B1 , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE FROM V$RESOURCE_LIMIT WHERE LIMIT_VALUE != ' UNLIMITED' AND MAX_UTILIZATION > 0
SCOTT 1,464 8 183 /* OracleOEM */ SELECT owner, object_name, NLS_INITCAP(status) FROM sys.dba_objects WHERE object_type = 'DIMENSION' ORDER BY 1, 2
PERFSTAT 1,457 491 3 INSERT INTO STATS$SGA ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , VALUE ) SELECT :B3 , :B2 , :B1 , NAME , VALUE FROM V$SGA
SCOTT 1,418 1 1,418 SELECT t.owner , t.type_name , t.typecode , a.ATTR_TYPE_NAME FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_n ame = a.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY t.owner , t.type_name
SCOTT 1,403 1 1,403 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attribute' am , a.attr_name name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attribute_datatype FROM dba_types t , (select owner, type_name, attr_name, attr_type_name, length from dba_type_attrs order by attr_no) a WHERE t.owner = a.owner AND t.type_name = a .type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') UNION SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Met hod ' || m.method_no torder , m.method_name name , null FROM dba_types t , dba_type_methods m WHERE t.owner = m.owner AND t.type_name = m.type_name AND t.owner NOT IN ('SYS', 'SYSTEM', 'XDB') ORDER BY 1,2,3,4
SCOTT 1,359 1 1,359 SELECT l.owner , l.table_name , l.column_name , l.segment_name , s.segment_type , s.TABLESPACE_NAME , s.BYTES , l.index_name , l.in_row FROM dba_lobs l , dba_segments s WHERE l.owner = s.owner and l.segment_name = s.segment_name ORDER BY l.owner , l.table_name
SCOTT 1,299 1 1,299 SELECT t.owner type_owner , t.type_name type_name , t.typecode type_code , 'Attributes' attribute_or_method , a.attr_na me attribute_or_method_name , DECODE( a.length , null , a.attr_type_name , a.attr_type_name || '(' || a.length || ')') attrib ute_datatype , a.attr_no , null FROM dba_types t , (select 1 torder , owner , type_name , attr_name , attr_type_name , length , attr_no from dba_type_attrs order by owner , type_name , attr_no) a , (select 2 torder , owner , type_name , method_name , method_no from dba_type_methods order by owner , type_name , method_no) m WH ERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner = m.owner AND t.type_name = m.ty
PERFSTAT 1,263 491 3 INSERT INTO STATS$BUFFER_POOL_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUMBER , ID , NAME , BLOCK_SIZE , SET_MSIZE , CNUM_REPL , CNUM_WRITE , CNUM_SET , BUF_GOT , SUM_WRITE , SU M_SCAN , FREE_BUFFER_WAIT , WRITE_COMPLETE_WAIT , BUFFER_BUSY_WAIT , FREE_BUFFER_INSPECTED , DIRTY_BUFFERS_INSPECTED , DB_BLOCK_CHANGE , DB_BLOCK_GETS , CONSISTENT_GETS , PHYS ICAL_READS , PHYSICAL_WRITES ) SELECT :B3 , :B2 , :B1 , ID , NAME , BLOCK_SIZE , SET_MSIZE , CNUM_REPL , CNUM_WRITE , CNUM_SET , BUF_GOT , SUM_WRITE , SUM_SCAN , FREE_BUFFER_W AIT , WRITE_COMPLETE_WAIT , BUFFER_BUSY_WAIT , FREE_BUFFER_INSPECTED , DIRTY_BUFFERS_INSPECTED , DB_BLOCK_CHANGE , DB_BLOCK_GETS , CONSISTENT_GETS , PHYSICAL_READS , PHYSICAL_ WRITES FROM V$BUFFER_POOL_STATISTICS
OEM 1,232 939 1 /* OracleOEM */ BEGIN smp_vdm_notification_pkg.purge_ui_notification; END;
SCOTT 1,230 3 410 select distinct(directory_name) DIRECTORY_NAME from all_directories d, all_tab_privs p where d.directory_name = p.table_name(+) and (( privilege = 'READ ' and grantee = :SCHEMA ) or ( user = 'SYS'))
PERFSTAT 1,228 491 3 INSERT INTO STATS$INSTANCE_RECOVERY ( SNAP_ID , DBID , INSTANCE_NUMBER , RECOVERY_ESTIMATED_IOS , ACTUAL_REDO_BLKS , TARGET_REDO_BLKS , LOG_FILE_SIZE_REDO_BLKS , LOG_CHKPT_TIM EOUT_REDO_BLKS , LOG_CHKPT_INTERVAL_REDO_BLKS , FAST_START_IO_TARGET_REDO_BLKS , TARGET_MTTR , ESTIMATED_MTTR , CKPT_BLOCK_WRITES ) SELECT :B3 , :B2 , :B1 , RECOVERY_ESTIMATED _IOS , ACTUAL_REDO_BLKS , TARGET_REDO_BLKS , LOG_FILE_SIZE_REDO_BLKS , LOG_CHKPT_TIMEOUT_REDO_BLKS , LOG_CHKPT_INTERVAL_REDO_BLKS , FAST_START_IO_TARGET_REDO_BLKS , TARGET_MTT R , ESTIMATED_MTTR , CKPT_BLOCK_WRITES FROM V$INSTANCE_RECOVERY
PERFSTAT 1,223 491 2 INSERT INTO STATS$SQL_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUMBER , TOTAL_SQL , TOTAL_SQL_MEM , SINGLE_USE_SQL , SINGLE_USE_SQL_MEM ) SELECT :B3 , :B2 , :B1 , COUNT(1) , SUM (SHARABLE_MEM) , SUM(DECODE(EXECUTIONS, 1, 1, 0)) , SUM(DECODE(EXECUTIONS, 1, SHARABLE_MEM, 0)) FROM STATS$V$SQLXS WHERE IS_OBSOLETE = 'N'
SCOTT 1,064 1 1,064 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , DECODE( c.length , null , c.elem_t ype_name , c.elem_type_name || '(' || c.length || ')') elem_datatype , (CASE WHEN (c.elem_type_name = 'NUMBER' AND (c.precision is not NULL and c.sca le is not NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' END) elem_datatype2 , TO_CHAR(c.precision, '99 9999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_name character_set_name , c.elem_storage elem_storage , c.nulls_stored nulls_stored FROM dba_coll_types c WHERE c.ow
SCOTT 1,047 1 1,047 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , DECODE( c.length , null , c.elem_t ype_name , c.elem_type_name || '(' || c.length || ')') elem_datatype , (CASE WHEN (c.elem_type_name = 'VARCHAR2') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision is not NULL and c.scale is not NULL)) THEN c.elem_type_name || '(' || c.precision | | ',' || c.scale || ')' END) elem_datatype2 , TO_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_name character_set_name , c.elem_storage
SCOTT 1,005 1 1,005 SELECT c.owner owner , c.type_name type_name , c.coll_type coll_type , TO _CHAR(c.upper_bound, '9,999,999,999') upper_bound , c.elem_type_owner elem_type_owner , (CASE WHEN (c.elem_type_name = 'VARCHAR2' OR c.elem_t ype_name = 'CHAR') THEN c.elem_type_name || '(' || c.length || ')' WHEN (c.elem_type_name = 'NUMBER' AND (c.precision is not NULL and c.scale is not NULL)) THEN c.elem_type_name || '(' || c.precision || ',' || c.scale || ')' END) elem_datatype , TO_CHAR(c.precision, '999999') precision , TO_CHAR(c.scale, '999999') scale , c.character_set_name character_set_name , c.elem_storage elem_storage , c.nulls_stored nulls_stored FROM dba_coll_types c ORDER BY c.owner

[Top]



Top 10 Tables


Command Type Object Name Number of Executions Buffer Gets Rows Processed
SELECT FROM
SOE.CUSTOMERS 22,442,330 139,916,120 21,399,177
SELECT FROM
SOE.INVENTORIES 9,011,264 663,168,035 93,573,351
SELECT FROM
SOE.PRODUCT_INFORMATION 9,011,264 663,168,035 93,573,351
SELECT FROM
SYS.DUAL 8,465,733 25,412,106 8,465,918
INSERT INTO
SOE.LOGON 5,806,537 14,717,215 5,702,817
INSERT INTO
SOE.ORDERS 4,216,469 60,630,393 3,221,887
INSERT INTO
SOE.CUSTOMERS 3,594,352 49,540,531 2,605,440
SELECT FROM
SOE.ORDERS 2,342,832 59,081,839 1,497,890
UPDATE OF
SOE.ORDERS 1,782,974 5,844,483 740,064
INSERT INTO
SOE.ORDER_ITEMS 1,713,285 13,682,519 794,921
    -------------------- -------------------- --------------------
Total:   68,387,040 1,695,161,276 231,574,816

[Top]



Top 10 Procedures


Object Type Object Name Number of Executions
PACKAGE
 SYS.PLITBLM 605,459,325
PACKAGE BODY
 SYS.DBMS_APPLICATION_INFO 98,597,968
PACKAGE BODY
 SYS.DBMS_RANDOM 63,079,935
PACKAGE
 SYS.DBMS_STANDARD 29,781,054
PACKAGE BODY
 SOE.ORDERENTRY 22,916,147
PACKAGE BODY
 SYS.DBMS_LOCK 16,369,488
PACKAGE BODY
 SCOTT.RANDOM 6,123,000
PACKAGE BODY
 SYS.STANDARD 168,687
PACKAGE BODY
 SYS.DBMS_SPACE_ADMIN 33,852
PACKAGE
 SYS.DBMS_STATS_INTERNAL 23,309
    --------------------
Total:   842,552,765

[Top]



Statspack List


Snap ID Database Startup Time Statspack Snap Time
1
03/17/2008 11:30:16
03/17/2008 12:00:04
2
  
03/17/2008 12:30:03
3
  
03/17/2008 13:00:04
4
  
03/17/2008 13:30:00
5
03/17/2008 13:46:39
03/17/2008 14:00:05
6
  
03/17/2008 14:30:03
7
  
03/17/2008 15:00:02
8
  
03/17/2008 15:30:02
9
  
03/17/2008 16:00:01
10
  
03/17/2008 16:30:01
11
  
03/17/2008 17:00:06
12
  
03/17/2008 17:30:01
13
  
03/17/2008 18:00:06
14
  
03/17/2008 18:30:05
15
  
03/17/2008 19:00:05
16
  
03/17/2008 19:30:04
17
  
03/17/2008 20:00:05
18
  
03/17/2008 20:30:04
19
  
03/17/2008 21:00:04
20
  
03/17/2008 21:30:03
21
  
03/17/2008 22:00:04
22
  
03/17/2008 22:30:04
23
  
03/17/2008 23:00:02
24
  
03/17/2008 23:30:02
25
  
03/18/2008 00:00:02
26
  
03/18/2008 00:30:02
27
  
03/18/2008 01:00:01
28
  
03/18/2008 01:30:01
29
  
03/18/2008 02:00:00
30
  
03/18/2008 02:30:04
31
  
03/18/2008 03:00:03
32
  
03/18/2008 03:30:02
33
  
03/18/2008 04:00:01
34
  
03/18/2008 04:30:00
35
  
03/18/2008 05:00:05
36
  
03/18/2008 05:30:03
37
  
03/18/2008 06:00:02
38
  
03/18/2008 06:30:02
39
  
03/18/2008 07:00:00
40
  
03/18/2008 07:30:00
41
  
03/18/2008 08:00:04
42
  
03/18/2008 08:30:03
43
  
03/18/2008 09:00:02
44
  
03/18/2008 09:30:01
45
  
03/18/2008 10:00:00
46
  
03/18/2008 10:30:05
47
  
03/18/2008 11:00:03
48
  
03/18/2008 11:30:03
49
  
03/18/2008 12:00:02
50
  
03/18/2008 12:30:01
51
  
03/18/2008 13:00:00
52
  
03/18/2008 13:30:05
53
  
03/18/2008 14:00:03
54
  
03/18/2008 14:30:03
55
  
03/18/2008 15:00:02
56
  
03/18/2008 15:30:01
57
  
03/18/2008 16:00:00
58
  
03/18/2008 16:30:04
59
  
03/18/2008 17:00:03
60
  
03/18/2008 17:30:02
61
  
03/18/2008 18:00:01
62
  
03/18/2008 18:30:00
63
  
03/18/2008 19:00:04
64
  
03/18/2008 19:30:03
65
  
03/18/2008 20:00:02
66
  
03/18/2008 20:30:01
67
  
03/18/2008 21:00:00
68
  
03/18/2008 21:30:04
69
  
03/18/2008 22:00:03
70
  
03/18/2008 22:30:02
71
  
03/18/2008 23:00:01
72
  
03/18/2008 23:30:01
73
  
03/19/2008 00:00:05
74
  
03/19/2008 00:30:04
75
  
03/19/2008 01:00:03
76
  
03/19/2008 01:30:03
77
  
03/19/2008 02:00:02
78
  
03/19/2008 02:30:01
79
  
03/19/2008 03:00:00
80
  
03/19/2008 03:30:05
81
  
03/19/2008 04:00:04
82
  
03/19/2008 04:30:03
83
  
03/19/2008 05:00:02
84
  
03/19/2008 05:30:01
85
  
03/19/2008 06:00:00
86
  
03/19/2008 06:30:04
87
  
03/19/2008 07:00:04
88
  
03/19/2008 07:30:03
89
  
03/19/2008 08:00:02
90
  
03/19/2008 08:30:02
91
  
03/19/2008 09:00:01
92
  
03/19/2008 09:30:00
93
  
03/19/2008 10:00:05
94
  
03/19/2008 10:30:04
95
  
03/19/2008 11:00:03
96
  
03/19/2008 11:30:02
97
  
03/19/2008 12:00:01
98
  
03/19/2008 12:30:00
99
  
03/19/2008 13:00:05
100
  
03/19/2008 13:30:03
101
  
03/19/2008 14:00:03
102
  
03/19/2008 14:30:02
103
  
03/19/2008 15:00:01
104
  
03/19/2008 15:30:00
105
  
03/19/2008 16:00:05
106
  
03/19/2008 16:30:03
107
  
03/19/2008 17:00:03
108
  
03/19/2008 17:30:02
109
  
03/19/2008 18:00:01
110
  
03/19/2008 18:30:00
111
  
03/19/2008 19:00:04
112
  
03/19/2008 19:30:04
113
  
03/19/2008 20:00:02
114
  
03/19/2008 20:30:02
115
  
03/19/2008 21:00:01
116
  
03/19/2008 21:30:00
117
  
03/19/2008 22:00:04
118
  
03/19/2008 22:30:03
119
  
03/19/2008 23:00:02
120
  
03/19/2008 23:30:02
121
  
03/20/2008 00:00:01
122
  
03/20/2008 00:30:00
123
  
03/20/2008 01:00:05
124
  
03/20/2008 01:30:05
125
  
03/20/2008 02:00:06
126
  
03/20/2008 02:30:06
127
  
03/20/2008 03:00:05
128