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