PERF_SERVER_SQLS
This table stores the data collected by the Server SQL monitor.
You can examine the data in this table as it relates to the user actions that are performed (stored in the PERF_CLIENT_OPERATIONS table) and the resulting requests that are generated (stored in the PERF_CLIENT_REQUESTS table).
The table contains one record for each SQL statement run on the server. The column prefix for the table is PSS
. For example, PSS_SQL_ID.
COLUMN NAME |
DESCRIPTION |
---|---|
SQL_ID |
The SQL unique GUID. |
SERVER_MACHINE_NAME |
The ALM server that ran this SQL statement. |
THREAD_ID |
The ID of the thread in the context of which the SQL statement was run. |
THREAD_CATEGORY |
The thread category. |
THREAD_TYPE |
The thread type. |
PROJECT |
The domain and project name, in the format |
USER_NAME |
The user name. |
SQL_TYPE |
The type of SQL statement, for example: `executeQuery' and `executeUpdate'. |
RECORD_COUNT |
Number of records added, deleted or etched by this SQL statement. |
START_TIME |
The SQL statement start time as a date time data type. |
START_TIME_MS |
The SQL statement start time as the number of milliseconds since 01/01/1970. |
TOTAL_TIME |
The total time, in milliseconds, that it took for the server to execute the SQL statement. |
SQL_STRING |
The actual SQL string. |