Oracle Rdb® Extension to Oracle Enterprise Manager 10g User Guide
Release 7.2.1.0
  Go To Table Of Contents
Contents 		Go To Index
Index
Previous
Previous 		Next
Next 		 

7 Oracle Rdb SQL/Services Service Metrics

This chapter describes the different metrics associated with an Oracle Rdb SQL/Services Service entity target.

The following topics are discussed in this chapter:

7.1 Introduction

The Oracle Rdb SQL/Services Service target type is used to monitor a service component of an Oracle Rdb SQL/Services' environment.


Oracle Rdb SQL/Services Service home web page

7.2 Metrics

Three sets of metrics are collected for Oracle SQL/Services Service targets. As shown on the All Metrics web page , they are:


Oracle Rdb SQL/Services Service All Metrics web page

Response

Characteristic Definition
Purpose This screen shows the running/unavailable status for the SQL/Services Service. This metric is used by the Enterprise Manager to set the up/down status of the target on the Enterprise Manager home and target list pages.
Frequency of Collection Every 5 minutes.
Web page Format Name - Type - Value
Web page Example An example of the Response web page is shown below.
Rdb Equivalent 
    $ sqlsrv :== "$sys$system:sqlsrv_manage<VERSION>"
    $ sqlsrv
    connect server;
    show service <SERVICE>;
Individual Metrics
  • Status


Oracle Rdb SQL/Services Service Response web page

General Information

Characteristic Definition
Purpose This screen shows the basic setup information for the SQL/Services Service.
Frequency of Collection Every 60 minutes.
Web page Format Attribute - Value
Web page Example An example of the General Information web page is shown below.
Rdb Equivalent 
    $ sqlsrv :== "$sys$system:sqlsrv_manage<VERSION>"
    $ sqlsrv
    connect server;
    show service <SERVICE> full;
Individual Metrics
  • Service
  • State
  • Nodename
  • Hardware
  • Owner
  • Owner Password
  • Protocol
  • Default Connect Username
  • SQL version
  • Autostart
  • Process init
  • Attach
  • Schema
  • Reuse
  • Database Authorization
  • dbsrc file
  • SQL init file
  • Appl Transaction Usage
  • Idle User Timeout
  • Idle Exec Timeout
  • Min Executors
  • Max Executors
  • Clients Per Executor
  • Active Clients


Oracle Rdb SQL/Services Service General Information web page

List of Clients

Characteristic Definition
Purpose This screen lists the clients/users currently connected to a SQL/Services service.
Frequency of Collection Every 5 minutes.
Web page Format Table
Web page Example An example of the List of Clients web page is shown below.
Rdb Equivalent 
    $ sqlsrv :== "$sys$system:sqlsrv_manage<VERSION>"
    $ sqlsrv
    connect server;
    show clients;
Metric Attributes
  • User Index
  • Service
  • Username
  • Node
  • State
  • Executor PID
  • Application


Oracle Rdb SQL/Services Service List of Clients web page