# 22. Virtuoso Functions Guide - status

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
db.dba.vacuum
user_change_password
user_create
user_drop
user_get_option
user_grant_role
user_revoke_role
user_role_create
user_role_drop
user_set_option
user_set_qualifier
cfg_item_count
cfg_item_name
cfg_item_value
cfg_section_count
cfg_section_name
cfg_write
checkpoint_interval
disconnect_user
fk_check_input_value...
log_enable
log_text
prof_enable
prof_sample
status
sys_lockdown
sys_stat
system
trace_status
user_set_password
virtuoso_ini_path
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## status

Returns statistics for a running server as a result set
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
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.