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

F5
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