order by rows_accessed desc fetch first 5 rows only"
Table 9 3 lists the more commonly used snapshot table functions. A complete list 
and detailed descriptions of snapshot table functions can be found in the 
System 
Monitor Guide and Reference, 
SC09 4847.
Table 9 3   Common snapshot table functions
Snapshot table function
Information returned
SNAPSHOT_DBM
Database manager information
SNAPSHOT_DATABASE
Database information. Information is returned only if 
there is at least one application connected to the 
database.
SNAPSHOT_APPL
General application information for each application that 
is connected to the database on the partition. This 
includes cumulative counters, status information, and the 
most recent SQL statement executed (if the statement 
monitor switch is set).
SNAPSHOT_APPL_INFO
General application identification information for each 
application that is connected to the database on the 
partition.
SNAPSHOT_LOCKWAIT
Application information regarding lock waits for the 
applications connected to the database on the partition.
SNAPSHOT_STATEMENT
Application information regarding statements for the 
applications connected to the database on the partition. 
This includes the most recent SQL statement executed (if 
the statement monitor switch is set).
SNAPSHOT_TABLE
Table activity information for each table that was 
accessed by an application connected to the database. 
Requires the table monitor switch.
SNAPSHOT_LOCK
Lock information at the database level, and application 
level for each application connected to the database. 
Requires the lock monitor switch.
SNAPSHOT_TBS
Information about table space activity at the database 
level, the application level for each application connected 
to the database, and the table space level for each table 
space that has been accessed by an application 
connected to the database. Requires the buffer pool 
monitor switch.
SNAPSHOT_BP
Buffer pool activity counters for the specified database. 
Requires the buffer pool monitor switch.
 Chapter 9. Testing and tuning 
291






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved