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



Report Index











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


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

UNDO Segments
UNDO Segments UNDO Segment Contention

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


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

Sessions
Current Sessions User Session Matrix

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


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




Report Header


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

[Top]



Version


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

[Top]



Options


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

[Top]



Database Registry


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

[Top]



Instance Overview


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

[Top]



Database Overview


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

[Top]



Initialization Parameters


SPFILE Usage
This database IS using an SPFILE.

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

[Top]



Control Files


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

[Top]



Control File Records


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

[Top]



Online Redo Logs


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

[Top]



Redo Log Switches


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

[Top]



Jobs


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

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

[Top]



Tablespaces


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

[Top]



Data Files


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

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