STL_WLM_QUERYPDFRSS Enthält einen Datensatz für jeden Ausführungsversuch einer Abfrage in einer von WLM berücksichtigten Service-Klasse. STL_WLM_QUERY ist für alle Benutzer sichtbar. Superuser können alle Zeilen sehen; reguläre Benutzer können nur ihre eigenen Daten sehen. Weitere...
SVL_QUERY_METRICS ビューと SVL_QUERY_METRICS_SUMMARY ビューは、このビューのデータを集計し、より便利な形式で情報を表示します。 STL_QUERY_METRICS はすべてのユーザーに表示されます。スーパーユーザーはすべての行を表示できますが、通常のユーザーは自分のデータのみを表示できます。詳細...
STL_SAVE STL_SCAN STL_SCHEMA_QUOTA_VIOLATIONS STL_SESSIONS STL_SORT STL_SSHCLIENT_ERROR STL_STREAM_SEGS STL_TR_CONFLICT STL_UNDONE STL_UNIQUE STL_UNLOAD_LOG STL_USAGE_CONTROL STL_USERLOG STL_UTILITYTEXT STL_VACUUM STL_WINDOW STL_WLM_ERROR STL_WLM_RULE_ACTION STL_WLM_QUERY ...
For more information, see wlm_query_slot_count. service_class_start_time timestamp Time that the query was assigned to the service class. This time is in the UTC time zone. queue_start_time timestamp Time that the query entered the queue for the service class. This time is in the UTC...
SELECTw.service_classASqueue , q.concurrency_scaling_status ,COUNT(*)ASqueries ,SUM( q.aborted )ASaborted ,SUM( ROUND( total_queue_time::NUMERIC/1000000,2) )ASqueue_secs ,SUM( ROUND( total_exec_time::NUMERIC/1000000,2) )ASexec_secsFROMstl_query qJOINstl_wlm_query wUSING(userid,query...
SELECTw.service_classASqueue , q.concurrency_scaling_status ,COUNT(*)ASqueries ,SUM( q.aborted )ASaborted ,SUM( ROUND( total_queue_time::NUMERIC/1000000,2) )ASqueue_secs ,SUM( ROUND( total_exec_time::NUMERIC/1000000,2) )ASexec_secsFROMstl_query qJOINstl_wlm_query wUSING(userid,query...
SELECTw.service_classASqueue , q.concurrency_scaling_status ,COUNT(*)ASqueries ,SUM( q.aborted )ASaborted ,SUM( ROUND( total_queue_time::NUMERIC/1000000,2) )ASqueue_secs ,SUM( ROUND( total_exec_time::NUMERIC/1000000,2) )ASexec_secsFROMstl_query qJOINstl_wlm_query wUSING(userid,query...
SELECTw.service_classASqueue , q.concurrency_scaling_status ,COUNT(*)ASqueries ,SUM( q.aborted )ASaborted ,SUM( ROUND( total_queue_time::NUMERIC/1000000,2) )ASqueue_secs ,SUM( ROUND( total_exec_time::NUMERIC/1000000,2) )ASexec_secsFROMstl_query qJOINstl_wlm_query wUSING(userid,query...
Query queues are defined in the WLM configuration. Metrics are reported only for user-defined queues. query integer Query ID. The query column can be used to join other system tables and views. segment integer Segment number. A query consists of multiple segments, and each segment consists of...
SELECTw.service_classASqueue , q.concurrency_scaling_status ,COUNT(*)ASqueries ,SUM( q.aborted )ASaborted ,SUM( ROUND( total_queue_time::NUMERIC/1000000,2) )ASqueue_secs ,SUM( ROUND( total_exec_time::NUMERIC/1000000,2) )ASexec_secsFROMstl_query qJOINstl_wlm_query wUSING(userid,query...