Shared Flashcard Set

Details

Onstat User/Session Options
Onstat User/Session Options
9
Internet/New Media
Graduate
03/07/2012

Additional Internet/New Media Flashcards

 


 

Cards

Term
Prints SQL tracing information.
Definition
onstat -g
Term
Prints the values of environment variables the database server is
currently using.
Definition
onstat -g env
Term
Prints SQL tracing information.
Definition
onstat -g his
Term
Prints operators used in currently running SQL queries.
Definition
onstat -g pqs
Term
Prints summary information for all active sessions or detailed information for individual sessions.
Definition
onstat -g ses
Term
Prints SQL information for all active sessions or detailed SQL information for individual sessions.
Definition
onstat -g sql
Term
Prints global transactions.
Definition
onstat -G
Term
• Prints status of user threads and their global read/write statistics.
Definition
onstat -u
Term
Prints information about transactions.
Definition
onstat -x
Supporting users have an ad free experience!