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



Report Index









DATABASE AND INSTANCE INFORMATION
Report Header Version Options Initialization Parameters
Instance Overview Database Overview Jobs Processes Summary
STORAGE
Control Files Control File Records Online Redo Logs Redo Log Switches
Redo Log Contention Database Growth Tablespaces Tablespace Extents
Tablespace to Owner Owner to Tablespace Data Files Rollback Segments
Rollback Segment Contention


ARCHIVING
Archiving Mode Archiving Parameters Archiving History
RMAN
Backup Sets Backup Pieces Backup Control Files
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
Full Table Scans Sorts File I/O Statistics SQL Statements With Most Disk Reads
SQL Statements With Most Buffer Gets Top 10 Tables Top 10 Procedures Outlines
SESSIONS
Current Sessions Summary Session Statistics Sessions by Memory Current SQL
All Locks Blocking Locks

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


OBJECTS
Object summary Segment Summary Directories Libraries
Top 200 Segments (by size) Top 200 Segments (by number of extents) 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
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_8i_ORA817_20041202.html
Date / Time12/02/2004 14:57:48
Database NameORA817
Global Database NameORA817.IDEVELOPMENT.INFO
Database Startup Time12/02/2004 12:27:49
Database Block Size8192
Report Run UserSYSTEM

[Top]



Version



Banner
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

[Top]



Options



Option Name Installed?
Partitioning
TRUE
Objects
TRUE
Parallel Server
FALSE
Advanced replication
TRUE
Bit-mapped indexes
TRUE
Connection multiplexing
TRUE
Connection pooling
TRUE
Database queuing
TRUE
Incremental backup and recovery
TRUE
Instead-of triggers
TRUE
Parallel backup and recovery
TRUE
Parallel execution
TRUE
Parallel load
TRUE
Point-in-time tablespace recovery
TRUE
Fine-grained access control
TRUE
N-Tier authentication/authorization
TRUE
Function-based indexes
TRUE
Plan Stability
TRUE
Online Index Build
TRUE
Coalesce Index
TRUE
Managed Standby
TRUE
Materialized view rewrite
TRUE
Materialized view warehouse refresh
TRUE
Database resource manager
TRUE
Spatial
TRUE
Visual Information Retrieval
TRUE
Export transportable tablespaces
TRUE
Transparent Application Failover
TRUE
Fast-Start Fault Recovery
TRUE
Sample Scan
TRUE
Duplexed backups
TRUE
Java
FALSE
OLAP Window Functions
TRUE

[Top]



Initialization Parameters



Parameter Name Value Is Default? Is Dynamic?
O7_DICTIONARY_ACCESSIBILITY TRUE
FALSE
FALSE
_complex_view_merging TRUE
FALSE
FALSE
_push_join_predicate TRUE
FALSE
FALSE
_trace_files_public TRUE
FALSE
FALSE
active_instance_count  
TRUE
FALSE
always_anti_join NESTED_LOOPS
TRUE
FALSE
always_semi_join STANDARD
TRUE
FALSE
aq_tm_processes 1
FALSE
IMMEDIATE
audit_file_dest /u01/app/oracle/admin/ORA817/adump
FALSE
FALSE
audit_trail NONE
FALSE
FALSE
background_core_dump partial
TRUE
FALSE
background_dump_dest /u01/app/oracle/admin/ORA817/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
commit_point_strength 1
TRUE
FALSE
compatible 8.1.7
FALSE
FALSE
control_file_record_keep_time 7
FALSE
IMMEDIATE
control_files /u03/app/oradata/ORA817/control01.ctl, /u04/app/or adata/ORA817/control02.ctl, /u05/app/oradata/ORA817/control03.ctl
FALSE
FALSE
core_dump_dest /u01/app/oracle/admin/ORA817/cdump
FALSE
IMMEDIATE
cpu_count 1
TRUE
FALSE
create_bitmap_area_size 8388608
TRUE
FALSE
cursor_sharing EXACT
FALSE
IMMEDIATE
cursor_space_for_time FALSE
TRUE
FALSE
db_block_buffers 10240
FALSE
FALSE
db_block_checking FALSE
FALSE
DEFERRED
db_block_checksum FALSE
FALSE
IMMEDIATE
db_block_lru_latches 1
TRUE
FALSE
db_block_max_dirty_target 10240
TRUE
IMMEDIATE
db_block_size 8192
FALSE
FALSE
db_domain IDEVELOPMENT.INFO
FALSE
FALSE
db_file_direct_io_count 64
TRUE
DEFERRED
db_file_multiblock_read_count 32
FALSE
IMMEDIATE
db_file_name_convert  
TRUE
FALSE
db_files 600
FALSE
FALSE
db_name ORA817
FALSE
FALSE
db_writer_processes 1
FALSE
FALSE
dblink_encrypt_login FALSE
TRUE
FALSE
dbwr_io_slaves 0
TRUE
FALSE
disk_asynch_io TRUE
TRUE
FALSE
distributed_transactions 61
TRUE
FALSE
dml_locks 988
TRUE
FALSE
enqueue_resources 1608
TRUE
FALSE
event  
TRUE
FALSE
fast_start_io_target 10240
TRUE
IMMEDIATE
fast_start_parallel_rollback LOW
TRUE
IMMEDIATE
fixed_date  
TRUE
IMMEDIATE
gc_defer_time 10
TRUE
IMMEDIATE
gc_files_to_locks  
TRUE
FALSE
gc_releasable_locks 0
TRUE
FALSE
gc_rollback_locks 0-1024=32!8REACH
TRUE
FALSE
global_names FALSE
FALSE
IMMEDIATE
hash_area_size 1024000
TRUE
FALSE
hash_join_enabled TRUE
TRUE
FALSE
hash_multiblock_io_count 0
TRUE
IMMEDIATE
hi_shared_memory_address 0
TRUE
FALSE
hpux_sched_noage  
TRUE
IMMEDIATE
hs_autoregister TRUE
TRUE
IMMEDIATE
ifile  
TRUE
FALSE
instance_groups  
TRUE
FALSE
instance_name ORA817
FALSE
FALSE
instance_number 0
TRUE
FALSE
java_max_sessionspace_size 0
TRUE
FALSE
java_pool_size 30000000
FALSE
FALSE
java_soft_sessionspace_limit 0
TRUE
FALSE
job_queue_interval 60
FALSE
FALSE
job_queue_processes 2
FALSE
IMMEDIATE
large_pool_size 20000000
FALSE
FALSE
license_max_sessions 0
TRUE
IMMEDIATE
license_max_users 0
TRUE
IMMEDIATE
license_sessions_warning 0
TRUE
IMMEDIATE
lm_locks 12000
TRUE
FALSE
lm_ress 6000
TRUE
FALSE
local_listener  
TRUE
FALSE
lock_name_space  
TRUE
FALSE
lock_sga FALSE
TRUE
FALSE
log_archive_dest  
TRUE
IMMEDIATE
log_archive_dest_1 location=/u06/app/oradata/ORA817/archive MANDATORY
FALSE
IMMEDIATE
log_archive_dest_2 service=ORA817_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_state_1 enable
FALSE
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_duplex_dest  
TRUE
IMMEDIATE
log_archive_format arch_t%t_s%s.dbf
FALSE
FALSE
log_archive_max_processes 1
TRUE
IMMEDIATE
log_archive_min_succeed_dest 1
TRUE
IMMEDIATE
log_archive_start TRUE
FALSE
FALSE
log_archive_trace 0
TRUE
IMMEDIATE
log_buffer 32768
FALSE
FALSE
log_checkpoint_interval 0
TRUE
IMMEDIATE
log_checkpoint_timeout 21600
FALSE
IMMEDIATE
log_checkpoints_to_alert TRUE
FALSE
FALSE
log_file_name_convert  
TRUE
FALSE
max_commit_propagation_delay 700
TRUE
FALSE
max_dump_file_size unlimited
FALSE
IMMEDIATE
max_enabled_roles 145
FALSE
FALSE
max_rollback_segments 49
TRUE
FALSE
mts_circuits 0
TRUE
FALSE
mts_dispatchers  
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 0
TRUE
IMMEDIATE
mts_service ORA817
TRUE
FALSE
mts_sessions 0
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_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
open_cursors 1000
FALSE
FALSE
open_links 10
FALSE
FALSE
open_links_per_instance 4
TRUE
FALSE
ops_interconnects  
TRUE
FALSE
optimizer_features_enable 8.1.7
TRUE
FALSE
optimizer_index_caching 0
TRUE
FALSE
optimizer_index_cost_adj 100
TRUE
FALSE
optimizer_max_permutations 80000
TRUE
FALSE
optimizer_mode CHOOSE
FALSE
FALSE
optimizer_percent_parallel 0
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
FALSE
FALSE
parallel_broadcast_enabled FALSE
TRUE
FALSE
parallel_execution_message_size 2148
TRUE
FALSE
parallel_instance_group  
TRUE
IMMEDIATE
parallel_max_servers 5
FALSE
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
plsql_v2_compatibility FALSE
TRUE
IMMEDIATE
pre_page_sga TRUE
FALSE
FALSE
processes 200
FALSE
FALSE
query_rewrite_enabled TRUE
FALSE
IMMEDIATE
query_rewrite_integrity enforced
FALSE
IMMEDIATE
rdbms_server_dn  
TRUE
FALSE
read_only_open_delayed FALSE
TRUE
FALSE
recovery_parallelism 0
TRUE
FALSE
remote_dependencies_mode TIMESTAMP
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 rbs1, rbs2, rbs3, rbs4, rbs5, rbs6, rbs7, rbs8
FALSE
FALSE
row_locking always
TRUE
FALSE
serial_reuse DISABLE
TRUE
FALSE
serializable FALSE
TRUE
FALSE
service_names ORA817_ALEX.IDEVELOPMENT.INFO
FALSE
FALSE
session_cached_cursors 0
TRUE
FALSE
session_max_open_files 10
TRUE
FALSE
sessions 225
TRUE
FALSE
shadow_core_dump partial
TRUE
FALSE
shared_memory_address 0
TRUE
FALSE
shared_pool_reserved_size 3750000
TRUE
FALSE
shared_pool_size 75000000
FALSE
FALSE
sort_area_retained_size 512000
FALSE
DEFERRED
sort_area_size 512000
FALSE
DEFERRED
sort_multiblock_read_count 2
TRUE
DEFERRED
sql92_security FALSE
TRUE
FALSE
sql_trace FALSE
TRUE
FALSE
sql_version NATIVE
TRUE
FALSE
standby_archive_dest ?/dbs/arch
TRUE
IMMEDIATE
star_transformation_enabled FALSE
TRUE
FALSE
tape_asynch_io TRUE
TRUE
FALSE
text_enable FALSE
TRUE
IMMEDIATE
thread 0
TRUE
FALSE
timed_os_statistics 0
TRUE
IMMEDIATE
timed_statistics TRUE
FALSE
IMMEDIATE
tracefile_identifier  
TRUE
FALSE
transaction_auditing TRUE
TRUE
DEFERRED
transactions 247
TRUE
FALSE
transactions_per_rollback_segment 5
TRUE
FALSE
use_indirect_data_buffers FALSE
TRUE
FALSE
user_dump_dest /u01/app/oracle/admin/ORA817/udump
FALSE
IMMEDIATE
utl_file_dir /u01/app/oracle/common/out, /u01/app/oracle/common /extproc
FALSE
FALSE

[Top]



Instance Overview



Instance
Num
Instance
Name
Host
Name
Oracle
Version
Parallel Instance
Status
Start
Time
Current
Time
Uptime
(in days)
Logins Archiver
1
ORA817
alex
8.1.7.4.0
NO
OPEN
12/02/2004 12:27:49
12/02/2004 14:57:48
.1
ALLOWED
STARTED

[Top]



Database Overview



DB Name DB ID Log Mode Version Time Open Mode
ORA817
1701256249
ARCHIVELOG
08/28/2004 14:15:21
READ WRITE

[Top]



Jobs



Job ID User What Next Run Date Interval Last Run Date Failures Broken?
1
SCOTT test_proc; 12/03/2004 13:43:54 sysdate + 1 12/02/2004 13:43:54
0
N
2
SCOTT test_proc; 01/01/4000 00:00:00 sysdate + 1 12/02/2004 14:27:07
0
Y

[Top]



Processes Summary



Current No. of Processes Max No. of Processes % Usage
19
200
9.5%

[Top]



Control Files



Controlfile Name Status
/u03/app/oradata/ORA817/control01.ctl
VALID
/u04/app/oradata/ORA817/control02.ctl
VALID
/u05/app/oradata/ORA817/control03.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 1,007 588,088 10 5,840 1 1 10 10
BACKUP CORRUPTION
44 742 32,648 0 0   0 0 0
BACKUP DATAFILE
116 1,056 122,496 27 3,132 3 1 27 27
BACKUP PIECE
736 1,009 742,624 9 6,624 1 1 9 9
BACKUP REDOLOG
76 107 8,132 5 380 5 1 5 5
BACKUP SET
40 612 24,480 9 360 1 1 9 9
CKPT PROGRESS
4,084 10 40,840 0 0   0 0 0
COPY CORRUPTION
40 612 24,480 0 0   0 0 0
DATABASE
192 1 192 1 192 100 0 0 0
DATAFILE COPY
660 1,002 661,320 6 3,960 1 1 6 6
DATAFILE
180 600 108,000 9 1,620 2 0 0 32
DELETED OBJECT
20 1,225 24,500 16 320 1 1 16 16
FILENAME
524 761 398,764 19 9,956 2 0 0 0
LOG HISTORY
36 1,134 40,824 43 1,548 4 1 43 43
OFFLINE RANGE
56 729 40,824 0 0   0 0 0
PROXY COPY
852 1,006 857,112 0 0   0 0 0
REDO LOG
72 32 2,304 3 216 9 0 0 3
REDO THREAD
104 10 1,040 1 104 10 0 0 0
RESERVED1
56 600 33,600 1 56   0 0 1
RESERVED2
1 1 1 0 0   0 0 0
RESERVED4
1 8,168 8,168 0 0   0 0 0
TABLESPACE
68 600 40,800 9 612 2 0 0 9
  ----------- ----------------- --------------- ------------ ------------ ------      
Average:           6      
Total: 8,542 21,024 3,801,237 168 34,920        

[Top]



Online Redo Logs



Member Group Number Bytes
/u03/app/oradata/ORA817/redo_g01a.log 1 52,428,800
/u04/app/oradata/ORA817/redo_g01b.log 1 52,428,800
/u05/app/oradata/ORA817/redo_g01c.log 1 52,428,800
/u03/app/oradata/ORA817/redo_g02a.log 2 52,428,800
/u04/app/oradata/ORA817/redo_g02b.log 2 52,428,800
/u05/app/oradata/ORA817/redo_g02c.log 2 52,428,800
/u03/app/oradata/ORA817/redo_g03a.log 3 52,428,800
/u04/app/oradata/ORA817/redo_g03b.log 3 52,428,800
/u05/app/oradata/ORA817/redo_g03c.log 3 52,428,800

[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
08/28
                            14 5                 19
09/02
                  1                             1
09/10
                                          1     1
09/17
    1                                           1
09/23
                  1                             1
09/24
                          1                     1
09/30
                                      1         1
10/07
1                                               1
10/13
            1                                   1
10/19
                      1                         1
10/25
                                  1             1
10/31
                                            1   1
11/10
                  1                             1
11/16
                                1               1
11/22
                                  1             1
11/28
                          1                     1
12/02
                        3 2 4                   9
                                                  ------------
Average:                                                 3
Total:                                                 43

[Top]



Redo Log Contention



All Latches Like redo%

Latch Name Gets Misses Sleeps Immediate Gets Immediate Misses
Redo Allocation
290,596 3 3 0 0
Redo Copy
18 0 0 266,803 48
Redo Writing
37,758 2 4 0 0
  ------------------------ ---------------- ---------------- ------------------------ ----------------
Total: 328,372 5 7 266,803 48


System Statistics Like redo%

Statistics Name Value
Redo Synch Writes
72
Redo Synch Time
25
Redo Entries
261,134
Redo Size
292,347,180
Redo Buffer Allocation Retries
5,674
Redo Wastage
2,262,988
Redo Writer Latching Time
70
Redo Writes
8,903
Redo Blocks Written
593,972
Redo Write Time
42,643
Redo Log Space Requests
5
Redo Log Space Wait Time
50
Redo Log Switch Interrupts
0
Redo Ordering Marks
0

[Top]



Database Growth



Month Growth (Bytes)
2004-08
3,822,059,520
2004-11
5,242,880
2004-12
1,048,576
  ----------------
Total: 3,828,350,976

[Top]



Tablespaces



Status Tablespace Name TS Type Ext. Mgt. Tablespace Size Free (in bytes) Used (in bytes) Pct. Used
ONLINE
DRSYS PERMANENT LOCAL 104,857,600 100,466,688 4,390,912
4 %
ONLINE
PERFSTAT PERMANENT LOCAL 524,288,000 524,222,464 65,536
0 %
ONLINE
RBS1 PERMANENT LOCAL 1,048,576,000 954,204,160 94,371,840
9 %
ONLINE
RBS2 PERMANENT LOCAL 1,048,576,000 943,718,400 104,857,600
10 %
ONLINE
SYSTEM PERMANENT DICTIONARY 838,860,800 585,416,704 253,444,096
30 %
ONLINE
USERS PERMANENT LOCAL 257,949,696 5,701,632 252,248,064
97 %
OFFLINE
USERS2 PERMANENT DICTIONARY 1,048,576 1,040,384 8,192
0 %
ONLINE
USERS_DICT PERMANENT DICTIONARY 5,242,880 1,597,440 3,645,440
69 %
ONLINE
TEMP TEMPORARY LOCAL 524,288,000 510,656,512 13,631,488
2 %
        -------------------- -------------------- --------------------  
Total:       4,353,687,552 3,627,024,384 726,663,168  

[Top]



Tablespace Extents



Tablespace
Name
Largest
Extent
Smallest
Extent
Total
Free
Number of
Free Extents
DRSYS 100,466,688 100,466,688 100,466,688 1
PERFSTAT 524,222,464 524,222,464 524,222,464 1
RBS1 954,204,160 954,204,160 954,204,160 1
RBS2 943,718,400 943,718,400 943,718,400 1
SYSTEM 585,416,704 585,416,704 585,416,704 1
USERS2 1,040,384 1,040,384 1,040,384 1
USERS 5,177,344 524,288 5,701,632 2
USERS_DICT 1,597,440 1,597,440 1,597,440 1
  -------------------- -------------------- -------------------- --------------------
Total: 3,115,843,584 3,111,190,528 3,116,367,872 9

[Top]



Tablespace to Owner



Tablespace Name Owner Segment Type Size (in Bytes) Segment Count
DRSYS
CTXSYS
INDEX
2,686,976 41
 
CTXSYS
LOBINDEX
65,536 1
 
CTXSYS
LOBSEGMENT
65,536 1
 
CTXSYS
TABLE
1,507,328 23
RBS1
SYS
ROLLBACK
83,886,080 4
RBS2
SYS
ROLLBACK
94,371,840 4
SYSTEM
AURORA$JIS$UTILITY$
INDEX
851,968 13
 
AURORA$JIS$UTILITY$
LOBINDEX
65,536 1
 
AURORA$JIS$UTILITY$
LOBSEGMENT
65,536 1
 
AURORA$JIS$UTILITY$
TABLE
917,504 14
 
MDSYS
INDEX
983,040 15
 
MDSYS
LOBINDEX
262,144 4
 
MDSYS
LOBSEGMENT
262,144 4
 
MDSYS
TABLE
1,507,328 15
 
ORDSYS
INDEX
851,968 13
 
ORDSYS
LOBINDEX
65,536 1
 
ORDSYS
LOBSEGMENT
65,536 1
 
ORDSYS
TABLE
589,824 9
 
OSE$HTTP$ADMIN
TABLE
196,608 3
 
OUTLN
INDEX
49,152 3
 
OUTLN
TABLE
32,768 2
 
SYS
CACHE
8,192 1
 
SYS
CLUSTER
3,661,824 9
 
SYS
DEFERRED ROLLBACK
65,536 1
 
SYS
INDEX
34,119,680 220
 
SYS
LOBINDEX
131,072 5
 
SYS
LOBSEGMENT
229,376 5
 
SYS
ROLLBACK
2,539,520 2
 
SYS
TABLE
195,297,280 169
 
SYSTEM
INDEX
5,701,632 87
 
SYSTEM
LOBINDEX
851,968 13
 
SYSTEM
LOBSEGMENT
851,968 13
 
SYSTEM
TABLE
3,211,264 49
USERS
SCOTT
INDEX
131,072 2
 
SCOTT
LOBINDEX
65,536 1
 
SCOTT
LOBSEGMENT
65,536 1
 
SCOTT
TABLE
251,854,848 4
USERS_DICT
SCOTT
TABLE
3,637,248 1
******************************************************************     -------------------- ----------------
Total:     691,773,440 756

[Top]



Owner to Tablespace



Owner Tablespace Name Segment Type Size (in Bytes) Segment Count
AURORA$JIS$UTILITY$
SYSTEM
INDEX
851,968 13
 
SYSTEM
LOBINDEX
65,536 1
 
SYSTEM
LOBSEGMENT
65,536 1
 
SYSTEM
TABLE
917,504 14
CTXSYS
DRSYS
INDEX
2,686,976 41
 
DRSYS
LOBINDEX
65,536 1
 
DRSYS
LOBSEGMENT
65,536 1
 
DRSYS
TABLE
1,507,328 23
MDSYS
SYSTEM
INDEX
983,040 15
 
SYSTEM
LOBINDEX
262,144 4
 
SYSTEM
LOBSEGMENT
262,144 4
 
SYSTEM
TABLE
1,507,328 15
ORDSYS
SYSTEM
INDEX
851,968 13
 
SYSTEM
LOBINDEX
65,536 1
 
SYSTEM
LOBSEGMENT
65,536 1
 
SYSTEM
TABLE
589,824 9
OSE$HTTP$ADMIN
SYSTEM
TABLE
196,608 3
OUTLN
SYSTEM
INDEX
49,152 3
 
SYSTEM
TABLE
32,768 2
SCOTT
USERS
INDEX
131,072 2
 
USERS
LOBINDEX
65,536 1
 
USERS
LOBSEGMENT
65,536 1
 
USERS
TABLE
251,854,848 4
 
USERS_DICT
TABLE
3,637,248 1
SYS
RBS1
ROLLBACK
83,886,080 4
 
RBS2
ROLLBACK
94,371,840 4
 
SYSTEM
CACHE
8,192 1
 
SYSTEM
CLUSTER
3,661,824 9
 
SYSTEM
DEFERRED ROLLBACK
65,536 1
 
SYSTEM
INDEX
34,119,680 220
 
SYSTEM
LOBINDEX
131,072 5
 
SYSTEM
LOBSEGMENT
229,376 5
 
SYSTEM
ROLLBACK
2,539,520 2
 
SYSTEM
TABLE
195,297,280 169
SYSTEM
SYSTEM
INDEX
5,701,632 87
 
SYSTEM
LOBINDEX
851,968 13
 
SYSTEM
LOBSEGMENT
851,968 13
 
SYSTEM
TABLE
3,211,264 49
******************************************************************     -------------------- ----------------
Total:     691,773,440 756

[Top]



Data Files



Tablespace Name / File Class Filename File Size Autoextensible Next Max
DRSYS /u06/app/oradata/ORA817/drsys01.dbf 104,857,600
YES
1,048,576 34,359,721,984
PERFSTAT /u06/app/oradata/ORA817/perfstat01.dbf 524,288,000
NO
0 0
RBS1 /u06/app/oradata/ORA817/rbs1_01.dbf 1,048,576,000
YES
1,048,576,000 8,388,608,000
RBS2 /u06/app/oradata/ORA817/rbs2_01.dbf 1,048,576,000
YES
1,048,576,000 8,388,608,000
SYSTEM /u06/app/oradata/ORA817/system01.dbf 838,860,800
NO
0 0
TEMP /u06/app/oradata/ORA817/temp01.dbf 524,288,000
YES
104,857,600 34,359,721,984
USERS2 /u06/app/oradata/ORA817/users2_01.dbf 1,048,576
NO
0 0
USERS /u06/app/oradata/ORA817/users01.dbf 256,901,120
YES
10,485,760 262,144,000
USERS /u06/app/oradata/ORA817/users02.dbf 1,048,576
NO
0 0
USERS_DICT /u06/app/oradata/ORA817/users_dict_01.dbf 5,242,880
NO
0 0
[ CONTROL FILE ] /u03/app/oradata/ORA817/control01.ctl        
[ CONTROL FILE ] /u04/app/oradata/ORA817/control02.ctl        
[ CONTROL FILE ] /u05/app/oradata/ORA817/control03.ctl        
[ ONLINE REDO LOG ] /u03/app/oradata/ORA817/redo_g01a.log 52,428,800      
[ ONLINE REDO LOG ] /u03/app/oradata/ORA817/redo_g02a.log 52,428,800      
[ ONLINE REDO LOG ] /u03/app/oradata/ORA817/redo_g03a.log 52,428,800      
[ ONLINE REDO LOG ] /u04/app/oradata/ORA817/redo_g01b.log 52,428,800      
[ ONLINE REDO LOG ] /u04/app/oradata/ORA817/redo_g02b.log 52,428,800      
[ ONLINE REDO LOG ] /u04/app/oradata/ORA817/redo_g03b.log 52,428,800      
[ ONLINE REDO LOG ] /u05/app/oradata/ORA817/redo_g01c.log 52,428,800      
[ ONLINE REDO LOG ] /u05/app/oradata/ORA817/redo_g02c.log 52,428,800      
[ ONLINE REDO LOG ] /u05/app/oradata/ORA817/redo_g03c.log 52,428,800      
    --------------------      
Total:   4,825,546,752      

[Top]



Rollback Segments



Rollback Name Tablspace Init/Next Extents Min/Max Extents Status Bytes Extents Shrinks Wraps Opt. Size
SYS.R000 SYSTEM
1048576 / 1048576
2 / 505
OFFLINE
2,129,920 2      
PUBLIC.RBS1 RBS1
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
PUBLIC.RBS2 RBS2
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
PUBLIC.RBS3 RBS1
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 1 52,428,800
PUBLIC.RBS4 RBS2
20971520 / 10485760
1 / 32765
ONLINE
31,457,280 3 0 0 52,428,800
PUBLIC.RBS5 RBS1
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
PUBLIC.RBS6 RBS2
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
PUBLIC.RBS7 RBS1
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
PUBLIC.RBS8 RBS2
20971520 / 10485760
1 / 32765
ONLINE
20,971,520 2 0 0 52,428,800
SYS.SYSTEM SYSTEM
57344 / 57344
2 / 505
ONLINE
409,600 5 0 0  
          ---------------- ------------ ------------ ------------  
Total:         180,797,440 24 0 1  

[Top]



Rollback Segment Contention



Rollback Statistics From V$ROLLSTAT

Rollback Name Gets waits Hit Ratio
RBS1 566 0
100%
RBS2 582 0
100%
RBS3 14,768 6
99.96%
RBS4 588 0
100%
RBS5 1,667 0
100%
RBS6 3,499 0
100%
RBS7 1,334 0
100%
RBS8 1,414 0
100%
SYSTEM 178 0
100%
  ------------ ------------  
Total: 24,596 6  


Wait Statistics

Class Wait Ratio
system undo block
0%
system undo header
0%
undo block
0%
undo header
.00007958%

[Top]



Archiving Mode



Database
Log Mode
Automatic
Archival
Archive
Destination
Current
Log Sequence
Oldest Online
Log Sequence
Archive Mode
Enabled
location=/u06/app/oradata/ORA817/archive MANDATORY 44 42

[Top]



Archiving Parameters



Parameter Name Parameter Value
log_archive_dest  
log_archive_dest_1 location=/u06/app/oradata/ORA817/archive MANDATORY
log_archive_dest_2 service=ORA817_STBY OPTIONAL REOPEN=30
log_archive_dest_3  
log_archive_dest_4  
log_archive_dest_5  
log_archive_dest_state_1 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_duplex_dest  
log_archive_format arch_t%t_s%s.dbf
log_archive_max_processes 1
log_archive_min_succeed_dest 1
log_archive_start TRUE
log_archive_trace 0
log_buffer 32768
log_checkpoint_interval 0
log_checkpoint_timeout 21600
log_checkpoints_to_alert TRUE
log_file_name_convert  

[Top]



Archiving History



Sequence# Name First
Change #
First
Time
Next
Change #
Next
Time
Size (in bytes) Archived? Deleted?
34
/u06/app/oradata/ORA817/archive/arch_t1_s34.dbf 1527239
11/28/2004 13:26:25
1592086
12/02/2004 12:28:42
33,184,768
YES
YES
35
/u06/app/oradata/ORA817/archive/arch_t1_s35.dbf 1592086
12/02/2004 12:28:42
1592087
12/02/2004 12:28:46
512
YES
YES
36
/u06/app/oradata/ORA817/archive/arch_t1_s36.dbf 1592087
12/02/2004 12:28:46
1592420
12/02/2004 12:56:54
170,496
YES
YES
37
/u06/app/oradata/ORA817/archive/arch_t1_s37.dbf 1592420
12/02/2004 12:56:54
1592608
12/02/2004 13:12:35
95,232
YES
YES
38
/u06/app/oradata/ORA817/archive/arch_t1_s38.dbf 1592608
12/02/2004 13:12:35
1592724
12/02/2004 13:22:05
58,368
YES
YES
39
/u06/app/oradata/ORA817/archive/arch_t1_s39.dbf 1592724
12/02/2004 13:22:05
1595135
12/02/2004 14:36:54
52,427,264
YES
NO
40
/u06/app/oradata/ORA817/archive/arch_t1_s40.dbf 1595135
12/02/2004 14:36:54
1596567
12/02/2004 14:39:49
52,426,752
YES
NO
41
/u06/app/oradata/ORA817/archive/arch_t1_s41.dbf 1596567
12/02/2004 14:39:49
1598055
12/02/2004 14:41:33
52,427,264
YES
NO
42
/u06/app/oradata/ORA817/archive/arch_t1_s42.dbf 1598055
12/02/2004 14:41:33
1599539
12/02/2004 14:42:29
52,428,288
YES
NO
43
/u06/app/oradata/ORA817/archive/arch_t1_s43.dbf 1599539
12/02/2004 14:42:29
1601132
12/02/2004 14:43:28
52,423,168
YES
NO

[Top]



Backup Sets



Available backup sets. Includes available and expired backup sets.

BS Key Backup Type Device Type Controlfile Included? Incremental Level # of Pieces Start Time End Time Elapsed Seconds Tag Block Size
1
Datafile Full Backup
DISK
SBY
  1
02-DEC-2004 12:56:54
02-DEC-2004 13:00:33
219 RMAN_BACKUP_HOT_FULL 8,192
2
Datafile Full Backup
DISK
-
  1
02-DEC-2004 13:00:40
02-DEC-2004 13:03:16
156 RMAN_BACKUP_HOT_FULL 8,192
3
Archived Redo Logs
DISK
-
  1
02-DEC-2004 13:03:26
02-DEC-2004 13:03:28
2   512
4
Datafile Full Backup
DISK
YES
  1
02-DEC-2004 13:12:35
02-DEC-2004 13:15:55
200 RMAN_BACKUP_HOT_FULL 8,192
5
Datafile Full Backup
DISK
-
  1
02-DEC-2004 13:16:01
02-DEC-2004 13:18:19
138 RMAN_BACKUP_HOT_FULL 8,192
6
Archived Redo Logs
DISK
-
  1
02-DEC-2004 13:18:27
02-DEC-2004 13:18:28
1   512
7
Datafile Full Backup
DISK
YES
  1
02-DEC-2004 13:22:06
02-DEC-2004 13:25:28
202 RMAN_BACKUP_HOT_FULL 8,192
8
Datafile Full Backup
DISK
-
  1
02-DEC-2004 13:25:31
02-DEC-2004 13:27:51
140 RMAN_BACKUP_HOT_FULL 8,192
9
Archived Redo Logs
DISK
-
  1
02-DEC-2004 13:27:57
02-DEC-2004 13:27:57
0   512
          ----------------     --------------------    
Total:         9     1,058    

[Top]



Backup Pieces



Available backup pieces. Includes available and expired backup sets.

BS Key Piece # Copy # BP Key Status Handle Start Time End Time Elapsed Seconds
1
1 1 1
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543848214_s1_p1
02-DEC-2004 12:56:55
02-DEC-2004 13:00:33
218
2
1 1 2
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543848440_s2_p1
02-DEC-2004 13:00:40
02-DEC-2004 13:03:16
156
3
1 1 3
Available
/orabackup/rman/ORA817/backup_db_ORA817_al_t543848606_s3_p1
02-DEC-2004 13:03:27
02-DEC-2004 13:03:28
1
4
1 1 4
Expired
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849155_s4_p1
02-DEC-2004 13:12:36
02-DEC-2004 13:15:55
199
5
1 1 5
Expired
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849361_s5_p1
02-DEC-2004 13:16:01
02-DEC-2004 13:18:19
138
6
1 1 6
Available
/orabackup/rman/ORA817/backup_db_ORA817_al_t543849507_s6_p1
02-DEC-2004 13:18:28
02-DEC-2004 13:18:28
0
7
1 1 7
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849726_s7_p1
02-DEC-2004 13:22:06
02-DEC-2004 13:25:28
202
8
1 1 8
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849931_s8_p1
02-DEC-2004 13:25:31
02-DEC-2004 13:27:51
140
9
1 1 9
Available
/orabackup/rman/ORA817/backup_db_ORA817_al_t543850077_s9_p1
02-DEC-2004 13:27:57
02-DEC-2004 13:27:57
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
1
1 1 1
SBY
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543848214_s1_p1
4
1 1 4
YES
Expired
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849155_s4_p1
7
1 1 7
YES
Available
/orabackup/rman/ORA817/backup_db_ORA817_df_t543849726_s7_p1

[Top]



SGA Information



Pool Name Bytes
Fixed Size
73,888
Variable Size
129,986,560
Database Buffers
83,886,080
Redo Buffers
90,112
  ----------------
Total: 214,036,640

[Top]



DB Buffer Cache Hit Ratio



Consistent Gets DB Block Gets Physical Reads Hit Ratio
7,155,753 383,908 48,403
99.36%

[Top]



Dictionary Cache Hit Ratio



Misses Gets Hit Ratio
43,857 1,722
96.07%

[Top]



Library Cache Hit Ratio



Pins - (Executions) Reloads - (Cache Miss) Hit Ratio
45,853 69
99.85%

[Top]



Latch Contention



Latches with Gets, Misses, Sleeps, Immediate Gets, or Immediate Misses Greater Than 0

Latch Name Gets Misses Sleeps Willing to Wait Ratio Immediate Gets Immediate Misses Immediate Ratio
messages 334,469 3 3
.0009%
0 0
0%
checkpoint queue latch 131,913 3 3
.0023%
0 0
0%
redo allocation 290,596 3 3
.001%
0 0
0%
redo writing 37,759 2 4
.0053%
0 0
0%
enqueue hash chains 193,370 1 1
.0005%
0 0
0%
process allocation 73 0 0
0%
73 0
0%
session allocation 18,958 0 0
0%
0 0
0%
session switching 140 0 0
0%
0 0
0%
process group creation 127 0 0
0%
0 0
0%
X$KSFQP 63 0 0
0%
0 0
0%
channel operations parent latch 263 0 0
0%
0 0
0%
file number translation table 286 0 0
0%
0 0
0%
loader state object freelist 560 0 0
0%
0 0
0%
redo copy 18 0 0
0%
266,803 48
.018%
archive process latch 25 0 0
0%
0 0
0%
archive control 20 0 0
0%
0 0
0%
multiblock read objects 2,182 0 0
0%
0 0
0%
cache buffer handles 4,295 0 0
0%
0 0
0%
cache buffers chains 13,345,461 0 0
0%
99,438 0
0%
active checkpoint queue latch 3,428 0 0
0%
0 0
0%
cache buffers lru chain 352,539 0 0
0%
143 0
0%
Direct I/O Adaptor 2 0 0
0%
0 0
0%
Token Manager 1,330 0 0
0%
0 0
0%
library cache load lock 3,559 0 0
0%
0 0
0%
library cache 467,067 0 0
0%
0 0
0%
shared pool 73,424 0 0
0%
0 0
0%
user lock 160 0 0
0%
0 0
0%
dictionary lookup 12 0 0
0%
0 0
0%
row cache objects 132,333 0 0
0%
0 0
0%
sequence cache 370 0 0
0%
0 0
0%
kwqit: protect wakeup time 283 0 0
0%
0 0
0%
device information 72 0 0
0%
0 0
0%
job_queue_processes parameter latch 140 0 0
0%
0 0
0%
JOX SGA heap latch 3,690 0 0
0%
3,095 0
0%
NLS data objects 1 0 0
0%
0 0
0%
ncodef allocation latch 140 0 0
0%
0 0
0%
address list 1 0 0
0%
0 0
0%
presentation list 2 0 0
0%
0 0
0%
ktm global data 31 0 0
0%
0 0
0%
undo global data 49,339 0 0
0%
0 0
0%
sort extent pool 1,862 0 0
0%
0 0
0%
transaction branch allocation 140 0 0
0%
0 0
0%
transaction allocation 1,567,195 0 0
0%
0 0
0%
list of block allocation 3,013 0 0
0%
0 0
0%
dml lock allocation 3,875 0 0
0%
0 0
0%
begin backup scn array 32 0 0
0%
0 0
0%
message pool operations parent latch 3 0 0
0%
0 0
0%
channel handle pool latch 139 0 0
0%
0 0
0%
enqueues 379,331 0 0
0%
0 0
0%
session idle bit 34,953 0 0
0%
0 0
0%
longop free list 81 0 0
0%
0 0
0%
shared java pool 1,126 0 0
0%
0 0
0%
event group latch 73 0 0
0%
0 0
0%

[Top]



System Wait Statistics



Classes with Counts Greater Than 0

Class Count
undo header 6

[Top]



System Statistics



Statistics with Values Greater Than 0

Name Value
process last non-idle time 46,284,598,868
session connect time 46,284,598,868
redo size 292,347,180
session pga memory max 265,866,828
session pga memory 239,647,640
session uga memory max 153,961,368
buffer is pinned count 9,732,179
table scan rows gotten 7,779,303
session logical reads 7,539,661
consistent gets 7,155,753
session uga memory 5,059,736
sorts (rows) 4,856,226
buffer is not pinned count 4,852,324
bytes sent via SQL*Net to client 4,791,813
no work - consistent read gets 4,381,768
table fetch by rowid 3,947,632
bytes received via SQL*Net from client 2,975,402
redo wastage 2,262,988
cluster key scan block gets 1,329,937
cluster key scans 889,708
redo blocks written 593,972
db block changes 456,030
db block gets 383,908
table scan blocks gotten 280,412
redo entries 261,134
rows fetched via callback 238,241
recursive calls 123,752
enqueue requests 96,127
enqueue releases 96,113
messages received 96,067
messages sent 96,066
CPU used by this session 86,620
CPU used when call started 84,468
summed dirty queue length 79,491
physical writes 73,369
physical writes non checkpoint 70,462
free buffer requested 69,540
physical reads 48,403
redo write time 42,643
physical writes direct 36,074
calls to kcmgcs 31,505
DBWR checkpoint buffers written 31,163
prefetched blocks 25,732
change write time 24,860
rollback changes - undo records applied 23,904
calls to get snapshot scn: kcmgss 16,995
user calls 15,408
execute count 14,852
physical reads direct 14,322
SQL*Net roundtrips to/from client 13,756
parse count (total) 11,351
hot buffers moved to head of LRU 10,942
opened cursors cumulative 9,800
background timeouts 9,112
redo writes 8,903
sorts (memory) 8,130
immediate (CR) block cleanout applications 6,941
cleanouts only - consistent read gets 6,841
table scans (short tables) 5,959
redo buffer allocation retries 5,674
commit cleanouts successfully completed 4,803
commit cleanouts 4,803
free buffer inspected 4,623
dirty buffers inspected 4,618
DBWR undo block writes 2,992
deferred (CURRENT) block cleanout applications 2,621
DBWR buffers scanned 2,221
DBWR summed scan depth 2,221
DBWR revisited being-written buffer 1,972
calls to kcmgas 1,642
total file opens 1,294
table scans (long tables) 1,138
consistent changes 1,120
data blocks consistent reads - undo records applied 1,105
switch current to new buffer 1,032
parse time elapsed 963
recursive cpu usage 861
rollbacks only - consistent read gets 798
logons cumulative 659
CR blocks created 616
parse time cpu 607
parse count (hard) 587
DBWR free buffers found 507
table fetch continued row 385
cursor authentications 309
sorts (disk) 267
write clones created in foreground 240
cleanouts and rollbacks - consistent read gets 100
index fast full scans (full) 86
DBWR transaction table writes 72
redo synch writes 72
redo writer latching time 70
user commits 53
redo log space wait time 50
opened cursors current 43
prefetched blocks aged out before use 31
enqueue conversions 25
redo synch time 25
write clones created in background 23
logons current 19
immediate (CURRENT) block cleanout applications 18
DBWR checkpoints 16
background checkpoints completed 10
background checkpoints started 10
DBWR lru scans 6
DBWR make free requests 6
transaction rollbacks 6
redo log space requests 5
leaf node splits 1
no buffer to keep pinned count 1

[Top]



System Event Statistics



Non-Idle Events with Total Waits Greater Than 0

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
wakeup time manager 283 283 869,578 3,073
enqueue 196 186 57,304 292
log buffer space 5,667 3 23,952 4
db file parallel write 408 0 16,055 39
log file parallel write 8,903 1 7,511 1
db file scattered read 1,068 0 4,245 4
db file sequential read 7,659 0 3,666 0
control file parallel write 3,235 0 3,594 1
direct path write 6,233 0 3,042 0
control file sequential read 421,001 0 2,335 0
refresh controlfile command 83,085 0 1,012 0
log file sequential read 9,097 0 564 0
free buffer waits 7 4 524 75
direct path read 1,429 0 108 0
control file single write 99 0 75 1
LGWR wait for redo copy 48 4 70 1
file open 1,294 0 60 0
log file switch completion 5 0 50 10
buffer busy waits 6 0 39 7
rdbms ipc reply 43 0 30 1
latch free 14 14 29 2
log file single write 72 0 25 0
log file sync 44 0 25 1
switch logfile command 5 0 18 4
single-task message 56 0 15 0
file identify 314 0 11 0
SQL*Net break/reset to client 430 0 8 0
process startup 5 0 7 1
library cache load lock 3 0 3 1
local write wait 22 0 2 0
instance state change 2 0 1 1
reliable message 1 0 0 0
SQL*Net more data from client 99 0 0 0
db file single write 45 0 0 0

[Top]



Full Table Scans



Large Table Scans Small Table Scans Pct. Large Scans
1,138 5,959
16.03%

[Top]



Sorts



Disk Sorts Memory Sorts Pct. Disk Sorts
267 8,133
3.18%

[Top]



File I/O Statistics



Tablespace File Name Physical Reads Read Pct. Physical Writes Write Pct. Total I/O
USERS /u06/app/oradata/ORA817/users01.dbf 5,240
52.67%
33,517
67.74%
38,757
SYSTEM /u06/app/oradata/ORA817/system01.dbf 2,751
27.65%
82
.17%
2,833
TEMP /u06/app/oradata/ORA817/temp01.dbf 1,511
15.19%
12,112
24.48%
13,623
RBS1 /u06/app/oradata/ORA817/rbs1_01.dbf 240
2.41%
2,148
4.34%
2,388
DRSYS /u06/app/oradata/ORA817/drsys01.dbf 80
.8%
10
.02%
90
USERS_DICT /u06/app/oradata/ORA817/users_dict_01.dbf 54
.54%
649
1.31%
703
USERS /u06/app/oradata/ORA817/users02.dbf 34
.34%
17
.03%
51
RBS2 /u06/app/oradata/ORA817/rbs2_01.dbf 24
.24%
934
1.89%
958
PERFSTAT /u06/app/oradata/ORA817/perfstat01.dbf 14
.14%
10
.02%
24
USERS2 /u06/app/oradata/ORA817/users2_01.dbf 0
0%
0
0%
0
    --------------------   --------------------   --------------------
Total:   9,948   49,479   59,427

[Top]



SQL Statements With Most Disk Reads



SQL with disk reads greater than 1000

Username Disk Reads Executions Reads / Execution SQL
SCOTT 21,782 7 3,112 insert into extents2 select * from extents2
SCOTT 1,285 1 1,285 select distinct owner from extents2

[Top]



SQL Statements With Most Buffer Gets



SQL with buffer gets greater than 1000

Username Buffer Gets Executions Buffer Gets / Execution SQL
SCOTT 250,975 7 35,854 insert into extents2 select * from extents2
SCOTT 38,883 1 38,883 delete from extents
SCOTT 13,129 1 13,129 insert into extents select * from dba_extents
SCOTT 12,827 1 12,827 select distinct owner from extents2
SCOTT 7,419 7 1,060 insert into extents select * from extents

[Top]



Top 10 Tables



Command Type Object Name Number of Executions Buffer Gets Rows Processed
SELECT FROM
SYS.OBJ$ 2,008 6,958,441 32,178
SELECT FROM
SYS.AQ$_QUEUE_TABLE_AFFINITIES 1,129 23,789 1,412
SELECT FROM
SYS.FILE$ 908 1,811,915 18,874
SELECT FROM
SYS.USER$ 867 7,023,201 29,231
SELECT FROM
SYSTEM.AQ$_QUEUE_TABLES 846 22,343 1,128
SELECT FROM
SYS.TS$ 618 4,205,075 24,064
SELECT FROM
SYS.JOB$ 532 2,138 147
SELECT FROM
SYS.SEG$ 526 4,185,785 21,793
SELECT FROM
SYS.DEPENDENCY$ 509 15,952 5,099
SELECT FROM
SYS.ACCESS$ 505 9,607 4,284
    -------------------- -------------------- --------------------
Total:   8,448 24,258,246 138,210

[Top]



Top 10 Procedures



Object Type Object Name Number of Executions
PACKAGE
SYS.DBMS_RCVMAN 696
PACKAGE BODY
SYS.DBMS_RCVMAN 667
PACKAGE
SYS.DBMS_OUTPUT 360
PACKAGE BODY
SYS.DBMS_OUTPUT 357
PACKAGE
SYS.STANDARD 312
PACKAGE BODY
SYS.STANDARD 312
PACKAGE
SYS.DBMS_APPLICATION_INFO 299
PACKAGE BODY
SYS.DBMS_APPLICATION_INFO 295
PACKAGE
SYS.DBMS_SPACE_ADMIN 246
PACKAGE BODY
SYS.DBMS_SPACE_ADMIN 246
    --------------------
Total:   3,790

[Top]



Outlines



Owner Name Category Used Time Stamp Version SQL Text
SYSTEM
NEW_DUAL
DEFAULT UNUSED 12/02/2004 14:47:22 8.1.7.4.0 select user from dual
SYSTEM
NEW_OBJECTS
DEFAULT UNUSED 12/02/2004 14:47:38 8.1.7.4.0 select * from dba_objects

[Top]



Current Sessions Summary



Current No. of Processes Max No. of Processes % Usage
19
200
9.5%

Oracle
User
Total Number
of Logins
Active
Logins
Inactive
Logins
SCOTT
3 1 2
SYS
4 0 4
SYSTEM
1 1 0
[B.G. Process]
11 11 0
  ---------------- ------------ ------------
Total: 19 13 6

[Top]



Session Statistics



User Sessions and Statistics Ordered by Logical I/O

SID Status Oracle User Machine Session Program CPU Logical I/O Physical Reads Physical Writes PGA Memory Cursors Txns
18
INACTIVE
SCOTT alex sqlplus@alex (TNS V1-V3) 5,174 351,804 27,789 290 2,643,844 0 4
21
INACTIVE
SCOTT alex sqlplus@alex (TNS V1-V3) 462 82,501 590 0 2,435,056 1 5
17
ACTIVE
SYSTEM WORKGROUP\MELODY sqlplus.exe 231 25,086 166 182 1,366,504 1 1
9
ACTIVE
[B.G. Process] alex oracle@alex (QMN0) 0 19,831 45 0 358,640 3 0
5
ACTIVE
[B.G. Process] alex oracle@alex (SMON) 0 2,336 535 0 382,504 0 0
20
ACTIVE
SCOTT alex sqlplus@alex (TNS V1-V3) 3 93 2 0 111,792 1 1
6
ACTIVE
[B.G. Process] alex oracle@alex (RECO) 0 45 1 0 111,792 0 0
16
INACTIVE
SYS alex rman@alex (TNS V1- V3) 82 5 0 0 587,264 30 0
1
ACTIVE
[B.G. Process] alex oracle@alex (PMON) 0 0 0 0 59,568 0 0
2
ACTIVE
[B.G. Process] alex oracle@alex (DBW0) 0 0 8 37,295 1,974,940 0 0
12
ACTIVE
[B.G. Process] alex oracle@alex (ARC1) 0 0 0 0 218,848 0 0
19
INACTIVE
SYS alex rman@alex (TNS V1- V3) 17 0 0 0 2,316,200 3 0
11
INACTIVE
SYS alex rman@alex (TNS V1- V3) 15,035 0 0 0 6,551,620 3 0
15
INACTIVE
SYS alex rman@alex (TNS V1- V3) 2 0 0 0 86,256 1 0
10
ACTIVE
[B.G. Process] alex oracle@alex (ARC0) 0 0 0 0 260,504 0 0
8
ACTIVE
[B.G. Process]     0 0 0 0 76,592 0 0
7
ACTIVE
[B.G. Process]     0 0 0 0 142,528 0 0
3
ACTIVE
[B.G. Process] alex oracle@alex (LGWR) 0 0 8 7 187,496 0 0
4
ACTIVE
[B.G. Process] alex oracle@alex (CKPT) 0 0 69 69 220,156 0 0
          ---------------- ---------------- ---------------- ---------------- ---------------- -------- --------
Total:         21,006 481,701 29,213 37,843 20,092,104 43 11

[Top]



Sessions by Memory



User Sessions Ordered by Current PGA Size

SID Serial# Status Oracle User O/S User O/S PID Session Program Machine PGA Memory PGA Memory Max UGA Memory UGA Memory MAX
11
85
INACTIVE
SYS oracle 9496 rman@alex (TNS V1- V3) alex 6,551,620 18,611,564 51,404 63,912
17
554
ACTIVE
SYSTEM jhunter 9739 sqlplus.exe WORKGROUP\MELODY 5,369,576 5,369,576 425,976 5,136,288
18
341
INACTIVE
SCOTT oracle 9686 sqlplus@alex (TNS V1-V3) alex 2,643,844 2,643,844 57,872 627,296
21
41
INACTIVE
SCOTT oracle 9667 sqlplus@alex (TNS V1-V3) alex 2,435,056 2,435,056 74,968 627,292
19
56
INACTIVE
SYS oracle 9567 rman@alex (TNS V1- V3) alex 2,316,200 2,316,200 51,404 61,428
2
1
ACTIVE
  oracle 9410 oracle@alex (DBW0) alex 1,974,940 1,974,940 20,436 20,436
16
162
INACTIVE
SYS oracle 9492 rman@alex (TNS V1- V3) alex 587,264 587,264 229,816 348,004
5
1
ACTIVE
  oracle 9416 oracle@alex (SMON) alex 382,504 382,504 35,876 35,876
9
1
ACTIVE
  oracle 9424 oracle@alex (QMN0) alex 358,640 358,640 61,836 102,160
10
1
ACTIVE
  oracle 9426 oracle@alex (ARC0) alex 260,504 260,504 17,964 17,964
4
1
ACTIVE
  oracle 9414 oracle@alex (CKPT) alex 220,156 220,156 17,868 17,868
12
5
ACTIVE
  oracle 9430 oracle@alex (ARC1) alex 218,848 218,848 17,960 17,960
3
1
ACTIVE
  oracle 9412 oracle@alex (LGWR) alex 187,496 187,496 18,252 18,252
7
585
ACTIVE
    9420     142,528 142,528 24,812 24,812
6
1
ACTIVE
  oracle 9418 oracle@alex (RECO) alex 111,792 111,792 39,084 39,084
20
78
ACTIVE
SCOTT oracle 9715 sqlplus@alex (TNS V1-V3) alex 111,792 111,792 31,400 31,400
15
114
INACTIVE
SYS oracle 9494 rman@alex (TNS V1- V3) alex 86,256 86,256 22,024 22,024
8
585
ACTIVE
    9422     76,592 76,592 24,572 24,572
1
1
ACTIVE
  oracle 9408 oracle@alex (PMON) alex 59,568 59,568 18,556 18,556
                ---------------- ---------------- ---------------- ----------------
Total:               24,095,176 36,155,120 1,242,080 7,255,184

[Top]



Current SQL



All Active User Sessions with SQL

SID Serial # Status Oracle User O/S User O/S PID Session Program Current SQL
20
78
ACTIVE
SCOTT oracle 9715 sqlplus@alex (TNS V1-V3) lock table extents in exclusive mode

[Top]



All Locks



All locks (excluding background process locks).

SID Lock Type Mode Held Mode Requested Lock ID1 Lock ID2 Last Convert Blocking Others?
18
Transaction Exclusive None 262214 1570 1047 Not Blocking
18
DML Row-X (SX) None 24989 0 1047 Not Blocking
20
DML None Exclusive 24978 0 581 Not Blocking
21
DML Exclusive None 24978 0 1269 Blocking

[Top]



Blocking Locks



WAITING USER OS User SID PID HOLDING USER OS User Sid PID
SCOTT
oracle
20
9715
SCOTT
oracle
21
9667

[Top]



User Accounts



Username Status Expire Date Default Tbs. Temp Tbs. Created On Profile SYSDBA SYSOPER
AURORA$JIS$UTILITY$ OPEN   SYSTEM SYSTEM 28-AUG-2004 14:35:37 DEFAULT    
AURORA$ORB$UNAUTHENTICATED OPEN   SYSTEM SYSTEM 28-AUG-2004 14:43:55 DEFAULT    
CTXSYS OPEN   DRSYS DRSYS 28-AUG-2004 15:14:22 DEFAULT    
DBSNMP OPEN   SYSTEM SYSTEM 28-AUG-2004 14:21:13 DEFAULT    
JHUNTER OPEN   USERS TEMP 10-SEP-2004 23:55:33 DEFAULT TRUE  
MDSYS OPEN   SYSTEM SYSTEM 28-AUG-2004 15:11:48 DEFAULT    
ORDPLUGINS OPEN   SYSTEM SYSTEM 28-AUG-2004 15:11:48 DEFAULT    
ORDSYS OPEN   SYSTEM SYSTEM 28-AUG-2004 15:11:47 DEFAULT    
OSE$HTTP$ADMIN OPEN   SYSTEM SYSTEM 28-AUG-2004 14:35:37 DEFAULT    
OUTLN OPEN   SYSTEM SYSTEM 28-AUG-2004 14:16:33 DEFAULT    
SCOTT OPEN   USERS TEMP 01-OCT-2004 19:48:17 DEFAULT    
SYS OPEN   SYSTEM TEMP 28-AUG-2004 14:16:23 DEFAULT TRUE TRUE
SYSTEM OPEN   SYSTEM TEMP 28-AUG-2004 14:16:23 DEFAULT    

[Top]



Users With DBA Privileges



Grantee Granted Role Admin. Option? Default Role?
CTXSYS
DBA
NO
YES
JHUNTER
DBA
NO
YES
SCOTT
DBA
NO
YES
SYS
DBA
YES
YES
SYSTEM
DBA
YES
YES

[Top]



Roles



Role Name Grantee Admin Option? Default Role?
AQ_ADMINISTRATOR_ROLE SYS
YES
YES
  SYSTEM
YES
YES
AQ_USER_ROLE SYS
YES
YES
CONNECT CTXSYS
NO
YES
  DBSNMP
NO
YES
  JHUNTER
NO
YES
  OEM_MONITOR
NO
YES
  ORDPLUGINS
NO
YES
  ORDSYS
NO
YES
  OUTLN
NO
YES
  SCOTT
NO
YES
  SYS
YES
YES
CTXAPP SYS
YES
YES
DBA CTXSYS
NO
YES
  JHUNTER
NO
YES
  SCOTT
NO
YES
  SYS
YES
YES
  SYSTEM
YES
YES
DELETE_CATALOG_ROLE DBA
YES
YES
  SYS
YES
YES
EXECUTE_CATALOG_ROLE DBA
YES
YES
  EXP_FULL_DATABASE
NO
YES
  IMP_FULL_DATABASE
NO
YES
  SYS
YES
YES
EXP_FULL_DATABASE DBA
NO
YES
  SYS
YES
YES
HS_ADMIN_ROLE EXECUTE_CATALOG_ROLE
NO
YES
  SELECT_CATALOG_ROLE
NO
YES
  SYS
YES
YES
IMP_FULL_DATABASE DBA
NO
YES
  SYS
YES
YES
JAVADEBUGPRIV SYS
YES
YES
JAVAIDPRIV SYS
YES
YES
JAVASYSPRIV SYS
YES
YES
JAVAUSERPRIV JAVASYSPRIV
NO
YES
  ORDSYS
NO
YES
  OSE$HTTP$ADMIN
NO
YES
  SYS
YES
YES
JAVA_ADMIN DBA
NO
YES
  SYS
YES
YES
JAVA_DEPLOY DBA
NO
YES
  SYS
YES
YES
OEM_MONITOR SYS
YES
YES
RECOVERY_CATALOG_OWNER SYS
YES
YES
RESOURCE AURORA$JIS$UTILITY$
NO
YES
  CTXSYS
NO
YES
  DBSNMP
NO
YES
  JHUNTER
NO
YES
  ORDPLUGINS
NO
YES
  ORDSYS
NO
YES
  OSE$HTTP$ADMIN
NO
YES
  OUTLN
NO
YES
  SCOTT
NO
YES
  SYS
YES
YES
SELECT_CATALOG_ROLE DBA
YES
YES
  EXP_FULL_DATABASE
NO
YES
  IMP_FULL_DATABASE
NO
YES
  OEM_MONITOR
NO
YES
  SYS
YES
YES
SNMPAGENT DBSNMP
NO
YES
  SYS
YES
YES
TIMESERIES_DBA SYS
YES
YES
TIMESERIES_DEVELOPER SYS
YES
YES

[Top]



Default Passwords



User(s) with Default Password

Username Account Status
SYS
OPEN
SYSTEM
OPEN
OUTLN
OPEN
DBSNMP
OPEN
ORDSYS
OPEN
ORDPLUGINS
OPEN
MDSYS
OPEN
CTXSYS
OPEN
SCOTT
OPEN

[Top]



DB Links



Owner DB Link Username Host Created
SCOTT ORA920.IDEVELOPMENT.INFO SCOTT ORA920 12/02/2004 14:49:02

[Top]



Object summary



Owner Object Type Object Count
AURORA$JIS$UTILITY$ INDEX 13
  LOB 1
  SEQUENCE 3
  TABLE 14
************************************************************   ----------------
    31
CTXSYS FUNCTION 1
  INDEX 41
  INDEXTYPE 2
  LIBRARY 2
  LOB 1
  OPERATOR 3
  PACKAGE 44
  PACKAGE BODY 38
  PROCEDURE 1
  SEQUENCE 3
  TABLE 31
  TYPE 5
  TYPE BODY 4
  VIEW 41
************************************************************   ----------------
    217
DBSNMP SYNONYM 4
************************************************************   ----------------
    4
MDSYS INDEX 15
  INDEXTYPE 2
  LIBRARY 9
  LOB 4
  OPERATOR 13
  PACKAGE 33
  PACKAGE BODY 33
  SEQUENCE 1
  TABLE 15
  TRIGGER 4
  TYPE 20
  TYPE BODY 2
  VIEW 36
************************************************************   ----------------
    187
ORDPLUGINS PACKAGE 13
  PACKAGE BODY 13
************************************************************   ----------------
    26
ORDSYS INDEX 13
  INDEXTYPE 1
  JAVA CLASS 160
  LIBRARY 4
  LOB 1
  OPERATOR 2
  PACKAGE 33
  PACKAGE BODY 26
  SYNONYM 1
  TABLE 9
  TYPE 32
  TYPE BODY 12
  VIEW 11
************************************************************   ----------------
    305
OSE$HTTP$ADMIN SEQUENCE 2
  TABLE 3
************************************************************   ----------------
    5
OUTLN INDEX 3
  TABLE 2
************************************************************   ----------------
    5
PUBLIC SYNONYM 10,981
************************************************************   ----------------
    10,981
SCOTT DATABASE LINK 1
  INDEX 2
  JAVA CLASS 2
  JAVA SOURCE 2
  LOB 1
  PACKAGE 1
  PACKAGE BODY 1
  PROCEDURE 2
  TABLE 5
  VIEW 1
************************************************************   ----------------
    18
SYS CLUSTER 9
  CONSUMER GROUP 4
  DIRECTORY 2
  FUNCTION 23
  INDEX 221
  JAVA CLASS 9,971
  JAVA DATA 290
  JAVA RESOURCE 132
  JAVA SOURCE 8
  LIBRARY 22
  LOB 5
  PACKAGE 253
  PACKAGE BODY 232
  PROCEDURE 11
  RESOURCE PLAN 1
  SEQUENCE 30
  SYNONYM 22
  TABLE 202
  TRIGGER 3
  TYPE 93
  VIEW 1,289
************************************************************   ----------------
    12,823
SYSTEM INDEX 87
  LOB 13
  PACKAGE 1
  PACKAGE BODY 1
  PROCEDURE 1
  QUEUE 4
  SEQUENCE 11
  SYNONYM 8
  TABLE 49
  TRIGGER 2
  VIEW 3
************************************************************   ----------------
    180
    ----------------
Grand Total:   24,782

[Top]



Segment Summary



Owner Segment Type Segment Count Size (in Bytes)
AURORA$JIS$UTILITY$ INDEX 13 851,968
    LOBINDEX 1 65,536
    LOBSEGMENT 1 65,536
    TABLE 14 917,504
**************************************************   ---------------- --------------------
    29 1,900,544
CTXSYS INDEX 41 2,686,976
  LOBINDEX 1 65,536
  LOBSEGMENT 1 65,536
  TABLE 23 1,507,328
**************************************************   ---------------- --------------------
    66 4,325,376
MDSYS INDEX 15 983,040
  LOBINDEX 4 262,144
  LOBSEGMENT 4 262,144
  TABLE 15 1,507,328
**************************************************   ---------------- --------------------
    38 3,014,656
ORDSYS INDEX 13 851,968
  LOBINDEX 1 65,536
  LOBSEGMENT 1 65,536
  TABLE 9 589,824
**************************************************   ---------------- --------------------
    24 1,572,864
OSE$HTTP$ADMIN TABLE 3 196,608
**************************************************   ---------------- --------------------
    3 196,608
OUTLN INDEX 3 49,152
  TABLE 2 32,768
**************************************************   ---------------- --------------------
    5 81,920
SCOTT INDEX 2 131,072
  LOBINDEX 1 65,536
  LOBSEGMENT 1 65,536
  TABLE 5 255,492,096
**************************************************   ---------------- --------------------
    9 255,754,240
SYS CACHE 1 8,192
  CLUSTER 9 3,661,824
  DEFERRED ROLLBACK 1 65,536
  INDEX 220 34,119,680
  LOBINDEX 5 131,072
  LOBSEGMENT 5 229,376
  ROLLBACK 10 180,797,440
  TABLE 169 195,297,280
**************************************************   ---------------- --------------------
    420 414,310,400
SYSTEM INDEX 87 5,701,632
  LOBINDEX 13 851,968
  LOBSEGMENT 13 851,968
  TABLE 49 3,211,264
**************************************************   ---------------- --------------------
    162 10,616,832
    ---------------- --------------------
Grand Total:   756 691,773,440

[Top]



Directories



Owner Directory Name Directory Path
SYS USER_FILES /utl/user_files
SYS GWCUSTOM /utl/oracle_data

[Top]



Libraries



Owner Library Name File Spec Dynamic? Status
SYS DBMS_AQADM_LIB  
N
VALID
SYS DBMS_AQ_LIB  
N
VALID
SYS DBMS_DEFER_ENQ_UTL_LIB  
N
VALID
SYS DBMS_OBFUSCATION_LIB  
N
VALID
SYS DBMS_PICKLER_LIB  
N
VALID
SYS DBMS_PLUGTS_LIB  
N
VALID
SYS DBMS_REPAIR_LIB  
N
VALID
SYS DBMS_REPAPI_LIB  
N
VALID
SYS DBMS_REPCAT_INTERNAL_PKG_LIB  
N
VALID
SYS DBMS_RLS_LIB  
N
VALID
SYS DBMS_RMGR_LIB  
N
VALID
SYS DBMS_RULES_LIB  
N
VALID
SYS DBMS_SNAPSHOT_LIB  
N
VALID
SYS DBMS_SPACE_ADMIN_LIB  
N
VALID
SYS DBMS_STATS_LIB  
N
VALID
SYS DBMS_SUMADV_LIB /u01/app/oracle/product/8.1.7/lib/libqsmashr.so
Y
VALID
SYS DBMS_SUMAPI_LIB  
N
VALID
SYS DBMS_TRACE_LIB  
N
VALID
SYS DBMS_UTL_COLL_LIB  
N
VALID
SYS DBMS_UTL_REF_LIB  
N
VALID
SYS DBMS_ZHELP_LIB  
N
VALID
SYS EXTIDX_IMP_LIB  
N
VALID
ORDSYS ORDIMLIBS /u01/app/oracle/product/8.1.7/lib/libordim8.so
Y
VALID
ORDSYS ORDTSLIBT  
N
VALID
ORDSYS ORDVIRLIBS /u01/app/oracle/product/8.1.7/lib/libordvir8.so
Y
VALID
ORDSYS ORDVIRLIBT  
N
VALID
MDSYS ORDMD_CS_LIBS  
N
VALID
MDSYS ORDMD_IDX_LIBS  
N
VALID
MDSYS ORDMD_LRS_LIBS  
N
VALID
MDSYS ORDMD_MBR_LIBS  
N
VALID
MDSYS ORDMD_MIG_LIBS  
N
VALID
MDSYS ORDMD_REL_LIBS  
N
VALID
MDSYS ORDMD_RTREE_LIBS  
N
VALID
MDSYS ORDMD_UDT_LIBS  
N
VALID
MDSYS ORDMD_WD_LIBS  
N
VALID
CTXSYS DR$LIB  
N
VALID
CTXSYS DR$LIBX /u01/app/oracle/product/8.1.7/ctx/lib/libctxx8.so
Y
VALID

[Top]



Top 200 Segments (by size)



Owner Segment Name Partition Name Segment Type Tablespace Name Size (in bytes) Extents
SCOTT EXTENTS2   TABLE USERS 251,658,240 101
SYS IDL_UB1$   TABLE SYSTEM 98,574,336 753
SYS SOURCE$   TABLE SYSTEM 60,514,304 232
SYS RBS4   ROLLBACK RBS2 31,457,280 3
SYS RBS1   ROLLBACK RBS1 20,971,520 2
SYS RBS5   ROLLBACK RBS1 20,971,520 2
SYS RBS7   ROLLBACK RBS1 20,971,520 2
SYS RBS8   ROLLBACK RBS2 20,971,520 2
SYS RBS6   ROLLBACK RBS2 20,971,520 2
SYS RBS3   ROLLBACK RBS1 20,971,520 2
SYS RBS2   ROLLBACK RBS2 20,971,520 2
SYS IDL_UB2$   TABLE SYSTEM 7,593,984 59
SYS DEPENDENCY$   TABLE SYSTEM 5,251,072 41
SYS I_DEPENDENCY1   INDEX SYSTEM 4,857,856 38
SYS I_DEPENDENCY2   INDEX SYSTEM 4,726,784 37
SCOTT EXTENTS   TABLE USERS_DICT 3,637,248 31
SYS IDL_SB4$   TABLE SYSTEM 3,547,136 28
SYS I_ACCESS1   INDEX SYSTEM 3,416,064 27
SYS IDL_CHAR$   TABLE SYSTEM 2,768,896 22
SYS ARGUMENT$   TABLE SYSTEM 2,629,632 21
SYS ACCESS$   TABLE SYSTEM 2,490,368 20
SYS OBJ$   TABLE SYSTEM 2,359,296 19
SYS R000   ROLLBACK SYSTEM 2,129,920 2
SYS I_ARGUMENT1   INDEX SYSTEM 2,105,344 17
SYS I_SOURCE1   INDEX SYSTEM 1,794,048 8
SYS I_IDL_UB11   INDEX SYSTEM 1,785,856 10
SYS C_OBJ#   CLUSTER SYSTEM 1,712,128 8
SYS I_OBJ2   INDEX SYSTEM 1,712,128 14
SYS C_TOID_VERSION#   CLUSTER SYSTEM 1,286,144 11
SYS VIEW$   TABLE SYSTEM 1,269,760 11
SYS JAVASNM$   TABLE SYSTEM 1,261,568 9
SYS I_IDL_SB41   INDEX SYSTEM 868,352 8
SYS I_COL1   INDEX SYSTEM 778,240 7
SYS I_IDL_CHAR1   INDEX SYSTEM 606,208 7
SYS I_JAVASNM1   INDEX SYSTEM 606,208 7
SYS I_IDL_UB21   INDEX SYSTEM 606,208 7
MDSYS CS_SRS   TABLE SYSTEM 589,824 9
SYS SYN$   TABLE SYSTEM 557,056 7
SYS I_OBJ1   INDEX SYSTEM 516,096 7
SYS I_OBJAUTH1   INDEX SYSTEM 516,096 7
SYS I_OBJAUTH2   INDEX SYSTEM 516,096 7
SYS I_COL2   INDEX SYSTEM 409,600 4
SYS SYSTEM   ROLLBACK SYSTEM 409,600 5
SYS I_COL3   INDEX SYSTEM 409,600 4
SYS COM$   TABLE SYSTEM 393,216 4
SYS SYS_C001010   INDEX SYSTEM 393,216 6
SYS KOTAD$   TABLE SYSTEM 360,448 6
SYS JAVA$CLASS$MD5$TABLE   TABLE SYSTEM 327,680 5
SYS OBJAUTH$   TABLE SYSTEM 319,488 6
SYS C_FILE#_BLOCK#   CLUSTER SYSTEM 303,104 6
SYS I_COM1   INDEX SYSTEM 270,336 3
SYS I_SYN1   INDEX SYSTEM 229,376 5
SYS KOTMD$   TABLE SYSTEM 147,456 3
SYS C_COBJ#   CLUSTER SYSTEM 147,456 2
SYS SYS_LOB0000016880C00002$$   LOBSEGMENT SYSTEM 131,072 2
SYS I_CON1   INDEX SYSTEM 122,880 4
SYS CON$   TABLE SYSTEM 98,304 3
SYS I_VIEW1   INDEX SYSTEM 98,304 3
SYS I_CON2   INDEX SYSTEM 98,304 3
SYS I_CCOL2   INDEX SYSTEM 98,304 3
SYS I_CDEF1   INDEX SYSTEM 98,304 3
SYS I_CDEF2   INDEX SYSTEM 98,304 3
SYS I_CCOL1   INDEX SYSTEM 98,304 3
SYS I_CDEF4   INDEX SYSTEM 98,304 3
SYS KOTTD$   TABLE SYSTEM 98,304 3
SYS BOOTSTRAP$   TABLE SYSTEM 81,920 1
SYS I_METHOD1   INDEX SYSTEM 81,920 2
SYS I_ATTRIBUTE2   INDEX SYSTEM 81,920 2
SYS I_ATTRIBUTE1   INDEX SYSTEM 81,920 2
SYS I_SYSAUTH1   INDEX SYSTEM 81,920 2
SYS I_PROCEDURE1   INDEX SYSTEM 81,920 2
SYS I_FILE#_BLOCK#   INDEX SYSTEM 81,920 2
SYS I_ICOL1   INDEX SYSTEM 81,920 2
SYS C_USER#   CLUSTER SYSTEM 81,920 2
SYS C_TS#   CLUSTER SYSTEM 81,920 2
SYS SYS_C00599   INDEX SYSTEM 81,920 2
SYS SYS_C00598   INDEX SYSTEM 81,920 2
SYS I_RESULT1   INDEX SYSTEM 81,920 2
SYS I_PARAMETER2   INDEX SYSTEM 81,920 2
SYS I_PARAMETER1   INDEX SYSTEM 81,920 2
SYS KOTTB$   TABLE SYSTEM 81,920 2
SYS SYSAUTH$   TABLE SYSTEM 81,920 2
SYS PROCEDURE$   TABLE SYSTEM 81,920 2
SYS PSTUBTBL   TABLE SYSTEM 65,536 1
SYS DBMS_LOCK_ALLOCATED   TABLE SYSTEM 65,536 1
SYS DBMS_ALERT_INFO   TABLE SYSTEM 65,536 1
SYSTEM AQ$_QUEUE_TABLES   TABLE SYSTEM 65,536 1
SYS AQ$_QUEUE_TABLE_AFFINITIES   TABLE SYSTEM 65,536 1
SYSTEM DEF$_ERROR   TABLE SYSTEM 65,536 1
SYSTEM DEF$_AQERROR   TABLE SYSTEM 65,536 1
SYSTEM DEF$_AQCALL   TABLE SYSTEM 65,536 1
SYS AQ$_QUEUE_STATISTICS   TABLE SYSTEM 65,536 1
SYS AQ$_PENDING_MESSAGES   TABLE SYSTEM 65,536 1
SYS AQ$_PROPAGATION_STATUS   TABLE SYSTEM 65,536 1
SYS AQ$_MESSAGE_TYPES   TABLE SYSTEM 65,536 1
SYS AQ$_SCHEDULES   TABLE SYSTEM 65,536 1
SYSTEM AQ$_SCHEDULES   TABLE SYSTEM 65,536 1
SYS PRVT_EPGCTAB_PORTS   TABLE SYSTEM 65,536 1
SYSTEM DEF$_PUSHED_TRANSACTIONS   TABLE SYSTEM 65,536 1
SYSTEM DEF$_ORIGIN   TABLE SYSTEM 65,536 1
SYSTEM DEF$_PROPAGATOR   TABLE SYSTEM 65,536 1
SYSTEM DEF$_TEMP$LOB   TABLE SYSTEM 65,536 1
SYSTEM DEF$_LOB   TABLE SYSTEM 65,536 1
SYSTEM DEF$_DEFAULTDEST   TABLE SYSTEM 65,536 1
SYSTEM DEF$_CALLDEST   TABLE SYSTEM 65,536 1
SYSTEM DEF$_DESTINATION   TABLE SYSTEM 65,536 1
SYS HS$_PRIVILEGES   TABLE SYSTEM 65,536 1
SYS HS$_GRANTED_USERS   TABLE SYSTEM 65,536 1
SYS HS$_EXTERNAL_OBJECTS   TABLE SYSTEM 65,536 1
SYS HS$_INST_INIT   TABLE SYSTEM 65,536 1
SYS HS$_CLASS_INIT   TABLE SYSTEM 65,536 1
SYS HS$_INST_DD   TABLE SYSTEM 65,536 1
SYS HS$_CLASS_DD   TABLE SYSTEM 65,536 1
SYS HS$_BASE_DD   TABLE SYSTEM 65,536 1
SYS HS$_INST_CAPS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_PRIORITY   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_PRIORITY_GROUP   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_REPGROUP_PRIVS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_DDL   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_REPCATLOG   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_REPPROP   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_GENERATED   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_KEY_COLUMNS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_REPCOLUMN   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_USER_PARM_VALUES   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_OBJECT_PARMS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_TEMPLATE_PARMS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_TEMPLATE_OBJECTS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_USER_AUTHORIZATIONS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_REFRESH_TEMPLATES   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_FLAVOR_OBJECTS   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_AUDIT_COLUMN   TABLE SYSTEM 65,536 1
SYSTEM REPCAT$_AUDIT_ATTRIBUTE   TABLE SYSTEM 65,536 1
SCOTT JAVA$OPTIONS   TABLE USERS 65,536 1
SCOTT CREATE$JAVA$LOB$TABLE   TABLE USERS 65,536 1
SCOTT JAVA$CLASS$MD5$TABLE   TABLE USERS 65,536 1
ORDSYS ORDT_TIMESERIES_OBJS   TABLE SYSTEM 65,536 1
ORDSYS ORDT_TIMESERIES   TABLE SYSTEM 65,536 1
SYSTEM HELP   TABLE SYSTEM 65,536 1
MDSYS SDO_INDEX_METADATA_TABLE   TABLE SYSTEM 65,536 1
MDSYS SDO_GEOM_METADATA_TABLE   TABLE SYSTEM 65,536 1
CTXSYS DR$STATS   TABLE DRSYS 65,536 1
CTXSYS SYS_IOT_OVER_24622   TABLE DRSYS 65,536 1
CTXSYS DR$INDEX_ERROR   TABLE DRSYS 65,536 1
CTXSYS DR$WAITING   TABLE DRSYS 65,536 1
CTXSYS DR$SERVER   TABLE DRSYS 65,536 1
CTXSYS DR$INDEX_SET_INDEX   TABLE DRSYS 65,536 1
CTXSYS DR$INDEX_SET   TABLE DRSYS 65,536 1
CTXSYS DR$SUB_LEXER   TABLE DRSYS 65,536 1
CTXSYS DR$STOPLIST   TABLE DRSYS 65,536 1
CTXSYS DR$SECTION   TABLE DRSYS 65,536 1
CTXSYS DR$SECTION_GROUP   TABLE DRSYS 65,536 1
CTXSYS DR$THS_BT   TABLE DRSYS 65,536 1
CTXSYS DR$THS_PHRASE   TABLE DRSYS 65,536 1
CTXSYS DR$THS   TABLE DRSYS 65,536 1
CTXSYS SYS_IOT_OVER_24531   TABLE DRSYS 65,536 1
CTXSYS DR$INDEX_VALUE   TABLE DRSYS 65,536 1
CTXSYS DR$INDEX   TABLE DRSYS 65,536 1
CTXSYS DR$PREFERENCE_VALUE   TABLE DRSYS 65,536 1
CTXSYS DR$PREFERENCE   TABLE DRSYS 65,536 1
CTXSYS DR$OBJECT_ATTRIBUTE_LOV   TABLE DRSYS 65,536 1
CTXSYS DR$OBJECT_ATTRIBUTE   TABLE DRSYS 65,536 1
CTXSYS DR$OBJECT   TABLE DRSYS 65,536 1
CTXSYS DR$CLASS   TABLE DRSYS 65,536 1
MDSYS USER_CS_SRS   TABLE SYSTEM 65,536 1
ORDSYS ORDT_FLAT_ATTRIBUTES   TABLE SYSTEM 65,536 1
ORDSYS ORDT_TIMESERIES_COLS   TABLE SYSTEM 65,536 1
ORDSYS ORDT_OBJECT_ATTRIBUTES   TABLE SYSTEM 65,536 1
MDSYS OGIS_GEOMETRY_COLUMNS   TABLE SYSTEM 65,536 1
MDSYS OGIS_SPATIAL_REFERENCE_SYSTEMS   TABLE SYSTEM 65,536 1
MDSYS MD$RELATE   TABLE SYSTEM 65,536 1
MDSYS MD$DICTVER   TABLE SYSTEM 65,536 1
MDSYS MD$EXC   TABLE SYSTEM 65,536 1
MDSYS MD$LER   TABLE SYSTEM 65,536 1
MDSYS MD$DIM   TABLE SYSTEM 65,536 1
MDSYS MD$COL   TABLE SYSTEM 65,536 1
MDSYS MD$PTAB   TABLE SYSTEM 65,536 1
MDSYS MD$PTS   TABLE SYSTEM 65,536 1
MDSYS MD$TAB   TABLE SYSTEM 65,536 1
ORDSYS JAVA$CLASS$MD5$TABLE   TABLE SYSTEM 65,536 1
ORDSYS CREATE$JAVA$LOB$TABLE   TABLE SYSTEM 65,536 1
ORDSYS ORD_CARTRIDGE_COMPONENTS   TABLE SYSTEM 65,536 1
ORDSYS ORD_INSTALLATIONS   TABLE SYSTEM 65,536 1
SYS JACCELERATOR$STATUS   TABLE SYSTEM 65,536 1
SYS JACCELERATOR$DLL_ERRORS   TABLE SYSTEM 65,536 1
SYS JACCELERATOR$DLLS   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$DEPLOYMENT$DIGEST$   TABLE SYSTEM 65,536 1
OSE$HTTP$ADMIN ERROR$LOG   TABLE SYSTEM 65,536 1
OSE$HTTP$ADMIN EVENT$LOG   TABLE SYSTEM 65,536 1
OSE$HTTP$ADMIN HTTP$LOG$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$LOG$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$REALM$MAPPING$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$REALM$POLICY$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$REALM$GROUP$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$REALM$ID$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ JAVA$HTTP$REALM$PRINCIPAL$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ SNS$SHARED$OBJ$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ SNS$PERMISSIONS$   TABLE SYSTEM 65,536 1
AURORA$JIS$UTILITY$ SNS$REFADDR$   TABLE SYSTEM 65,536 1

[Top]



Top 200 Segments (by number of extents)



Owner Segment Name Partition Name Segment Type Tablespace Name Extents Size (in bytes)
SYS IDL_UB1$   TABLE SYSTEM 753 98,574,336
SYS SOURCE$   TABLE SYSTEM 232 60,514,304
SCOTT EXTENTS2   TABLE USERS 101 251,658,240
SYS IDL_UB2$   TABLE SYSTEM 59 7,593,984
SYS DEPENDENCY$   TABLE SYSTEM 41 5,251,072
SYS I_DEPENDENCY1   INDEX SYSTEM 38 4,857,856
SYS I_DEPENDENCY2   INDEX SYSTEM 37 4,726,784
SCOTT EXTENTS   TABLE USERS_DICT 31 3,637,248
SYS IDL_SB4$   TABLE SYSTEM 28 3,547,136
SYS I_ACCESS1   INDEX SYSTEM 27 3,416,064
SYS IDL_CHAR$   TABLE SYSTEM 22 2,768,896
SYS ARGUMENT$   TABLE SYSTEM 21 2,629,632
SYS ACCESS$   TABLE SYSTEM 20 2,490,368
SYS OBJ$   TABLE SYSTEM 19 2,359,296
SYS I_ARGUMENT1   INDEX SYSTEM 17 2,105,344
SYS I_OBJ2   INDEX SYSTEM 14 1,712,128
SYS VIEW$   TABLE SYSTEM 11 1,269,760
SYS C_TOID_VERSION#   CLUSTER SYSTEM 11 1,286,144
SYS I_IDL_UB11   INDEX SYSTEM 10 1,785,856
SYS JAVASNM$   TABLE SYSTEM 9 1,261,568
MDSYS CS_SRS   TABLE SYSTEM 9 589,824
SYS C_OBJ#   CLUSTER SYSTEM 8 1,712,128
SYS I_IDL_SB41   INDEX SYSTEM 8 868,352
SYS I_SOURCE1   INDEX SYSTEM 8 1,794,048
SYS SYN$   TABLE SYSTEM 7 557,056
SYS I_COL1   INDEX SYSTEM 7 778,240
SYS I_OBJAUTH1   INDEX SYSTEM 7 516,096
SYS I_JAVASNM1   INDEX SYSTEM 7 606,208
SYS I_OBJAUTH2   INDEX SYSTEM 7 516,096
SYS I_IDL_UB21   INDEX SYSTEM 7 606,208
SYS I_IDL_CHAR1   INDEX SYSTEM 7 606,208
SYS I_OBJ1   INDEX SYSTEM 7 516,096
SYS OBJAUTH$   TABLE SYSTEM 6 319,488
SYS KOTAD$   TABLE SYSTEM 6 360,448
SYS SYS_C001010   INDEX SYSTEM 6 393,216
SYS C_FILE#_BLOCK#   CLUSTER SYSTEM 6 303,104
SYS JAVA$CLASS$MD5$TABLE   TABLE SYSTEM 5 327,680
SYS I_SYN1   INDEX SYSTEM 5 229,376
SYS SYSTEM   ROLLBACK SYSTEM 5 409,600
SYS COM$   TABLE SYSTEM 4 393,216
SYS I_CON1   INDEX SYSTEM 4 122,880
SYS I_COL2   INDEX SYSTEM 4 409,600
SYS I_COL3   INDEX SYSTEM 4 409,600
SYS CON$   TABLE SYSTEM 3 98,304
SYS I_CON2   INDEX SYSTEM 3 98,304
SYS RBS4   ROLLBACK RBS2 3 31,457,280
SYS I_COM1   INDEX SYSTEM 3 270,336
SYS I_VIEW1   INDEX SYSTEM 3 98,304
SYS I_OBJ#   INDEX SYSTEM 3 57,344
SYS I_CCOL2   INDEX SYSTEM 3 98,304
SYS I_CCOL1   INDEX SYSTEM 3 98,304
SYS I_CDEF4   INDEX SYSTEM 3 98,304
SYS I_CDEF2   INDEX SYSTEM 3 98,304
SYS KOTMD$   TABLE SYSTEM 3 147,456
SYS I_CDEF1   INDEX SYSTEM 3 98,304
SYS KOTTD$   TABLE SYSTEM 3 98,304
SYS PROCEDURE$   TABLE SYSTEM 2 81,920
SYS I_SYSAUTH1   INDEX SYSTEM 2 81,920
SYS I_PROCEDURE1   INDEX SYSTEM 2 81,920
SYS I_FILE#_BLOCK#   INDEX SYSTEM 2 81,920
SYS I_ICOL1   INDEX SYSTEM 2 81,920
SYS C_COBJ#   CLUSTER SYSTEM 2 147,456
SYS C_USER#   CLUSTER SYSTEM 2 81,920
SYS C_TS#   CLUSTER SYSTEM 2 81,920
SYS KOTTB$   TABLE SYSTEM 2 81,920
SYS SYSAUTH$   TABLE SYSTEM 2 81,920
SYS SYS_LOB0000016880C00002$$   LOBSEGMENT SYSTEM 2 131,072
SYS SYS_C00599   INDEX SYSTEM 2 81,920
SYS SYS_C00598   INDEX SYSTEM 2 81,920
SYS I_RESULT1   INDEX SYSTEM 2 81,920
SYS I_PARAMETER2   INDEX SYSTEM 2 81,920
SYS I_PARAMETER1   INDEX SYSTEM 2 81,920
SYS I_METHOD1   INDEX SYSTEM 2 81,920
SYS I_ATTRIBUTE2   INDEX SYSTEM 2 81,920
SYS I_ATTRIBUTE1   INDEX SYSTEM 2 81,920
SYS RBS8   ROLLBACK RBS2 2 20,971,520
SYS RBS7   ROLLBACK RBS1 2 20,971,520
SYS RBS6   ROLLBACK RBS2 2 20,971,520
SYS RBS5   ROLLBACK RBS1 2 20,971,520
SYS RBS3   ROLLBACK RBS1 2 20,971,520
SYS RBS2   ROLLBACK RBS2 2 20,971,520
SYS RBS1   ROLLBACK RBS1 2 20,971,520
SYS R000   ROLLBACK SYSTEM 2 2,129,920
SYS UNDO$   TABLE SYSTEM 1 16,384
SYS TYPED_VIEW$   TABLE SYSTEM 1 16,384
SYS SEQ$   TABLE SYSTEM 1 16,384
SYS BOOTSTRAP$   TABLE SYSTEM 1 81,920
SYS ERROR$   TABLE SYSTEM 1 16,384
SYS RESOURCE_CONSUMER_GROUP$   TABLE SYSTEM 1 16,384
SYS TRIGGER$   TABLE SYSTEM 1 16,384
SYS REG$   TABLE SYSTEM 1 16,384
SYS INCFIL   TABLE SYSTEM 1 16,384
SYS INCVID   TABLE SYSTEM 1 16,384
SYS INCEXP   TABLE SYSTEM 1 16,384
SYS RESOURCE_COST$   TABLE SYSTEM 1 16,384
SYS PROPS$   TABLE SYSTEM 1 16,384
SYS TRUSTED_LIST$   TABLE SYSTEM 1 16,384
SYS LINK$   TABLE SYSTEM 1 16,384
SYS AUD$   TABLE SYSTEM 1 16,384
SYS PROFNAME$   TABLE SYSTEM 1 16,384
SYS DUC$   TABLE SYSTEM 1 16,384
SYS JOB$   TABLE SYSTEM 1 16,384
SYS SNAP_SITE$   TABLE SYSTEM 1 16,384
SYS REG_SNAP$   TABLE SYSTEM 1 16,384
SYS SNAP_COLMAP$   TABLE SYSTEM 1 16,384
SYS SNAP_REFOP$   TABLE SYSTEM 1 16,384
SYS MLOG_REFCOL$   TABLE SYSTEM 1 16,384
SYS SNAP_REFTIME$   TABLE SYSTEM 1 16,384
SYS SNAP$   TABLE SYSTEM 1 16,384
SYS INDTYPES$   TABLE SYSTEM 1 16,384
SYS OPARG$   TABLE SYSTEM 1 16,384
SYS OPANCILLARY$   TABLE SYSTEM 1 16,384
SYS OPBINDING$   TABLE SYSTEM 1 16,384
SYS OPERATOR$   TABLE SYSTEM 1 16,384
SYS MIGRATE$   TABLE SYSTEM 1 16,384
SYS USER_HISTORY$   TABLE SYSTEM 1 16,384
SYS KOPM$   TABLE SYSTEM 1 16,384
SYS STMT_AUDIT_OPTION_MAP   TABLE SYSTEM 1 16,384
SYS RLS$   TABLE SYSTEM 1 16,384
SYS HIERLEVEL$   TABLE SYSTEM 1 16,384
SYS HIER$   TABLE SYSTEM 1 16,384
SYS DIMATTR$   TABLE SYSTEM 1 16,384
SYS DIMJOINKEY$   TABLE SYSTEM 1 16,384
SYS DIMLEVELKEY$   TABLE SYSTEM 1 16,384
SYS DIMLEVEL$   TABLE SYSTEM 1 16,384
SYS DIM$   TABLE SYSTEM 1 16,384
SYS SUMDEP$   TABLE SYSTEM 1 16,384
SYS AQ$_QUEUE_TABLE_AFFINITIES   TABLE SYSTEM 1 65,536
SYSTEM AQ$_QUEUES   TABLE SYSTEM 1 65,536
SYSTEM AQ$_QUEUE_TABLES   TABLE SYSTEM 1 65,536
SYS DBMS_ALERT_INFO   TABLE SYSTEM 1 65,536
SYS DBMS_LOCK_ALLOCATED   TABLE SYSTEM 1 65,536
SYS PSTUBTBL   TABLE SYSTEM 1 65,536
SYS AUDIT_ACTIONS   TABLE SYSTEM 1 16,384
SYS SQL_VERSION$   TABLE SYSTEM 1 16,384
SYS MON_MODS$   TABLE SYSTEM 1 16,384
SYSTEM REPCAT$_USER_AUTHORIZATIONS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REFRESH_TEMPLATES   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_FLAVOR_OBJECTS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_AUDIT_COLUMN   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_AUDIT_ATTRIBUTE   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_PARAMETER_COLUMN   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_RESOL_STATS_CONTROL   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_RESOLUTION_STATISTICS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_RESOLUTION   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_RESOLUTION_METHOD   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_CONFLICT   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_GROUPED_COLUMN   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_COLUMN_GROUP   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_PRIORITY   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_PRIORITY_GROUP   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPGROUP_PRIVS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_DDL   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPCATLOG   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPPROP   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_GENERATED   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_KEY_COLUMNS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPCOLUMN   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPOBJECT   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_SNAPGROUP   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPSCHEMA   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_FLAVORS   TABLE SYSTEM 1 65,536
SYSTEM REPCAT$_REPCAT   TABLE SYSTEM 1 65,536
SYSTEM SQLPLUS_PRODUCT_PROFILE   TABLE SYSTEM 1 65,536
SYS HS$_CREATE_GRANTEES   TABLE SYSTEM 1 65,536
SYS HS$_ACCESS_GRANTEES   TABLE SYSTEM 1 65,536
SYS HS$_PRIVILEGES   TABLE SYSTEM 1 65,536
SYS HS$_GRANTED_USERS   TABLE SYSTEM 1 65,536
SYS HS$_EXTERNAL_OBJECTS   TABLE SYSTEM 1 65,536
SYS HS$_INST_INIT   TABLE SYSTEM 1 65,536
SYS HS$_CLASS_INIT   TABLE SYSTEM 1 65,536
SYS HS$_INST_DD   TABLE SYSTEM 1 65,536
SYS HS$_CLASS_DD   TABLE SYSTEM 1 65,536
SYS HS$_BASE_DD   TABLE SYSTEM 1 65,536
SYS HS$_INST_CAPS   TABLE SYSTEM 1 65,536
SYS HS$_CLASS_CAPS   TABLE SYSTEM 1 65,536
SYS HS$_BASE_CAPS   TABLE SYSTEM 1 65,536
SYS HS$_FDS_INST   TABLE SYSTEM 1 65,536
SYS HS$_FDS_CLASS   TABLE SYSTEM 1 65,536
SYS PRVT_EPGCTAB_DAD_ATTRS   TABLE SYSTEM 1 65,536
SYS PRVT_EPGCTAB_DAD   TABLE SYSTEM 1 65,536
SYS PRVT_EPGCTAB_GLOBALS   TABLE SYSTEM 1 65,536
SYS PRVT_EPGCTAB_ADMIN   TABLE SYSTEM 1 65,536
SYS PRVT_EPGCTAB_PORTS   TABLE SYSTEM 1 65,536
SYSTEM DEF$_PUSHED_TRANSACTIONS   TABLE SYSTEM 1 65,536
SYSTEM DEF$_ORIGIN   TABLE SYSTEM 1 65,536
SYSTEM DEF$_PROPAGATOR   TABLE SYSTEM 1 65,536
SYSTEM DEF$_TEMP$LOB   TABLE SYSTEM 1 65,536
SYSTEM DEF$_LOB   TABLE SYSTEM 1 65,536
SYSTEM DEF$_DEFAULTDEST   TABLE SYSTEM 1 65,536
SYSTEM DEF$_CALLDEST   TABLE SYSTEM 1 65,536
SYSTEM DEF$_DESTINATION   TABLE SYSTEM 1 65,536
SYSTEM DEF$_ERROR   TABLE SYSTEM 1 65,536
SYSTEM DEF$_AQERROR   TABLE SYSTEM 1 65,536
SYSTEM DEF$_AQCALL   TABLE SYSTEM 1 65,536
SYS AQ$_QUEUE_STATISTICS   TABLE SYSTEM 1 65,536
SYS AQ$_PENDING_MESSAGES   TABLE SYSTEM 1 65,536
SYS AQ$_PROPAGATION_STATUS   TABLE SYSTEM 1 65,536
SYS AQ$_MESSAGE_TYPES   TABLE SYSTEM 1 65,536

[Top]



Objects Unable to Extend



Segments that cannot extend because of MAXEXTENTS or not enough space

[Top]



Objects Which Are Nearing MAXEXTENTS



Segments where number of EXTENTS is less than 1/2 of MAXEXTENTS

Owner Tablespace name Segment Name Segment Type Size (in bytes) Next Extent Size % Increase Num. of Extents Max Extents % Utilized
SCOTT USERS_DICT EXTENTS TABLE 3,637,248 98,304 0 31 32
96.88%

[Top]



Invalid Objects



Owner Object Name Object Type Status
MDSYS ALL_SDO_INDEX_INFO VIEW INVALID
MDSYS DBA_SDO_INDEX_INFO VIEW INVALID
MDSYS GEODETIC_SRIDS VIEW INVALID
MDSYS USER_SDO_INDEX_INFO VIEW INVALID
SCOTT BAD_PROC PROCEDURE INVALID
SCOTT BAD_VIEW VIEW INVALID
SYS ALL_REPCAT VIEW INVALID
SYS ALL_REPCOLUMN VIEW INVALID
SYS ALL_REPCOLUMN_GROUP VIEW INVALID
SYS ALL_REPFLAVOR_COLUMNS VIEW INVALID
SYS ALL_REPGENERATED VIEW INVALID
SYS ALL_REPGENOBJECTS VIEW INVALID
SYS ALL_REPGROUP VIEW INVALID
SYS ALL_REPGROUPED_COLUMN VIEW INVALID
SYS ALL_REPKEY_COLUMNS VIEW INVALID
SYS ALL_REPOBJECT VIEW INVALID
SYS ALL_REPPROP VIEW INVALID
SYS DBA_REPCOLUMN VIEW INVALID
SYS DBA_REPFLAVOR_COLUMNS VIEW INVALID
SYS DBA_REPPROP VIEW INVALID
SYS DBMSOBJG PACKAGE BODY INVALID
SYS DBMS_IAS_INST_UTL PACKAGE BODY INVALID
SYS DBMS_IAS_MT_INST PACKAGE BODY INVALID
SYS DBMS_OBFUSCATION_TOOLKIT PACKAGE BODY INVALID
SYS DBMS_PSP PACKAGE BODY INVALID
SYS DBMS_REPCAT_ADMIN PACKAGE BODY INVALID
SYS DBMS_REPCAT_CONF PACKAGE BODY INVALID
SYS DBMS_REPCAT_FLA PACKAGE BODY INVALID
SYS DBMS_REPCAT_FLA_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_MAS PACKAGE BODY INVALID
SYS DBMS_REPCAT_MIG_INTERNAL PACKAGE BODY INVALID
SYS DBMS_REPCAT_SNA_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_UTL2 PACKAGE BODY INVALID
SYS DBMS_REPCAT_UTL3 PACKAGE BODY INVALID
SYS DBMS_REPUTIL PACKAGE BODY INVALID
SYS DBMS_SNAP_INTERNAL PACKAGE BODY INVALID
SYS USER_REPCAT VIEW INVALID
SYS USER_REPCOLUMN VIEW INVALID
SYS USER_REPFLAVOR_COLUMNS VIEW INVALID
SYS USER_REPGROUP VIEW INVALID
SYS USER_REPOBJECT VIEW INVALID
SYS USER_REPPROP VIEW INVALID
SYS UTL_TCP PACKAGE BODY INVALID
  ------------------------------    
Grand Total: 44    

[Top]



Procedural Object Errors



All records from DBA_ERRORS

Object Type Schema Object Name Sequence Line Position Text
PROCEDURE SCOTT BAD_PROC 1 3 1 PLS-00201: identifier 'LSDJF' must be declared
PROCEDURE SCOTT BAD_PROC 2 3 1 PL/SQL: Statement ignored
VIEW SCOTT BAD_VIEW 1 0 0 ORA-00942: table or view does not exist

[Top]



Objects without Statistics



Owner Object Type Object Name Partition Name
AURORA$JIS$UTILITY$ Index HTTP_GROUP_CON  
AURORA$JIS$UTILITY$ Index HTTP_ID_CON  
AURORA$JIS$UTILITY$ Index HTTP_POLICY_CON  
AURORA$JIS$UTILITY$ Index HTTP_PRINCIPAL_CON  
AURORA$JIS$UTILITY$ Index KEY_C  
AURORA$JIS$UTILITY$ Index P_MAP_CON  
AURORA$JIS$UTILITY$ Index SNS$NODE_INDEX  
AURORA$JIS$UTILITY$ Index SNS$PERM_INDEX  
AURORA$JIS$UTILITY$ Index SNS$REFADDR_INDEX  
AURORA$JIS$UTILITY$ Index SNS$SHARED$OBJ_INDEX  
AURORA$JIS$UTILITY$ Index SYS_C001012  
AURORA$JIS$UTILITY$ Index SYS_C001013  
AURORA$JIS$UTILITY$ Index SYS_C001023  
AURORA$JIS$UTILITY$ Index SYS_IL0000022598C00003$$  
AURORA$JIS$UTILITY$ Table AURORA$IIOP$SYSTEM$PROPERTIES  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$DEPLOYMENT$DIGEST$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$LOG$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$REALM$GROUP$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$REALM$ID$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$REALM$MAPPING$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$REALM$POLICY$  
AURORA$JIS$UTILITY$ Table JAVA$HTTP$REALM$PRINCIPAL$  
AURORA$JIS$UTILITY$ Table SNS$ATTRIBUTES$  
AURORA$JIS$UTILITY$ Table SNS$BINDINGS$  
AURORA$JIS$UTILITY$ Table SNS$INODE$  
AURORA$JIS$UTILITY$ Table SNS$PERMISSIONS$  
AURORA$JIS$UTILITY$ Table SNS$REFADDR$  
AURORA$JIS$UTILITY$ Table SNS$SHARED$OBJ$  
CTXSYS Index DRC$DEL_KEY  
CTXSYS Index DRC$IDX_COLSPEC  
CTXSYS Index DRC$IDX_COLUMN  
CTXSYS Index DRC$IDX_KEY  
CTXSYS Index DRC$IXO_KEY  
CTXSYS Index DRC$IXS_KEY  
CTXSYS Index DRC$IXS_NAME  
CTXSYS Index DRC$IXX_KEY  
CTXSYS Index DRC$OAT_KEY  
CTXSYS Index DRC$OAT_NAME  
CTXSYS Index DRC$OBJ_KEY  
CTXSYS Index DRC$OBJ_NAME  
CTXSYS Index DRC$PRE_KEY  
CTXSYS Index DRC$PRE_NAME  
CTXSYS Index DRC$PRV_KEY  
CTXSYS Index DRC$SEC_KEY  
CTXSYS Index DRC$SGP_KEY  
CTXSYS Index DRC$SGP_UNIQE  
CTXSYS Index DRC$SLX_KEY  
CTXSYS Index DRX$IXV_KEY  
CTXSYS Index DRX$OAL_ID  
CTXSYS Index DRX$SEC_NAME  
CTXSYS Index DRX$SEC_TAG  
CTXSYS Index DRX$SLX_SUB_PRE_ID  
CTXSYS Index DR_SERVER_SID  
CTXSYS Index DR_STOPLIST_PK  
CTXSYS Index DR_STOPLIST_UNIQ  
CTXSYS Index DR_THS_BT  
CTXSYS Index DR_THS_RINGID  
CTXSYS Index DR_UNIQ_THS_BT  
CTXSYS Index DR_UNIQ_THS_PHRASE  
CTXSYS Index SYS_C001115  
CTXSYS Index SYS_C001116  
CTXSYS Index SYS_C001118  
CTXSYS Index SYS_C001159  
CTXSYS Index SYS_IL0000024625C00002$$  
CTXSYS Index SYS_IOT_TOP_24480  
CTXSYS Index SYS_IOT_TOP_24531  
CTXSYS Index SYS_IOT_TOP_24553  
CTXSYS Index SYS_IOT_TOP_24580  
CTXSYS Index SYS_IOT_TOP_24610  
CTXSYS Index SYS_IOT_TOP_24622  
CTXSYS Table DR$CLASS  
CTXSYS Table DR$DELETE  
CTXSYS Table DR$INDEX  
CTXSYS Table DR$INDEX_ERROR  
CTXSYS Table DR$INDEX_OBJECT  
CTXSYS Table DR$INDEX_SET  
CTXSYS Table DR$INDEX_SET_INDEX  
CTXSYS Table DR$INDEX_VALUE  
CTXSYS Table DR$OBJECT  
CTXSYS Table DR$OBJECT_ATTRIBUTE  
CTXSYS Table DR$OBJECT_ATTRIBUTE_LOV  
CTXSYS Table DR$PARALLEL  
CTXSYS Table DR$PARAMETER  
CTXSYS Table DR$PENDING  
CTXSYS Table DR$PREFERENCE  
CTXSYS Table DR$PREFERENCE_VALUE  
CTXSYS Table DR$SECTION  
CTXSYS Table DR$SECTION_GROUP  
CTXSYS Table DR$SERVER  
CTXSYS Table DR$SQE  
CTXSYS Table DR$STATS  
CTXSYS Table DR$STOPLIST  
CTXSYS Table DR$STOPWORD  
CTXSYS Table DR$SUB_LEXER  
CTXSYS Table DR$THS  
CTXSYS Table DR$THS_BT  
CTXSYS Table DR$THS_FPHRASE  
CTXSYS Table DR$THS_PHRASE  
CTXSYS Table DR$WAITING  
CTXSYS Table SYS_IOT_OVER_24531  
CTXSYS Table SYS_IOT_OVER_24622  
MDSYS Index MD$ILER  
MDSYS Index MD15  
MDSYS Index MD1A  
MDSYS Index MD24A  
MDSYS Index MD33  
MDSYS Index MD3B  
MDSYS Index MD5  
MDSYS Index PK_SDO_MASK  
MDSYS Index PK_SRID  
MDSYS Index SDO_GEOM_IDX  
MDSYS Index SDO_IDX_MDATA_IDX  
MDSYS Index SYS_C001081  
MDSYS Index SYS_C001085  
MDSYS Index SYS_C001200  
MDSYS Index SYS_IL0000024459C00012$$  
MDSYS Index SYS_IL0000024459C00013$$  
MDSYS Index SYS_IL0000024832C00012$$  
MDSYS Index SYS_IL0000024832C00013$$  
MDSYS Index UNIQUE_LAYERS  
MDSYS Table CS_SRS  
MDSYS Table MD$COL  
MDSYS Table MD$DICTVER  
MDSYS Table MD$DIM  
MDSYS Table MD$EXC  
MDSYS Table MD$LER  
MDSYS Table MD$PTAB  
MDSYS Table MD$PTS  
MDSYS Table MD$RELATE  
MDSYS Table MD$TAB  
MDSYS Table OGIS_GEOMETRY_COLUMNS  
MDSYS Table OGIS_SPATIAL_REFERENCE_SYSTEMS  
MDSYS Table SDO_GEOM_METADATA_TABLE  
MDSYS Table SDO_INDEX_METADATA_TABLE  
MDSYS Table USER_CS_SRS  
ORDSYS Index ORDT_FLAT_ATTRIBUTES_IDX  
ORDSYS Index ORDT_OBJECT_ATTRIBUTES_IDX  
ORDSYS Index ORDT_TIMESERIES_COLS_IDX  
ORDSYS Index ORDT_TIMESERIES_IDX  
ORDSYS Index ORDT_TIMESERIES_IDX1  
ORDSYS Index ORDT_TIMESERIES_IDX2  
ORDSYS Index ORDT_TIMESERIES_OBJ_IDX  
ORDSYS Index ORDT_TIMESERIES_OBJ_IDX1  
ORDSYS Index ORDT_TIMESERIES_OBJ_IDX2  
ORDSYS Index PK_ORD_CARTRIDGE_COMPONENTS  
ORDSYS Index PK_ORD_INSTALLATIONS  
ORDSYS Index SYS_C001037  
ORDSYS Index SYS_C001038  
ORDSYS Index SYS_IL0000024005C00002$$  
ORDSYS Table CREATE$JAVA$LOB$TABLE  
ORDSYS Table JAVA$CLASS$MD5$TABLE  
ORDSYS Table ORDT_FLAT_ATTRIBUTES  
ORDSYS Table ORDT_OBJECT_ATTRIBUTES  
ORDSYS Table ORDT_TIMESERIES  
ORDSYS Table ORDT_TIMESERIES_COLS  
ORDSYS Table ORDT_TIMESERIES_OBJS  
ORDSYS Table ORD_CARTRIDGE_COMPONENTS  
ORDSYS Table ORD_INSTALLATIONS  
OSE$HTTP$ADMIN Table ERROR$LOG  
OSE$HTTP$ADMIN Table EVENT$LOG  
OSE$HTTP$ADMIN Table HTTP$LOG$  
OUTLN Index OL$HNT_NUM  
OUTLN Index OL$NAME  
OUTLN Index OL$SIGNATURE  
OUTLN Table OL$  
OUTLN Table OL$HINTS  
SCOTT Index SYS_C001262  
SCOTT Index SYS_C001263  
SCOTT Index SYS_IL0000024960C00002$$  
SCOTT Table CREATE$JAVA$LOB$TABLE  
SCOTT Table EXTENTS  
SCOTT Table EXTENTS2  
SCOTT Table JAVA$CLASS$MD5$TABLE  
SCOTT Table JAVA$OPTIONS  
    ------------------------------  
Total:   174  

[Top]



Tables Suffering From Row Chaining/Migration



NOTE: Must collect statistics using ANALYZE TABLE

[Top]



Users With Default Tablespace - (SYSTEM)



Username Default Tablespace Temporary Tablespace Created Status
AURORA$JIS$UTILITY$
SYSTEM
SYSTEM
08/28/2004 14:35:37
OPEN
AURORA$ORB$UNAUTHENTICATED
SYSTEM
SYSTEM
08/28/2004 14:43:55
OPEN
DBSNMP
SYSTEM
SYSTEM
08/28/2004 14:21:13
OPEN
MDSYS
SYSTEM
SYSTEM
08/28/2004 15:11:48
OPEN
ORDPLUGINS
SYSTEM
SYSTEM
08/28/2004 15:11:48
OPEN
ORDSYS
SYSTEM
SYSTEM
08/28/2004 15:11:47
OPEN
OSE$HTTP$ADMIN
SYSTEM
SYSTEM
08/28/2004 14:35:37
OPEN
OUTLN
SYSTEM
SYSTEM
08/28/2004 14:16:33
OPEN
SYS
SYSTEM
TEMP
08/28/2004 14:16:23
OPEN
SYSTEM
SYSTEM
TEMP
08/28/2004 14:16:23
OPEN

[Top]



Users With Default Temporary Tablespace - (SYSTEM)



Username Default Tablespace Temporary Tablespace Created Status
AURORA$JIS$UTILITY$
SYSTEM
SYSTEM
08/28/2004 14:35:37
OPEN
AURORA$ORB$UNAUTHENTICATED
SYSTEM
SYSTEM
08/28/2004 14:43:55
OPEN
DBSNMP
SYSTEM
SYSTEM
08/28/2004 14:21:13
OPEN
MDSYS
SYSTEM
SYSTEM
08/28/2004 15:11:48
OPEN
ORDPLUGINS
SYSTEM
SYSTEM
08/28/2004 15:11:48
OPEN
ORDSYS
SYSTEM
SYSTEM
08/28/2004 15:11:47
OPEN
OSE$HTTP$ADMIN
SYSTEM
SYSTEM
08/28/2004 14:35:37
OPEN
OUTLN
SYSTEM
SYSTEM
08/28/2004 14:16:33
OPEN

[Top]



Objects in the SYSTEM Tablespace



Owner Type Segment Name Tablespace Bytes
Alloc
Extents Initial
Ext
Next
Ext
Pct
Inc
AURORA$JIS$UTILITY$ INDEX HTTP_GROUP_CON SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX HTTP_ID_CON SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX HTTP_POLICY_CON SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX HTTP_PRINCIPAL_CON SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX KEY_C SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX P_MAP_CON SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SNS$NODE_INDEX SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SNS$PERM_INDEX SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SNS$REFADDR_INDEX SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SNS$SHARED$OBJ_INDEX SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SYS_C001012 SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SYS_C001013 SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ INDEX SYS_C001023 SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ LOBINDEX SYS_IL0000022598C00003$$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ LOBSEGMENT SYS_LOB0000022598C00003$$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE AURORA$IIOP$SYSTEM$PROPERTIES SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$DEPLOYMENT$DIGEST$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$LOG$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$REALM$GROUP$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$REALM$ID$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$REALM$MAPPING$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$REALM$POLICY$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE JAVA$HTTP$REALM$PRINCIPAL$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$ATTRIBUTES$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$BINDINGS$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$INODE$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$PERMISSIONS$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$REFADDR$ SYSTEM 65,536 1 65,536 65,536 0
AURORA$JIS$UTILITY$ TABLE SNS$SHARED$OBJ$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE CS_SRS SYSTEM 589,824 9 65,536 65,536 0
MDSYS INDEX MD$ILER SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD15 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD1A SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD24A SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD33 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD3B SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX MD5 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX PK_SDO_MASK SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX PK_SRID SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX SDO_GEOM_IDX SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX SDO_IDX_MDATA_IDX SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX SYS_C001081 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX SYS_C001085 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX SYS_C001200 SYSTEM 65,536 1 65,536 65,536 0
MDSYS INDEX UNIQUE_LAYERS SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBINDEX SYS_IL0000024459C00012$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBINDEX SYS_IL0000024459C00013$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBINDEX SYS_IL0000024832C00012$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBINDEX SYS_IL0000024832C00013$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBSEGMENT SYS_LOB0000024459C00012$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBSEGMENT SYS_LOB0000024459C00013$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBSEGMENT SYS_LOB0000024832C00012$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS LOBSEGMENT SYS_LOB0000024832C00013$$ SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$COL SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$DICTVER SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$DIM SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$EXC SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$LER SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$PTAB SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$PTS SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$RELATE SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE MD$TAB SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE OGIS_GEOMETRY_COLUMNS SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE OGIS_SPATIAL_REFERENCE_SYSTEMS SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE SDO_GEOM_METADATA_TABLE SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE SDO_INDEX_METADATA_TABLE SYSTEM 65,536 1 65,536 65,536 0
MDSYS TABLE USER_CS_SRS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_FLAT_ATTRIBUTES_IDX SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_OBJECT_ATTRIBUTES_IDX SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_COLS_IDX SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_IDX SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_IDX1 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_IDX2 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_OBJ_IDX SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_OBJ_IDX1 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX ORDT_TIMESERIES_OBJ_IDX2 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX PK_ORD_CARTRIDGE_COMPONENTS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX PK_ORD_INSTALLATIONS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX SYS_C001037 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS INDEX SYS_C001038 SYSTEM 65,536 1 65,536 65,536 0
ORDSYS LOBINDEX SYS_IL0000024005C00002$$ SYSTEM 65,536 1 65,536 65,536 0
ORDSYS LOBSEGMENT SYS_LOB0000024005C00002$$ SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE CREATE$JAVA$LOB$TABLE SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE JAVA$CLASS$MD5$TABLE SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORDT_FLAT_ATTRIBUTES SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORDT_OBJECT_ATTRIBUTES SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORDT_TIMESERIES SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORDT_TIMESERIES_COLS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORDT_TIMESERIES_OBJS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORD_CARTRIDGE_COMPONENTS SYSTEM 65,536 1 65,536 65,536 0
ORDSYS TABLE ORD_INSTALLATIONS SYSTEM 65,536 1 65,536 65,536 0
OSE$HTTP$ADMIN TABLE ERROR$LOG SYSTEM 65,536 1 65,536 65,536 0
OSE$HTTP$ADMIN TABLE EVENT$LOG SYSTEM 65,536 1 65,536 65,536 0
OSE$HTTP$ADMIN TABLE HTTP$LOG$ SYSTEM 65,536 1 65,536 65,536 0
OUTLN INDEX OL$HNT_NUM SYSTEM 16,384 1 16,384 16,384 50
OUTLN INDEX OL$NAME SYSTEM 16,384 1 16,384 16,384 50
OUTLN INDEX OL$SIGNATURE SYSTEM 16,384 1 16,384 16,384 50
OUTLN TABLE OL$ SYSTEM 16,384 1 16,384 16,384 50
OUTLN TABLE OL$HINTS SYSTEM 16,384 1 16,384 16,384 50
    ---------------------------------------------------------------------------------   --------------------        
Total Count:   99            
Total Bytes:       6,766,592        

[Top]



MTS Dispatcher Statistics



Dispatcher Rate

Dispatcher Busy Rate

[Top]



MTS Dispatcher Response Queue Wait Stats



[Top]



MTS Shared Server Wait Statistics



[Top]



Replication Summary



Current Database Name # Admin. Requests # Admin. Request Errors # Def. Trans # Def. Tran Errors # Complete Trans in Queue
ORA817.IDEVELOPMENT.INFO 0 0 0 0 0

[Top]



Deferred Transactions



[Top]



Administrative Request Jobs



[Top]



Initialization Parameters



Parameter Name Value Is Default? Is Dynamic?
commit_point_strength 1
TRUE
FALSE
compatible 8.1.7
FALSE
FALSE
dblink_encrypt_login FALSE
TRUE
FALSE
distributed_transactions 61
TRUE
FALSE
global_names FALSE
FALSE
IMMEDIATE
job_queue_interval 60
FALSE
FALSE
job_queue_processes 2
FALSE
IMMEDIATE
open_links 10
FALSE
FALSE
open_links_per_instance 4
TRUE
FALSE
parallel_automatic_tuning FALSE
FALSE
FALSE
parallel_max_servers 5
FALSE
FALSE
parallel_min_servers 0
TRUE
FALSE
processes 200
FALSE
FALSE
remote_dependencies_mode TIMESTAMP
TRUE
IMMEDIATE
replication_dependency_tracking TRUE
TRUE
FALSE
shared_pool_size 75000000
FALSE
FALSE
utl_file_dir /u01/app/oracle/common/out, /u01/app/oracle/common /extproc
FALSE
FALSE

[Top]



(Schedule) - Purge Jobs



[Top]



(Schedule) - Push Jobs



[Top]



(Schedule) - Refresh Jobs



[Top]



(Multi-Master) - Master Groups



[Top]



(Multi-Master) - Master Groups and Sites



[Top]



(Materialized View) - Master Site Summary



# of Master Groups # of Registered MV Groups # of Registered MVs # of MV Logs # of Templates
0 0 0 0 0

[Top]



(Materialized View) - Master Site Logs



[Top]



(Materialized View) - Master Site Templates



[Top]



(Materialized View) - Site Summary



# of Materialized View Groups # of Materialized Views # of Refresh Groups
0 0 0

[Top]



(Materialized View) - Site Groups



[Top]



(Materialized View) - Site Materialized Views



[Top]



(Materialized View) - Site Refresh Groups



[Top]