Snapshot Level Database Application |
Logical Data Grouping dbase appl |
Monitor Switch Basic Basic |
Resettable |
Yes |
|
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
Element Name Element Type |
ddl_sql_stmts counter |
Description: This element indicates the number of SQL Data Definition Language (DDL) statements that were executed.
Usage: You can use this element to determine the level of database activity at the application or database level. DDL statements are expensive to run due to their impact on the system catalog tables. As a result, if the value of this element is high, you should determine the cause, and possibly restrict this activity from being performed.
You can also use this element to determine the percentage of DDL activity using the following formula:
data definition language (DDL) SQL statements / total number of statements
This information can be useful for analyzing application activity and throughput. DDL statements can also impact the package cache, by invalidating sections that are stored there and causing additional system overhead due to section recompilation.
Examples of DDL statements are CREATE TABLE, CREATE VIEW, ALTER TABLE, and DROP INDEX.