# 22. Virtuoso Functions Guide - sys_stat

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

## sys_stat

Return statistical information about the Virtuoso server.
any sys_stat (in stat_name varchar);
Description

This function returns the statistic related to the requested statistic name give as a parameter to the function.

Parameters
stat_name – The name of the statistic to look-up and return. This can be one of:

- st_dbms_name
- st_dbms_ver
- st_build_thread_model
- st_build_opsys_id
- st_build_date
- st_lic_owner
- st_lic_max_connections
- st_lic_current_use
- st_lic_granted_use
- st_lic_peak_use
- st_lic_times_exceeded
- st_lic_claims
- st_lic_clients
- st_lic_issuer
- st_lic_serial_number
- st_lic_release
- st_lic_platform
- st_lic_expiredate
- st_lic_ncpus
- st_lic_nusers
- st_lic_modules
- st_lic_applications
- st_lic_availability
- st_lic_clients
- st_lic_nodename
- st_lic_wstype
- st_lic_notice
- st_lic_lmgr_version
- st_lic_lmgr_directory
- st_proc_served
- st_proc_active
- st_proc_running
- st_proc_queued_req
- st_proc_brk
- st_db_file_size
- st_db_pages
- st_db_free_pages
- st_db_buffers
- st_db_used_buffers
- st_db_dirty_buffers
- st_db_wired_buffers
- st_db_disk_read_avg
- st_db_disk_read_pct
- st_db_disk_read_last
- st_db_disk_read_aheads
- st_db_disk_read_ahead_batch
- st_db_disk_second_reads
- st_db_disk_in_while_read
- st_db_disk_mt_write
- st_db_log_name
- st_db_log_length
- st_cli_connects
- st_cli_max_connected
- st_cli_n_current_connections
- st_cli_n_http_threads
- st_rpc_stat
- st_inx_pages_changed
- st_inx_pages_new
- st_chkp_remap_pages
- st_chkp_mapback_pages
- st_chkp_atomic_time
- st_chkp_autocheckpoint
- st_chkp_last_checkpointed
- st_repl_serv_name
- st_host_name
- st_os_user_name
- st_case_mode

Return Types

Statistic to be returned. Can be a value such as the server version, or a string such as the database name.

Examples
Returning simple statistics.

    SQL> select concat(sys_stat('st_dbms_name'), ' - ', sys_stat('st_dbms_ver'));
    callret
    VARCHAR
    _______________________________________________________________________________

    OpenLink Virtuoso PHP4 Server - 03.00.2402