Thread SQL Counts 1 Workspace
The Thread SQL Counts 1 workspace provides information about SQL DCL (Data Control Language) declarations, SQL DDL (Data Definition Language) statements, and SQL DML (Data Manipulation Language) statements.
This workspace is comprised of the following views:
- Thread ID (table view)
- Lists the thread IDs.
- DML (table view)
- Provides information on SQL DML (Data Manipulation Language) statements.
- DCL (table view)
- Provides information on DCL (Data Control Language) declarations.
- DDL Create (table view)
- Provides information on SQL DDL (Data Definition Language) statements for Create.
- DDL Drop (table view)
- Provides information on SQL DDL (Data Definition Language) statements for Drop.
- DDL Alter / Rename (table view)
- Provides information on SQL DDL (Data Definition Language) statements for Alter / Rename.
Note: For DML, DCL, and DDL, each table view provides total counts
since the last sample period.
Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.