iSQL*Plus logo

Previous Page
Previous

Next Page
Next

Table Of Contents
Contents

Index
Index

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

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 Page
Previous

Next Page
Next

Table Of Contents
Contents

Index
Index