Snapshot Database 8i
Copyright (c) 1998-2007 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