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



Report Index













Database and Instance Information
Report Header Version Options Database Registry
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.d