Snapshot Database 10g Release 2
Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved. (www.idevelopment.info)



Report Index













Database and Instance Information
Report Header Version Options Database Registry
Feature Usage Statistics High Water Mark Statistics Instance Overview Database Overview
Initialization Parameters Control Files Control File Records Online Redo Logs
Redo Log Switches Outstanding Alerts Statistics Level
Scheduler / Jobs
Jobs


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

UNDO Segments
UNDO Segments UNDO Segment Contention UNDO Retention Parameters
Backups
RMAN Backup Jobs RMAN Configuration RMAN Backup Sets RMAN Backup Pieces
RMAN Backup Control Files RMAN Backup SPFILE Archiving Mode Archive Destinations
Archiving Instance Parameters Archiving History Flash Recovery Area Parameters Flash Recovery Area Status
Flashback Technologies
UNDO Retention Parameters Flashback Database Parameters Flashback Database Status Flashback Database Redo Time Matrix
Recycle Bin


Performance
SGA Information SGA Target Advice SGA (ASMM) Dynamic Components PGA Target Advice
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 Enabled Traces Enabled Aggregations
Automatic Workload Repository - (AWR)
Workload Repository Information AWR Snapshot Settings AWR Snapshot List AWR Snapshot Size Estimates
AWR Baselines


Sessions
Current Sessions User Session Matrix Enabled Traces Enabled Aggregations
Security
User Accounts Users With DBA Privileges Roles Default Passwords
DB Links


Objects
Object Summary Segment Summary Top 100 Segments (by size) Top 100 Segments (by number of extents)
Directories Directory Privileges 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 Recycle Bin

Online Analytical Processing - (OLAP)
Dimensions Dimension Levels Dimension Attributes Dimension Hierarchies
Cubes Materialized Views Materialized View Logs Materialized View Refresh Groups
Data Pump
Data Pump Jobs Data Pump Sessions Data Pump Job Progress
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



Database and Instance Information



Report Header

Report Namedba_snapshot_database_10g_ORCL_20080601.html
Snapshot Database Version5.3
Run Date / Time / TimezoneJun 01, 2008 (Sunday) at 06:28:37 PM in Timezone -04:00
Host Namelinux1
Database NameORCL
Database ID1183261123
Global Database NameORCL.IDEVELOPMENT.INFO
Platform Name / IDLinux IA (32-bit) / 10
Clustered Database?TRUE
Clustered Database Instances2
Instance Nameorcl1
Instance Number 1
Thread Number 1
Database Startup Time05/28/2008 19:58:25
Database Block Size8192
Report Run UserSYS

[Top]



Version



Banner
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

[Top]



Options



Option Name Installed?
Advanced replication
TRUE
Application Role
TRUE
Backup Encryption
TRUE
Bit-mapped indexes
TRUE
Block Change Tracking
TRUE
Block Media Recovery
TRUE
Change Data Capture
TRUE
Coalesce Index
TRUE
Connection multiplexing
TRUE
Connection pooling
TRUE
Data Mining Scoring Engine
TRUE
Data Mining
FALSE
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
Flashback Database
TRUE
Flashback Table
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 Database Vault
FALSE
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
TRUE
Sample Scan
TRUE
Spatial
TRUE
Streams Capture
TRUE
Table compression
TRUE
Transparent Application Failover
TRUE
Transparent Data Encryption
TRUE
Trial Recovery
TRUE
Unused Block Compression
TRUE
Visual Information Retrieval
TRUE

[Top]



Database Registry



Component ID Component Name Version Status Modified Control Schema Procedure
JAVAVM
JServer JAVA Virtual Machine
10.2.0.3.0
VALID
23-MAY-2008 14:12:18
SYS SYS INITJVMAUX.VALIDATE_JAVAVM
APS
OLAP Analytic Workspace
10.2.0.3.0
VALID
23-MAY-2008 14:27:21
SYS SYS APS_VALIDATE
AMD
OLAP Catalog
10.2.0.3.0
VALID
23-MAY-2008 14:29:31
SYS OLAPSYS CWM2_OLAP_INSTALLER.VALIDATE_CWM2_INSTALL
ODM
Oracle Data Mining
10.2.0.3.0
VALID
23-MAY-2008 14:15:24
SYS DMSYS VALIDATE_ODM
CATALOG
Oracle Database Catalog Views
10.2.0.3.0
VALID
23-MAY-2008 14:09:40
SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATALOG
CATJAVA
Oracle Database Java Packages
10.2.0.3.0
VALID
23-MAY-2008 14:14:30
SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
CATPROC
Oracle Database Packages and Types
10.2.0.3.0
VALID
23-MAY-2008 14:09:40
SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATPROC
EM
Oracle Enterprise Manager
10.2.0.3.0
VALID
23-MAY-2008 14:42:58
SYS SYSMAN  
EXF
Oracle Expression Filter
10.2.0.3.0
VALID
23-MAY-2008 14:14:56
SYS EXFSYS VALIDATE_EXF
OLS
Oracle Label Security
10.2.0.3.0
VALID
23-MAY-2008 14:34:45
SYS LBACSYS VALIDATE_OLS
XOQ
Oracle OLAP API
10.2.0.3.0
VALID
23-MAY-2008 14:28:00
SYS SYS XOQ_VALIDATE
RAC
Oracle Real Application Clusters
10.2.0.3.0
VALID
23-MAY-2008 14:43:01
SYS SYS DBMS_CLUSTDB.VALIDATE
RUL
Oracle Rules Manager
10.2.0.3.0
VALID
23-MAY-2008 14:18:13
SYS EXFSYS VALIDATE_RUL
CONTEXT
Oracle Text
10.2.0.3.0
VALID
23-MAY-2008 14:16:05
SYS CTXSYS VALIDATE_CONTEXT
WK
Oracle Ultra Search
10.2.0.3.0
VALID
23-MAY-2008 14:34:15
SYS WKSYS VALIDATE_WK
OWM
Oracle Workspace Manager
10.2.0.1.0
VALID
23-MAY-2008 14:10:35
SYS WMSYS VALIDATE_OWM
XML
Oracle XDK
10.2.0.3.0
VALID
23-MAY-2008 14:13:25
SYS SYS XMLVALIDATE
XDB
Oracle XML Database
10.2.0.3.0
VALID
23-MAY-2008 14:17:56
SYS XDB DBMS_REGXDB.VALIDATEXDB
ORDIM
Oracle interMedia
10.2.0.3.0
VALID
23-MAY-2008 14:24:03
SYS ORDSYS VALIDATE_ORDIM
SDO
Spatial
10.2.0.3.0
VALID
23-MAY-2008 14:33:31
SYS MDSYS VALIDATE_SDO

[Top]



Feature Usage Statistics



Feature
Name
Version Detected
Usages
Total
Samples
Currently
Used
First Usage
Date
Last Usage
Date
Last Sample
Date
Next Sample
Date
Advanced Replication
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Advanced Security
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Audit Options
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Database Diagnostic Monitor
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic SQL Execution Memory
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Segment Space Management (system)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Segment Space Management (user)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Storage Manager
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Undo Management
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Automatic Workload Repository
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
CSSCAN
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Change-Aware Incremental Backup
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Character Semantics
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Character Set
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Client Identifier
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Data Guard
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Data Guard Broker
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Data Mining
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Dynamic SGA
10.2.0.3.0
1
2
TRUE
05/31/2008 00:00:10
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
File Mapping
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Flashback Database
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Internode Parallel Execution
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Label Security
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Locally Managed Tablespaces (system)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Locally Managed Tablespaces (user)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
MTTR Advisor
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Messaging Gateway
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Multiple Block Sizes
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
OLAP - Analytic Workspaces
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
OLAP - Cubes
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Oracle Managed Files
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
PL/SQL Native Compilation
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Parallel SQL DDL Execution
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Parallel SQL DML Execution
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Parallel SQL Query Execution
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Partitioning (system)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Partitioning (user)
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Protection Mode - Maximum Availability
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Protection Mode - Maximum Performance
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Protection Mode - Maximum Protection
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Protection Mode - Unprotected
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
RMAN - Disk Backup
10.2.0.3.0
1
2
TRUE
05/31/2008 00:00:10
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
RMAN - Tape Backup
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Real Application Clusters (RAC)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Recovery Area
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Recovery Manager (RMAN)
10.2.0.3.0
1
2
TRUE
05/31/2008 00:00:10
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Resource Manager
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
SQL Access Advisor
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
SQL Tuning Advisor
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
SQL Tuning Set
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Segment Advisor
10.2.0.3.0
1
2
TRUE
05/31/2008 00:00:10
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Server Parameter File
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Shared Server
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Spatial
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Standby Archival - ARCH
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Standby Archival - LGWR
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Standby Transmission
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Streams (system)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Streams (user)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10
Transparent Gateway
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Undo Advisor
10.2.0.3.0
0
2
FALSE


05/31/2008 00:00:10
06/07/2008 00:00:10
Virtual Private Database (VPD)
10.2.0.3.0
2
2
TRUE
05/23/2008 16:04:16
05/31/2008 00:00:10
05/31/2008 00:00:10
06/07/2008 00:00:10

[Top]



High Water Mark Statistics



Statistic Name Version Highwater Last Value Description
CPU_COUNT
10.2.0.3.0
2 2 Maximum Number of CPUs
DATAFILES
10.2.0.3.0
9 9 Maximum Number of Datafiles
DB_SIZE
10.2.0.3.0
13,112,442,880 13,112,442,880 Maximum Size of the Database (Bytes)
PART_INDEXES
10.2.0.3.0
0 0 Maximum Number of Partitions belonging to an User Index
PART_TABLES
10.2.0.3.0
0 0 Maximum Number of Partitions belonging to an User Table
QUERY_LENGTH
10.2.0.3.0
150 150 Maximum Query Length
SEGMENT_SIZE
10.2.0.3.0
1,476,395,008 1,476,395,008 Size of Largest Segment (Bytes)
SERVICES
10.2.0.3.0
24 24 Maximum Number of Services
SESSIONS
10.2.0.3.0
30 30 Maximum Number of Concurrent Sessions seen in the database
SQL_NCHAR_COLUMNS
10.2.0.3.0
12 12 Maximum Number of SQL NCHAR Columns
TABLESPACES
10.2.0.3.0
10 10 Maximum Number of Tablespaces
USER_INDEXES
10.2.0.3.0
1,496 1,496 Number of User Indexes
USER_TABLES
10.2.0.3.0
844 844 Number of User Tables

[Top]



Instance Overview



Instance
Name
Instance
Num
Thread
Num
Host
Name
Oracle
Version
Start
Time
Uptime
(in days)
Parallel - (RAC) Instance
Status
Logins Archiver
orcl1
1
1
linux1
10.2.0.3.0
05/28/2008 19:58:25
3.94
YES
OPEN
ALLOWED
STARTED
orcl2
2
2
linux2
10.2.0.3.0
05/28/2008 19:58:48
3.94
YES
OPEN
ALLOWED
STARTED

[Top]



Database Overview



Database
Name
Database
ID
Database
Unique Name
Creation
Date
Platform
Name
Current
SCN
Log
Mode
Open
Mode
Force
Logging
Flashback
On?
Controlfile
Type
Last Open
Incarnation Num
ORCL
1183261123
orcl
05/23/2008 13:53:07
Linux IA (32-bit)
48410778
ARCHIVELOG
READ WRITE
NO
YES
CURRENT
1

[Top]



Initialization Parameters



SPFILE Usage
This database IS using an SPFILE.

Parameter Name Instance Name Value Is Default? Is Dynamic?
O7_DICTIONARY_ACCESSIBILITY orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
active_instance_count orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
aq_tm_processes orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
archive_lag_target orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
asm_diskgroups orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
asm_diskstring orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
asm_power_limit orcl1 1
TRUE
IMMEDIATE
  orcl2 1
TRUE
IMMEDIATE
audit_file_dest orcl1 /u01/app/oracle/admin/orcl/adump
FALSE
DEFERRED
  orcl2 /u01/app/oracle/admin/orcl/adump
FALSE
DEFERRED
audit_sys_operations orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
audit_syslog_level orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
audit_trail orcl1 NONE
TRUE
FALSE
  orcl2 NONE
TRUE
FALSE
background_core_dump orcl1 partial
TRUE
FALSE
  orcl2 partial
TRUE
FALSE
background_dump_dest orcl1 /u01/app/oracle/admin/orcl/bdump
FALSE
IMMEDIATE
  orcl2 /u01/app/oracle/admin/orcl/bdump
FALSE
IMMEDIATE
backup_tape_io_slaves orcl1 FALSE
TRUE
DEFERRED
  orcl2 FALSE
TRUE
DEFERRED
bitmap_merge_area_size orcl1 1048576
TRUE
FALSE
  orcl2 1048576
TRUE
FALSE
blank_trimming orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
buffer_pool_keep orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
buffer_pool_recycle orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
circuits orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
cluster_database orcl1 TRUE
FALSE
FALSE
  orcl2 TRUE
FALSE
FALSE
cluster_database_instances orcl1 2
FALSE
FALSE
  orcl2 2
FALSE
FALSE
cluster_interconnects orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
commit_point_strength orcl1 1
TRUE
FALSE
  orcl2 1
TRUE
FALSE
commit_write orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
compatible orcl1 10.2.0.3.0
FALSE
FALSE
  orcl2 10.2.0.3.0
FALSE
FALSE
control_file_record_keep_time orcl1 7
TRUE
IMMEDIATE
  orcl2 7
TRUE
IMMEDIATE
control_files orcl1 +ORCL_DATA1/orcl/controlfile/current.267.655480391 , +FLASH_RECOVERY_AREA/orcl/controlfile/current.653.655480391
FALSE
FALSE
  orcl2 +ORCL_DATA1/orcl/controlfile/current.267.655480391 , +FLASH_RECOVERY_AREA/orcl/controlfile/current.653.655480391
FALSE
FALSE
core_dump_dest orcl1 /u01/app/oracle/admin/orcl/cdump
FALSE
IMMEDIATE
  orcl2 /u01/app/oracle/admin/orcl/cdump
FALSE
IMMEDIATE
cpu_count orcl1 1
TRUE
IMMEDIATE
  orcl2 1
TRUE
IMMEDIATE
create_bitmap_area_size orcl1 8388608
TRUE
FALSE
  orcl2 8388608
TRUE
FALSE
create_stored_outlines orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
cursor_sharing orcl1 EXACT
TRUE
IMMEDIATE
  orcl2 EXACT
TRUE
IMMEDIATE
cursor_space_for_time orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
db_16k_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_2k_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_32k_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_4k_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_8k_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_block_buffers orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
db_block_checking orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
db_block_checksum orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
db_block_size orcl1 8192
FALSE
FALSE
  orcl2 8192
FALSE
FALSE
db_cache_advice orcl1 ON
TRUE
IMMEDIATE
  orcl2 ON
TRUE
IMMEDIATE
db_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_create_file_dest orcl1 +ORCL_DATA1
FALSE
IMMEDIATE
  orcl2 +ORCL_DATA1
FALSE
IMMEDIATE
db_create_online_log_dest_1 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
db_create_online_log_dest_2 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
db_create_online_log_dest_3 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
db_create_online_log_dest_4 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
db_create_online_log_dest_5 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
db_domain orcl1 idevelopment.info
FALSE
FALSE
  orcl2 idevelopment.info
FALSE
FALSE
db_file_multiblock_read_count orcl1 16
FALSE
IMMEDIATE
  orcl2 16
FALSE
IMMEDIATE
db_file_name_convert orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
db_files orcl1 200
TRUE
FALSE
  orcl2 200
TRUE
FALSE
db_flashback_retention_target orcl1 1440
TRUE
IMMEDIATE
  orcl2 1440
TRUE
IMMEDIATE
db_keep_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_name orcl1 orcl
FALSE
FALSE
  orcl2 orcl
FALSE
FALSE
db_recovery_file_dest orcl1 +FLASH_RECOVERY_AREA
FALSE
IMMEDIATE
  orcl2 +FLASH_RECOVERY_AREA
FALSE
IMMEDIATE
db_recovery_file_dest_size orcl1 220382363648
FALSE
IMMEDIATE
  orcl2 220382363648
FALSE
IMMEDIATE
db_recycle_cache_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
db_unique_name orcl1 orcl
TRUE
FALSE
  orcl2 orcl
TRUE
FALSE
db_writer_processes orcl1 1
TRUE
FALSE
  orcl2 1
TRUE
FALSE
dbwr_io_slaves orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
ddl_wait_for_locks orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
dg_broker_config_file1 orcl1 /u01/app/oracle/product/10.2.0/db_1/dbs/dr1orcl.dat
TRUE
IMMEDIATE
  orcl2 /u01/app/oracle/product/10.2.0/db_1/dbs/dr1orcl.dat
TRUE
IMMEDIATE
dg_broker_config_file2 orcl1 /u01/app/oracle/product/10.2.0/db_1/dbs/dr2orcl.dat
TRUE
IMMEDIATE
  orcl2 /u01/app/oracle/product/10.2.0/db_1/dbs/dr2orcl.dat
TRUE
IMMEDIATE
dg_broker_start orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
disk_asynch_io orcl1 TRUE
TRUE
FALSE
  orcl2 TRUE
TRUE
FALSE
dispatchers orcl1 (PROTOCOL=TCP) (SERVICE=orclXDB)
FALSE
IMMEDIATE
  orcl2 (PROTOCOL=TCP) (SERVICE=orclXDB)
FALSE
IMMEDIATE
distributed_lock_timeout orcl1 60
TRUE
FALSE
  orcl2 60
TRUE
FALSE
dml_locks orcl1 748
TRUE
FALSE
  orcl2 748
TRUE
FALSE
drs_start orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
event orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
fal_client orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
fal_server orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
fast_start_io_target orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
fast_start_mttr_target orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
fast_start_parallel_rollback orcl1 LOW
TRUE
IMMEDIATE
  orcl2 LOW
TRUE
IMMEDIATE
file_mapping orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
fileio_network_adapters orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
filesystemio_options orcl1 none
TRUE
FALSE
  orcl2 none
TRUE
FALSE
fixed_date orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
gc_files_to_locks orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
gcs_server_processes orcl1 1
TRUE
FALSE
  orcl2 1
TRUE
FALSE
global_context_pool_size orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
global_names orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
hash_area_size orcl1 131072
TRUE
FALSE
  orcl2 131072
TRUE
FALSE
hi_shared_memory_address orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
hs_autoregister orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
ifile orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
instance_groups orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
instance_name orcl1 orcl1
TRUE
FALSE
  orcl2 orcl2
TRUE
FALSE
instance_number orcl1 1
FALSE
FALSE
  orcl2 2
FALSE
FALSE
instance_type orcl1 RDBMS
TRUE
FALSE
  orcl2 RDBMS
TRUE
FALSE
java_max_sessionspace_size orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
java_pool_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
java_soft_sessionspace_limit orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
job_queue_processes orcl1 10
FALSE
IMMEDIATE
  orcl2 10
FALSE
IMMEDIATE
large_pool_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
ldap_directory_access orcl1 NONE
TRUE
IMMEDIATE
  orcl2 NONE
TRUE
IMMEDIATE
license_max_sessions orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
license_max_users orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
license_sessions_warning orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
local_listener orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
lock_name_space orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
lock_sga orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
log_archive_config orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_1 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_10 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_2 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_3 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_4 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_5 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_6 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_7 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_8 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_9 orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_dest_state_1 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_10 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_2 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_3 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_4 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_5 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_6 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_7 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_8 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_dest_state_9 orcl1 enable
TRUE
IMMEDIATE
  orcl2 enable
TRUE
IMMEDIATE
log_archive_duplex_dest orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
log_archive_format orcl1 %t_%s_%r.dbf
TRUE
FALSE
  orcl2 %t_%s_%r.dbf
TRUE
FALSE
log_archive_local_first orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
log_archive_max_processes orcl1 2
TRUE
IMMEDIATE
  orcl2 2
TRUE
IMMEDIATE
log_archive_min_succeed_dest orcl1 1
TRUE
IMMEDIATE
  orcl2 1
TRUE
IMMEDIATE
log_archive_start orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
log_archive_trace orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
log_buffer orcl1 2883584
TRUE
FALSE
  orcl2 2883584
TRUE
FALSE
log_checkpoint_interval orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
log_checkpoint_timeout orcl1 1800
TRUE
IMMEDIATE
  orcl2 1800
TRUE
IMMEDIATE
log_checkpoints_to_alert orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
log_file_name_convert orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
logmnr_max_persistent_sessions orcl1 1
TRUE
FALSE
  orcl2 1
TRUE
FALSE
max_commit_propagation_delay orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
max_dispatchers orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
max_dump_file_size orcl1 UNLIMITED
TRUE
IMMEDIATE
  orcl2 UNLIMITED
TRUE
IMMEDIATE
max_enabled_roles orcl1 150
TRUE
FALSE
  orcl2 150
TRUE
FALSE
max_shared_servers orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
nls_calendar orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_comp orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_currency orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_date_format orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_date_language orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_dual_currency orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_iso_currency orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_language orcl1 AMERICAN
TRUE
FALSE
  orcl2 AMERICAN
TRUE
FALSE
nls_length_semantics orcl1 BYTE
TRUE
IMMEDIATE
  orcl2 BYTE
TRUE
IMMEDIATE
nls_nchar_conv_excp orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
nls_numeric_characters orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_sort orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_territory orcl1 AMERICA
TRUE
FALSE
  orcl2 AMERICA
TRUE
FALSE
nls_time_format orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_time_tz_format orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_timestamp_format orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
nls_timestamp_tz_format orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
object_cache_max_size_percent orcl1 10
TRUE
DEFERRED
  orcl2 10
TRUE
DEFERRED
object_cache_optimal_size orcl1 102400
TRUE
DEFERRED
  orcl2 102400
TRUE
DEFERRED
olap_page_pool_size orcl1 0
TRUE
DEFERRED
  orcl2 0
TRUE
DEFERRED
open_cursors orcl1 300
FALSE
IMMEDIATE
  orcl2 300
FALSE
IMMEDIATE
open_links orcl1 4
TRUE
FALSE
  orcl2 4
TRUE
FALSE
open_links_per_instance orcl1 4
TRUE
FALSE
  orcl2 4
TRUE
FALSE
optimizer_dynamic_sampling orcl1 2
TRUE
IMMEDIATE
  orcl2 2
TRUE
IMMEDIATE
optimizer_features_enable orcl1 10.2.0.3
TRUE
IMMEDIATE
  orcl2 10.2.0.3
TRUE
IMMEDIATE
optimizer_index_caching orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
optimizer_index_cost_adj orcl1 100
TRUE
IMMEDIATE
  orcl2 100
TRUE
IMMEDIATE
optimizer_mode orcl1 ALL_ROWS
TRUE
IMMEDIATE
  orcl2 ALL_ROWS
TRUE
IMMEDIATE
optimizer_secure_view_merging orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
os_authent_prefix orcl1 ops$
TRUE
FALSE
  orcl2 ops$
TRUE
FALSE
os_roles orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
parallel_adaptive_multi_user orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
parallel_automatic_tuning orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
parallel_execution_message_size orcl1 2148
TRUE
FALSE
  orcl2 2148
TRUE
FALSE
parallel_instance_group orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
parallel_max_servers orcl1 20
TRUE
IMMEDIATE
  orcl2 20
TRUE
IMMEDIATE
parallel_min_percent orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
parallel_min_servers orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
parallel_server orcl1 TRUE
TRUE
FALSE
  orcl2 TRUE
TRUE
FALSE
parallel_server_instances orcl1 2
TRUE
FALSE
  orcl2 2
TRUE
FALSE
parallel_threads_per_cpu orcl1 2
TRUE
IMMEDIATE
  orcl2 2
TRUE
IMMEDIATE
pga_aggregate_target orcl1 201326592
FALSE
IMMEDIATE
  orcl2 201326592
FALSE
IMMEDIATE
plsql_ccflags orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
plsql_code_type orcl1 INTERPRETED
TRUE
IMMEDIATE
  orcl2 INTERPRETED
TRUE
IMMEDIATE
plsql_compiler_flags orcl1 INTERPRETED, NON_DEBUG
TRUE
IMMEDIATE
  orcl2 INTERPRETED, NON_DEBUG
TRUE
IMMEDIATE
plsql_debug orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
plsql_native_library_dir orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
plsql_native_library_subdir_count orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
plsql_optimize_level orcl1 2
TRUE
IMMEDIATE
  orcl2 2
TRUE
IMMEDIATE
plsql_v2_compatibility orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
plsql_warnings orcl1 DISABLE:ALL
TRUE
IMMEDIATE
  orcl2 DISABLE:ALL
TRUE
IMMEDIATE
pre_page_sga orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
processes orcl1 150
FALSE
FALSE
  orcl2 150
FALSE
FALSE
query_rewrite_enabled orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
query_rewrite_integrity orcl1 enforced
TRUE
IMMEDIATE
  orcl2 enforced
TRUE
IMMEDIATE
rdbms_server_dn orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
read_only_open_delayed orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
recovery_parallelism orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
recyclebin orcl1 on
TRUE
IMMEDIATE
  orcl2 on
TRUE
IMMEDIATE
remote_archive_enable orcl1 true
TRUE
FALSE
  orcl2 true
TRUE
FALSE
remote_dependencies_mode orcl1 TIMESTAMP
TRUE
IMMEDIATE
  orcl2 TIMESTAMP
TRUE
IMMEDIATE
remote_listener orcl1 LISTENERS_ORCL
FALSE
IMMEDIATE
  orcl2 LISTENERS_ORCL
FALSE
IMMEDIATE
remote_login_passwordfile orcl1 EXCLUSIVE
FALSE
FALSE
  orcl2 EXCLUSIVE
FALSE
FALSE
remote_os_authent orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
remote_os_roles orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
replication_dependency_tracking orcl1 TRUE
TRUE
FALSE
  orcl2 TRUE
TRUE
FALSE
resource_limit orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
resource_manager_plan orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
resumable_timeout orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
rollback_segments orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
serial_reuse orcl1 disable
TRUE
FALSE
  orcl2 disable
TRUE
FALSE
service_names orcl1 SYS$SYS.KUPC$C_1_20080601182203.ORCL.IDEVELOPMENT.INFO, orcl_taf, orcl.idev elopment.info, SYS$SYS.KUPC$S_1_20080601182203.ORCL.IDEVELOPMENT.INFO
TRUE
IMMEDIATE
  orcl2 orcl.idevelopment.info, orcl_taf
TRUE
IMMEDIATE
session_cached_cursors orcl1 20
TRUE
FALSE
  orcl2 20
TRUE
FALSE
session_max_open_files orcl1 10
TRUE
FALSE
  orcl2 10
TRUE
FALSE
sessions orcl1 170
TRUE
FALSE
  orcl2 170
TRUE
FALSE
sga_max_size orcl1 608174080
TRUE
FALSE
  orcl2 608174080
TRUE
FALSE
sga_target orcl1 608174080
FALSE
IMMEDIATE
  orcl2 608174080
FALSE
IMMEDIATE
shadow_core_dump orcl1 partial
TRUE
FALSE
  orcl2 partial
TRUE
FALSE
shared_memory_address orcl1 0
TRUE
FALSE
  orcl2 0
TRUE
FALSE
shared_pool_reserved_size orcl1 9856614
TRUE
FALSE
  orcl2 6501171
TRUE
FALSE
shared_pool_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
shared_server_sessions orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
shared_servers orcl1 1
TRUE
IMMEDIATE
  orcl2 1
TRUE
IMMEDIATE
skip_unusable_indexes orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
smtp_out_server orcl1  
TRUE
IMMEDIATE
  orcl2  
TRUE
IMMEDIATE
sort_area_retained_size orcl1 0
TRUE
DEFERRED
  orcl2 0
TRUE
DEFERRED
sort_area_size orcl1 65536
TRUE
DEFERRED
  orcl2 65536
TRUE
DEFERRED
spfile orcl1 +ORCL_DATA1/orcl/spfileorcl.ora
FALSE
FALSE
  orcl2 +ORCL_DATA1/orcl/spfileorcl.ora
FALSE
FALSE
sql92_security orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
sql_trace orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
sql_version orcl1 NATIVE
TRUE
FALSE
  orcl2 NATIVE
TRUE
FALSE
sqltune_category orcl1 DEFAULT
TRUE
IMMEDIATE
  orcl2 DEFAULT
TRUE
IMMEDIATE
standby_archive_dest orcl1 ?/dbs/arch
TRUE
IMMEDIATE
  orcl2 ?/dbs/arch
TRUE
IMMEDIATE
standby_file_management orcl1 MANUAL
TRUE
IMMEDIATE
  orcl2 MANUAL
TRUE
IMMEDIATE
star_transformation_enabled orcl1 FALSE
TRUE
IMMEDIATE
  orcl2 FALSE
TRUE
IMMEDIATE
statistics_level orcl1 TYPICAL
TRUE
IMMEDIATE
  orcl2 TYPICAL
TRUE
IMMEDIATE
streams_pool_size orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
tape_asynch_io orcl1 TRUE
TRUE
FALSE
  orcl2 TRUE
TRUE
FALSE
thread orcl1 1
FALSE
IMMEDIATE
  orcl2 2
FALSE
IMMEDIATE
timed_os_statistics orcl1 0
TRUE
IMMEDIATE
  orcl2 0
TRUE
IMMEDIATE
timed_statistics orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
trace_enabled orcl1 TRUE
TRUE
IMMEDIATE
  orcl2 TRUE
TRUE
IMMEDIATE
tracefile_identifier orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
transactions orcl1 187
TRUE
FALSE
  orcl2 187
TRUE
FALSE
transactions_per_rollback_segment orcl1 5
TRUE
FALSE
  orcl2 5
TRUE
FALSE
undo_management orcl1 AUTO
FALSE
FALSE
  orcl2 AUTO
FALSE
FALSE
undo_retention orcl1 900
TRUE
IMMEDIATE
  orcl2 900
TRUE
IMMEDIATE
undo_tablespace orcl1 UNDOTBS1
FALSE
IMMEDIATE
  orcl2 UNDOTBS2
FALSE
IMMEDIATE
use_indirect_data_buffers orcl1 FALSE
TRUE
FALSE
  orcl2 FALSE
TRUE
FALSE
user_dump_dest orcl1 /u01/app/oracle/admin/orcl/udump
FALSE
IMMEDIATE
  orcl2 /u01/app/oracle/admin/orcl/udump
FALSE
IMMEDIATE
utl_file_dir orcl1  
TRUE
FALSE
  orcl2  
TRUE
FALSE
workarea_size_policy orcl1 AUTO
TRUE
IMMEDIATE
  orcl2 AUTO
TRUE
IMMEDIATE

[Top]



Control Files



Controlfile Name Status File Size
+FLASH_RECOVERY_AREA/orcl/controlfile/current.653.655480391
VALID
18,874,368
+ORCL_DATA1/orcl/controlfile/current.267.655480391
VALID
18,874,368

[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 2,766 1,615,344 1,810 1,057,040 65 1 1810 1810
BACKUP CORRUPTION
44 1,115 49,060 0 0   0 0 0
BACKUP DATAFILE
116 1,128 130,848 113 13,108 10 1 113 113
BACKUP PIECE
736 1,000 736,000 100 73,600 10 1 100 100
BACKUP REDOLOG
76 1,479 112,404 1,479 112,404 100 210 209 1688
BACKUP SET
40 1,227 49,080 73 2,920 6 1 73 73
BACKUP SPFILE
36 454 16,344 14 504 3 1 14 14
CKPT PROGRESS
8,180 35 286,300 0 0   0 0 0
COPY CORRUPTION
40 1,227 49,080 0 0   0 0 0
DATABASE INCARNATION
56 292 16,352 1 56   1 1 1
DATABASE
316 1 316 1 316 100 0 0 0
DATAFILE COPY
660 1,016 670,560 0 0   0 0 0
DATAFILE HISTORY
568 57 32,376 0 0   0 0 0
DATAFILE
428 1,024 438,272 11 4,708 1 0 0 959
DELETED OBJECT
20 1,636 32,720 1,636 32,720 100 229 228 1864
FILENAME
524 4,674 2,449,176 637 333,788 14 0 0 0
FLASHBACK LOG
84 2,048 172,032 617 51,828 30 0 0 0
GUARANTEED RESTORE POINT
212 2,048 434,176 0 0   0 0 0
INSTANCE SPACE RESERVATION
28 1,055 29,540 2 56   0 0 0
LOG HISTORY
56 1,486 83,216 1,486 83,216 100 354 353 1839
MTTR
100 32 3,200 2 200 6 0 0 0
OFFLINE RANGE
200 1,063 212,600 0 0   0 0 0
PROXY COPY
852 1,017 866,484 0 0   0 0 0
RECOVERY DESTINATION
180 1 180 1 180 100 0 0 0
REDO LOG
72 192 13,824 4 288 2 0 0 4
REDO THREAD
256 32 8,192 2 512 6 0 0 2
REMOVABLE RECOVERY FILES
32 1,000 32,000 0 0   0 0 0
RESTORE POINT
212 2,083 441,596 0 0   0 0 0
RMAN CONFIGURATION
1,108 50 55,400 2 2,216 4 0 0 2
RMAN STATUS
116 141 16,356 66 7,656 47 1 66 66
STANDBY DATABASE MATRIX
400 10 4,000 10 4,000 100 0 0 0
TABLESPACE
68 1,024 69,632 11 748 1 0 0 11
TEMPORARY FILENAME
56 1,024 57,344 1 56   0 0 1
THREAD INSTANCE NAME MAPPING
80 32 2,560 32 2,560 100 0 0 0
  ----------- ----------------- --------------- ------------ ------------ ------      
Average:           27      
Total: 16,536 33,469 9,186,564 8,111 1,784,680        

[Top]



Online Redo Logs



Instance Name Thread Number Group Number Member Redo Type Log Status Bytes Archived?
orcl1
1
1 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.546.655480393 ONLINE
CURRENT
52,428,800
NO
    1 +ORCL_DATA1/orcl/onlinelog/group_1.896.655480393 ONLINE
CURRENT
52,428,800
NO
    2 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_2.687.655480395 ONLINE
INACTIVE
52,428,800
YES
    2 +ORCL_DATA1/orcl/onlinelog/group_2.890.655480395 ONLINE
INACTIVE
52,428,800
YES
orcl2
2
3 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_3.685.655483413 ONLINE
INACTIVE
52,428,800
YES
    3 +ORCL_DATA1/orcl/onlinelog/group_3.814.655483413 ONLINE
INACTIVE
52,428,800
YES
    4 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_4.684.655483417 ONLINE
CURRENT
52,428,800
NO
    4 +ORCL_DATA1/orcl/onlinelog/group_4.806.655483415 ONLINE
CURRENT
52,428,800
NO

[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
05/25
          2 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 146
05/26
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 196
05/27
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 196
05/28
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 8 11 9 8 201
05/29
10 9 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 8 200
05/30
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 9 198
05/31
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 11 199
06/01
8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 8 8 8 2           150
                                                  ------------
Average:                                                 186
Total:                                                 1,486

[Top]



Outstanding Alerts



Severity Target Name Target Type Category Name Message Alert Triggered
Warning
orcl.idevelopment.info_orcl2 Database Instance User Audit Audited User User SYS logged on from linux2.
05/23/2008 14:52:38
Warning
orcl.idevelopment.info_orcl1 Database Instance User Audit Audited User User SYS logged on from linux1.
05/23/2008 15:12:45

[Top]



Statistics Level



"Automatic Database Management" was first introduced in Oracle10g where the Oracle database
can now automatically perform many of the routine monitoring and administrative activities that had
to be manually executed by the DBA in previous versions. Several of the new components that make
up this new feature include (1) Automatic Workload Repository (2) Automatic Database Diagnostic
Monitoring (3) Automatic Shared Memory Management and (4) Automatic UNDO Retention Tuning. All
of these new components can only be enabled when the STATISTICS_LEVEL initialization parameter
is set to TYPICAL (the default) or ALL. A value of BASIC turns off these components and disables
all self-tuning capabilities of the database. The view V$STATISTICS_LEVEL shows the statistic
component, description, and at what level of the STATISTICS_LEVEL parameter the
component is enabled.

Instance Name Statistics Name Session Status System Status Activation Level Statistics View Name Session Settable?
orcl1
Active Session History
ENABLED
ENABLED
TYPICAL
V$ACTIVE_SESSION_HISTORY
NO
 
Bind Data Capture
ENABLED
ENABLED
TYPICAL
V$SQL_BIND_CAPTURE
NO
 
Buffer Cache Advice
ENABLED
ENABLED
TYPICAL
V$DB_CACHE_ADVICE
NO
 
Global Cache Statistics
ENABLED
ENABLED
TYPICAL
 
NO
 
Longops Statistics
ENABLED
ENABLED
TYPICAL
V$SESSION_LONGOPS
NO
 
MTTR Advice
ENABLED
ENABLED
TYPICAL
V$MTTR_TARGET_ADVICE
NO
 
Modification Monitoring
ENABLED
ENABLED
TYPICAL
 
NO
 
PGA Advice
ENABLED
ENABLED
TYPICAL
V$PGA_TARGET_ADVICE
NO
 
Plan Execution Statistics
DISABLED
DISABLED
ALL
V$SQL_PLAN_STATISTICS
YES
 
Segment Level Statistics
ENABLED
ENABLED
TYPICAL
V$SEGSTAT
NO
 
Shared Pool Advice
ENABLED
ENABLED
TYPICAL
V$SHARED_POOL_ADVICE
NO
 
Streams Pool Advice
ENABLED
ENABLED
TYPICAL
V$STREAMS_POOL_ADVICE
NO
 
Threshold-based Alerts
ENABLED
ENABLED
TYPICAL
 
NO
 
Timed OS Statistics
DISABLED
DISABLED
ALL
 
YES
 
Timed Statistics
ENABLED
ENABLED
TYPICAL
 
YES
 
Ultrafast Latch Statistics
ENABLED
ENABLED
TYPICAL
 
NO
 
Undo Advisor, Alerts and Fast Ramp up
ENABLED
ENABLED
TYPICAL
V$UNDOSTAT
NO
orcl2
Active Session History
ENABLED
ENABLED
TYPICAL
V$ACTIVE_SESSION_HISTORY
NO
 
Bind Data Capture
ENABLED
ENABLED
TYPICAL
V$SQL_BIND_CAPTURE
NO
 
Buffer Cache Advice
ENABLED
ENABLED
TYPICAL
V$DB_CACHE_ADVICE
NO
 
Global Cache Statistics
ENABLED
ENABLED
TYPICAL
 
NO
 
Longops Statistics
ENABLED
ENABLED
TYPICAL
V$SESSION_LONGOPS
NO
 
MTTR Advice
ENABLED
ENABLED
TYPICAL
V$MTTR_TARGET_ADVICE
NO
 
Modification Monitoring
ENABLED
ENABLED
TYPICAL
 
NO
 
PGA Advice
ENABLED
ENABLED
TYPICAL
V$PGA_TARGET_ADVICE
NO
 
Plan Execution Statistics
DISABLED
DISABLED
ALL
V$SQL_PLAN_STATISTICS
YES
 
Segment Level Statistics
ENABLED
ENABLED
TYPICAL
V$SEGSTAT
NO
 
Shared Pool Advice
ENABLED
ENABLED
TYPICAL
V$SHARED_POOL_ADVICE
NO
 
Streams Pool Advice
ENABLED
ENABLED
TYPICAL
V$STREAMS_POOL_ADVICE
NO
 
Threshold-based Alerts
ENABLED
ENABLED
TYPICAL
 
NO
 
Timed OS Statistics
DISABLED
DISABLED
ALL
 
YES
 
Timed Statistics
ENABLED
ENABLED
TYPICAL
 
YES
 
Ultrafast Latch Statistics
ENABLED
ENABLED
TYPICAL
 
NO
 
Undo Advisor, Alerts and Fast Ramp up
ENABLED
ENABLED
TYPICAL
V$UNDOSTAT
NO

[Top]



Scheduler / Jobs


Jobs

Job ID User What Next Run Date Interval Last Run Date Failures Broken?
4
SYS wksys.wk_job.invoke(2,4);
06/01/2008 19:00:00
wk_job.next_time('HH0001')
06/01/2008 18:00:01
0
N
5
SYS wksys.wk_job.invoke(2,5);
06/08/2008 01:00:00
wk_job.next_time('DY0701')
06/01/2008 01:00:05
0
N
7
SYSMAN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
06/01/2008 18:29:31
sysdate + 1 / (24 * 60)
06/01/2008 18:28:31
0
N
8
SCOTT CALCULATE_NDS_COSTS;
01/01/4000 00:00:00
TRUNC(sysdate,'HH24')+((FLOOR(TO_NUMBER(TO_CHAR(sy sdate,'MI'))/30)+1)*30)/(24*60)

16
Y
10
SCOTT dbms_refresh.refresh('"SCOTT"."SEGMENTS_RG"');
06/02/2008 15:15:02
/*24:Hr*/sysdate + 24/24
06/01/2008 15:15:02
0
N

[Top]



Storage


Tablespaces

Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Free (in bytes) Used (in bytes) Pct. Used
ONLINE
EXAMPLE PERMANENT LOCAL AUTO 157,286,400 73,465,856 83,820,544
53 %
ONLINE
NDS_DATA PERMANENT LOCAL AUTO 524,288,000 524,222,464 65,536
0 %
OFFLINE
REPORTS PERMANENT LOCAL AUTO 0 0 0
0 %
ONLINE
SOE PERMANENT LOCAL AUTO 3,221,225,472 1,547,599,872 1,673,625,600
51 %
ONLINE
SOEINDEX PERMANENT LOCAL AUTO 5,368,709,120 1,530,773,504 3,837,935,616
71 %
ONLINE
SYSAUX PERMANENT LOCAL AUTO 1,373,634,560 4,915,200 1,368,719,360
99 %
ONLINE
SYSTEM PERMANENT LOCAL MANUAL 534,773,760 6,356,992 528,416,768
98 %
ONLINE
TEMP TEMPORARY LOCAL MANUAL 1,073,741,824 574,619,648 499,122,176
46 %
ONLINE
UNDOTBS1 UNDO LOCAL MANUAL 225,443,840 195,756,032 29,687,808
13 %
ONLINE
UNDOTBS2 UNDO LOCAL MANUAL 209,715,200 184,221,696 25,493,504
12 %
ONLINE
USERS PERMANENT LOCAL AUTO 10,737,418,240 9,139,453,952 1,597,964,288
14 %
          -------------------- -------------------- --------------------  
Total:         23,426,236,416 13,781,385,216 9,644,851,200  

[Top]



Data Files



Tablespace Name / File Class Filename File Size Autoextensible Next Max
EXAMPLE +ORCL_DATA1/orcl/datafile/example.848.655480423 157,286,400
YES
655,360 34,359,721,984
NDS_DATA +ORCL_DATA1/orcl/datafile/nds_data.761.656273589 524,288,000
YES
106,496 8,589,934,592
REPORTS +ORCL_DATA1/orcl/datafile/reports.796.655484761  

   
SOE +ORCL_DATA1/orcl/datafile/soe.794.655486311 3,221,225,472
YES
52,428,800 8,589,934,592
SOEINDEX +ORCL_DATA1/orcl/datafile/soeindex.775.655486339 5,368,709,120
YES
52,428,800 8,589,934,592
SYSAUX +ORCL_DATA1/orcl/datafile/sysaux.863.655480415 1,373,634,560
YES
10,485,760 34,359,721,984
SYSTEM +ORCL_DATA1/orcl/datafile/system.888.655480397 534,773,760
YES
10,485,760 34,359,721,984
TEMP +ORCL_DATA1/orcl/tempfile/temp.857.655480419 1,073,741,824
YES
655,360 34,359,721,984
UNDOTBS1 +ORCL_DATA1/orcl/datafile/undotbs1.884.655480411 225,443,840
YES
5,242,880 34,359,721,984
UNDOTBS2 +ORCL_DATA1/orcl/datafile/undotbs2.837.655480427 209,715,200
YES
5,242,880 34,359,721,984
USERS +ORCL_DATA1/orcl/datafile/users.753.656274021 2,147,483,648
YES
104,857,600 9,663,676,416
USERS +ORCL_DATA1/orcl/datafile/users.826.655480429 8,589,934,592
YES
104,857,600 9,663,676,416
[ CONTROL FILE ] +FLASH_RECOVERY_AREA/orcl/controlfile/current.653.655480391        
[ CONTROL FILE ] +ORCL_DATA1/orcl/controlfile/current.267.655480391        
[ ONLINE REDO LOG ] +FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.546.655480393 52,428,800      
[ ONLINE REDO LOG ] +FLASH_RECOVERY_AREA/orcl/onlinelog/group_2.687.655480395 52,428,800      
[ ONLINE REDO LOG ] +FLASH_RECOVERY_AREA/orcl/onlinelog/group_3.685.655483413 52,428,800      
[ ONLINE REDO LOG ] +FLASH_RECOVERY_AREA/orcl/onlinelog/group_4.684.655483417 52,428,800      
[ ONLINE REDO LOG ] +ORCL_DATA1/orcl/onlinelog/group_1.896.655480393 52,428,800      
[ ONLINE REDO LOG ] +ORCL_DATA1/orcl/onlinelog/group_2.890.655480395 52,428,800      
[ ONLINE REDO LOG ] +ORCL_DATA1/orcl/onlinelog/group_3.814.655483413 52,428,800      
[ ONLINE REDO LOG ] +ORCL_DATA1/orcl/onlinelog/group_4.806.655483415 52,428,800      
    --------------------      
Total:   23,845,666,816      

[Top]



Database Growth



Month Growth (bytes)
2008-05
19,680,722,944
2008-06
2,671,771,648
  --------------------
Total: 22,352,494,592

[Top]



Tablespace Extents



Tablespace Name Largest Extent Smallest Extent Total Free Number of Free Extents
EXAMPLE 73,465,856 73,465,856 73,465,856 1
NDS_DATA 524,222,464 524,222,464 524,222,464 1
SOE 1,547,599,872 1,547,599,872 1,547,599,872 1
SOEINDEX 1,530,773,504 1,530,773,504 1,530,773,504 1
SYSAUX 4,128,768 65,536 4,915,200 3
SYSTEM 6,225,920 131,072 6,356,992 2
UNDOTBS1 194,969,600 65,536 195,756,032 3
UNDOTBS2 176,095,232 65,536 184,221,696 15
USERS 4,160,749,568 65,536 9,139,453,952 73
  -------------------- -------------------- -------------------- ----------------------
Total: 8,218,230,784 3,676,454,912 13,206,765,568 100

[Top]



Tablespace to Owner



Tablespace Name Owner Segment Type Size (in Bytes) Segment Count
EXAMPLE
HR
INDEX
1,245,184 19
 
HR
TABLE
393,216 6
 
IX
INDEX
917,504 14
 
IX
LOBINDEX
196,608 3
 
IX
LOBSEGMENT
196,608 3
 
IX
TABLE
393,216 6
 
OE
INDEX
3,080,192 31
 
OE
LOBINDEX
983,040 15
 
OE
LOBSEGMENT
983,040 15
 
OE
NESTED TABLE
131,072 2
 
OE
TABLE
4,063,232 12
 
PM
INDEX
196,608 3
 
PM
LOBINDEX
1,114,112 17
 
PM
LOBSEGMENT
10,944,512 17
 
PM
NESTED TABLE
65,536 1
 
PM
TABLE
131,072 2
 
SH
INDEX PARTITION
17,170,432 196
 
SH
INDEX
2,490,368 19
 
SH
LOBINDEX
131,072 2
 
SH
LOBSEGMENT
131,072 2
 
SH
TABLE PARTITION
19,922,944 56
 
SH
TABLE
18,874,368 12
SOE
SOE
INDEX
532,480 2
 
SOE
TABLE
1,672,945,664 8
SOEINDEX
SOE
INDEX
3,837,796,352 21
SYSAUX
CTXSYS
INDEX
3,014,656 46
 
CTXSYS
LOBINDEX
65,536 1
 
CTXSYS
LOBSEGMENT
65,536 1
 
CTXSYS
TABLE
1,703,936 26
 
DBSNMP
INDEX
524,288 8
 
DBSNMP
TABLE
1,114,112 17
 
DMSYS
INDEX
131,072 2
 
DMSYS
TABLE
131,072 2
 
EXFSYS
INDEX
2,359,296 36
 
EXFSYS
LOBINDEX
131,072 2
 
EXFSYS
LOBSEGMENT
131,072 2
 
EXFSYS
TABLE
1,179,648 18
 
MDSYS
INDEX
4,390,912 53
 
MDSYS
LOBINDEX
1,310,720 19
 
MDSYS
LOBSEGMENT
20,185,088 19
 
MDSYS
TABLE
8,454,144 40
 
OLAPSYS
INDEX
8,847,360 135
 
OLAPSYS
TABLE
7,471,104 114
 
ORDSYS
INDEX
262,144 4
 
ORDSYS
TABLE
262,144 4
 
SYS
INDEX PARTITION
396,820,480 195
 
SYS
INDEX
132,644,864 223
 
SYS
LOB PARTITION
65,536 1
 
SYS
LOBINDEX
2,752,512 41
 
SYS
LOBSEGMENT
28,639,232 41
 
SYS
NESTED TABLE
65,536 1
 
SYS
TABLE PARTITION
424,280,064 185
 
SYS
TABLE
146,800,640 187
 
SYSMAN
INDEX
50,724,864 396
 
SYSMAN
LOBINDEX
1,835,008 28
 
SYSMAN
LOBSEGMENT
1,835,008 28
 
SYSMAN
NESTED TABLE
131,072 2
 
SYSMAN
TABLE
34,275,328 312
 
SYSTEM
INDEX PARTITION
2,097,152 32
 
SYSTEM
INDEX
917,504 14
 
SYSTEM
LOBINDEX
458,752 7
 
SYSTEM
LOBSEGMENT
458,752 7
 
SYSTEM
TABLE PARTITION
1,769,472 27
 
SYSTEM
TABLE
1,441,792 22
 
TSMSYS
INDEX
65,536 1
 
TSMSYS
LOBINDEX
65,536 1
 
TSMSYS
LOBSEGMENT
65,536 1
 
TSMSYS
TABLE
65,536 1
 
WKSYS
INDEX
5,177,344 79
 
WKSYS
TABLE
2,621,440 40
 
WK_TEST
INDEX
6,553,600 21
 
WK_TEST
LOBINDEX
131,072 2
 
WK_TEST
LOBSEGMENT
131,072 2
 
WK_TEST
TABLE
5,767,168 9
 
WMSYS
INDEX
3,735,552 57
 
WMSYS
LOBINDEX
524,288 8
 
WMSYS
LOBSEGMENT
524,288 8
 
WMSYS
NESTED TABLE
131,072 2
 
WMSYS
TABLE
2,293,760 35
 
XDB
INDEX
3,473,408 50
 
XDB
LOBINDEX
21,889,024 334
 
XDB
LOBSEGMENT
21,889,024 334
 
XDB
TABLE
3,801,088 35
SYSTEM
LBACSYS
INDEX
1,835,008 28
 
LBACSYS
LOBINDEX
65,536 1
 
LBACSYS
LOBSEGMENT
65,536 1
 
LBACSYS
TABLE
1,376,256 21
 
OUTLN
INDEX
196,608 3
 
OUTLN
LOBINDEX
65,536 1
 
OUTLN
LOBSEGMENT
65,536 1
 
OUTLN
TABLE
196,608 3
 
SYS
CLUSTER
47,251,456 10
 
SYS
DEFERRED ROLLBACK
65,536 1
 
SYS
INDEX
136,380,416 464
 
SYS
LOBINDEX
4,128,768 63
 
SYS
LOBSEGMENT
7,995,392 63
 
SYS
NESTED TABLE
393,216 6
 
SYS
ROLLBACK
393,216 1
 
SYS
TABLE
311,361,536 391
 
SYSTEM
INDEX
8,519,680 130
 
SYSTEM
LOBINDEX
1,114,112 17
 
SYSTEM
LOBSEGMENT
1,114,112 17
 
SYSTEM
TABLE
5,767,168 88
UNDOTBS1
SYS
TYPE2 UNDO
29,622,272 10
UNDOTBS2
SYS
TYPE2 UNDO
25,427,968 10
USERS
APPS
LOBINDEX
262,144 4
 
APPS
LOBSEGMENT
262,144 4
 
APPS
TABLE
131,072 2
 
BACKUP_ADMIN
INDEX
983,040 2
 
BACKUP_ADMIN
LOBINDEX
65,536 1
 
BACKUP_ADMIN
LOBSEGMENT
9,437,184 1
 
BACKUP_ADMIN
TABLE
3,145,728 1
 
REPORTS
INDEX
2,228,224 2
 
REPORTS
TABLE
3,342,336 2
 
SCOTT
TABLE
1,598,226,432 8
***************************************************************************     -------------------- ----------------
Total:     9,165,168,640 5,159

[Top]



Owner to Tablespace



Owner Tablespace Name Segment Type Size (in Bytes) Segment Count
APPS
USERS
LOBINDEX
262,144 4
 
USERS
LOBSEGMENT
262,144 4
 
USERS
TABLE
131,072 2
BACKUP_ADMIN
USERS
INDEX
983,040 2
 
USERS
LOBINDEX
65,536 1
 
USERS
LOBSEGMENT
9,437,184 1
 
USERS
TABLE
3,145,728 1
CTXSYS
SYSAUX
INDEX
3,014,656 46
 
SYSAUX
LOBINDEX
65,536 1
 
SYSAUX
LOBSEGMENT
65,536 1
 
SYSAUX
TABLE
1,703,936 26
DBSNMP
SYSAUX
INDEX
524,288 8
 
SYSAUX
TABLE
1,114,112 17
DMSYS
SYSAUX
INDEX
131,072 2
 
SYSAUX
TABLE
131,072 2
EXFSYS
SYSAUX
INDEX
2,359,296 36
 
SYSAUX
LOBINDEX
131,072 2
 
SYSAUX
LOBSEGMENT
131,072 2
 
SYSAUX
TABLE
1,179,648 18
HR
EXAMPLE
INDEX
1,245,184 19
 
EXAMPLE
TABLE
393,216 6
IX
EXAMPLE
INDEX
917,504 14
 
EXAMPLE
LOBINDEX
196,608 3
 
EXAMPLE
LOBSEGMENT
196,608 3
 
EXAMPLE
TABLE
393,216 6
LBACSYS
SYSTEM
INDEX
1,835,008 28
 
SYSTEM
LOBINDEX
65,536 1
 
SYSTEM
LOBSEGMENT
65,536 1
 
SYSTEM
TABLE
1,376,256 21
MDSYS
SYSAUX
INDEX
4,390,912 53
 
SYSAUX
LOBINDEX
1,310,720 19
 
SYSAUX
LOBSEGMENT
20,185,088 19
 
SYSAUX
TABLE
8,454,144 40
OE
EXAMPLE
INDEX
3,080,192 31
 
EXAMPLE
LOBINDEX
983,040 15
 
EXAMPLE
LOBSEGMENT
983,040 15
 
EXAMPLE
NESTED TABLE
131,072 2
 
EXAMPLE
TABLE
4,063,232 12
OLAPSYS
SYSAUX
INDEX
8,847,360 135
 
SYSAUX
TABLE
7,471,104 114
ORDSYS
SYSAUX
INDEX
262,144 4
 
SYSAUX
TABLE
262,144 4
OUTLN
SYSTEM
INDEX
196,608 3
 
SYSTEM
LOBINDEX
65,536 1
 
SYSTEM
LOBSEGMENT
65,536 1
 
SYSTEM
TABLE
196,608 3
PM
EXAMPLE
INDEX
196,608 3
 
EXAMPLE
LOBINDEX
1,114,112 17
 
EXAMPLE
LOBSEGMENT
10,944,512 17
 
EXAMPLE
NESTED TABLE
65,536 1
 
EXAMPLE
TABLE
131,072 2
REPORTS
USERS
INDEX
2,228,224 2
 
USERS
TABLE
3,342,336 2
SCOTT
USERS
TABLE
1,598,226,432 8
SH
EXAMPLE
INDEX PARTITION
17,170,432 196
 
EXAMPLE
INDEX
2,490,368 19
 
EXAMPLE
LOBINDEX
131,072 2
 
EXAMPLE
LOBSEGMENT
131,072 2
 
EXAMPLE
TABLE PARTITION
19,922,944 56
 
EXAMPLE
TABLE
18,874,368 12
SOE
SOE
INDEX
532,480 2
 
SOE
TABLE
1,672,945,664 8
 
SOEINDEX
INDEX
3,837,796,352 21
SYS
SYSAUX
INDEX PARTITION
396,820,480 195
 
SYSAUX
INDEX
132,644,864 223
 
SYSAUX
LOB PARTITION
65,536 1
 
SYSAUX
LOBINDEX
2,752,512 41
 
SYSAUX
LOBSEGMENT
28,639,232 41
 
SYSAUX
NESTED TABLE
65,536 1
 
SYSAUX
TABLE PARTITION
424,280,064 185
 
SYSAUX
TABLE
146,800,640 187
 
SYSTEM
CLUSTER
47,251,456 10
 
SYSTEM
DEFERRED ROLLBACK
65,536 1
 
SYSTEM
INDEX
136,380,416 464
 
SYSTEM
LOBINDEX
4,128,768 63
 
SYSTEM
LOBSEGMENT
7,995,392 63
 
SYSTEM
NESTED TABLE
393,216 6
 
SYSTEM
ROLLBACK
393,216 1
 
SYSTEM
TABLE
311,361,536 391
 
UNDOTBS1
TYPE2 UNDO
29,622,272 10
 
UNDOTBS2
TYPE2 UNDO
25,427,968 10
SYSMAN
SYSAUX
INDEX
50,724,864 396
 
SYSAUX
LOBINDEX
1,835,008 28
 
SYSAUX
LOBSEGMENT
1,835,008 28
 
SYSAUX
NESTED TABLE
131,072 2
 
SYSAUX
TABLE
34,275,328 312
SYSTEM
SYSAUX
INDEX PARTITION
2,097,152 32
 
SYSAUX
INDEX
917,504 14
 
SYSAUX
LOBINDEX
458,752 7
 
SYSAUX
LOBSEGMENT
458,752 7
 
SYSAUX
TABLE PARTITION
1,769,472 27
 
SYSAUX
TABLE
1,441,792 22
 
SYSTEM
INDEX
8,519,680 130
 
SYSTEM
LOBINDEX
1,114,112 17
 
SYSTEM
LOBSEGMENT
1,114,112 17
 
SYSTEM
TABLE
5,767,168 88
TSMSYS
SYSAUX
INDEX
65,536 1
 
SYSAUX
LOBINDEX
65,536 1
 
SYSAUX
LOBSEGMENT
65,536 1
 
SYSAUX
TABLE
65,536 1
WKSYS
SYSAUX
INDEX
5,177,344 79
 
SYSAUX
TABLE
2,621,440 40
WK_TEST
SYSAUX
INDEX
6,553,600 21
 
SYSAUX
LOBINDEX
131,072 2
 
SYSAUX
LOBSEGMENT
131,072 2
 
SYSAUX
TABLE
5,767,168 9
WMSYS
SYSAUX
INDEX
3,735,552 57
 
SYSAUX
LOBINDEX
524,288 8
 
SYSAUX
LOBSEGMENT
524,288 8
 
SYSAUX
NESTED TABLE
131,072 2
 
SYSAUX
TABLE
2,293,760 35
XDB
SYSAUX
INDEX
3,473,408 50
 
SYSAUX
LOBINDEX
21,889,024 334
 
SYSAUX
LOBSEGMENT
21,889,024 334
 
SYSAUX
TABLE
3,801,088 35
***************************************************************************     -------------------- ----------------
Total:     9,165,168,640 5,159

[Top]



UNDO Segments


UNDO Retention Parameters

undo_retention is specified in minutes

Instance Name Thread Number Name Value
orcl1
1
undo_management
AUTO
   
undo_retention
15
   
undo_tablespace
UNDOTBS1
orcl2
2
undo_management
AUTO
   
undo_retention
15
   
undo_tablespace
UNDOTBS2

[Top]



UNDO Segments



Instance Name Tablspace UNDO Segment Name Init/Next Extents Min/Max Extents Status Bytes Extents Shrinks Wraps Opt. Size

SYSTEM
SYS.SYSTEM
114688 /
1 / 32765
ONLINE
393,216 6 0 0  
orcl1
UNDOTBS1
PUBLIC._SYSSMU1$
131072 /
2 / 32765
ONLINE
3,276,800 5 21 500  
   
PUBLIC._SYSSMU10$
131072 /
2 / 32765
ONLINE
3,276,800 5 20 469  
   
PUBLIC._SYSSMU2$
131072 /
2 / 32765
ONLINE
3,276,800 5 22 503  
   
PUBLIC._SYSSMU3$
131072 /
2 / 32765
ONLINE
3,276,800 5 20 490  
   
PUBLIC._SYSSMU4$
131072 /
2 / 32765
ONLINE
3,276,800 5 17 480  
   
PUBLIC._SYSSMU5$
131072 /
2 / 32765
ONLINE
2,228,224 4 13 484  
   
PUBLIC._SYSSMU6$
131072 /
2 / 32765
ONLINE
3,276,800 5 15 475  
   
PUBLIC._SYSSMU7$
131072 /
2 / 32765
ONLINE
3,276,800 5 16 475  
   
PUBLIC._SYSSMU8$
131072 /
2 / 32765
ONLINE
2,228,224 4 23 474  
   
PUBLIC._SYSSMU9$
131072 /
2 / 32765
ONLINE
2,228,224 4 21 471  
orcl2
UNDOTBS2
PUBLIC._SYSSMU11$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU12$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU13$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU14$
131072 /
2 / 32765
ONLINE
3,276,800 5      
   
PUBLIC._SYSSMU15$
131072 /
2 / 32765
ONLINE
3,276,800 5      
   
PUBLIC._SYSSMU16$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU17$
131072 /
2 / 32765
ONLINE
3,276,800 5      
   
PUBLIC._SYSSMU18$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU19$
131072 /
2 / 32765
ONLINE
2,228,224 4      
   
PUBLIC._SYSSMU20$
131072 /
2 / 32765
ONLINE
2,228,224 4      

[Top]



UNDO Segment Contention



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

UNDO Segment Name Gets Waits Hit Ratio
_SYSSMU9$ 982,033 25
100%
_SYSSMU10$ 981,577 22
100%
_SYSSMU3$ 984,692 22
100%
_SYSSMU5$ 981,778 21
100%
_SYSSMU8$ 982,942 21
100%
_SYSSMU6$ 981,469 20
100%
_SYSSMU2$ 985,420 19
100%
_SYSSMU1$ 986,040 18
100%
_SYSSMU4$ 981,676 14
100%
_SYSSMU7$ 981,390 13
100%
SYSTEM 1,772 0
100%
  ------------ ------------  
Total: 9,830,789 195  


Wait statistics

Class Wait Ratio
system undo block
0%
system undo header
0%
undo header
.00002111%
undo block
.00000362%

[Top]



Backups


RMAN Backup Jobs

Last 10 RMAN backup jobs

Backup Name Start Time Elapsed Time Status Input Type Output Devices Input Size Output Size Output Rate Per Sec
2008-06-01T03:00:02
06/01/2008 03:00:05
00:11:41
COMPLETED
DB FULL DISK
12.98G
12.68G
18.53M
2008-05-31T03:00:01
05/31/2008 03:00:04
00:11:01
COMPLETED
DB FULL DISK
12.38G
12.08G
18.71M
2008-05-30T03:00:02
05/30/2008 03:00:05
00:10:15
COMPLETED
DB FULL DISK
11.78G
11.48G
19.12M
2008-05-29T03:00:02
05/29/2008 03:00:06
00:09:11
COMPLETED
DB FULL DISK
9.26G
8.97G
16.68M
2008-05-28T03:00:04
05/28/2008 03:00:06
00:06:35
COMPLETED
DB FULL DISK
7.45G
7.16G
18.57M
2008-05-27T03:00:02
05/27/2008 03:00:05
00:06:11
COMPLETED
DB FULL DISK
7.33G
7.06G
19.49M
2008-05-26T03:00:02
05/26/2008 03:00:04
00:07:51
COMPLETED
DB FULL DISK
10.69G
10.43G
22.68M
2008-05-25T03:00:02
05/25/2008 03:00:05
00:09:44
COMPLETED
DB FULL DISK
12.31G
12.06G
21.14M
2008-05-24T03:00:05
05/24/2008 03:00:09
00:04:56
COMPLETED
DB FULL DISK
5.78G
5.53G
19.13M
2008-05-24T02:28:24
05/24/2008 02:28:26
00:04:39
COMPLETED
DB FULL DISK
5.68G
5.42G
19.89M

[Top]



RMAN Configuration



All non-default RMAN configuration settings

Name Value
CHANNEL
DEVICE TYPE DISK MAXPIECESIZE 2 G
CONTROLFILE AUTOBACKUP
ON

[Top]



RMAN Backup Sets



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

BS Key Backup Type Device Type Controlfile Included? SPFILE Included? Incremental Level # of Pieces Start Time End Time Elapsed Seconds Tag Block Size Keep? Keep Until Keep Options
65
Archived Redo Logs
DISK
-
-
  1
06/01/2008 03:00:22
06/01/2008 03:01:16
54 TAG20080601T030016 512
NO

 
66
Archived Redo Logs
DISK
-
-
  1
06/01/2008 03:01:31
06/01/2008 03:02:21
50 TAG20080601T030016 512
NO

 
67
Archived Redo Logs
DISK
-
-
  1
06/01/2008 03:02:38
06/01/2008 03:03:24
46 TAG20080601T030016 512
NO

 
68
Archived Redo Logs
DISK
-
-
  1
06/01/2008 03:03:46
06/01/2008 03:04:33
47 TAG20080601T030016 512
NO

 
69
Datafile Full Backup
DISK
-
-
  4
06/01/2008 03:04:52
06/01/2008 03:11:23
391 TAG20080601T030452 8,192
NO

 
70
Archived Redo Logs
DISK
-
-
  1
06/01/2008 03:11:40
06/01/2008 03:11:43
3 TAG20080601T031139 512
NO

 
71
Datafile Full Backup
DISK
YES
YES
  1
06/01/2008 03:11:48
06/01/2008 03:11:51
3 TAG20080601T031148 16,384
NO

 
72
Datafile Full Backup
DISK
YES
YES
  1
06/01/2008 18:13:21
06/01/2008 18:13:24
3 TAG20080601T181321 16,384
NO

 
73
Datafile Full Backup
DISK
YES
YES
  1
06/01/2008 18:21:11
06/01/2008 18:21:14
3 TAG20080601T182111 16,384
NO

 
            ----------------     --------------------          
Total:           12     600          

[Top]



RMAN Backup Pieces



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

BS Key Piece # Copy # BP Key Status Handle Start Time End Time Elapsed Seconds
65
1 1 89
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/annnf0_tag20080601t030016_0.957.656218825
06/01/2008 03:00:24
06/01/2008 03:01:15
51
66
1 1 90
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/annnf0_tag20080601t030016_0.436.656218895
06/01/2008 03:01:34
06/01/2008 03:02:21
47
67
1 1 91
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/annnf0_tag20080601t030016_0.627.656218961
06/01/2008 03:02:40
06/01/2008 03:03:24
44
68
1 1 92
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/annnf0_tag20080601t030016_0.998.656219029
06/01/2008 03:03:48
06/01/2008 03:04:33
45
69
1 1 93
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/nnndf0_tag20080601t030452_0.1073.656219107
06/01/2008 03:05:06
06/01/2008 03:06:31
85
  2 1 94
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/nnndf0_tag20080601t030452_0.733.656219199
06/01/2008 03:06:38
06/01/2008 03:08:00
82
  3 1 95
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/nnndf0_tag20080601t030452_0.929.656219283
06/01/2008 03:08:03
06/01/2008 03:09:22
79
  4 1 96
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/nnndf0_tag20080601t030452_0.615.656219369
06/01/2008 03:09:28
06/01/2008 03:11:22
114
70
1 1 97
Available
+FLASH_RECOVERY_AREA/orcl/backupset/2008_06_01/annnf0_tag20080601t031139_0.782.656219501
06/01/2008 03:11:41
06/01/2008 03:11:43
2
71
1 1 98
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656219508.1076.656219515
06/01/2008 03:11:50
06/01/2008 03:11:51
1
72
1 1 99
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656273601.332.656273603
06/01/2008 18:13:23
06/01/2008 18:13:24
1
73
1 1 100
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656274071.384.656274073
06/01/2008 18:21:13
06/01/2008 18:21:14
1

[Top]



RMAN Backup Control Files



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

BS Key Piece # Copy # BP Key Controlfile Included? Status Handle
71
1 1 98
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656219508.1076.656219515
72
1 1 99
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656273601.332.656273603
73
1 1 100
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656274071.384.656274073

[Top]



RMAN Backup SPFILE



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

BS Key Piece # Copy # BP Key SPFILE Included? Status Handle
71
1 1 98
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656219508.1076.656219515
72
1 1 99
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656273601.332.656273603
73
1 1 100
YES
Available
+FLASH_RECOVERY_AREA/orcl/autobackup/2008_06_01/s_656274071.384.656274073

[Top]



Archiving Mode



Database
Log Mode
Automatic
Archival
Current
Log Sequence
Oldest Online
Log Sequence
Archive Mode
Enabled
953 952

[Top]



Archive Destinations



Destination
ID
Destination
Name
Destination Status Schedule Archiver Current Log
Sequence
1
LOG_ARCHIVE_DEST_1  
INACTIVE
INACTIVE
ARCH 0
2
LOG_ARCHIVE_DEST_2  
INACTIVE
INACTIVE
ARCH 0
3
LOG_ARCHIVE_DEST_3  
INACTIVE
INACTIVE
ARCH 0
4
LOG_ARCHIVE_DEST_4  
INACTIVE
INACTIVE
ARCH 0
5
LOG_ARCHIVE_DEST_5  
INACTIVE
INACTIVE
ARCH 0
6
LOG_ARCHIVE_DEST_6  
INACTIVE
INACTIVE
ARCH 0
7
LOG_ARCHIVE_DEST_7  
INACTIVE
INACTIVE
ARCH 0
8
LOG_ARCHIVE_DEST_8  
INACTIVE
INACTIVE
ARCH 0
9
LOG_ARCHIVE_DEST_9  
INACTIVE
INACTIVE
ARCH 0
10
LOG_ARCHIVE_DEST_10 USE_DB_RECOVERY_FILE_DEST
VALID
ACTIVE
ARCH 952

[Top]



Archiving Instance Parameters



Parameter Name Parameter Value
log_archive_config  
log_archive_dest  
log_archive_dest_1  
log_archive_dest_10  
log_archive_dest_2  
log_archive_dest_3  
log_archive_dest_4  
log_archive_dest_5  
log_archive_dest_6  
log_archive_dest_7  
log_archive_dest_8  
log_archive_dest_9  
log_archive_dest_state_1 enable
log_archive_dest_state_10 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_duplex_dest  
log_archive_format %t_%s_%r.dbf
log_archive_local_first TRUE
log_archive_max_processes 2
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 2883584
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert  
logmnr_max_persistent_sessions 1

[Top]



Archiving History



Thread# Sequence# Name First
Change #
First
Time
Next
Change #
Next
Time
Size (in bytes) Archived? Applied? Deleted? Status
1
892
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_892.465.656220009 43908120
06/01/2008 03:11:26
43950838
06/01/2008 03:20:06
13,260,288
YES
NO
NO
Available
 
893
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_893.372.656220903 43950838
06/01/2008 03:20:06
44026001
06/01/2008 03:35:03
22,817,792
YES
NO
NO
Available
 
894
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_894.766.656221811 44026001
06/01/2008 03:35:03
44102366
06/01/2008 03:50:10
24,209,920
YES
NO
NO
Available
 
895
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_895.476.656222705 44102366
06/01/2008 03:50:10
44170069
06/01/2008 04:05:03
21,739,008
YES
NO
NO
Available
 
896
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_896.686.656223607 44170069
06/01/2008 04:05:03
44246557
06/01/2008 04:20:05
23,575,040
YES
NO
NO
Available
 
897
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_897.1024.656224503 44246557
06/01/2008 04:20:05
44316576
06/01/2008 04:35:02
22,061,056
YES
NO
NO
Available
 
898
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_898.1075.656225407 44316576
06/01/2008 04:35:02
44391977
06/01/2008 04:50:05
23,637,504
YES
NO
NO
Available
 
899
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_899.419.656226303 44391977
06/01/2008 04:50:05
44469225
06/01/2008 05:05:02
23,329,792
YES
NO
NO
Available
 
900
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_900.971.656227209 44469225
06/01/2008 05:05:02
44541105
06/01/2008 05:20:06
23,658,496
YES
NO
NO
Available
 
901
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_901.395.656228103 44541105
06/01/2008 05:20:06
44614724
06/01/2008 05:35:03
22,743,040
YES
NO
NO
Available
 
902
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_902.972.656229003 44614724
06/01/2008 05:35:03
44688687
06/01/2008 05:50:02
22,643,200
YES
NO
NO
Available
 
903
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_903.779.656229903 44688687
06/01/2008 05:50:02
44768588
06/01/2008 06:05:03
24,318,976
YES
NO
NO
Available
 
904
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_904.960.656230803 44768588
06/01/2008 06:05:03
44838330
06/01/2008 06:20:02
21,503,488
YES
NO
NO
Available
 
905
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_905.363.656231705 44838330
06/01/2008 06:20:02
44908462
06/01/2008 06:35:03
23,782,400
YES
NO
NO
Available
 
906
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_906.1087.656232603 44908462
06/01/2008 06:35:03
44981764
06/01/2008 06:50:03
22,427,136
YES
NO
NO
Available
 
907
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_907.500.656233509 44981764
06/01/2008 06:50:03
45064166
06/01/2008 07:05:09
48,454,144
YES
NO
NO
Available
 
908
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_908.915.656234405 45064166
06/01/2008 07:05:09
45147697
06/01/2008 07:20:02
25,990,144
YES
NO
NO
Available
 
909
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_909.751.656235303 45147697
06/01/2008 07:20:02
45220485
06/01/2008 07:35:01
23,652,352
YES
NO
NO
Available
 
910
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_910.804.656236203 45220485
06/01/2008 07:35:01
45293541
06/01/2008 07:50:02
22,059,008
YES
NO
NO
Available
 
911
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_911.709.656237103 45293541
06/01/2008 07:50:02
45368745
06/01/2008 08:05:02
23,290,368
YES
NO
NO
Available
 
912
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_912.931.656238003 45368745
06/01/2008 08:05:02
45442948
06/01/2008 08:20:01
23,464,448
YES
NO
NO
Available
 
913
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_913.692.656238903 45442948
06/01/2008 08:20:01
45515271
06/01/2008 08:35:01
21,532,672
YES
NO
NO
Available
 
914
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_914.1031.656239803 45515271
06/01/2008 08:35:01
45584064
06/01/2008 08:50:01
23,165,440
YES
NO
NO
Available
 
915
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_915.621.656240703 45584064
06/01/2008 08:50:01
45662199
06/01/2008 09:05:02
21,753,344
YES
NO
NO
Available
 
916
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_916.347.656241603 45662199
06/01/2008 09:05:02
45735978
06/01/2008 09:20:02
23,281,152
YES
NO
NO
Available
 
917
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_917.1041.656242503 45735978
06/01/2008 09:20:02
45803867
06/01/2008 09:35:02
21,842,944
YES
NO
NO
Available
 
918
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_918.557.656243403 45803867
06/01/2008 09:35:02
45878076
06/01/2008 09:50:02
22,696,448
YES
NO
NO
Available
 
919
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_919.585.656244303 45878076
06/01/2008 09:50:02
45953255
06/01/2008 10:05:01
21,919,744
YES
NO
NO
Available
 
920
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_920.887.656245203 45953255
06/01/2008 10:05:01
46027936
06/01/2008 10:20:01
22,353,920
YES
NO
NO
Available
 
921
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_921.693.656246101 46027936
06/01/2008 10:20:01
46099098
06/01/2008 10:35:01
22,702,592
YES
NO
NO
Available
 
922
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_922.1025.656247003 46099098
06/01/2008 10:35:01
46172009
06/01/2008 10:50:02
22,297,600
YES
NO
NO
Available
 
923
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_923.710.656247903 46172009
06/01/2008 10:50:02
46248255
06/01/2008 11:05:01
23,256,576
YES
NO
NO
Available
 
924
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_924.831.656248803 46248255
06/01/2008 11:05:01
46319320
06/01/2008 11:20:02
21,173,248
YES
NO
NO
Available
 
925
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_925.994.656249703 46319320
06/01/2008 11:20:02
46393162
06/01/2008 11:35:02
23,737,344
YES
NO
NO
Available
 
926
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_926.819.656250603 46393162
06/01/2008 11:35:02
46463810
06/01/2008 11:50:02
22,516,224
YES
NO
NO
Available
 
927
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_927.987.656251503 46463810
06/01/2008 11:50:02
46543005
06/01/2008 12:05:01
22,574,080
YES
NO
NO
Available
 
928
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_928.908.656252403 46543005
06/01/2008 12:05:01
46616436
06/01/2008 12:20:01
21,941,248
YES
NO
NO
Available
 
929
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_929.1077.656253303 46616436
06/01/2008 12:20:01
46689613
06/01/2008 12:35:02
22,560,768
YES
NO
NO
Available
 
930
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_930.924.656254203 46689613
06/01/2008 12:35:02
46760846
06/01/2008 12:50:02
21,993,472
YES
NO
NO
Available
 
931
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_931.320.656255103 46760846
06/01/2008 12:50:02
46831091
06/01/2008 13:05:02
22,959,104
YES
NO
NO
Available
 
932
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_932.407.656256003 46831091
06/01/2008 13:05:02
46907284
06/01/2008 13:20:02
22,593,024
YES
NO
NO
Available
 
933
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_933.1084.656256903 46907284
06/01/2008 13:20:02
46979019
06/01/2008 13:35:02
21,665,280
YES
NO
NO
Available
 
934
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_934.1085.656257803 46979019
06/01/2008 13:35:02
47050299
06/01/2008 13:50:02
23,259,648
YES
NO
NO
Available
 
935
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_935.992.656258703 47050299
06/01/2008 13:50:02
47124326
06/01/2008 14:05:02
21,333,504
YES
NO
NO
Available
 
936
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_936.561.656259605 47124326
06/01/2008 14:05:02
47197112
06/01/2008 14:20:03
22,618,112
YES
NO
NO
Available
 
937
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_937.849.656260503 47197112
06/01/2008 14:20:03
47269237
06/01/2008 14:35:01
21,787,648
YES
NO
NO
Available
 
938
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_938.1067.656261403 47269237
06/01/2008 14:35:01
47339362
06/01/2008 14:50:02
21,783,552
YES
NO
NO
Available
 
939
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_939.1078.656262303 47339362
06/01/2008 14:50:02
47417411
06/01/2008 15:05:02
23,651,840
YES
NO
NO
Available
 
940
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_940.303.656263203 47417411
06/01/2008 15:05:02
47491583
06/01/2008 15:20:02
21,878,272
YES
NO
NO
Available
 
941
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_941.490.656264103 47491583
06/01/2008 15:20:02
47563237
06/01/2008 15:35:02
23,976,448
YES
NO
NO
Available
 
942
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_942.792.656265003 47563237
06/01/2008 15:35:02
47636072
06/01/2008 15:50:02
22,014,976
YES
NO
NO
Available
 
943
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_943.722.656265903 47636072
06/01/2008 15:50:02
47705902
06/01/2008 16:05:01
22,941,696
YES
NO
NO
Available
 
944
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_944.1074.656266803 47705902
06/01/2008 16:05:01
47783114
06/01/2008 16:20:01
22,311,424
YES
NO
NO
Available
 
945
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_945.946.656267703 47783114
06/01/2008 16:20:01
47857153
06/01/2008 16:35:02
22,910,464
YES
NO
NO
Available
 
946
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_946.1004.656268603 47857153
06/01/2008 16:35:02
47928912
06/01/2008 16:50:01
22,246,400
YES
NO
NO
Available
 
947
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_947.1063.656269503 47928912
06/01/2008 16:50:01
48004416
06/01/2008 17:05:01
22,827,520
YES
NO
NO
Available
 
948
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_948.812.656270403 48004416
06/01/2008 17:05:01
48077357
06/01/2008 17:20:02
21,799,424
YES
NO
NO
Available
 
949
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_949.705.656271303 48077357
06/01/2008 17:20:02
48151262
06/01/2008 17:35:02
22,607,360
YES
NO
NO
Available
 
950
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_950.903.656272203 48151262
06/01/2008 17:35:02
48222141
06/01/2008 17:50:02
22,493,184
YES
NO
NO
Available
 
951
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_951.1070.656273103 48222141
06/01/2008 17:50:02
48295922
06/01/2008 18:05:02
21,901,824
YES
NO
NO
Available
 
952
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_1_seq_952.951.656274005 48295922
06/01/2008 18:05:02
48366162
06/01/2008 18:20:03
21,917,696
YES
NO
NO
Available
2
827
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_827.289.656220183 43908426
06/01/2008 03:11:52
43963089
06/01/2008 03:23:02
21,146,624
YES
NO
NO
Available
 
828
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_828.335.656221083 43963089
06/01/2008 03:23:02
44039363
06/01/2008 03:38:02
29,082,112
YES
NO
NO
Available
 
829
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_829.1088.656221981 44039363
06/01/2008 03:38:02
44113406
06/01/2008 03:53:01
29,554,688
YES
NO
NO
Available
 
830
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_830.1086.656222883 44113406
06/01/2008 03:53:01
44184089
06/01/2008 04:08:02
30,799,872
YES
NO
NO
Available
 
831
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_831.351.656223783 44184089
06/01/2008 04:08:02
44259062
06/01/2008 04:23:02
29,348,864
YES
NO
NO
Available
 
832
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_832.955.656224683 44259062
06/01/2008 04:23:02
44329459
06/01/2008 04:38:02
27,706,368
YES
NO
NO
Available
 
833
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_833.502.656225583 44329459
06/01/2008 04:38:02
44406104
06/01/2008 04:53:01
28,406,784
YES
NO
NO
Available
 
834
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_834.982.656226483 44406104
06/01/2008 04:53:01
44482031
06/01/2008 05:08:02
30,209,024
YES
NO
NO
Available
 
835
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_835.267.656227383 44482031
06/01/2008 05:08:02
44553830
06/01/2008 05:23:01
29,733,376
YES
NO
NO
Available
 
836
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_836.961.656228283 44553830
06/01/2008 05:23:01
44627111
06/01/2008 05:38:02
28,708,864
YES
NO
NO
Available
 
837
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_837.824.656229183 44627111
06/01/2008 05:38:02
44703433
06/01/2008 05:53:02
29,568,000
YES
NO
NO
Available
 
838
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_838.838.656230081 44703433
06/01/2008 05:53:02
44780838
06/01/2008 06:08:01
30,889,472
YES
NO
NO
Available
 
839
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_839.398.656230981 44780838
06/01/2008 06:08:01
44850349
06/01/2008 06:23:01
28,698,624
YES
NO
NO
Available
 
840
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_840.284.656231881 44850349
06/01/2008 06:23:01
44921420
06/01/2008 06:38:01
27,475,968
YES
NO
NO
Available
 
841
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_841.1089.656232783 44921420
06/01/2008 06:38:01
44994233
06/01/2008 06:53:01
28,602,368
YES
NO
NO
Available
 
842
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_842.404.656233683 44994233
06/01/2008 06:53:01
45077639
06/01/2008 07:08:02
30,756,864
YES
NO
NO
Available
 
843
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_843.577.656234583 45077639
06/01/2008 07:08:02
45163108
06/01/2008 07:23:02
29,507,584
YES
NO
NO
Available
 
844
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_844.863.656235481 45163108
06/01/2008 07:23:02
45233225
06/01/2008 07:38:01
27,769,344
YES
NO
NO
Available
 
845
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_845.433.656236383 45233225
06/01/2008 07:38:01
45307261
06/01/2008 07:53:01
29,045,760
YES
NO
NO
Available
 
846
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_846.920.656237283 45307261
06/01/2008 07:53:01
45381224
06/01/2008 08:08:01
29,788,672
YES
NO
NO
Available
 
847
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_847.896.656238183 45381224
06/01/2008 08:08:01
45456324
06/01/2008 08:23:02
29,419,520
YES
NO
NO
Available
 
848
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_848.870.656239081 45456324
06/01/2008 08:23:02
45527351
06/01/2008 08:38:01
28,485,120
YES
NO
NO
Available
 
849
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_849.1008.656239983 45527351
06/01/2008 08:38:01
45597486
06/01/2008 08:53:01
28,783,616
YES
NO
NO
Available
 
850
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_850.315.656240883 45597486
06/01/2008 08:53:01
45675249
06/01/2008 09:08:02
30,377,984
YES
NO
NO
Available
 
851
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_851.1021.656241783 45675249
06/01/2008 09:08:02
45747404
06/01/2008 09:23:01
28,965,888
YES
NO
NO
Available
 
852
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_852.632.656242683 45747404
06/01/2008 09:23:01
45816692
06/01/2008 09:38:02
27,743,232
YES
NO
NO
Available
 
853
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_853.832.656243581 45816692
06/01/2008 09:38:02
45891042
06/01/2008 09:53:01
29,286,400
YES
NO
NO
Available
 
854
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_854.877.656244483 45891042
06/01/2008 09:53:01
45967191
06/01/2008 10:08:01
30,658,048
YES
NO
NO
Available
 
855
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_855.1002.656245383 45967191
06/01/2008 10:08:01
46042116
06/01/2008 10:23:02
29,180,416
YES
NO
NO
Available
 
856
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_856.456.656246281 46042116
06/01/2008 10:23:02
46111267
06/01/2008 10:38:01
27,572,224
YES
NO
NO
Available
 
857
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_857.880.656247183 46111267
06/01/2008 10:38:01
46184991
06/01/2008 10:53:01
29,069,824
YES
NO
NO
Available
 
858
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_858.719.656248083 46184991
06/01/2008 10:53:01
46260393
06/01/2008 11:08:02
30,345,728
YES
NO
NO
Available
 
859
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_859.1080.656248983 46260393
06/01/2008 11:08:02
46332492
06/01/2008 11:23:02
28,804,608
YES
NO
NO
Available
 
860
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_860.935.656249883 46332492
06/01/2008 11:23:02
46405744
06/01/2008 11:38:02
27,976,704
YES
NO
NO
Available
 
861
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_861.875.656250783 46405744
06/01/2008 11:38:02
46476572
06/01/2008 11:53:02
28,599,296
YES
NO
NO
Available
 
862
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_862.518.656251683 46476572
06/01/2008 11:53:02
46556057
06/01/2008 12:08:02
30,608,896
YES
NO
NO
Available
 
863
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_863.897.656252583 46556057
06/01/2008 12:08:02
46629730
06/01/2008 12:23:02
28,977,664
YES
NO
NO
Available
 
864
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_864.1064.656253483 46629730
06/01/2008 12:23:02
46702004
06/01/2008 12:38:02
28,515,840
YES
NO
NO
Available
 
865
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_865.947.656254383 46702004
06/01/2008 12:38:02
46774071
06/01/2008 12:53:02
29,096,960
YES
NO
NO
Available
 
866
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_866.423.656255283 46774071
06/01/2008 12:53:02
46843853
06/01/2008 13:08:02
29,880,832
YES
NO
NO
Available
 
867
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_867.376.656256183 46843853
06/01/2008 13:08:02
46920539
06/01/2008 13:23:02
28,947,456
YES
NO
NO
Available
 
868
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_868.968.656257083 46920539
06/01/2008 13:23:02
46990722
06/01/2008 13:38:02
28,279,296
YES
NO
NO
Available
 
869
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_869.786.656257983 46990722
06/01/2008 13:38:02
47062766
06/01/2008 13:53:01
29,145,088
YES
NO
NO
Available
 
870
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_870.854.656258883 47062766
06/01/2008 13:53:01
47137193
06/01/2008 14:08:01
30,634,496
YES
NO
NO
Available
 
871
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_871.412.656259783 47137193
06/01/2008 14:08:01
47210734
06/01/2008 14:23:02
29,282,816
YES
NO
NO
Available
 
872
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_872.811.656260681 47210734
06/01/2008 14:23:02
47281871
06/01/2008 14:38:01
27,772,416
YES
NO
NO
Available
 
873
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_873.770.656261583 47281871
06/01/2008 14:38:01
47352172
06/01/2008 14:53:02
29,162,496
YES
NO
NO
Available
 
874
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_874.918.656262483 47352172
06/01/2008 14:53:02
47430227
06/01/2008 15:08:01
30,731,264
YES
NO
NO
Available
 
875
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_875.1030.656263383 47430227
06/01/2008 15:08:01
47504045
06/01/2008 15:23:02
29,331,456
YES
NO
NO
Available
 
876
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_876.550.656264281 47504045
06/01/2008 15:23:02
47576340
06/01/2008 15:38:01
28,190,720
YES
NO
NO
Available
 
877
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_877.339.656265183 47576340
06/01/2008 15:38:01
47649150
06/01/2008 15:53:02
28,902,912
YES
NO
NO
Available
 
878
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_878.446.656266083 47649150
06/01/2008 15:53:02
47719778
06/01/2008 16:08:02
30,006,784
YES
NO
NO
Available
 
879
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_879.1015.656266983 47719778
06/01/2008 16:08:02
47798456
06/01/2008 16:23:02
29,684,224
YES
NO
NO
Available
 
880
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_880.348.656267881 47798456
06/01/2008 16:23:02
47869672
06/01/2008 16:38:01
27,858,944
YES
NO
NO
Available
 
881
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_881.402.656268783 47869672
06/01/2008 16:38:01
47942105
06/01/2008 16:53:02
29,289,472
YES
NO
NO
Available
 
882
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_882.799.656269683 47942105
06/01/2008 16:53:02
48017024
06/01/2008 17:08:01
30,087,680
YES
NO
NO
Available
 
883
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_883.892.656270583 48017024
06/01/2008 17:08:01
48091175
06/01/2008 17:23:02
29,611,520
YES
NO
NO
Available
 
884
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_884.1035.656271483 48091175
06/01/2008 17:23:02
48163787
06/01/2008 17:38:02
28,576,768
YES
NO
NO
Available
 
885
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_885.1053.656272383 48163787
06/01/2008 17:38:02
48234870
06/01/2008 17:53:02
28,594,688
YES
NO
NO
Available
 
886
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_886.272.656273281 48234870
06/01/2008 17:53:02
48308442
06/01/2008 18:08:01
30,105,600
YES
NO
NO
Available
 
887
+FLASH_RECOVERY_AREA/orcl/archivelog/2008_06_01/thread_2_seq_887.999.656274183 48308442
06/01/2008 18:08:01
48380047
06/01/2008 18:23:02
27,293,696
YES
NO
NO
Available

[Top]



Flash Recovery Area Parameters



db_recovery_file_dest_size is specified in bytes

Instance Name Thread Number Name Value
orcl1
1
db_recovery_file_dest
+FLASH_RECOVERY_AREA
   
db_recovery_file_dest_size
220,382,363,648
orcl2
2
db_recovery_file_dest
+FLASH_RECOVERY_AREA
   
db_recovery_file_dest_size
220,382,363,648

[Top]



Flash Recovery Area Status



Current location, disk quota, space in use, space reclaimable by deleting files, and number of files in the Flash Recovery Area

Name Space Limit Space Used % Used Space Reclaimable % Reclaimable Number of Files
+FLASH_RECOVERY_AREA
220,382,363,648 34,158,411,776 15.50 456,130,560 .21 756

File Type Percent Space Used Percent Space Reclaimable Number of Files
CONTROLFILE
.01 0 1
ONLINELOG
.1 0 4
ARCHIVELOG
1.47 0 122
BACKUPPIECE
6.21 0 12
IMAGECOPY
0 0 0
FLASHBACKLOG
7.72 .21 617

[Top]



Flashback Technologies


Flashback Database Parameters

db_flashback_retention_target is specified in minutes
db_recovery_file_dest_size is specified in bytes

Instance Name Thread Number Name Value
orcl1
1
db_flashback_retention_target
1,440
   
db_recovery_file_dest
+FLASH_RECOVERY_AREA
   
db_recovery_file_dest_size
220,382,363,648
orcl2
2
db_flashback_retention_target
1,440
   
db_recovery_file_dest
+FLASH_RECOVERY_AREA
   
db_recovery_file_dest_size
220,382,363,648

[Top]



Flashback Database Status



DB ID DB Name Log Mode Flashback DB On?
1183261123
ORCL
ARCHIVELOG
YES

Oldest Flashback Time Oldest Flashback SCN Retention Target (min) Retention Target (hour) Flashback Size Estimated Flashback Size
05/31/2008 18:12:19
41266361 1,440 24 16,700,776,448 10,541,039,616

[Top]



Flashback Database Redo Time Matrix



Begin Time End Time Flashback Data DB Data Redo Data Estimated Flashback Size
05/31/2008 18:11:52
05/31/2008 19:11:55
660,054,016 808,042,496 203,922,944 9,937,403,904
05/31/2008 19:11:55
05/31/2008 20:11:59
664,797,184 811,548,672 205,752,320 9,968,050,176
05/31/2008 20:11:59
05/31/2008 21:12:04
667,344,896 805,715,968 206,013,952 9,998,671,872
05/31/2008 21:12:04
05/31/2008 22:12:08
664,330,240 813,031,424 205,323,776 10,028,630,016
05/31/2008 22:12:08
05/31/2008 23:12:12
714,997,760 879,886,336 285,652,480 10,064,388,096
05/31/2008 23:12:12
06/01/2008 00:12:16
665,468,928 813,359,104 207,526,912 10,093,830,144
06/01/2008 00:12:16
06/01/2008 01:12:21
668,033,024 803,045,376 209,130,496 10,123,321,344
06/01/2008 01:12:21
06/01/2008 02:12:25
666,746,880 806,027,264 208,739,328 10,152,321,024
06/01/2008 02:12:25
06/01/2008 03:12:29
648,675,328 796,573,696 202,177,024 10,178,936,832
06/01/2008 03:12:29
06/01/2008 04:12:36
675,807,232 814,366,720 210,849,280 10,208,477,184
06/01/2008 04:12:36
06/01/2008 05:12:41
668,368,896 805,175,296 209,125,888 10,236,813,312
06/01/2008 05:12:41
06/01/2008 06:12:45
673,136,640 819,732,480 211,101,696 10,265,444,352
06/01/2008 06:12:45
06/01/2008 07:12:52
698,482,688 837,795,840 235,891,712 10,296,778,752
06/01/2008 07:12:52
06/01/2008 08:12:58
673,284,096 811,966,464 208,547,328 10,324,844,544
06/01/2008 08:12:58
06/01/2008 09:13:04
671,907,840 807,919,616 206,815,232 10,352,492,544
06/01/2008 09:13:04
06/01/2008 10:13:08
669,868,032 809,287,680 206,709,760 10,379,649,024
06/01/2008 10:13:08
06/01/2008 11:13:13
673,431,552 815,923,200 206,911,488 10,406,977,536
06/01/2008 11:13:13
06/01/2008 12:13:20
671,113,216 810,811,392 206,466,048 10,433,789,952
06/01/2008 12:13:20
06/01/2008 13:13:30
665,804,800 801,988,608 205,680,128 10,459,717,632
06/01/2008 13:13:30
06/01/2008 14:13:36
675,684,352 810,369,024 206,868,992 10,486,456,320
06/01/2008 14:13:36
06/01/2008 15:13:43
673,005,568 816,398,336 207,275,008 10,512,703,488
06/01/2008 15:13:43
06/01/2008 16:13:48
675,078,144 815,349,760 207,686,656 10,538,926,080
06/01/2008 16:13:48
06/01/2008 17:13:53
673,718,272 812,253,184 207,627,776 10,564,804,608
06/01/2008 17:13:53
06/01/2008 18:13:57
664,657,920 806,199,296 204,101,632 10,589,429,760

[Top]



Performance


SGA Information

Instance Name Pool Name Bytes
orcl1
Database Buffers
436,207,616
 
Variable Size
167,774,600
 
Redo Buffers
2,928,640
 
Fixed Size
1,263,224
*******************************************************************************   --------------------
Total:   608,174,080
orcl2
Database Buffers
469,762,048
 
Variable Size
134,220,168
 
Redo Buffers
2,928,640
 
Fixed Size
1,263,224
*******************************************************************************   --------------------
Total:   608,174,080

[Top]



SGA Target Advice



Modify the SGA_TARGET parameter (up to the size of the SGA_MAX_SIZE, if necessary) to reduce
the number of "Estimated Physical Reads".

Instance Name Parameter Name Value
orcl1
sga_max_size
608,174,080
  sga_target
608,174,080
orcl2
sga_max_size
608,174,080
  sga_target
608,174,080

Instance Name SGA Size SGA Size Factor Estimated DB Time Estimated DB Time Factor Estimated Physical Reads
orcl1
290 1 295,554 1 23,585,931
  435 1 237,619 1 14,201,630
  580 1 209,227 1 10,260,552
  725 1 197,176 1 8,308,995
  870 2 187,385 1 6,720,662
  1,015 2 183,012 1 6,014,736
  1,160 2 183,012 1 6,014,736
orcl2
145 0 875,364 3 46,391,223
  290 1 366,406 1 32,253,408
  435 1 290,234 1 20,259,737
  580 1 255,015 1 14,716,160
  725 1 239,052 1 12,201,168
  870 2 224,134 1 9,853,941
  1,015 2 214,979 1 8,414,700
  1,160 2 214,979 1 8,414,700

[Top]



SGA (ASMM) Dynamic Components



Provides a summary report of all dynamic components as part of the Automatic Shared Memory
Management (ASMM) configuration. This will display the total real memory allocation for the current
SGA from the V$SGA_DYNAMIC_COMPONENTS view, which contains both manual and autotuned SGA components.
As with the other manageability features of Oracle Database 10g, ASMM requires you to set the
STATISTICS_LEVEL parameter to at least TYPICAL (the default) before attempting to enable ASMM. ASMM
can be enabled by setting SGA_TARGET to a nonzero value in the initialization parameter file (pfile/spfile).

Instance Name Component Name Current Size Min Size Max Size User Specified
Size
Oper.
Count
Last Oper.
Type
Last Oper.
Mode
Last Oper.
Time
Granule Size
orcl1
streams pool 8,388,608 8,388,608 0 0 3 SHRINK DEFERRED
05/28/2008 21:03:35
4,194,304
  streams pool 0 0 0 0 0 STATIC  

4,194,304
  shared pool 146,800,640 146,800,640 0 0 365 SHRINK DEFERRED
06/01/2008 18:28:00
4,194,304
  shared pool 125,829,120 92,274,688 0 0 1,342 GROW DEFERRED
06/01/2008 18:29:23
4,194,304
  large pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  large pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  java pool 8,388,608 8,388,608 0 0 0 STATIC  

4,194,304
  java pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  RECYCLE buffer cache 0 0 0 0 0 STATIC  

4,194,304
  RECYCLE buffer cache 0 0 0 0 0 STATIC  

4,194,304
  KEEP buffer cache 0 0 0 0 0 STATIC  

4,194,304
  KEEP buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT buffer cache 436,207,616 306,184,192 0 0 368 GROW DEFERRED
06/01/2008 18:28:00
4,194,304
  DEFAULT buffer cache 469,762,048 461,373,440 0 0 1,342 SHRINK DEFERRED
06/01/2008 18:29:23
4,194,304
  DEFAULT 8K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 8K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 4K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 4K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 32K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 32K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 2K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 2K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 16K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 16K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  ASM Buffer Cache 0 0 0 0 0 STATIC  

4,194,304
  ASM Buffer Cache 0 0 0 0 0 STATIC  

4,194,304
orcl2
streams pool 0 0 0 0 0 STATIC  

4,194,304
  streams pool 8,388,608 8,388,608 0 0 3 SHRINK DEFERRED
05/28/2008 21:03:35
4,194,304
  shared pool 125,829,120 92,274,688 0 0 1,342 GROW DEFERRED
06/01/2008 18:29:23
4,194,304
  shared pool 146,800,640 146,800,640 0 0 365 SHRINK DEFERRED
06/01/2008 18:28:00
4,194,304
  large pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  large pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  java pool 8,388,608 8,388,608 0 0 0 STATIC  

4,194,304
  java pool 4,194,304 4,194,304 0 0 0 STATIC  

4,194,304
  RECYCLE buffer cache 0 0 0 0 0 STATIC  

4,194,304
  RECYCLE buffer cache 0 0 0 0 0 STATIC  

4,194,304
  KEEP buffer cache 0 0 0 0 0 STATIC  

4,194,304
  KEEP buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT buffer cache 436,207,616 306,184,192 0 0 368 GROW DEFERRED
06/01/2008 18:28:00
4,194,304
  DEFAULT buffer cache 469,762,048 461,373,440 0 0 1,342 SHRINK DEFERRED
06/01/2008 18:29:23
4,194,304
  DEFAULT 8K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 8K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 4K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 4K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 32K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 32K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 2K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 2K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 16K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  DEFAULT 16K buffer cache 0 0 0 0 0 STATIC  

4,194,304
  ASM Buffer Cache 0 0 0 0 0 STATIC  

4,194,304
  ASM Buffer Cache 0 0 0 0 0 STATIC  

4,194,304

[Top]



PGA Target Advice



The V$PGA_TARGET_ADVICE view predicts how the statistics cache hit percentage and over
allocation count in V$PGASTAT will be impacted if you change the value of the
initialization parameter PGA_AGGREGATE_TARGET. When you set the PGA_AGGREGATE_TARGET and
WORKAREA_SIZE_POLICY to AUTO then the *_AREA_SIZE parameter are automatically ignored and
Oracle will automatically use the computed value for these parameters. Use the results from
the query below to adequately set the initialization parameter PGA_AGGREGATE_TARGET as to avoid
any over allocation. If column ESTD_OVERALLOCATION_COUNT in the V$PGA_TARGET_ADVICE
view (below) is nonzero, it indicates that PGA_AGGREGATE_TARGET is too small to even
meet the minimum PGA memory needs. If PGA_AGGREGATE_TARGET is set within the over
allocation zone, the memory manager will over-allocate memory and actual PGA memory
consumed will be more than the limit you set. It is therefore meaningless to set a
value of PGA_AGGREGATE_TARGET in that zone. After eliminating over-allocations, the
goal is to maximize the PGA cache hit percentage, based on your response-time requirement
and memory constraints.

Instance Name Parameter Name Value
orcl1
pga_aggregate_target
201,326,592
  workarea_size_policy
AUTO
orcl2
pga_aggregate_target
201,326,592
  workarea_size_policy
AUTO

Instance Name PGA Target for Estimate Estimated Extra Bytes R/W Estimated PGA Cache Hit % ESTD_OVERALLOC_COUNT
orcl1
25,165,824 43,679,744,000 99 10,397
  50,331,648 43,679,744,000 99 10,397
  100,663,296 43,607,171,072 99 10,380
  150,994,944 2,104,852,480 100 498
  201,326,592 0 100 1
  241,591,296 0 100 0
  281,857,024 0 100 0
  322,121,728 0 100 0
  362,387,456 0 100 0
  402,653,184 0 100 0
  603,979,776 0 100 0
  805,306,368 0 100 0
  1,207,959,552 0 100 0
  1,610,612,736 0 100 0
orcl2
25,165,824 61,601,734,656 99 13,831
  50,331,648 61,601,734,656 99 13,831
  100,663,296 61,462,350,848 99 13,799
  150,994,944 262,050,816 100 41
  201,326,592 99,462,144 100 0
  241,591,296 55,440,384 100 0
  281,857,024 0 100 0
  322,121,728 0 100 0
  362,387,456 0 100 0
  402,653,184 0 100 0
  603,979,776 0 100 0
  805,306,368 0 100 0
  1,207,959,552 0 100 0
  1,610,612,736 0 100 0

[Top]



File I/O Statistics



Ordered by "Physical Reads" since last startup of the Oracle instance

Tablespace File Name Physical Reads Read Pct. Physical Writes Write Pct. Total I/O
SOE +ORCL_DATA1/orcl/datafile/soe.794.655486311 5,608,133
53.66%
366,071
11.22%
5,974,204
SOEINDEX +ORCL_DATA1/orcl/datafile/soeindex.775.655486339 3,636,644
34.8%
2,540,020
77.88%
6,176,664
SYSAUX +ORCL_DATA1/orcl/datafile/sysaux.863.655480415 463,286
4.43%
286,024
8.77%
749,310
UNDOTBS1 +ORCL_DATA1/orcl/datafile/undotbs1.884.655480411 331,848
3.18%
40,849
1.25%
372,697
SYSTEM +ORCL_DATA1/orcl/datafile/system.888.655480397 238,521
2.28%
11,104
.34%
249,625
USERS +ORCL_DATA1/orcl/datafile/users.826.655480429 154,128
1.47%
15,755
.48%
169,883
EXAMPLE +ORCL_DATA1/orcl/datafile/example.848.655480423 16,946
.16%
384
.01%
17,330
UNDOTBS2 +ORCL_DATA1/orcl/datafile/undotbs2.837.655480427 803
.01%
384
.01%
1,187
USERS +ORCL_DATA1/orcl/datafile/users.753.656274021 770
.01%
579
.02%
1,349
TEMP +ORCL_DATA1/orcl/tempfile/temp.857.655480419 174
0%
114
0%
288
NDS_DATA +ORCL_DATA1/orcl/datafile/nds_data.761.656273589 1
0%
1
0%
2
REPORTS +ORCL_DATA1/orcl/datafile/reports.796.655484761 0
0%
0
0%
0
    --------------------   --------------------   --------------------
Total:   10,451,254   3,261,285   13,712,539

[Top]



File I/O Timings



Average time (in milliseconds) for an I/O call per datafile since last startup of the Oracle instance - (ordered by Physical Reads)

File Name Physical Reads Average Read Time
(milliseconds per read)
Physical Writes Average Write Time
(milliseconds per write)
+ORCL_DATA1/orcl/datafile/soe.794.655486311 5,608,540 .59 366,071 .00
+ORCL_DATA1/orcl/datafile/soeindex.775.655486339 3,636,692 .69 2,540,020 .00
+ORCL_DATA1/orcl/datafile/sysaux.863.655480415 463,286 .35 286,024 .00
+ORCL_DATA1/orcl/datafile/undotbs1.884.655480411 331,856 .15 40,849 .00
+ORCL_DATA1/orcl/datafile/system.888.655480397 238,521 .36 11,104 .00
+ORCL_DATA1/orcl/datafile/users.826.655480429 154,128 .01 15,755 .00
+ORCL_DATA1/orcl/datafile/example.848.655480423 16,946 .10 384 .00
+ORCL_DATA1/orcl/datafile/undotbs2.837.655480427 803 .24 384 .00
+ORCL_DATA1/orcl/datafile/users.753.656274021 770 .07 579 .00
+ORCL_DATA1/orcl/tempfile/temp.857.655480419 174 .09 114 .00
+ORCL_DATA1/orcl/datafile/nds_data.761.656273589 1 .00 1 .00
+ORCL_DATA1/orcl/datafile/reports.796.655484761 0 .00 0 .00
  -------------------- -------------------------------------------- -------------------- ----------------------------------------------
Average:   .22   .00
Total: 10,451,717   3,261,285  

[Top]



Average Overall I/O per Second



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





Elapsed Time (in seconds) 340,252
Datafile I/O Calls per Second 40
Tempfile I/O Calls per Second 0
Total I/O Calls per Second 40

[Top]



Redo Log Contention



All latches like redo% - (ordered by misses)

Latch Name Gets Misses Sleeps Immediate Gets Immediate Misses
Redo Allocation
7,127,827 1,486 1,488 24,377,409 1,346
Redo Copy
2,655 31 32 24,375,828 14,074
Redo On-Disk Scn
1 0 0 0 0
Redo Writing
14,239,575 133 133 0 0
  ------------------------ ---------------- ---------------- ------------------------ ----------------
Total: 21,370,058 1,650 1,653 48,753,237 15,420


System statistics like redo%

Statistics Name Value
Redo Blocks Read For Recovery
0
Redo Blocks Written
16,975,319
Redo Buffer Allocation Retries
2,473
Redo Entries
24,375,612
Redo Log Space Requests
2,554
Redo Log Space Wait Time
5,361
Redo Log Switch Interrupts
0
Redo Ordering Marks
295,937
Redo Size
7,231,226,752
Redo Subscn Max Counts
0
Redo Synch Time
3,003,035
Redo Synch Writes
13,465,047
Redo Wastage
1,165,231,056
Redo Write Time
5,020,891
Redo Writer Latching Time
738
Redo Writes
3,558,850

[Top]



Full Table Scans



Large Table Scans Small Table Scans Pct. Large Scans
3,099 6,477,066
.05%

[Top]



Sorts



Disk Sorts Memory Sorts Pct. Disk Sorts
0 4,058,518
0%

[Top]



Outlines



Category Owner Name Used? Time Stamp Version SQL Text
DEFAULT
SCOTT EXTENTS_OUTLN1 UNUSED
05/23/2008 15:14:37
10.2.0.3.0 select count(*), a.owner, a.segment_type from extents a, segments b where a. owner = b.owner and a.segment_type = b.segment_type group by a.owner, a . segment_type
DEFAULT
SCOTT SEGMENTS_OUTLN1 UNUSED
05/23/2008 15:14:38
10.2.0.3.0 select count(*) from segments where owner = 'PUBLIC'

[Top]



Outline Hints



Category Owner Name Node Join Position Hint
DEFAULT
SCOTT EXTENTS_OUTLN1
1
0
IGNORE_OPTIM_EMBEDDED_HINTS
     
1
0
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
     
1
0
ALL_ROWS
     
1
0
OUTLINE_LEAF(@"SEL$1")
     
1
0
USE_HASH(@"SEL$1" "A"@"SEL$1")
     
1
0
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
     
1
0
OUTLINE_LEAF(@"SEL$1")
     
1
1
FULL(@"SEL$1" "SEGMENTS"@"SEL$1")
     
1
0
ALL_ROWS
     
1
0
IGNORE_OPTIM_EMBEDDED_HINTS
     
1
0
LEADING(@"SEL$1" "B"@"SEL$1" "A"@"SEL$1")
     
1
2
FULL(@"SEL$1" "A"@"SEL$1")
     
1
1
FULL(@"SEL$1" "B"@"SEL$1")
    SEGMENTS_OUTLN1
1
0
IGNORE_OPTIM_EMBEDDED_HINTS
     
1
1
FULL(@"SEL$1" "SEGMENTS"@"SEL$1")
     
1
0
OUTLINE_LEAF(@"SEL$1")
     
1
0
ALL_ROWS
     
1
0
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
     
1
0
IGNORE_OPTIM_EMBEDDED_HINTS
     
1
0
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
     
1
0
ALL_ROWS
     
1
0
OUTLINE_LEAF(@"SEL$1")
     
1
1
FULL(@"SEL$1" "B"@"SEL$1")
     
1
2
FULL(@"SEL$1" "A"@"SEL$1")
     
1
0
LEADING(@"SEL$1" "B"@"SEL$1" "A"@"SEL$1")
     
1
0
USE_HASH(@"SEL$1" "A"@"SEL$1")

[Top]



SQL Statements With Most Buffer Gets



Top 100 SQL statements with buffer gets greater than 1000

Username Buffer Gets Executions Buffer Gets / Execution SQL Text
SOE 3,503,130,490 2,750,835 1,273 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID ORDER BY INVENTORIES.WAREHOUSE_ID
SOE 1,498,112,835 1,469,915 1,019 BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
SOE 35,148,048 295,281 119 SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ O.ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, ORDER_MODE, ORDER_STATUS, O RDER_TOTAL, SALES_REP_ID, PROMOTION_ID, C.CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT, CUST_EMAIL, ORDER_DATE FROM ORDERS O , ORDER_ITEMS OI, CUSTOMERS C WHERE O.ORDER_ID = OI.ORDER_ID AND O.CUSTOMER_ID = C.CUSTOMER_ID AND O.ORDER_STATUS <= 4
SOE 20,240,999 5,023,591 4 SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B1
SOE 14,643,400 1,277,696 11 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUA NTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID
SOE 12,338,087 591,835 21 INSERT INTO CUSTOMERS(CUSTOMER_ID ,CUST_FIRST_NAME ,CUST_LAST_NAME ,NLS_LANGUAGE ,NLS_TERRITORY ,CREDIT_LIMIT ,CUST_EMAIL ,ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
SOE 10,251,643 86,137 119 BEGIN :1 := orderentry.processorders(:2,:3); END;
SOE 5,036,723 172,529 29 BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7); END;
SOE 4,656,989 524,417 9 BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
SOE 3,022,314 1,425,924 2 INSERT INTO LOGON VALUES (:B2 , :B1 )
SOE 2,849,306 487,478 6 BEGIN :1 := orderentry.browseandupdateorders(:2,:3,:4); END;
SYSMAN 2,594,756 28,894 90 INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
BACKUP_ADMIN 2,424,766 0 2,424,766 BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'BACKUP_ADMIN'); END;
SOE 2,207,828 525,668 4 SELECT ORDER_ID, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID FROM ORDERS WHERE CUSTOMER_ID = :B1
SYSMAN 1,044,627 203,199 5 begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
SOE 895,325 175,546 5 UPDATE ORDER_ITEMS SET QUANTITY = QUANTITY + 1 WHERE ORDER_ITEMS.ORDER_ID = :B2 AND ORDER_ITEMS.LINE_ITEM_ID = :B1
SOE 716,836 175,546 4 SELECT ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY FROM ORDER_ITEMS WHERE ORDER_ID = :B1
SOE 711,375 175,546 4 UPDATE ORDERS SET ORDER_TOTAL = ORDER_TOTAL + :B2 WHERE ORDER_ID = :B1
LBACSYS 391,135 3,772 104 BEGIN LBACSYS.lbac_events.logon(dbms_standard.login_user); END;
SYSMAN 213,409 6,970 31 SELECT T.TARGET_GUID, T.TARGET_TYPE, M.METRIC_GUID FROM MGMT_TARGETS T, MGMT_METRICS M, MGMT_CURRENT_AVAILABILITY A WHERE T.TARGET_TYPE = M.TARGET_TYPE AND T.TARGET_GUID = A.T ARGET_GUID AND A.CURRENT_STATUS = :B4 AND M.TYPE_META_VER = T.TYPE_META_VER AND (M.CATEGORY_PROP_1 = T.CATEGORY_PROP_1 OR M.CATEGORY_PROP_1 = ' ') AND (M.CATEGORY_PROP_2 = T.C ATEGORY_PROP_2 OR M.CATEGORY_PROP_2 = ' ') AND (M.CATEGORY_PROP_3 = T.CATEGORY_PROP_3 OR M.CATEGORY_PROP_3 = ' ') AND (M.CATEGORY_PROP_4 = T.CATEGORY_PROP_4 OR M.CATEGORY_PROP _4 = ' ') AND (M.CATEGORY_PROP_5 = T.CATEGORY_PROP_5 OR M.CATEGORY_PROP_5 = ' ') AND T.EMD_URL = :B3 AND T.REP_SIDE_AVAIL = 0 AND M.METRIC_NAME = :B2 AND M.METRIC_COLUMN = :B1  
SYSMAN 198,657 2,281 87 BEGIN EMD_LOADER.END_UPLOAD(:1, :2, :3, :4, :5); END;
SYSMAN 164,725 6,970 24 UPDATE MGMT_AVAILABILITY_MARKER SET MARKER_TIMESTAMP = :B1 WHERE MARKER_TIMESTAMP <= :B1 AND TARGET_GUID IN (SELECT T.TARGET_GUID FROM MGMT_TARGETS T WHERE T.EMD_URL = :B2 AND T.REP_SIDE_AVAIL = 0 AND NOT EXISTS (SELECT 1 FROM MGMT_BLACKOUT_WINDOWS BW WHERE BW.TARGET_GUID = T.TARGET_GUID AND BW.START_TIME <= :B1 AND (BW.STATUS NOT IN (:B4 , :B3 ) ) ) AND NOT EXISTS (SELECT 1 FROM MGMT_BCN_AVAIL_DEF BCNAV WHERE BCNAV.TARGET_GUID = T.TARGET_GUID) )
SYSMAN 127,820 1,012 126 INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE) VALUES ( :1, :2, :3)
SYSMAN 113,048 7,133 16 SELECT PING.TARGET_GUID, TGT.TIMEZONE_REGION, TGT.TIMEZONE_DELTA, PING.STATUS FROM MGMT_TARGETS TGT, MGMT_EMD_PING PING WHERE TGT.TARGET_GUID = PING.TARGET_GUID AND TGT.TARGET _TYPE = :B2 AND TGT.EMD_URL = :B1 FOR UPDATE OF PING.TARGET_GUID
SYSMAN 109,418 6,970 16 SELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE
SYSMAN 94,231 68 1,386 BEGIN ECM_CT.POSTLOAD_CALLBACK(:1, :2); END;
DBSNMP 88,245 12,597 7 SELECT SQL_ID FROM DBSNMP.MGMT_BASELINE_SQL WHERE HASH_VALUE=:B2 AND INSTANCE_NUMBER=:B1
SYSMAN 83,152 2,856 29 INSERT INTO mgmt_ha_mttr(COLLECTION_TIMESTAMP, ESTIMATED_MTTR, TARGET_GUID) VALUES ( :1, :2, :3)
BACKUP_ADMIN 70,155 0 70,155 BEGIN SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'BACKUP_ADMIN', 'KUPC$C_1_20080601182203', 'KUPC$S_1_20080601182203', 0); END;
SYSMAN 63,521 5,951 11 UPDATE MGMT_TARGETS SET LAST_LOAD_TIME = :B1 WHERE TARGET_GUID = :B2 AND (LAST_LOAD_TIME < :B1 OR LAST_LOAD_TIME IS NULL)
SYSMAN 59,979 5,645 11 BEGIN :1 := MGMT_FAILOVER.heartbeat(:2); END;
DBSNMP 59,309 995 60 DELETE FROM DBSNMP.MGMT_LATEST_SQL WHERE CAPTURE_ID IN (SELECT CAPTURE_ID FROM DBSNMP.MGMT_LATEST WHERE INSTANCE_NUMBER = :B1 )
BACKUP_ADMIN 55,905 941 59 INSERT INTO "BACKUP_ADMIN"."SYS_EXPORT_FULL_01" (object_type_path, object_path_seqno, dump_fileid, dump_position,dump_length, dump_allocation, process_order, duplicate, object _row, object_type, object_schema, original_object_schema,object_name, object_long_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_or der,base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, size_estimate) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28)
SYSMAN 52,479 38,112 1 SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1
LBACSYS 45,811 3,772 12 select pol#, db_labels, default_format from lbac$pol
DBSNMP 44,365 19,228 2 SELECT * FROM V$SQLAREA V WHERE V.HASH_VALUE = :B1
DBSNMP 36,014 19,228 2 INSERT INTO DBSNMP.MGMT_TEMPT_SQL(SQL_ID, HASH_VALUE, ELAPSED_TIME, EXECUTIONS) VALUES (:B4 , :B3 , :B2 , :B1 )
LBACSYS 35,200 3,772 9 SELECT MAX(TAG#) FROM LBAC$LAB
DBSNMP 27,659 663 42 SELECT CAPTURE1.HASH_VALUE, CAPTURE1.SQL_ID, CASE WHEN CAPTURE1.ELAPSED_TIME >= CAPTURE2.ELAPSED_TIME THEN CAPTURE1.ELAPSED_TIME - CAPTURE2.ELAPSED_TIME ELSE CAPTURE1.ELAPSED_ TIME END, CASE WHEN CAPTURE1.EXECUTIONS >= CAPTURE2.EXECUTIONS THEN CAPTURE1.EXECUTIONS - CAPTURE2.EXECUTIONS ELSE CAPTURE1.EXECUTIONS END, BASELINE.EXECUTIONS, BASELINE.ELAPS ED_TIME FROM (SELECT * FROM DBSNMP.MGMT_CAPTURE_SQL WHERE CAPTURE_ID = :B2 ) CAPTURE1, (SELECT * FROM DBSNMP.MGMT_CAPTURE_SQL WHERE CAPTURE_ID = :B1 ) CAPTURE2, DBSNMP.MGMT_BA SELINE_SQL BASELINE WHERE CAPTURE1.HASH_VALUE = CAPTURE2.HASH_VALUE AND CAPTURE1.HASH_VALUE = BASELINE.HASH_VALUE AND BASELINE.INSTANCE_NUMBER = :B4 AND (CASE WHEN CAPTURE1.EX ECUTIONS >= CAPTURE2.EXECUTIONS THEN CAPTURE1.EXECUTIONS - CAPTURE2.EXECUTIONS ELSE CAPTURE1.EXECUTIONS END) >= :B3
SYSMAN 25,216 11,342 2 SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
DBSNMP 24,246 2,205 11 SELECT COUNT(*) FROM DBSNMP.MGMT_BASELINE_SQL WHERE INSTANCE_NUMBER = :B1
DBSNMP 23,872 663 36 DELETE FROM DBSNMP.MGMT_CAPTURE_SQL WHERE CAPTURE_ID IN ( SELECT CAPTURE_ID FROM DBSNMP.MGMT_CAPTURE WHERE INSTANCE_NUMBER = :B2 AND CAPTURE_ID < :B1 )
SYSMAN 23,554 796 30 BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
SYSMAN 23,335 7,030 3 INSERT INTO mgmt_db_latest_hdm_findings(COLLECTION_TIMESTAMP, END_TIME, FINDING_ID, IMPACT_PCT, MESSAGE, REC_COUNT, REC_TYPE, START_TIME, TARGET_GUID, TASK_ID) VALUES ( :1, :2 , :3, :4, :5, :6, :7, :8, :9, :10)
BACKUP_ADMIN 21,974 1 21,974 DECLARE JOBHNDL NUMBER; BEGIN :JOBHNDL := SYS.DBMS_DATAPUMP.OPEN( operation =>:OPERATION, job_mode => :JOB_MODE, remote_link => :REMOTE_LINK, job_name => :JOB_NAME, version => :VERSION, com pression => :COMPRESSION); END;
SYSMAN 21,970 3,553 6 UPDATE MGMT_FAILOVER_TABLE SET LAST_TIME_STAMP=SYSDATE WHERE FAILOVER_ID=:B1
DBSNMP 20,793 18,703 1 INSERT INTO DBSNMP.MGMT_LATEST_SQL( CAPTURE_ID, SQL_ID, HASH_VALUE, EXECUTIONS, ELAPSED_TIME, T_PER_EXEC, ADJUSTED_ELAPSED_TIME) VALUES(:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
SYSMAN 19,245 86 224 SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
SYSMAN 19,126 476 40 UPDATE mgmt_db_hdm_metric_helper SET COLLECTION_TIMESTAMP= :1 , TASK_AVAILABLE= :2 WHERE TARGET_GUID= HEXTORAW(:3)
SYSMAN 19,013 6,970 3 UPDATE MGMT_EMD_PING SET LAST_HEARTBEAT_TS = :B6 , LAST_HEARTBEAT_UTC = CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE), CLEAN_HEARTBEAT_UTC = :B5 , STATUS_SYNC_UTC = :B4 , EMD_UP TIME_UTC = :B3 , HEARTBEAT_RECORDER_URL = SUBSTR(:B1 , 0, 256) WHERE TARGET_GUID = :B2
DBSNMP 16,301 663 25 INSERT INTO DBSNMP.MGMT_CAPTURE_SQL( CAPTURE_ID, SQL_ID, HASH_VALUE, ELAPSED_TIME, EXECUTIONS) SELECT :B1 , SQL_ID, HASH_VALUE, SUM(ELAPSED_TIME), SUM(EXECUTIONS) FROM DBSNMP. MGMT_TEMPT_SQL GROUP BY HASH_VALUE, SQL_ID
SYSMAN 16,150 859 19 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 5 12), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,128), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
SYSMAN