Session Application Actions Summary

The Session Application Actions Summary (md_session_app_action.summary) view provides a summary of the session application actions, allowing you to evaluate the impact of the actions on a system.

  • The session application actions table stores data that can be analyzed to measure performance.

The following list defines every field available in the session application actions summary (md_session_app_action.summary) table in alphabetical order:

  • Action Name - this field is not maintainable. The action that was taken.

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Database Name - this field is not maintainable. The database involved in the action.

  • Database Transaction - this field is not maintainable. A flag that indicates whether or not the action is in a transaction. The following options are available:

    • Yes - indicates that the database is in a transaction.

    • No - indicates that the database is not in a transaction.

  • Duration in Milliseconds - this field is not maintainable. The length of execution time for the action in milliseconds.

  • Duration in Seconds - this field is not maintainable. The length of execution time for the action in seconds.

  • Extra Attributes - a CLOB-type field used to store additional JSON information.

  • Memo 1 - a user-defined text comment area.

  • Memo 2 - a user-defined text comment area.

  • Memo 3 - a user-defined text comment area.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

  • Note - an expression column that allows the user to to enter observations concerning the record being reviewed.

  • Number of Records - this field is not maintainable. The number of records brought back by this action.

  • Resource Name - this field is not maintainable. The name of the resource performing the action.

  • Runtime Context - this field is not maintainable. The context at the time the action was executed.

  • SQL Statement Hash Code - this field is not maintainable. A unique hash code for the SQL that was captured.

  • SQL Statement Prepared - this field is not maintainable. A flag that indicates whether or not the SQL was prepared. The following options are available:

    • Yes - indicates that the SQL was prepared.

    • No - indicates that the SQL was not prepared.

  • SQL Statement Text - the SQL that was captured.

  • SQL Statement Type - this field is not maintainable. The type of SQL captured for the action. The following options are available:

    • Select
    • Update
    • Delete
    • Commit

  • Session Application Action Criteria - a nested view of the session application action criteria associated with the action.

  • Session Application Action ID - this field is not maintainable. The unique identifier for a session application action.

  • Session Application Action Stack Traces - a nested view of the session application action stack trace associated with the action.

  • Session Application ID - this field is not maintainable. The unique identifier for a session application.

  • Session ID - this field is not maintainable. The unique identifier for a session.

  • Started On - this field is not maintainable. The time the action was started

  • Table List - this field is not maintainable. The list of tables used in the SQL.

  • Table Name - this field is not maintainable. The main table that the SQL researched.

  • Thread Name - this field is not maintainable. The thread name the action was executed on.

  • User Name - this field is not maintainable. The user that executed the action.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.