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
__dbf_set
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...
key_estimate
log_enable
log_text
prof_enable
prof_sample
server_root
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
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & 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