Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

Primitive Tables

Table Name Description
dbms_server_stats_prim Database server statistics, including resource usage, active session counts, and semaphore statistics.
dbms_servers_prim Database server configuration data, including listener address, max session, and max transaction limits.
dmf_bm_stats_prim DMF statistics for the buffer manager, including cache flush operations, connected server count, and table/database cache sizes.
dmf_cache_prim DMF cache configuration and current state for each enabled page size.
dmf_cache_stats_prim DMF cache statistics for each enabled page size, including hit rates, read, and write I/O rates.
dmf_server_stats_prim Per server DMF cache statistics for each enabled page size, including hit rates, read, and write I/O rates.
locking_config_prim Locking system configuration.
locking_stats_prim Locking system statistics, including lock and resource usage levels.
locklists_prim Locklist statistics for each active locklist, including lock counts and current state.
locks_prim Outstanding lock requests, one entry per lock request.
log_dbs_prim Logging statistics for each open database, including transaction counts and logging system operations performed.
log_header_stats_prim Logging system header, including system state, active transaction logs, and archive and journal windows.
log_procs_prim Logging statistics for each connected server, including transaction counts and logging system operations performed.
logging_config_prim Logging system configuration settings.
logging_stats_prim Logging system statistics, including log file usage and read/write I/O rates.
qsf_dbp_prim QSF pool database procedure statistics, including object size and execution counts.
qsf_pool_prim Overall QDF pool statistics, including free space and object counts.
qsf_rqp_prim QSF pool repeat query statistics, including object size and execution counts.
registered_servers_prim List of servers registered with the Ingres name server, including listener address and server class.
resources_prim List of resources currently known to the locking system, one row per resource.
session_os_stats_prim Session level resource usage statistics, including cpu, disk, and buffered io statistics.
session_stats_prim Session level statistics, including execution priority and current query.
sessions_prim Session level statistics, including client info, open database, and current group.
transactions_prim Transaction statistics, including current state, logging activity, and open database name.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.