Index

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

A

  • access control
    • support for Oracle ASM [1]
  • ACL attributes [1]
  • ACTION [1] , [2]
  • activating
    • Performance Policies [1]
  • active resource plan [1]
  • adding
    • classifiers to a Performance Class [1]
    • Performance Classes [1]
    • servers to server pools [1]
    • services to the Policy Set [1] , [2]
  • administrator-managed databases
  • administrators
    • cluster [1] , [2] , [3]
    • creating for Oracle Database QoS Management [1]
    • creating the QoSAdmin user [1]
    • database [1]
    • initial configuration tasks [1]
    • OC4J [1]
    • Oracle Database QoS Management [1]
  • alerts
    • in Oracle Enterprise Manager [1] , [2]
  • alternative recommendations [1] , [2]
  • application contexts [1]
  • applications
    • classifying work requests [1]
    • definition [1]
    • parameters used by classifiers [1]
    • resource requirements [1]
    • supported connections [1]
  • APPQOS_PLAN
  • APPQOSSYS user [1] , [2]
  • audit log [1]
  • authorized actions [1] , [2] , [3]
  • Automatic Database Diagnostic Monitor (ADDM) [1]
  • Automatic Workload Repository (AWR) [1]
  • average response times
    • and Performance Classes [1]
    • and Performance Objectives [1] , [2]
    • definition [1] , [2]

B

  • batch jobs [1]
  • bequeath connections [1]
  • bottlenecks
    • and Performance Classes [1] , [2]
    • and Performance Objectives [1]
    • and recommendations [1]
    • CPU resource [1]
    • for Performance Classes [1]
    • Global Cache resource [1]
    • I/O resource [1]
    • locating using metrics [1]
    • Other resource [1]
    • resolving [1]
  • business objectives [1]

C

  • calendars [1]
  • candidate server lists [1]
  • CHM [1]
  • classification rules
  • classifiers
    • adding [1]
    • and multiple services [1] , [2]
    • and Performance Classes [1] , [2]
    • and service names [1]
    • and session attributes [1]
    • and tags [1]
    • creating [1]
    • default_pc [1]
    • deleting [1]
    • evaluation order [1]
    • for the default Performance Class [1]
    • modifying [1]
    • multiple attributes [1]
    • order of evaluation [1]
    • session attributes [1]
    • specifying evaluation order [1] , [2]
  • clients
    • Java Database Connectivity (JDBC) clients [1]
    • name of program [1]
    • Oracle Call Interface (OCI) [1]
    • supported connections [1]
    • tracking across database sessions [1]
  • cluster administrator [1] , [2] , [3] , [4]
  • configuration recommendations [1]
  • configuration violations [1] , [2]
  • configuring
    • load balancing goals [1]
    • Oracle Grid Infrastructure for a cluster [1]
    • Oracle RAC databases [1]
    • Performance Objectives [1]
    • server pool directive overrides [1] , [2] , [3]
    • server pools [1]
  • connecting to a database [1]
  • connection load balancing [1]
  • connection pools [1]
  • connections
    • bequeath [1]
    • load balancing [1]
    • load balancing at run time [1]
    • to databases [1]
  • consumer groups
  • copying Performance Policies [1]
  • CPU_COUNT
  • CPU partition [1]
  • CPU resource bottlenecks
    • resolving [1]
  • Create Policy Set wizard [1]
  • creating
    • initial Policy Set [1]
    • Oracle Database QoS Management administrator user [1]
    • Performance Classes [1]
    • Performance Policies [1]
    • QoSAdmin user [1]
    • server pools [1] , [2]
    • services [1]
  • CRSCTL [1]

D

  • Dashboard
    • accessing [1]
    • analysis result for recommendations [1]
    • and recommendations [1]
    • and resource bottlenecks [1]
    • and workload surges [1]
    • description of General section [1]
    • implementing recommendations [1]
    • logging in [1]
    • main sections [1]
    • Performance Overview [1] , [2]
    • Performance Satisfaction Metric chart [1]
    • QoS Status [1]
    • recommendations not generated [1]
    • Recommendations section [1]
    • Resource Use vs. Wait Time chart [1]
    • Resource Wait Times Breakdown [1] , [2]
    • Situation Analysis [1]
    • viewing recommendation details [1]
    • viewing recommendations [1]
  • database
    • startup order determined by rank [1]
  • Database Configuration Assistant (DBCA) [1]
  • database connections [1]
  • database parameters [1]
  • Database Resource Manager
    • See: Oracle Database Resource Manager
  • databases
    • adding services [1] , [2]
    • and CPU_COUNT [1] , [2]
    • compliant [1]
    • connecting with a service [1]
    • connections [1]
    • default service [1]
    • enabling Oracle Database QoS Management [1]
    • Oracle RAC One Node [1]
    • policy-managed [1] , [2] , [3]
    • services [1]
    • sharing a server pool [1]
    • singleton [1]
    • startup order [1]
    • upgrading [1]
  • database services
    • See: services
  • database sessions
    • tracking client requests [1]
  • defaults
    • and classifiers [1]
    • and CPU_COUNT [1] , [2]
    • database services [1]
    • namespace [1]
    • OC4J_PORT [1]
    • password for QoSAdmin user [1]
    • Performance Policy [1] , [2]
    • Policy Set [1] , [2]
    • QoSAdmin password [1]
    • rank [1]
  • deleting
    • classifiers for a Performance Class [1]
    • Performance Classes [1]
    • Performance Policies [1]
  • demand
  • disabling
    • Oracle Database QoS Management for a cluster [1]

E

  • Edit Policy Set wizard [1] , [2] , [3] , [4] , [5] , [6]
  • enabling
    • Oracle Database QoS Management [1]
    • Oracle Database QoS Management for a cluster [1] , [2] , [3] , [4]
    • Oracle Database QoS Management for a database [1]
    • tracing [1]
  • Enterprise Manager
    • integration with Oracle Database QoS Management server [1]
  • evaluating classifiers [1]
  • evaluation order of classifiers [1]

F

  • FAST_START_MTTR_TARGET [1]
  • fast application notification (FAN) [1]
  • floaters [1]
  • Free pool [1] , [2] , [3]

G

  • Generic pool [1]
  • Global Cache resource bottlenecks
    • resolving [1]
  • goals
  • Grid Infrastructure Management Repository [1]
  • GV$ view queries [1]

H

  • headroom
    • maximizing [1]
  • high availability [1]

I

  • I/O resource bottlenecks
    • resolving [1]
  • implementing
    • alternative recommendations [1]
    • automatic actions [1]
    • recommendations [1]
  • initialization parameters
  • initial Policy Set [1]
  • instance caging [1]
  • IP addresses
    • IPv6 support [1]

J

  • Java Database Connectivity
  • JDBC
    • See: Java Database Connectivity

L

  • LMS processes [1]
  • load balancing
    • configuring goals for a service [1]
    • connections [1]
    • run-time connection [1]
  • load balancing advisory
  • log files [1]

M

  • maintenance windows [1]
  • managed server pools
    • and Oracle RAC database instances [1]
  • managing
  • measure-only
    • Performance Classes [1] , [2] , [3]
    • Performance Policies [1]
  • measure-only mode [1] , [2]
  • MemoryGuard [1] , [2]
  • memory pressure [1]
  • metrics
    • collecting [1]
    • for performance [1]
    • for Performance Classes [1]
    • for resources [1]
    • not displayed [1]
    • performance satisfaction [1]
  • minimum response times [1]
  • minimum size of server pools [1]
  • modifying
    • classifiers for a Performance Class [1]
    • Performance Classes [1]
    • Performance Policies [1]
    • server pool settings [1]
  • MODULE [1] , [2]
  • multi-tier environments [1]

N

  • namespaces

O

  • OC4J
    • administrator [1]
    • default port [1]
  • OC4J_PORT environment variable [1]
  • OC4J container
  • OCI
    • See: Oracle Call Interface
  • OCIAttrSet function [1]
  • ODP.NET [1]
  • OLTP workloads [1]
  • open workloads [1]
  • Oracle ASM
    • access control [1]
    • patching [1]
    • role separation [1]
  • Oracle Call Interface
  • Oracle Cluster Health Monitor [1]
  • Oracle Clusterware Repository [1] , [2]
  • Oracle Database QoS Management
    • administrator [1] , [2]
    • changing active Performance Policy [1] , [2]
    • Dashboard [1]
      • See also: Dashboard
    • Dashboard sections [1]
    • disabling for a cluster [1]
    • enabling for a cluster [1] , [2] , [3] , [4]
    • enabling for a database [1]
    • log files [1]
    • selecting server pools [1]
    • server hosting the OC4J container [1]
    • status [1]
    • trace files [1]
    • troubleshooting [1]
    • using the Dashboard [1]
    • viewing cluster management status [1]
    • viewing current status [1]
  • Oracle Database QoS Management administrator
    • creating [1]
    • default password [1]
  • Oracle Database Resource Manager
  • Oracle Enterprise Manager alerts [1]
  • Oracle Enterprise Manager Dashboard [1]
    • See also: Dashboard
  • Oracle RAC databases
    • creating [1]
    • supported releases [1]
  • Oracle RAC high availability framework [1]
  • Oracle RAC One Node databases [1]
  • Oracle Real Application Clusters (Oracle RAC)
    • and Oracle Database QoS Management [1]
  • Oracle Wallet [1]
  • overloaded systems [1]
  • overrides
    • See: server pool directive overrides

P

  • parallel queries [1]
  • patching
    • Oracle ASM [1]
  • performance class
  • Performance Classes
    • adding [1]
    • adding classifiers [1]
    • adding services [1] , [2]
    • and alerts [1]
    • and classifiers [1]
    • and homogenous requests [1]
    • and services [1]
    • changing the rank [1]
    • classifier ordering [1]
    • classifiers [1]
    • configuring Performance Objectives [1]
    • creating [1]
    • creating classifiers [1]
    • default [1]
    • default names [1]
    • default rank [1]
    • deleting [1]
    • deleting classifiers [1]
    • evaluating classifiers [1]
    • improvements in performance [1]
    • Incomplete data [1]
    • list of [1]
    • managing work requests separately [1]
    • maximum [1]
    • measure-only [1] , [2] , [3]
    • metrics [1]
    • metrics missing [1]
    • modifying [1]
    • modifying classifiers [1]
    • multiple classifiers [1]
    • No demand [1]
    • Nonconforming data [1]
    • projected impact of recommendations [1]
    • ranks [1]
    • relation to Performance Objectives [1]
    • renaming [1]
    • satisfying Performance Objectives [1]
    • setting evaluation order of classifiers [1]
    • specifying evaluation order of classifiers [1]
    • specifying ranks [1]
    • suggested by application developer [1]
    • unable to collect metrics [1]
    • used in Performance Policies [1]
    • viewing performance metrics [1] , [2] , [3]
    • viewing resource wait times [1]
    • wait times for resources [1]
  • performance metrics [1]
  • performance objectives
    • importance [1]
    • supported types [1]
  • Performance Objectives
    • and services [1]
    • configuring [1]
    • definition [1]
    • managing [1]
    • ranks [1] , [2]
    • relation to Performance Classes [1]
    • specifying [1]
    • specifying values [1]
  • Performance Policies
    • activating [1]
    • and server pools [1]
    • changing active [1] , [2]
    • copying [1]
    • creating [1]
    • creating additional [1]
    • default [1]
    • Default policy [1]
    • definition [1]
    • deleting [1]
    • measure-only [1]
    • modifying [1]
    • ranking Performance Classes [1]
    • refining with Performance Classes [1]
    • scheduling the active policy [1]
    • server pool directive overrides [1]
  • performance projections [1]
  • Performance Satisfaction Metric (PSM) [1] , [2] , [3] , [5]
  • performance tuning [1]
  • Policy and Performance Management engine [1]
  • policy changes
  • policy-managed databases [1] , [2]
  • Policy Set
    • active policy [1]
    • adding server pools [1]
    • administrating [1]
    • creating a new Policy Set [1]
    • current policy [1]
    • default [1]
    • initial [1]
    • modifying [1]
  • Policy Sets
  • Policy Set wizard
    • Define Classifier page [1]
  • PROGRAM [1] , [2]

Q

  • qosadmin [1]
  • QoS administrator
    • initial configuration tasks [1]
  • QoSAdmin user
  • qosctl [1]
  • QOSCTL utility

R

  • ranking Performance Objectives [1]
  • ranks
    • and database startup order [1]
    • and Performance Classes [1] , [2]
    • default [1]
    • Performance Classes [1]
  • recommendations
    • alternative [1]
    • alternatives [1] , [2]
    • analysis results [1]
    • choosing a different action [1]
    • consumer group mappings [1] , [2]
    • generating [1]
    • implementing [1] , [2] , [3]
    • implementing alternative recommendations [1]
    • interval [1]
    • iterations [1]
    • negative impacts [1]
    • not being displayed [1]
    • not generated [1]
    • reallocating servers [1]
    • section of the Dashboard [1]
    • Situation Analysis [1]
    • viewing [1] , [2]
    • viewing details [1]
  • Recommended Actions page [1]
  • removing servers from a server pool [1]
  • renaming
    • Performance Classes [1]
  • requirements
  • resolving
    • CPU resource bottlenecks [1]
    • Global Cache resource bottlenecks [1]
    • I/O resource bottlenecks [1]
    • Other resource bottlenecks [1]
  • resource bottlenecks
    • resolving [1]
  • Resource Manager
    • See: Oracle Database Resource Manager
  • resource plans
    • APPQOS_PLAN [1] , [2]
    • editing [1]
    • used by Oracle Database QoS Management [1]
  • resources
    • allocating [1]
    • bottlenecks
      • and recommendations [1]
    • increasing CPU access [1]
    • resolving bottlenecks [1]
    • starved [1]
    • types of [1]
    • usage [1]
    • waits [1]
    • wait times [1]
  • resource types
  • Resource Use vs. Wait Time chart [1]
  • response time [1]
  • response times
    • average per request [1]
    • definition [1]
    • minimum achievable [1]
  • RMI port conflict [1]
  • role separation
    • and Oracle ASM [1]
  • run-time connection load balancing [1]
  • run-time connection load balancing goal [1]

S

  • satrtup order for databases [1]
  • scheduling
    • active performance policy [1]
  • SERVER_NAMES attribute [1]
  • server pool directive overrides
  • server pools
    • accessing [1] , [2]
    • adding to a Policy Set [1]
    • adjusting size of [1]
    • and multiple databases [1]
    • and recommendations [1]
    • and services [1]
    • attributes [1]
    • candidate server lists [1] , [2]
    • configuring [1]
    • constraints [1]
    • creating [1] , [2]
    • directive overrides [1]
    • execute permission [1]
    • Free pool [1] , [2]
    • increasing minimum pool size [1]
    • list of [1]
    • managed [1] , [2]
    • marked as managed [1]
    • maximum size of one [1] , [2] , [4]
    • minimum size [1] , [2] , [3] , [4]
    • minimum size of one [1]
    • modifying settings [1]
    • modifying using Oracle Enterprise Manager [1]
    • privileges [1]
    • removing servers from [1]
    • selecting for management [1]
    • SERVER_NAMES attribute [1]
    • servers not added [1]
    • unmanageable [1]
    • unmanaged [1]
    • using multiple server pools [1]
    • viewing current settings [1]
  • servers
    • added to wrong server pool [1]
    • hosting the Oracle Database QoS Management server [1]
  • SERVICE_NAME [1]
  • SERVICE_TIME [1]
  • service-level agreements (SLAs) [1] , [2] , [3] , [5] , [6]
  • service levels [1]
  • services
    • adding to the Policy Set [1] , [2]
    • and Oracle Clusterware [1]
    • and work requests [1]
    • configuring load balancing goals [1]
    • creating [1]
    • default database service [1]
    • defaults
      • Performance Classes [1]
    • discovered automatically [1]
    • for database connections [1]
    • load balancing [1]
    • names [1]
    • singleton [1]
    • SINGLETON [1] , [2] , [3]
    • specifying multiple [1]
    • transactional shut down [1]
    • UNIFORM [1] , [2]
    • used by workloads [1]
  • session attributes
  • Set Policy [1]
  • singleton databases [1]
  • SINGLETON services [1] , [2]
  • Situation Analysis [1]
  • SLA
    • See: service-level agreements
  • slice [1]
  • SQL performance issues [1]
  • SRVCTL [1] , [2] , [3] , [4] , [5]
  • storage interconnect [1]
  • supported
    • connection types [1]
    • Oracle RAC database releases [1]
    • response times [1]
    • workloads [1] , [2] , [3]
  • support for Administrator-Managed databases [1] , [2]
  • system parameters [1]
  • system performance
  • system requirements [1] , [2]

T

  • tagging [1]
  • tags
    • and classifiers [1]
    • for work requests [1]
  • trace files [1]
  • tracing
  • troubleshooting
    • enabling Oracle Database QoS Management for a cluster [1]
    • enabling Oracle Database QoS Management for a database [1]

U

  • UNIFORM services [1]
  • USERENV namespace [1]
  • USERNAME [1]
  • user name [1]
  • users
    • APPQOSSYS [1]
    • creating administrators [1]
    • default for QoSAdmin [1]

V

  • viewing
    • current server pool settings [1]
    • latest analysis results [1]
    • performance metrics [1] , [2]
    • recommendation details [1]
    • recommendations [1]
    • resource wait times [1]
  • violations
    • and CPU_COUNT [1]
    • configuration [1] , [2] , [3]
    • for Performance Objectives [1]
    • logs [1]
    • resource plan not enabled [1]
    • viewing [1]

W

  • wait times
    • for resources [1]
    • viewing [1]
  • wizards
  • workload rank
    • and database startup order [1]
  • workloads
    • and creating new Performance Classes [1]
    • and GV$ view requests [1]
    • and parallel queries [1]
    • and server pools [1]
    • calls and Performance Classes [1]
    • consolidating [1]
    • database connections [1]
    • different resource requirements for work subsets [1]
    • managing [1]
    • monitoring [1]
    • OLTP [1]
    • scaling [1]
    • separating [1]
    • supported response times [1]
    • supported types [1] , [2] , [3]
    • surges [1] , [2] , [3]
    • tuning goals [1]
  • work requests
    • and services [1]
    • and tags [1]
    • creating classifiers [1]
    • definition [1]
    • managing separately [1]
    • metrics [1]