SUMMARY_WORKLOAD_SQL_COUNT

Displays the distribution of SQL statements in workloads on each primary database node in the database, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

**Table 1** SUMMARY_WORKLOAD_SQL_COUNT columns
Name	Type	Description
node_name	name	Node name.
workload	name	Workload name.
select_count	bigint	Number of SELECT statements.
update_count	bigint	Number of UPDATE statements.
insert_count	bigint	Number of INSERT statements.
delete_count	bigint	Number of DELETE statements.
ddl_count	bigint	Number of DDL statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.
dml_count	bigint	Number of DML statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.
dcl_count	bigint	Number of DCL statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.
dbid	oid	Database ID.
user_dml_count	bigint	Number of DML statements executed by users.
bg_dml_count	bigint	Number of DML statements executed by the database backend thread.