Shared Flashcard Set

Details

Onstat Table Options
Onstat Table Options
9
Internet/New Media
Graduate
03/07/2012

Additional Internet/New Media Flashcards

 


 

Cards

Term
Prints buffer pool profile information.
Definition
onstat -g buf
Term
Prints information on the status of currently active light appends
(writes bypassing the buffer pool).
Definition
onstat -g lap
Term
Prints information about currently active light scans (sequential
scans bypassing the buffer pool).
Definition
onstat -g lsc
Term
• Prints open partitions (tables).
Definition
onstat -g opn
Term
Prints partition profile (activity data) for the specified partition
number or prints profiles for all partitions.
Definition
onstat -g ppf
Term
Prints scan progress.
Definition
onstat -g scn
Term
Prints table and B-tree pages in the buffer pool, listed by partition(table).
Definition
onstat -P
Term
Prints basic tblspace (partition) information for active (t) • Prints basic tblspace (partition) information for active (t) tblspaces.
Definition
onstat -t
Term
Prints basic tblspace (partition) information for all (T)tblspaces.
Definition
onstat -T
Supporting users have an ad free experience!