Display Mode of SQL Command Monitor |
|
Display Mode affects the display content of the SQL_CMD and TIME_OF_SQL_CMD columns in the SYSUSER system table. JDBA Tool Users can view information about users accessing the database with the Database Monitor function. Session Information displays users currently connected to the database. The columns Current SQL command and Time of Current SQL Command display the most recent SQL transaction committed by the user and the time of execution, respectively. Display Mode of SQL Command Monitor sets the configuration for how these attributes are displayed. No SQL commands are shown if Disabled is clicked. The most recent SQL command executed by the user and its approximate time of execution are shown if Show SQL command and approximate time is clicked. The most recent SQL command executed by the user and its exact time of execution are shown if Show SQL command and exact time is clicked. Displaying the exact time of execution uses more CPU resources and slows down the database. The default mode is Show SQL command and approximate time
Related topic:
Setting
Cache and Control Options
Changing System Control Settings
Display Mode