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 		 

5 Oracle Rdb SQL/Services Server Metrics

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

The following topics are discussed in this chapter:

5.1 Introduction

The Oracle Rdb SQL/Services Server target type is used to monitor the server component of an Oracle Rdb SQL/Services' environment.

By default, event checks are established on the server's various subcomponents. As shown on the home page, alerts may be raised on those subcomponents if failures are detected.


Oracle Rdb SQL/Services Server home web page

5.2 Metrics

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


Oracle Rdb SQL/Services Server All Metrics web page

Response

Characteristic Definition
Purpose This screen shows the running/unavailable status for the SQL/Services Server. 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;
Individual Metrics
  • Status


Oracle Rdb SQL/Services Server Response web page

General Information

Characteristic Definition
Purpose This screen shows the basic setup information for the SQL/Services Server.
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 server;
Individual Metrics
  • State
  • Nodename
  • Hardware
  • Server Version
  • Server Platform
  • Max Shared Mem Size
  • Config file
  • Log path
  • Dump path
  • Proc start time
  • Proc shut time
  • DECnet object
  • DECnet state
  • DECnet protocol
  • TCP/IP port
  • TCP/IP state
  • TCP/IP protocol
  • Allocation unit
  • Total memory
  • Free memory
  • Partly allocated
  • Log File
  • Dump File


Oracle Rdb SQL/Services Server General Information web page

List of Clients

Characteristic Definition
Purpose This screen lists the clients/users currently connected to a service managed by the SQL/Services Server.
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 Server List of Clients web page

List of Dispatchers

Characteristic Definition
Purpose This screen lists the dispatchers currently managed by the SQL/Services Server.
Frequency of Collection Every 5 minutes.
Web page Format Table
Web page Example An example of the List of Dispatchers web page is shown below.
Rdb Equivalent 
    $ sqlsrv :== "$sys$system:sqlsrv_manage<VERSION>"
    $ sqlsrv
    connect server;
    show dispatcher;
Metric Attributes
  • Dispatcher
  • State
  • Maximum Connections Count


Oracle Rdb SQL/Services Server List of Dispatchers web page

List of Services

Characteristic Definition
Purpose This screen lists the services currently managed by the SQL/Services Server.
Frequency of Collection Every 5 minutes.
Web page Format Table
Web page Example An example of the List of Services web page is shown below.
Rdb Equivalent 
    $ sqlsrv :== "$sys$system:sqlsrv_manage<VERSION>"
    $ sqlsrv
    connect server;
    show services;
Metric Attributes
  • Service
  • State
  • Clients Per Executor
  • Maximum Client Count
  • Active Client Count
  • Minimum Executor Count
  • Maximum Executor Count
  • Running Executor Count


Oracle Rdb SQL/Services Server List of Services web page