A report containing iSQL*Plus Server statistics can be requested using:
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:
Host name Host address Oracle HTTP Server port Host system iSQL*Plus Server start time iSQL*Plus version iSQL*Plus logfile
ORACLE_HOME ORACLE_SID TNS_ADMIN NLS_LANG NLS_NCHAR
iSQLPlusNumberOfThreads iSQLPlusTimeOutInterval(minutes) iSQLPlusLogLevel iSQLPlusConnectIdList iSQLPlusHashTableSize
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