Oracle10g Grid Book - 10g RAC Clusters
Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
  Phone
  800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

    Privacy Policy

  

ISBN
0-9744355-4-6
ISBN 13
978-0974435541
Library of Congress Number:
2004101910
680 pages: Hardcover - 9x7  PD 504
Shelving: Database/Oracle Oracle In-Focus Series # 18
 

 

Oracle 10g Grid & Real Application Clusters
Oracle10g Grid Computing with RAC

Mike Ault, Madhu Tumma    

Retail Price $69.95 /  £47.95

Order now and get immediate online access to the code depot! Only $51.95 
(Almost 30% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     
Get the RAC Pack - Half price!
Six Pack RAC for $79.95 - A $168.00 value
Oracle 10g Grid & Real Application Clusters $69.95
Personal Oracle RAC Clusters $27.95
Oracle on VMware $34.95
Oracle SQL Internals eBook $19.95
Oracle Space Management eBook $24.95
Oracle 10g DBA Reference Poster

$8.95


Mike Ault and Madhu Tumma are recognized as leaders in Oracle massively-parallel architectures and authors of the bestselling book, Oracle9i RAC. Ault is one of the world's most famous Oracle authors with over 20 books in-print, and Madhu Tumma is a recognized Oracle10g Grid and RAC expert. Together, Ault and Tumma dive deep inside Oracle 10g clustering and show you the secrets for quickly implementing Oracle10g Grid technology.

Combining the expertise of two world-renowned RAC experts, Oracle10g Grid and RAC is the first-of-its-kind reference for Oracle Grid computing. Covering all areas of Oracle Grid computing, this book is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle10g Grid with server blades.

This text presents a complete guide to the installation, configuration and design of Oracle Grid and 10g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. The text also demonstrates the use of Oracle Grid using the Enterprise Manager Grid control utility.

 
Key Features

* See working examples of Oracle Grid and RAC installation.

* Learn to configure Oracle Grid using Enterprise Manager.

* View the internals of shared disk technology, raw devices and RAID with Oracle 10g Grid.

* Understand the internal concurrency, resource coordination and locking for Oracle Grid systems.

* Get examples of real-time server load balancing with Oracle Grid Controller.

* Use working scripts to monitor and tune Oracle Grid and RAC.

 

About the Authors:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 



Madhu Tumma

 

  Madhu Tumma has been working as Software Developer, IT Manager, Database Administrator, and Technical Consultant for about 18 years. He has worked on a wide variety of projects and environments ranging from mainframe, client-server, eBusiness to managed services. He has provided consultancy to variety of clients on database clusters, business continuity and high availability solutions. His experience ranges across multiple relational database systems. Madhu is frequent speaker at Oracle World and IOUG where he presented many technical papers. Madhu has Master Degree in science and attended Business Management graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep.

 

Table of Contents:

CHAPTER 1 - Introduction to RAC and Grid Computing

What is Grid Computing?

Where is the IT world on Grid Computing?
     What is the Oracle's direction?
        Why this new found love for Grid Computing !!

Grid Types –
Discussion - Different Classification Systems
    
Computational grids,
        Scavenging grids
        Data Grids

Nature of Data Grid and Federation of Databases
     What is the difference between a Grid and Cluster?

Introduction to Cluster Technology
     Introduction to Oracle Real Application Cluster

The Dynamic Business Environment
     Justification for HPC and HA Systems
     Benefits of Real Application Clusters (RAC)

Suitability of Oracle RAC to be a Grid Resource 

Where does 10g RAC stand Now
     Evolution from OPS
     9iRAC and now 10G RAC

Computing Trends
     Utility Computing
     On-Demand Computin
g

 Role of Blade Frame Server
Dynamism of Servers

Conclusion

References

CHAPTER 2 - High Performance and Highly Available Database Clusters

High Performance
     Growth of Powerful Processors    
     Why Parallel Processing?   
     Opportunities for Parallelism
     Scalability     

Parallel Databases
     Types of Parallelis

High Performance Computing Clusters - HPCC 

Clusterize Applications
When do you need to to clusterize
How do you Clusterize Applications?

Highly Available Databases
     Highly Available Data
     Failure
     Availability
     Reliability and Serviceability
     Fault Tolerant Systems
     Database Availability 

Clustered Systems 

Database Issues

Oracle RAC
     A truly High Performance and Highly Available Database 

Overview of the Cluster Technology
How Clusters Differ from Distributed Systems
Clusters are Different from Fault-Tolerant Systems
Why Clusters?
Cluster Objectives   
 

Types of Clusters
     Failover Clusters
     Scalable High Performance Clusters
     Application Server Clusters  
     Other Types of Clusters      

Components of a Cluster    
     Cluster Nodes
     Emerging Server Cluster Architectures
     Cluster Interconnect
     Cluster Interconnect Products
     Infiniband Interconnect
     ClusterWare
     Essentials for Parallel Database Clusters
     Concurrent Database Access

Failover Database Clusters
     Resources, Resource Types
     Resource Groups
     The Concept of a Virtual Server
     Failover Process
     Examples      
     Failover Cluster Architecture         
     Oracle Database Service in HA Cluster      
     Issues with FO Clusters - Hidden Risks
      

 Parallel Database Clusters
Shared-Nothing Model
Shared-Disk Model    
Microsoft SQL Server Federated Database  IBM Offerings
Requirements for Parallel Clusters  
Oracle’s Instance Membership Recovery
Cache Coherency and Lock Management   
 

Grid Enabled Clusters
      Handling unpredictable usage patterns

Conclusion    

References

CHAPTER 3- Grid Computing and the Role of Clusters

Grid and Cluster
Collection of computing resources - Grid
Aggregation of Nodes - Clustering

Nature of these two architectures
Nodes in the Clusters with Cluster software
Nodes in the Grid with Grid Management Software
Logical or Virtual Grid – as seen by Application 

Discuss from authors point of view 

Three-Point Check for Grid proposed by Ian Foster

CHAPTER 4 - REAL APPLICATION Cluster Architecture

Overview of Oracle Real Application Cluster
Evolution Real Application Cluster – The flag ship option of Oracle Database
First Incarnation as Oracle Parallel Server – OPS
Changes in 8i Release – OPS
Changes in 9i Release – RAC

     Full Implementation of Cache Fusion

     
Introduction of Real Application Cluster – 9i RAC (Re-Christened as RAC)
  New Features in 10g RAC Release

RAC Database Architecture
RAC Instance and RAC Database

 ·
         Discuss Nature and Differences
 
·
         Multi-Instance Database
Basic Database Processes
Basic Internal Structures
RAC Additional Processes
RAC Additional SGA Areas
Global Cache Service - GCS
Global Enqeue Service - GES
Resource Modes and Roles
Global Resource Directory 

Cluster Ready Services
     Primary CRS resources
                  Virtual IP Address (Session Alias

                  
Database Composite Resource Group
   
         Service Composite Resource Group
                    Net Listeners
     Oracle Cluster Registry – OCR
     OCR Clients: CSSD, CRSD, EVMD, and the EVM Logger daemons
     CRS Profiles 

Cluster Synchronization Services (CSS)
     New  cluster manager for all platforms
     Cluster Synchronization Service Daemon (OCSSD) for Unix 

GSI - Grid Security Infrastructure  

RAC Server Components
      Hosts and Blades
     Server Redundancy
     Necessity of Server Redundancy
     Redundancy Features

RAC Disk System
     Shared Storage – Components to reside on
           Raw Partitions
           Cluster File System

10g Automatic Storage Management – ASM
Logic behind this approach
Benefits – reduction layers
Issues one can anticipate
How does it compare with Volume Manager Controlled Volumes
VXVM and ASM 

How does ASM work
Mechanism
Examples

Storage Technology and Redundancy
     Basics of Storage Disk System
          Understanding I/O Path
          Host Bus Adapter (HBA
          Storage Redundancy Components   
          Multiple RAID Controllers and Storage Processors
          Power Management
          High Availability with SAN

                       
RAID and RAID Administration
                      
Multiple Access Paths to Host
                       Logical Volume Manager

     Cluster File System
          Oracle10g RAC and CFS      
          Context Dependent Symbolic Link - CDSL  
                  
          Veritas CFS   
         
 PolyServe Matrix Server (MxS)       
         
 HP Tru64 CFS

     Oracle Cluster File System (OCFS)
          Growth and changes over the last two years
          Can it be a true general file system
          New features on OCFS 2.0

     Other CFS solutions
         
 NFS as viable Cluster File system

     Oracle Managed Files

     Oracle Disk Manager
           
API developed by Oracle 

Conclusion

References

CHAPTER 5 - RAC Installation and Configuration

Preparation of Environment
     Fits in to the Grid
     Guidelines and Best Practices
     Certification Matrix 

Installation and Components
     Servers and Operating system
     Interconnect and Cluster_Interconnect parameter
     Cluster Software Installation
     Shared Storage
           Work out the Raw Devices or CFS Files – General Discussion 

General Steps
     Phase – 1 
     Phase – 2
     Phase – 3

On Solaris Servers
     Hardware / System Details
     Creating the Cluster Using Sun Cluster 3.1
          Install the Volume Manager

                        
Install the Clusterware (OSD) for RAC
          Configure Shared Storage
          Veritas Cluster Volume Management        
          UNIX Pre-Installation Steps
    Using Veritas DBE/Advanced Cluster
          Communication Stack
          Shared Storage Configuration        
          VCS Framework and Service Groups
          Veritas I/O Fencing and SCSI-3 Persistency
          Install DBE/AC and Configure Service Groups – First Stage
          Install DBE/AC and Configure Service Groups – Second Stage 

Using HP Tru64 Unix
     Hardware / System Details
     Set up Disks
     Creating the Cluster 

Using HP-UX Clusters
     Hardware / System Details
     Creating the Cluster
     Shared Storage Configuration        
     Configure HP ServiceGuard Cluster
     UNIX Pre-installation Tasks
     Using Veritas DBE/Advance Cluster on HP-UX Servers

Using IBM AIX Servers
     Hardware / System Details
     What is VSD?
     Configure using HACMP/ES
     General Parallel File System - GPFS
     Oracle Installation


Using Windows Cluster
     Hardware / System Details
     Creating the Cluster
     Configure Shared Storage
     Special Notes for NFS based shared Installation

On Linux Based Systems
     Install and Configuration
          • Red Hat
          • United Linux
     Hardware / System Details
     Interconnect & Cluster Software
     Shared Storage Volumes
     Oracle Cluster File System (OCFS)
     PolyServe Matrix Server
     FireWire Drive as Shared Storage
     Emphasize and Discuss the O C F S growth and Adaptability
    What is coming in OCFS 2.0
    Oracle Software Installation and Creation of Database
    Oracle Software Installation
    Database Creation using DBCA
          • Support Automatic Storage Management (ASM) (NEW feature)
          • Support for Oracle File Manager (OMF) (NEW feature)
     Database Creation Manually
     Adding Threads and expanding Instances

Dynamic Node Management
     Suggestions and Planning

Conclusion

References

CHAPTER 6 - Cache Fusion and Inter-Instance Coordination

Overview of Cache Fusion
     Evolution of Cache Fusion
     Nature of Cache Fusion
     Benefits of Cache Fusion    
     Concurrency and Consistency        
     Cache Coherency
     Global Cache Service

SGA Components and Locking
     SGA – System Global Area
     Program Global Area (PGA)
     Buffer Cache Management
     What is a Dirty Block?
     Multi-Version Consistency Model


RAC Components
     Global Cache Service
     Global Enqueue Service
     Row-Level Locks


Global Resource Directory
     Discussion

Resource Coordination
    Synchronization
    GCS Resource Modes and Roles
    Concept of Past Image
    Lock Modes
    Block Access Modes and Buffer States


Cache Fusion Scenarios
    Block Transfers using Cache Fusion - Examples
    Block Access, Grants, and Interrupts


Cache Fusion and Recovery
     Recovery Features
     Recovery Methodology and steps
     Recovery Process
     Re-mastering Resources

Conclusion

References

CHAPTER 7 - RAC Administration

Parameter Management
     Overview
     RAC and Initialization Parameters


Password File Management

UTIL_DIR location

UNDO Management
     Undo Management in RAC
     UNDO Tablespace Features
     System Rollback Segment


Concept of Thread
     Thread Features
     Redo Thread Maintenance

Segment Space Management
     Automatic Segment Space Management
     Manual Space Management


Oracle Managed Files
     Utility of OMF
     Format and Syntax


External Tables
     Use of external tables
     Relevance of Shared Storage for locating external tables


7.9 Server Control Utility
     srvctl add
     srvctl config
     srvctl getenv
     srvctl setenv
     srvctl start
     srvctl status
     srvctl stop

Using SQL*Plus
     Starting the database in Cluster mode

Using Oracle Enterprise Manager
     Configuration of OEM with RAC
     Managing with GRID Control Utility


Cluster Ready Services CRS
     Profiles administration

Conclusion

CHAPTER-8 - Transparent Application Failover - TAF

Overview of Transparent Application Failover
     Load Balancing
     Example listener.ora
     Example tnsnames.ora
     Dynamic Registration (new section)

Example TAF Configurations
     TAF with Connect-Time Failover and Client Load Balancing
     Configuring TAF to Retry a Connection
     Configuring TAF for Pre-Establishing Connections
     Verifying TAF Configurations
     Using Instance Role for Configuring the Primary and Secondary Instance
     Connection to Instance Role Type
     Establishing a Connection to a Specific Instance
     Using BACKUP with TAF Pre-Establishing a Connection

Using OCI Driver
    An example showing the TAF

Conclusion

References

CHAPTER-9 - Application Deployment

Overview
     Database Consolidation
     E-business Applications


RAC Suitability
     Advantages of the RAC database
     Scalability
     Unpredictable Loads
     High Availability


Application Deployment Issues
     OLTP applications using ‘exclusive’ or specific data
     Departmental Applications
     Data warehousing Applications

Applications requiring HA
     Large Batch jobs
     Using Parallel Instance Groups


RAC Suitability for Packaged Applications
     SAP and Real Application Clusters
     Status of Oracle RAC/SAP certification
     SAP's MCOD
     Performance considerations
     Siebel and RAC
     Oracle eBusiness Suite

Middleware Software
     JDBC Connectivity
     JDBC Thin Driver
     JDBC Oracle Call Interface Driver
     JDBC Server-Side Internal Driver
     Web Logic and RAC database

Conclusion

References

CHAPTER-10 - RAC Design Considerations

Designing Equipment for Real Application Clusters
     What are the effects of component failure?
          • Failure of the Internet or Intranet
          • Failure of the firewall
          • Failure of the Application Server
          • Failure of the Database Server
          • Failure of the fabric switch
          • SAN Failure
          • NICs
     Provide Redundancy at Each Level

Designing for High Performance
     Confining Transactions to Specific Nodes
     Creating Efficient RAC Data Objects
     Proper Sequence Usage


Tablespace Design in Real Application Clusters
     Extent Management and Locally Managed Tablespaces
          • Identifying Extent Management Issues
          • Minimizing Extent Management Operations
          • Using Locally Managed Tablespaces

Minimizing Table Locks to Optimize Performance
     Disabling Table Locks for Individual Tables
     Setting DML_LOCKS to Zero

Performance for Object Creation in Real Application Clusters

Summary of Guidelines

Conclusion
References


CHAPTER 11 -Backup and Recovery

Overview of RAC Backup and Recovery
     Discussion – Instance Failure v/s Media Failure
     Export – Logical Backup
     Cold Backup using Scripts
     Hot Backup Using Scripts
     RMAN (Recovery Manager)
     Third Party Solutions
     How do the things change with A S M?


Backup of RAC database
     Using RMAN for Backups
     Backup Procedures for RMAN and RAC

Recovery in the RAC Environment
     Media Recovery in RAC Instances
     Using RMAN to Recover a RAC Environment
     Recovery in an OCFS Environment
     Recovery in a Raw File System Environment
     Parallel Recovery


Standby Databases in RAC Configuration
     Setting up a Standby Database For a RAC Cluster
     Configuration when the Standby Database is also a Cluster (RAC-) System
     Log Shipping when the Standby Database is a Single Node System
     Cross-Instance Archival
     Archive Log Gap Resolution and FAL

Tips on using backup with Storage replication
     Hitachi Storage
     EMC Storage
     Using Veritas Volume Replicator

Conclusion

References

CHAPTER 12 - Performance Tuning

Analysis of Performance Issues

Using Automated Memory Management (AMM) with RAC

Disk Monitoring and Tuning for RAC and ASM

Monitoring RAC Cluster Interconnect Performance
     Undesirable Global Cache Statistics
     Monitoring CURRENT Blocks
     Additional Wait Events of Concern


Global Cache Service Times

GCS Monitoring
     Use of the "CACHE_TRANSFER" Views
     Monitoring the GES Processes
     Monitoring the Global Directory


Monitoring and Tuning RAC using OEM

Configuring the Oracle Intelligent Agent With RAC
     Step-By-Step Setup of the Intelligent Agents on UNIX

Monitoring RAC Using OEM

Tuning Guidelines

Conclusion

References

CHAPTER 13 - RAC Guard

Using RAC Cluster Guard

Examining the Basics of Cluster Guard Technology
     Oracle Real Application Clusters Guard Packs
     The RAC Guard PFSCTL Control Utility
     The Oracle Real Application Clusters Guard Monitors
     Oracle Real Application Clusters Guard Configuration Templates
     PFSSETUP Utility

Concepts of Oracle Real Application Clusters Guard
      Primary and Secondary Instance Roles
      Preferred Primary and Secondary Nodes
      Definition of the Home and Foreign Nodes


Architecture of Oracle Real Application Clusters Guard 558
     Oracle Real Application Clusters Guard Packs
     Resources
     Using the RAC Cluster Guard Command Line Utility
     Recovering from an Unplanned Outage on One Node
     Recovering from Unplanned Outages on Both Nodes
     Configuring the Call-Home Feature
     Enhancing Application Failover with Role Change Notification


ORATAB File Entries for Oracle RAC Guard

Using dbms_libcache to Warm the Secondary Cache
     Overview of Warming the Library Cache
     Set Up of DBMS_LIBCACHE

     Use of the dbms_libcache Package
     Managing the Oracle Real Application Clusters Guard Log Files
     What if a Failover Occurs while Datafiles are in Backup Mode?

Conclusion

References

CHAPTER 14 - Advanced Topics

Migration to RAC environment
     Moving Single Instance to RAC
         • Decision to migrate to a RAC database
         • Obtain the necessary server hardware infrastructure
         • Procedure - A
         • Procedure - B


Upgrading Oracle 9.2.0.4 to 10.x
     Moving HA cluster to a RAC cluster
        • Procedure to move the VCS to Veritas DBE/AC RAC
        • Migration Features
    Packaged Applications
        • In case of SAP applications
        • Verification Process
        • Upgrade SAP Software and Tools
        • BRTOOLS
     In case of Oracle eBusiness Suite

Convert from Raw Partition to OCFS based infrastructure
     Using Transportable Tablespaces - RMAN

Storage Replication in RAC Environment
     EMC SRDF implementation in RAC environment
     Hitachi replication

Blade Servers
     How do they help in node dynamism
     Survey of blade architecture
     Case Study of E-genera Bladeframe implementing RAC solution

Switched Computing and its role in RAC environment
     Top Spin switches
     Where is infiniband

CHAPTER 15 - Parallel Execution

Types of Parallelism
     Inter-Query and Intra Query-Parallelism
     Parallelism in Oracle Relational Database


Parallel Execution Mechanism
     Granules for Parallelism
     Parallel Execution Servers
     Degree of Parallelism – DOP


Parallel Operations
     Parallel Query: SELECT
     Parallel DML – update, Merge, Delete
     Parallel DML – Insert …. Select
     Parallel DDL Statements
     Rules for Parallelizing “Create Table as Select” (CTAS)


SQL*LOADER – parallel load
     Using concurrent conventional path loads
     Parallel Direct Path Load


Other Parallel Operations
     DBWR and LGWR
     Parallel Recovery
     Using Fast-Start Parallel Rollback
     Replication – Parallel Propagation


Oracle RAC and Inter-Instance parallelization
     Initialization Parameters at Glance
     Monitoring and Diagnosing the Parallel Execution


Technology

Conclusion

References

CHAPTER 16 - The Grid Computing

Basics

Introduction to Grid: Grid computing as the next evolution of the Internet.
     Leveraging Commodity Components
     Concept of building super size computers using cheap, off the shelf components is proven by supercomputers built on Intel/Linux platform.
     Elaborate further ...
     Why Grid ? Utilizing unused resources ( capacity built for peaks, lying around unused )


Technology
     Virtualization

Mechanics

Grid Case Studies (In brief)
     Business applications (Platform Computing etc)
     Scientific applications ( CERN openlab for DataGrid applications, Large Hadron Collider project; SETI@Home)

Grid Standards
     The Role of OGSA - Open Grid Services Architecture
     The OGSA Service Model
     Database as a Service with in the grid


What is Global Grid Forum?

What is Globus?

What is Globus Toolkit?

The Role of OGSA - Open Grid Services Architecture
     OGSA ( Open Grid Services Architecture ) integrates Globus and Web services:
     The OGSA Service Model
          Database as a Service with in the grid
          Making existing services readily usable individually or collectively within a Grid framework.



CHAPTER 17 - Grid and Oracle RAC Integration

On-demand Database Service

Oracle Grid Ready Database

Automatic Load balancing of systems

Consolidate and Share

Expanding DB computing resource

Oracle 10g Scheduler

Coordinated scheduling of both computing and database resources
     - Is this is a new dbms_job package ? New features/why to use it
     - What is program ?
     - What is schedule ?
     - Creating Schedules
     - Altering Schedules
     - Dropping Schedules
     - Administering Job Classes
     - Administering Windows
     Administering the Scheduler
     Configuring the Scheduler
     Monitoring and Managing the Scheduler
     How to Monitor and Manage Window and Job Logs
     Job Run Logs
     How to Change Job Priorities


Data Pump
     Data Pump Components
       - expdp and impdp
       - The DBMS_DATAPUMP
       - The DBMS_METADATA
    Data Pump New Features
        - performance improvement ( now same time for export and import )
        - Size estimate
        - The ability to restart Data Pump jobs.
        - Support for fine-grained object selection, based upon objects and object types ( all with samples )


Oracle Streams
     What Can Streams Do?
     Why Use Streams?
       - Message Queuing
       - Data Replication
       - Event Management and Notification
       - Data Warehouse Loading
       - Data Protection
     Administration Tools for a Streams Environment
     Sample application.

Transfer of data
    Fine-grained data transfer ( Oracle Streams )
    Bulk data transfers ( Data Pump, Transportable Tablespaces )
    Transportable Tablespaces
     Used with RENAME TABLESPACE to move data between databases; no platform independent
     Step-by-step primer
     Limitations/Usefulness summary
     DBMS_FILE_TRANSFER
    Step-by-step primer
     DBMS_STREAMS_TABLESPACES_ADM
     How Data Pump, DBMS_FILE_TRANSFER, DBMS_STREAMS_TABLESPACES_ADM interact ? Sample application.

Automatic Provisioning of Oracle RAC Instances
    Service Virtualization
    Virtualization is the abstraction into a service of every physical and logical entity in a grid. (Further elaborate).
     Resonance
     Oracle Portable Clusterware

Conclusion

References

CHAPTER 18 - Workload Management

Discuss the Service concept

Dynamic Allocation

Dynamic Provisioning
    - distributing supplies where they are needed.
    - Consolidate, share ( transportable tablespaces, Streams ) , and federate information.

Conclusion

References
 


 


 

 


 


 

Index Topics:
_syssmun$
{
{memb}
A
Acquisition Interrupt
active_instance_count
address_list
Advanced Queues
aio_read()
aio_write()
all_indexes
all_tables
ALTER SYSTEM SET
Amnesia
Application Server Clusters
Application Server Grid
ARCH
archive_lag_target
ASM
ASM aliases
asm_diskgroups
asm_diskstring
asm_power_limit
ASMLib
async_write()
ault_primary
ault_secondary
autolocation
Automated Storage Management
Automatic Storage Management
Automatic Undo Management
Availability
Avaki
average global cache convert time
B
big endian
bigfile tablespace
Bitmap Managed Block
Blade Server
BladeFrame
Blades Center
Block Arrival Interrupt
block pinging
Block Range Granules
Block Server Process
block transfer time
Blocking Interrupt
blocksize
buffer
buffer busy global cache
buffer busy global cr
buffer busy waits
buffer cache hit ratios
C
cache coherency
cache convert
cache fusion
cache open waits
Cache structure
Campus Grids
Capacity Planning
CATALOG.SQL
CATCLUST.SQL
CATPROC.SQL
cdslinvchk
CFSMount
charset
circuits
CKPT
Client Process
clscfg
Cluster Configuration Tool
Cluster Grids
Cluster Ready Services
Cluster Registry Configuration Tool
Cluster Synchronization Services
Cluster Volume Manager
cluster wait class
cluster_database
cluster_database_instances
cluster_interconnects
Clustered Database
ClusterPulse daemon
Clusterware
commit
compatible
compile
Computational Grid
Concurrent Logical Volume Manager
Concurrent Resource Manager
Concurrent Virtual Shared Disk
connect_data
consistent gets
Control Files
Control Queue
control_files
Coupling Facility
CPU cycles
CQJ
cr request retry
create()
create_consumer_group
create_pending_area
create_plan
create_plan_directive
create_schedule
create_simple_plan
crsd
css_voting_disk
current mode blocks
CVMCluster
CVMVoldg
D
Data Block Addresses
Data Files
Data Grid
Data Pump API
data_only
database buffer cache
Database Configuration Assistant
Database Resonance
Database Server Grid
DataSynapse
db block changes
db block gets
db_k_cache_size
db_block_buffers
db_block_size
db_cache_size
db_create_file_dest
db_create_online_log_dest_n
db_domain
db_file_multiblock_read_count
db_files
db_name
db_nk_cache_size
db_recovery_file_dest
db_recovery_file_dest_size
db_unique_name
dba_datapump_jobs
dba_datapump_sessions
dba_indexes
dba_tables
dba_tablespaces
dba_undo_extents
dbca_raw_config
dbms_datapump
dbms_defer_sys.schedule_push
dbms_libcache
dbms_metadata
dbms_resource_manager
dbms_rowid
dbms_scheduler
dbms_space.free_blocks
dbms_space.space_usage
dboraslib
DBWn
DBWR
dc_free_extents
dc_object_ids
dc_sequences
dc_used_extents
degree of parallelism
description_list
DIAG
Diagnosability Daemon
Dictionary cache
Dictionary Cache Locks
direct path api
dispatchers
DLM daemon
dlm_conflicts
dlm_requests
dml_locks
Dnnnn
E
end_date
endianness
Enqueues
Enterprise Manager Console
estimate_only
evmd
exclude
exp_full_database
External Table API
External Tables
F
failed_over
failover
Fail-over Clusters
failover_method
failover_mode
Failure
fal_client
fal_server
fast_start_io_target
fast_start_mttr_target
fast_start_parallel_rollback
federated database
Federation of Databases
fet$
file_mapping
filesize
filesystemio_options
flashback_scn
flashback_time
FMON
freelist groups
freelists
fsck
G
gc cr block -way
gc cr block -way
gc cr block busy
gc cr block congested
gc cr blocks received
gc cr grant -way
gc current block -way
gc current block -way
gc current block busy
gc current block congested
gc current blocks received
gc current buffer busy
gc current grant -way
gc_files_to_locks
 
General Parallel File System
Global Access to Secondary Storage
global cache
global cache bg
global cache blocks corrupt
global cache blocks lost
global cache busy
global cache converts
global cache cr
global cache cr block receive time
global cache cr blocks received
global cache cr request
global cache current blocks received
global cache current blocks served
global cache get
global cache gets
global cache null to s
global cache null to S
global cache null to x
global cache null to X
global cache open s
global cache open S
global cache open x
global cache open X
global cache pred cancel wait
global cache retry prepare
global cache S to X
Global Cache Service
Global Clusters
Global Enqueue Service
Global Enqueue Service Daemon
Global Grid
global lock async converts
global lock async gets
global lock convert time
global lock get time
global lock sync converts
global lock sync gets
Global Resource Directory
Global Service Daemon
Global Services Daemon
Global Toolkit
global_dbname
Globus Resource Allocation Manager
Grid Architecture
Grid Computing
Grid Control
Grid Control Utility
Grid Security Infrastructure
GridFTP
GridServer
GSD
gv$cache_transfer
gv$cr_block_server
gv$dml_misc
gv$enqueue_stat
gv$gchvmaster_info
gv$gcspfmaster_info
gv$segment_statistics
gv$session_wait
gv$sqlarea
gv$sysstat
gv$system_event
H
HA clusters
HACMP
HBA drivers
Hewlett-Packard
High Performance Computing Clusters
host_name
Hot spare
I
IBM
icx_parameters
if_name
if_type
ifile
include
Infiniband
Infiniband interconnect
init.ora
initial
initrans
instance_groups
instance_name
instance_number
instance_path
instance_role
instance_type
inter-query parallelism
Inter-Query Parallelism
Intra-Query Parallelism
ioctl
ioctl()
isqlplus
J
java_pool_size
JBOD
Jnnn
Job Class
job_name
job_queue_processes
Just a Bunch of Disks
K
kaio()
keep_master
kill_job
L
large_pool_size
Layered Grid Architecture
LCKx
LGWR
Library cache
Library Cache locks
license_max_sessions
license_max_users
license_sessions_warning
Lightweight Directory Access Protocol
lio_listio()
List structure
listener.ora
listeners_db_name
little endian
LMD
LMDx
LMON
LMSn
LMSx
load_balance
local_listener
lock buffers for read
lock converts per transaction
lock gets per transaction
Lock structure
log_archive_dest
log_archive_dest_n
log_archive_format
log_archive_start
log_archive_trace
log_buffer
log_checkpoint_interval
log_checkpoint_timeout
log_purge_policy
Logical Unit Number
Logical Volume Manager
lsnodes
lvcreate
M
Master Control Process
max_commit_propagation_delay
max_dispatchers
max_shared_servers
maxinstances
maxlogfiles
maxtrans
Mean Time To Failure
Mean Time To Recovery
Memory Manager
messages flow controlled
messages received
messages sent directly
messages sent indirectly
minextents
mkcdsl
mkfs
MMAN
MMNL
MMON
Monitoring and Discovery Service
mts_circuits See circuits
mts_dispatchers See dispatchers
mts_listener_address See local_listener
mts_max_servers See max_shared_servers
mts_max-dispatchers See max_dispatchers
mts_multiple_listeners See local_listener
mts_servers See shared_servers
mts_sessions See shared_server_sessions
Multiple Components in One Database
mxmpio
Myrinet
N
net_service_name
NetApp Filer Cluster
Network Attached Storage
Network Load Balancing Cluster
network_link
next
nodename
nologfile
NUMA architecture
O
o_direct
o_directio
ocfstool
ocrconfig
ocssd
odm_abort()
odm_commit()
odm_create()
odm_io()
OGDK
olsnodes
On-Demand and Utility Computing Model
opatch
Open Grid Services Architecture
Open Grid Services Infrastructure
open()
open_cursors
open_links_per_instance
oprocd
optimal
Optimal Flexible Architecture
ora_oemagent_dir
ORA-
Oracle Cluster Registry
Oracle Cluster Synchronization Service Daemon
Oracle Data pump
Oracle Database Configuration Assistant
Oracle Disk Manager
Oracle Enterprise Manager
Oracle Globus Toolkit
Oracle Interface Configuration
Oracle Managed Files
Oracle Notification Services
Oracle Parallel Server
Oracle Streams
Oracle Transportable Tablespace
Oracle Universal Installer
oracle_datapump
oracle_loader
oracle_sid
OracleCRService
OracleCSService
OracleEVMService
Oracle-managed files
OracleServicesid
orainstRoot.sh
ORB#
ORBn
ORCLUdlm
OSMB
P
PanPulse daemon
parallel
Parallel Clustered Database
Parallel Execution
parallel execution coordinator
Parallel Query Process
parallel_adaptive_multi_user
parallel_automatic_tuning
parallel_broadcast_enabled
parallel_execution_message_size
parallel_index
parallel_instance_group
parallel_max_servers
parallel_min_percent
parallel_min_servers
parallel_threads_per_cpu
parallelism
Partition Granules
pctfree
pctincrease
pctused
pga_aggregate_target
physical reads
physical writes
Platform Computing
Platform LSF
PMON
Pnnn
Portable Clusterware
prallel_max_servers
pread()
processes
Program Global Area
program_type
Psd drivers
pvcreate
pwrite()
Q
QMN
query
query_rewrite_enabled
query_rewrite_integrity
R
RAC
racgevt
RBAL
read()
readv()
Real Application Cluster
Real Application Clusters
recordlength
recovery_catalog_owner
recovery_parallelism
Redo Log files
Redundant Array of Independent Disks
Reliability
remap_datafile
remap_schema
remap_tablespace
remote instance undo block writes
remote instance undo header writes
remote_listener
remote_login_passwordfile
repeat_interval
Resource Consumer Group
Resource Manager
Resource Plan
Resource Plan Directive
Resource Specification Language
resumable
resumable_name
resumable_timeout
reuse_datafiles
rlogin
rollback_segment
rollback_segments
root.sh
row cache locks
row_locking
rsh
S
SAME
SANPulse daemon
Scalability
Scalable Coherent Interconnect
Scalable High-Performance Clusters
Scavenging Grid
schemas
scinstall
SCL daemon
Server Control Utility
Server Management
Service Registration
service_names
session_cached_cursors
session_cookie_name
sessions
set_group_mapping
set_initial_consumer_group
sga_max_size
sga_target
Shadow Process
Shared Disk Model
Shared Nothing Model
shared_pool_size
shared_server_sessions
shared_servers
Simple Object Access Protocol
 
skgxn
skgxp
smallfile tablespace
SMON
Snnn
spfile
SPFILE
Split Brain
spreport.sql
SQL*Net
SQL*Plus
sqlfile
sqlnet.ora
sqlplus
srvconfig
SRVCONFIG
srvctl
SRVCTL
srvctl add
srvctl config
srvctl getenv
srvctl setenv
srvctl start
srvctl status
srvctl stop
start_date
statistics
statspack.snap
status
Status Queue
STOMITH
STONITH
stop_job
Storage Control Layer
Storage Management Grid
streams_pool_size
Stripe and Mirror Everything
subnet
Switch Computing Architecture
switch_consumer_group_for_user
switch_current_consumer_group
System Change Number
System Global Area
T
Table locks
table_exists_action
tcp_recvspace
tcp_sendspace
thread
time_waited
tnsnames
tnsnames.ora
toid_novalidate
trace_enabled
Transaction locks
transactions
transactions_per_rollback_segment
transport_full_check
transport_tablespaces
Transportable Tablespaces
tts_owners
U
UDC
udlm
uet$
UNDO tablespace
undo_management
undo_retention
undo_suppress_errors
undo_tablespace
user_datapump_job
user_dump_dest
user_indexes
user_tables
userid
Utility Computing
Utility Data Center
utl_file
utl_file_dir
V
v$active_services
v$bh
v$cache_transfer
v$class_cache_transfer
v$database
v$dispatcher
v$dispatcher_config
v$enqueues_stats
v$file_cache_transfer
v$log
v$log_history
v$logfile
v$obj_stats
v$osm_alias
v$osm_client
v$osm_disk
v$osm_diskgroup
v$osm_file
v$osm_operation
v$osm_template
v$pq_sesstat
v$pq_slave
v$pq_sysstat
v$px_process
v$rollstat
v$rowcache
v$session
v$session_longops
v$session_wait
v$sesstat
v$system_event
v$tablespace
v$temp_cache_transfer
v$transaction
v$transportable_platform
v$undostat
varyonvg
version
vgcreate
vipca
Virtual IP Configuration Assistant
Virtual Shared Disk
virtualization
volsize
vxconfigd
vxfentsthdw
W
Worker Process
write()

Reviews:

 

Errata:

The timestamp heading on this script should read "Timestamp", not "Date Last Used":

SOURCE 10.41 Example of database outline report.

rem
rem NAME: outline.sql
rem FUNCTION: Generate a lit of all outlines in the
rem database for a specific user or all users
rem HISTORY: MRA 5/13/98 Created
rem
COLUMN owner        FORMAT a8   HEADING 'Owner'
COLUMN name         FORMAT a13  HEADING 'Outline|Name'
COLUMN category     FORMAT a8  HEADING 'Category|Name'
COLUMN used         FORMAT a7   HEADING 'Used?'
COLUMN timestamp    FORMAT a16  HEADING 'Date Last|Used'
COLUMN version      FORMAT a9   HEADING 'Version'
COLUMN sql_text     FORMAT a40  HEADING 'SQL Outlined' WORD_WRAPPED
BREAK ON owner ON category
SET PAGES 58 LINES 130 FEEDBACK OFF VERIFY OFF
START title132 'Database OUTLINE Report'
SPOOL rep_out\&db\outline.lis
SELECT
     owner,
     name,
     category,
     used,
     to_char(timestamp,'dd/mm/yyyy hh24:mi') timestamp ,
     version,
     sql_text
FROM
     Dba_outlines
WHERE
      Owner LIKE '%&owner%'
ORDER BY
      owner,category;
SPOOL OFF
CLEAR BREAKS
TTITLE OFF
SET FEEDBACK ON VERIFY ON

LISTING 10.39 Example of output from database outline report.

Date: 05/13/99                                                                         Page:   1   
Time: 11:44 PM                  Database OUTLINE Report                             SYSTEM        
                                  ORTEST1 database

         Outline       Category         Date Last
Owner    Name          Name     Used?   Used             Version   SQL Outlined
-------- ------------- -------- ------- ---------------- --------- -----------------
TELE_DBA PROD_OUTLINE1 PROD     UNUSED  13/05/1999 23:39 8.1.5.0.0
select owner,table_name from            

dba_tables
         PROD_OUTLINE2          UNUSED  13/05/1999 23:39 8.1.5.0.0
 

 

   

 Copyright © 1996 -2011 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks