System Database
The sysmaster database, established when XPS is initialized, provides access to database statistics with standard SQL. It is presented as a readonly database with a number of tables, although the tables are in fact pseudotables that reside in memory as internal database structures.
The sysmaster database contains a number of system monitoring interface (SMI) tables that provide information about the state of the database server. For example, you can monitor resource usage, locks, session information, extents, and VP CPU usage.
The following tables are examples of those available in the sysmaster database:
syschunks— Chunk information and statistics.
syscogroup— Information about cogroups.
sysconfig— Configuration information. ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
