Name

status — Returns statistics for a running server as a result set

Synopsis

status ( in option varchar );
 

Description

Depending of input parameter displays a statistics for running server.

Note that counters reported by status will be reset after server startup.

Parameters

option

This option controls the level of detail of the output returned from this procedure. Possible options are:

not supplied - general statistics report including : Database, Lock, Client, Replication status will be returned.
'c' - the report will contain also additional status report on running statements
'k' - to include index usage report
'r' - to include transactional replication status report
'h' - to include hash indexes usage report

Return Types

Status returns a result set with one varchar column, one row per line of text in the status report.

Example

Example 24.402. Retrieving Server Status

SQL> status('rhck');

VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso Server
Version 03.00.23NN-pthreads for Linux as of Nov 27 2002
<License information>

Database Status:
  File size 55705600, 6800 pages, 1345 free.
  2000 buffers, 180 used, 2 dirty 0 wired down, repl age 0 .
  Disk Usage: 188 reads avg 0 msec, 0% read last  80 s, 25 writes,
    7 read ahead, batch = 9.
Gate:  0 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = demo.trx, 1597 bytes
5454 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 4 connects, max 11 concurrent, 25 licensed
RPC: 55 calls, -2 pending, 2 max until now, 0 queued
Checkpoint Remap 74 pages, 0 mapped back. 0 s atomic time.
    DB master 6800 total 1345 free 74 remap 0 mapped back
   temp  200 total 197 free

Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
   Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:

Client 1111:5:  1944 bytes in, 29516 bytes out, 1 stmts.
Transaction status: PENDING, 1 threads.
Locks:

Running Statements:
 Time (msec) Text

Replication Status: Server  rep1.
   anonymous            anonymous                     0 OFF.
   rep1                 rep1                          0 OFF.

Index Usage:
Table         Index            Touches   Reads %Miss   Locks   Waits   %W n-dead
WS.WS.SYS_DAV_RES_TYPES SYS_DAV_RES_TYPES       254       1    0%     132       0   0% 0
VAD.DBA.VAD_REGISTRY VAD_REGISTRY              1       1   50%       1       0   0% 0
VAD.DBA.VAD_HELP   VAD_HELP                 20       1    4%      20       0   0% 0

Hash indexes

47 Rows. -- 9 msec.