Table of Contents Previous Next



You can use DRITA functions to gather wait information and manage snapshots. DRITA functions are fully supported by Advanced Server 10 whether your installation is made compatible with Oracle databases or is made in PostgreSQL-compatible mode.
The get_snaps() function returns a list of the current snapshots. The signature is:
The following example demonstrates using the get_snaps() function to display a list of snapshots:
4.2.2 sys_rpt()
The sys_rpt() function returns system wait information. The signature is:
sys_rpt(beginning_id, ending_id, top_n)
beginning_id is an integer value that represents the beginning session identifier.
ending_id is an integer value that represents the ending session identifier.
top_n represents the number of rows to return
The sess_rpt() function returns session wait information. The signature is:
sess_rpt(beginning_id, ending_id, top_n)
beginning_id is an integer value that represents the beginning session identifier.
ending_id is an integer value that represents the ending session identifier.
top_n represents the number of rows to return
The sessid_rpt() function returns session ID information for a specified backend. The signature is:
sessid_rpt(beginning_id, ending_id, backend_id)
beginning_id is an integer value that represents the beginning session identifier.
ending_id is an integer value that represents the ending session identifier.
backend_id is an integer value that represents the backend identifier.
The sesshist_rpt() function returns session wait information for a specified backend. The signature is:
sesshist_rpt(snapshot_id, session_id)
snapshot_id is an integer value that identifies the snapshot.
session_id is an integer value that represents the session.
The purgesnap() function purges a range of snapshots from the snapshot tables. The signature is:
purgesnap(beginning_id, ending_id)
beginning_id is an integer value that represents the beginning session identifier.
ending_id is an integer value that represents the ending session identifier.
purgesnap()removes all snapshots between beginning_id and ending_id (inclusive):
A call to the get_snaps() function after executing the example shows that snapshots 6 through 9 have been purged from the snapshot tables:
Use the truncsnap() function to delete all records from the snapshot table. The signature is:
A call to the get_snaps() function after calling the truncsnap() function shows that all records have been removed from the snapshot tables:


Table of Contents Previous Next