iSQL*Plus Server Statistics

A report containing iSQL*Plus Server statistics can be requested using:

http://machine_name.domain:7777/isqlplusdba?statistics=active|full[&refresh=number]

where

machine_name.domain:7777 is the URL of the Oracle HTTP Server for which you want to generate iSQL*Plus Server statistics.

?statistics=active|full specifies the level of detail to report.

full gives all possible statistics. This is the default.

active gives dynamically changing statistics for the iSQL*Plus Server. These statistics are included at the end of the full report.

[&refresh=number] optionally specifies the time in seconds before the statistics report is automatically refreshed. The minimum value is 10 seconds.

You must have Oracle HTTP Server authentication to access the iSQL*Plus DBA URL. As there is no connection to a database, no Oracle9i login is required.

All possible statistics for the full report are shown in the following list:

Server Details

Host name
Host address
Oracle HTTP Server port
Host system
iSQL*Plus Server start time
iSQL*Plus version
iSQL*Plus logfile

Server Environment

ORACLE_HOME
ORACLE_SID
TNS_ADMIN
NLS_LANG
NLS_NCHAR

Configuration Parameters

iSQLPlusNumberOfThreads
iSQLPlusTimeOutInterval(minutes)
iSQLPlusLogLevel
iSQLPlusConnectIdList
iSQLPlusHashTableSize

Client Details

HTTP client

Active Statistics

These are the statistics reported in the active report. They are also included in the full report.

Sessions active
Sessions since startup
Maximum concurrent sessions
Sessions expired since startup
Requests active
Requests since startup
Next expiry operation (minutes)
Expiry operations since startup
Hash table collisions
Hash table collisions since startup

Previous

Next

Contents

Index