Index

A B C D E F G H I J L M N O P R S T U V W X

A

accessing configuration pages, 4.2

Active Session History (ASH), databases, 6.2.2.1

Active Sessions Waiting page, picture of, 6.2.2.1

ADDM, 3.3.1

purpose of, 3.3.1

using, 6.2.3

viewing findings, 6.2.3

administering

databases, 6.3

hosts, 5.1.3

Linux hosts, 5.1.3.1

administrators

defining rules, 2.3.2

responsibilities today, 2.3.1

Advisor Central Home page, 6.3.15

advisors

database administration, 6.3.15

invoking, 6.3.15

versus alerts, 6.3.15

Aggregate Service service type, 8.1.1

alerts

Collaboration Suite, 10.5

initiating with AWR, 6.2

server-generated, 3.3.1

services, 8.4.5

versus advisors, 6.3.15

application database administrator, role of in data masking, 6.5.2

Application Server

analyzing historical performance, 9.5.3

extensible monitoring, 9.5.7

managing configurations, 9.8

applying critical patches, 12.6.4.1

automated

RAC deployments, picture of, 2.3.3

Automatic Database Diagnostic (ADDM) page, picture of, 6.2.3

Automatic Database Diagnostic Monitor

See ADDM

automatic restarts, RAC, 6.8.3

Automatic Storage Management (ASM), 6.3.3

Automatic Workload Repository (AWR)

databases and, 6.2

availability

definition, 8.1.1

diagnosing Collaboration Suite problems, 10.6

in services, 8.1.1

of a service, 8.2.1

services dashboard, 8.4.1

Average Active Sessions chart, databases, 6.2.1, 6.2.1

AWR baselines, 6.2.5.2

B

backing up

databases, 6.6.1

logical database objects, 6.7.1

backup settings, 6.6.4

baselines

AWR, 6.2.5.2

change management and, 6.3.14

services and, 8.4.5

BEA WebLogic, 5.2.1

Beacons

Collaboration Suite, 10.3.1

services and, 8.1.1

benefits of

Oracle Grid, 2

Oracle Grid Control, 2

BIG-IP

see load balancer switches

blocking sessions, hang analysis feature, 6.2.5.4

business metrics, services and, 8.2.3

C

change management, 6.3.14

Client Configuration Collection Tag, 4.1.5.2

client configurations, 4.1.5

Client System Analyzer (CSA)

client configurations, 4.1.5

deployed independently, 4.1.5.2

in Grid Control, 4.1.5.1

cloning

databases, 6.7.2

production database in data masking, 6.5.5

Cluster Cache Coherency page, picture of, 6.8.1

cluster cache coherency, RAC, 6.8.1

cluster interconnects, 6.8.2

Cluster Interconnects page, picture of, 6.8.2

Collaboration Suite

diagnosing problems, 10.6

Grid Control features for use with, 10.7

monitoring and alerts, 10.5

monitoring services, 10.3.2

Root Cause Analysis, 10.4

collected configurations for targets, 4.1.1

comparing configurations, 4.1.3, 6.7.5

configuration pages, accessing in Grid Control, 4.2

configurations

client, 4.1.5

Client System Analyzer (CSA), 4.1.5

comparing, 4.1.3, 6.7.5

features, databases, 6.3.2

hardware and software, 4.1

managing, 9.8

searching an enterprise, 4.1.4.2

using database configuration features, 6.3.2

viewing for an enterprise, 4.1.4.1

configuring

collected configurations for targets, 4.1.1

hardware and software, 4.1

software, reducing time with provisioning tools, 2.3.3

controlling distribution of resources, 6.3.6

converting

dictionary-managed tablespace, 6.3.5

single instances to RAC, 6.3.4

crash recovery, 6.6.2

Create Service page, picture of, 6.8.3

creating

database forms, 8.4.8

masking definition, 6.5.3

systems, 8.3.1, 8.3.1

critical patch advisories, 12.6.3

managing, 12.6.4

providing, 6.7.6

Critical Patch Facility, 12.6

Critical Patch metadata, downloading, 12.6.4.1

D

dashboard

services, 8.4.1

Data Guard, overview of, 6.6.6

data masking

Add Columns page, 6.5.10

Add Dependent Columns page, 6.5.11

adding columns to a masking definition, 6.5.6

application database administrator, role of, 6.5.2

Canadian social insurance numbers, 6.5.7.2

cloning the production database, 6.5.5, 6.5.12

Create Masking Definition page, 6.5.10

creating masking definition, 6.5.3

Data Masking Definitions page, 6.5.10

Define Column Mask page, 6.5.10, 6.5.15

Define Group Mask page, 6.5.10

defining new formats, 6.5.6

description, 6.5

DM_FMTLIB package, installing, 6.5.7.3

exporting and importing definitions, 6.5.16

information security administrator, role of, 6.5.2

ISBN numbers, 6.5.7.2

major task steps, 6.5.5

mask format libraries, description of, 6.5.3

masking definitions, description of, 6.5.3

masking format templates, using, 6.5.6

North American phone numbers, 6.5.7.2

other Oracle security products, 6.5.17

patterns of format definitions, 6.5.7.1

post-processing functions, 6.5.6

predefined masking formats, using, 6.5.7

primary key, 6.5.3

recommended workflow, 6.5.4

Script Generation Results page, 6.5.10

security administrator, 6.5.3

social security numbers, 6.5.7.2

staging region, 6.5.4

UPC numbers, 6.5.7.2

use cases, 6.5.16

user-defined functions, 6.5.6

workflow, 6.5.4

data, hiding with data masking, 6.5

Database Control and Grid Control, comparisons of, 6.1.1

Database Home page

features and information shown, 6.1.2

picture of, 6.1.2

Database Performance page, picture of, 6.2.1

Database Resource Manager, 6.3.6

databases

Active Session History (ASH), 6.2.2.1

ADDM, 6.2.3

administering, 6.3

administration, 6.3

advisors, 6.3.15

Automatic Storage Management (ASM), 6.3.3

Average Active Sessions chart, 6.2.1, 6.2.1

AWR baselines, 6.2.5.2

backing up, 6.6.1

backup and recovery settings, 6.6.4

change management, 6.3.14

cloning, 6.7.2

converting dictionary-managed tablespace, 6.3.5

converting single instance to RAC, 6.3.4

Data Guard overview, 6.6.6

Database Resource Manager, 6.3.6

diagnosing performance problems automatically, 6.2.3

Export to Files feature, 6.7.1

flashback recovery, 6.6.3

hang analysis feature, 6.2.5.4

historical SQL, 6.2.4.3

home page, 6.1.2

Home Page capabilities, 6.1.2

Host Average Runnable Processes chart, 6.2.1

Import from Database feature, 6.7.1

indexes and data retrieval, 6.3.10

instance activity, 6.2.4.2

I/O charts, 6.2.1

Load Data from File feature, 6.7.1

maintaining, 6.6

management, introduction, 6.1

managing

materialized views, 6.3.13

objects, 6.3.10

restore points, 6.6.5

users and privileges, 6.3.12, 6.4.1

Memory Access Mode, 6.2.5.3

Monitor Export and Import Job feature, 6.7.1

monitoring, 6.2

optimizing performance, 6.3.1

Oracle Streams, 6.7.4

Parallel Execution charts, 6.2.1

patching software, 6.7.6

recovery, 6.6.2

Recovery Manager (RMAN), 6.6.1

scheduling jobs, 6.3.8

schemas, working with, 6.3.9

Segment Advisor, 6.3.10

Services chart, 6.2.1

services, cluster-managed, 6.8.3

session details, viewing, 6.2.2.1.2

software patching, 6.7.6

SQL details, viewing, 6.2.2.1.1

Throughput charts, 6.2.1

top activity, viewing, 6.2.2.2

top consumers of system resources, 6.2.4.1

Topology Viewer, 6.2.5.1

tracking statistics to improve performance, 6.3.7

transporting tablespaces, 6.7.3

using configuration features, 6.3.2

views, 6.3.10

wait class drill-downs, 6.2.2.1

XML features, 6.3.11

Dell PowerEdge Linux hosts, 5.1.1.9

deploying software, reducing time with provisioning tools, 2.3.3

deployments

applying critical patches, 12.6.4.1

Client Configuration Collection Tag, 4.1.5.2

Client System Analyzer (CSA), 4.1.5.2

Critical Patch Facility, 12.6

Linux host patching, 12.6.6

Management Repository, 4.1.1

managing critical patch advisories, 12.6.4

managing for hosts, 5.1.3.5

patching, 12.6

patching Oracle software, 12.6.3

diagnosing

Collaboration Suite problems, 10.6

performance problems automatically, 6.2.3

performance problems interactively, 6.2.2

service problems, 8.5

slow or hung systems, 6.2.5.3

dictionary baseline, 6.3.14

dictionary-managed tablespace, converting, 6.3.5

directory monitoring, 5.1.1.8

documentation, getting from OTN, 3.3.1

downloading Critical Patch metadata, 12.6.4.1

E

EMC SMARTS integration with Grid Control, 2.4.2

emergency patching, 12.6.6.2

enterprise configuration, 4.1.4

hardware, 4.1.4.1

predefined searches, 4.1.4.2

searching, 4.1.4.2

user-defined searches, 4.1.4.2

viewing, 4.1.4.1

Execute Host Command page, description of, 5.1.3.2

Export to Files feature, 6.7.1

exporting files, 6.7.1

extending Enterprise Manager

lifecycle stages for plug-ins, 3.3.6

extensible monitoring, 9.5.7

F

see load balancer switches

figures

Active Sessions Waiting Page, 6.2.2.1

Automated RAC Deployments and Extensions, 2.3.3

Cluster Cache Coherency Page, 6.8.1

Cluster Interconnects Page, 6.8.2

Consolidated Dashboard View of Multiple Services, 8.4.1

Create Service Page, 6.8.3

Database Home Page, 6.1.2

Database Performance Page, 6.2.1

Host Configuration Page, 4.1.2

Host Hardware Details Page, 5.1.1.5

Host Home Page, 5.1.1.1

Host Operating System Details Page, 5.1.1.4

Host Performance Page, 5.1.1.2

Host Storage Details Page, 5.1.2

Searching for Patches, 2.3.4

Service Topology Page, 8.4.3

System Home Page, 8.3.2

System Topology Page, 8.4.2

Topology for SQL Details Plan, 6.2.5.1

file monitoring, 5.1.1.8

flashback recovery, 6.6.3

forms transactions, 8.4.8.1

G

Generic Service service type, 8.1.1

Grid Control

ability to eliminate costs and errors, 2.3.1

accessing configuration pages, 4.2

administrators and, 2.3.2

Client System Analyzer, 4.1.5.1

compared with Database Control, 6.1.1

console, definition of, 3.2, 3.2

leveraging for Collaboration Suite, 10.7

log file monitoring, 5.1.1.6

lower management costs and, 2.3

managing host deployments, 5.1.3.5

monitoring hosts, 5.1.1

third-party management, 5.2

Guaranteed Restore Point, 6.6.5

guest virtual machine, 13.1.1

guest VM server, 13.1.1

H

hang analysis, for hung systems, 6.2.5.4

hardware

configuration, collecting information, 4.1

enterprise configuration, 4.1.4.1

monitoring, Dell PowerEdge, 5.1.1.9

hiding data using data masking, 6.5

High Availability Oracle Clusterware, 6.8.5

historical SQL, databases, 6.2.4.3

Host Average Runnable Processes chart, databases, 6.2.1

Host Configuration page

description of, 5.1.1.3

picture of, 4.1.2

Host Hardware Details page

description of, 5.1.1.5

picture of, 5.1.1.5

Host Home page

description of, 5.1.1.1

picture of, 5.1.1.1

host management feature, 5.1

Host Operating System Details page

picture of, 5.1.1.4

Host Performance page

description of, 5.1.1.2

picture of, 5.1.1.2

Host Storage Details page

description of, 5.1.2

picture of, 5.1.2

hosts

administration, 5.1.3

Dell PowerEdge Linux, 5.1.1.9

Execute Host Command page, description of, 5.1.3.2

executing host commands remotely, 5.1.3.2

Host Configuration page

description of, 5.1.1.3

Host Hardware Details page

description of, 5.1.1.5

Host Home page, description of, 5.1.1.1

Host Performance page, 5.1.1.2

Host Storage Details page, description of, 5.1.2

Linux host patching, 12.6.6

Linux hosts administration, 5.1.3.1

managing deployments, 5.1.3.5

monitoring, 5.1.1

Operating System Details page

description of, 5.1.1.4

Program Resource Utilization page, 5.1.1.7

Remote File Editor page, 5.1.3.4

remote host target, 5.1.3.4

running operating system commands for, 5.1.3.3

storage resource tracking, 5.1.2

HP OpenView Operations integration with Grid Control, 2.4.2

I

IBM WebSphere, 5.2.1

Import from Database feature, 6.7.1

importing files, 6.7.1

indexes, data retrieval performance and, 6.3.10

Information Publisher

patches and, 12.6.3

information security administrator, role of in data masking, 6.5.2

installing software, reducing time with provisioning tools, 2.3.3

instance activity, databases, 6.2.4.2

integration with non-Oracle solutions, 2.4.2

I/O charts, databases, 6.2.1

IP traffic controllers, 5.2.3

IT infrastructure performance, 2.1

J

Java EE application responsiveness, monitoring, 9.5.2

JBoss, 5.2.1

Job System for hosts, 5.1.3.3

jobs

Job System for hosts, 5.1.3.3

predefined tasks, 3.3.3

purpose of, 3.3.3

scheduling, 6.3.8

L

Linux

host patching, 12.6.6

host patching groups, 12.6.6.2

load balancer switches

F5 Networks, 5.2.4

F5 server load balancers, extensions of, 2.4.1

Load Data from File feature, 6.7.1

log file monitoring, 5.1.1.6

M

maintaining databases, 6.6

backups, 6.6.1

Data Guard, 6.6.6

flashback recovery, 6.6.3

managing restore points, 6.6.5

recovery, 6.6.2

management

third-party, 5.2

Management Plug-ins

introduction, 2.4.1

Management Repository, 4.1.1

deployments and, 4.1

managing

backups, 6.6.1

configurations, 9.8

critical patch advisories, 12.6.4

database objects, 6.3.10

databases, Home page, 6.1.2

hosts, 5.1

materialized views, 6.3.13

patches, 2.3.4

restore points, 6.6.5

storage objects, 6.3.1

systems, 8.3

third-party targets, 5.2

users and privileges, 6.3.12, 6.4.1

mask format libraries, 6.5.3

masking definitions, 6.5.3

credit card numbers, 6.5.7.2

master server, 13.1.1

materialized views, managing, 6.3.13

media recovery, 6.6.2

Memory Access Mode, performance issues and, 6.2.5.3

metrics

AWR baselines, 6.2.5.2

performance and usage of services, 8.2.2

Micromuse integration with Grid Control, 2.4.2

Middleware

management, 9

modeling business applications using services, 8.2

Monitor Export and Import Job feature, 6.7.1

monitoring

business applications using services, 8.2

Collaboration Suite, 10.5

databases, 6.2

end-user performance, 8.4.8.2

extensible, Application Server, 9.5.7

files and directories, 5.1.1.8

hardware for Dell PowerEdge systems, 5.1.1.9

hosts, 5.1.1

log files, 5.1.1.6

Program Resource Utilization page, 5.1.1.7

RAC, 6.8

services, 8.4

services for Collaboration Suite, 10.3.2

systems, 8.3.2

templates for services, 8.2.5

Web application services, 8.4.7

Monitoring Templates feature

for services, 8.2.5

N

NetApp Filers

extensions of, 2.4.1

Network Appliance Filer, 5.2.3

notifications services, 8.4.5

O

object privileges, 6.3.12, 6.4.1

objects

dictionary baseline, 6.3.14

managing, 6.3.10

offline patching, 12.6.3

online patching, 12.6.3

Operating System Details page, description of, 5.1.1.4

optimizing

database performance, 6.3.1

performance in RAC, 6.8.1

Oracle

Application Server

historical performance, 9.5.3

Web Cache, 9.5.2

Clusterware, 6.8.5

Clusterware Registry, 6.8.5

Grid Control, benefits of, 2

home credentials, patching and, 12.6.3

Management Agent, configurations and, 6.7.5

patching software, 12.6.3

Streams, overview of, 6.7.4

Technology Network (OTN), 3.3.1

Oracle Forms, 8.4.8

Oracle Grid Control

See Grid Control

Oracle HTTP Server session volumes, 9.5.2

Oracle VM, 13.1.1

OTN and documentation, 3.3.1

P

Parallel execution charts, databases, 6.2.1

patch

management, 2.3.4

patches, searching for, 2.3.4

patching

applying critical patches, 12.6.4.1

compliance, 12.6.6.2

Critical Patch Facility, 12.6

deployment, 12.6

emergency, 12.6.6.2

information publisher, 12.6.3

Linux host patching groups, 12.6.6.2

Linux hosts, 12.6.6

offline, 12.6.3

online, 12.6.3

Oracle home credentials, 12.6.3

Oracle software, 12.6.3

setup, 12.6.3

shared agent patching, 12.6.3

software, 6.7.6

standalone database patching, 12.6.3

undoing, 12.6.6.2

validation, 12.6.3

performance

ADDM, 6.2.3

analyzing historical, 9.5.3

AWR baselines, 6.2.5.2

charts for services, 8.4.6

diagnosing Collaboration Suite problems, 10.6

diagnosing problems

automatically, 6.2.3

interactively, 6.2.2

for services, 8.1.1

hang analysis feature, 6.2.5.4

historical SQL, 6.2.4.3

Host Performance page, description of, 5.1.1.2

increasing with indexes, 6.3.10

instance activity, 6.2.4.2

Memory Access Mode, 6.2.5.3

metrics, services and, 8.2.2

optimizing, 6.3.1

optimizing in RAC, 6.8.1

Oracle Application Server, historical, 9.5.3

service management and, 8.2.2

services dashboard, 8.4.1

session details, viewing, 6.2.2.1.2

SQL details, viewing, 6.2.2.1.1

top activity, viewing, 6.2.2.2

top consumers of system resources, 6.2.4.1

tracking statistics, 6.3.7

wait class drill-downs, 6.2.2.1

post-processing functions, data masking and, 6.5.6

predefined

job tasks, 3.3.3

searches, enterprise configuration, 4.1.4.2

primary key, data masking and, 6.5.3

privileges

managing for users, 6.3.12, 6.4.1

Show Grantees function, 6.3.12, 6.4.1

provisioning Oracle VM, 13.7

R

RAC

adding cluster hosts for efficiency, 6.8

automatic restart of key components, 6.8.3

cluster cache coherency, 6.8.1

cluster interconnects, 6.8.2

cluster-managed database services, 6.8.3

converting single instances to RAC, 6.3.4

interconnects, 6.8.2

monitoring, 6.8

optimizing performance, 6.8.1

Oracle Clusterware, 6.8.5

Oracle Clusterware Registry, 6.8.5

purpose of, 6.8

tasks, 6.8

viewing current state of interfaces, 6.8.2

Voting Disk, 6.8.5

Real Application Clusters

See RAC

recovery

flashback, 6.6.3

settings, 6.6.4

types of, 6.6.2

Recovery Manager (RMAN), for backups, 6.6.1

regulatory compliance using masked data, 6.5.1

Remote File Editor page, 5.1.3.4

remote host target, 5.1.3.4

reports

for services, 8.4.4

resource tracking, storage, 5.1.2

restarts, RAC, 6.8.3

restore points, managing, 6.6.5

Right to Financial Privacy Act of 1978, 6.5.1

Root Cause Analysis

Collaboration Suite, 10.4

for services, 8.1.1, 8.5.1

service failure and, 8.4.3

Topology Viewer, 8.5.1

running operating system commands, 5.1.3.3

S

Sarbanes-Oxley requirements, 6.5.1

scheduling jobs, 6.3.8

schemas

objects, materialized views, 6.3.13

working with, 6.3.9

searching

enterprise configuration, 4.1.4.2

for patches, picture of, 2.3.4

security

compliance with masked data, 6.5.1

data masking, 6.5

list of Oracle products, 6.5.17

mask format libraries, 6.5.3

masking definitions, 6.5.3

security administrator, data masking and, 6.5.3

Segment Advisor, for managing databases, 6.3.10

server-generated alerts, 3.3.1

Service Level Management feature, 8.2.4

service test, 8.1.1

Service Topology page, picture of, 8.4.3

service types

Aggregate Service, 8.1.1

Generic Service, 8.1.1

Web Application, 8.1.1

service, definition of, 8.1.1

service-level agreements, 8.1

services, 8.1.1

alerts, 8.4.5

availability of, 8.2.1

baselines, 8.4.5

Beacons, 8.1.1

business metrics, 8.2.3

cluster-managed database services, 6.8.3

dashboard, 8.4.1

diagnosing problems, 8.5

failure and Root Cause Analysis, 8.5.1

forms and, 8.4.8

forms transactions, 8.4.8.1

introduction, 8.1

key Beacons, 8.2.1

key components, 8.2.1

key tests, 8.2.1

monitoring, 8.4

monitoring for Collaboration Suite, 10.3.2

Monitoring Templates feature, 8.2.5

monitoring templates for, 8.2.5

monitoring Web applications, Web application services, monitoring, 8.4.7

notifications, 8.4.5

performance and usage, 8.2.2

performance definition, 8.1.1

performance metrics, 8.2.2

performance of in charts, 8.4.6

reports for, 8.4.4

Root Cause Analysis, 8.5.1

Root Cause Analysis tool, 8.1.1

service level agreements, 8.1

service level definition, 8.1.1

Service Level Management feature, 8.2.4

service test, 8.1.1

service test-based availability, 8.2.1

Service Topology page, 8.4.3

setting service-level rules, 8.2.4

system-based availability, 8.2.1

Topology Viewer, 8.3.1

transactions and, 8.4.7.1

usage definition, 8.1.1

usage metrics, 8.2.2

Web Application Management feature, 8.4.7

Services chart, databases, 6.2.1

Services Dashboard, 8.4.1

session details, viewing, 6.2.2.1.2

setting service-level rules, 8.2.4

shared agent patching, 12.6.3

Shared Global Area (SGA), for slow or hung systems, 6.2.5.3

software configurations

collecting information, 4.1

working with, 6.7.5

Software Library, using, 12.4.4

software patching, 12.6.3

SQL

details, viewing, 6.2.2.1.1

historical, 6.2.4.3

SQL Details page, picture of, 6.2.2.1.2

stage and apply, for patches, 12.6.3

staging region, data masking and, 6.5.4

standalone database patching, 12.6.3

standby databases, Data Guard and, 6.6.6

storage

devices, 5.2.3

objects, managing, 6.3.1

resource tracking, 5.1.2

System Home page, picture of, 8.4

System Topology page, picture of, 8.4.2

system-based availability, 8.2.1

systems

creating, 8.3.1, 8.3.1

definition of, 8.3

managing, 8.3

monitoring, 8.3.2

privileges, 6.3.12, 6.4.1

System Topology page, 8.4.2

topologies, viewing and creating, 8.3.1

SYSUSER operations, 6.3.12, 6.4.1

T

tablespaces, transporting, 6.7.3

third-party

application servers, support for, 5.2.1

plug-ins, support for, 5.2.2

third-party management, 5.2

BIG-IP load balancer switches, 5.2.4

EMC SMARTS, 2.4.2

HP OpenView Operations, 2.4.2

Micromuse, 2.4.2

Network Appliance Filer, 5.2.3

Througput charts, databases, 6.2.1

Top Activity page, picture of, 6.2.2.2

top activity, viewing, 6.2.2.2

top consumers, databases, 6.2.4.1

topology

database, 6.2.5.1

service, 8.4.3

system, 8.4.2

Topology for SQL Details Plan, picture of, 6.2.5.1

Topology Viewer

database, 6.2.5.1

definition of, 8.3.1

Root Cause Analysis information, 8.5.1

service, 8.4.3

system, 8.4.2

tracking

statistics for databases, 6.3.7

storage resource allocation, 5.1.2

transporting tablespaces, 6.7.3

U

undoing patching, 12.6.6.2

usage metrics, services and, 8.2.2

use cases, data masking, 6.5.16

user-defined

functions, data masking and, 6.5.6

searches, enterprise configuration, 4.1.4.2

utility server, 13.1.1

V

viewing

enterprise configuration, 4.1.4.1

session details, 6.2.2.1.2

SQL details, 6.2.2.1.1

top activity, 6.2.2.2

views, database objects and, 6.3.10

virtual server, 13.1.1

virtual server pool, 13.1.1

Virtualization Central, 13.1.3

Voting Disk, 6.8.5

W

wait classes, databases, 6.2.2.1

Web Application Management feature, services and, 8.4.7

Web Application service type, 8.1.1

Workload Repository, database performance and, 6.3.7

X

XML database features, 6.3.11