PDF (US Ltr)
- 0.7Mb
PDF (A4)
- 0.7Mb
Lists the DDL Statement Activity metrics and provides a brief description of each.
Table 6.5 DDL Statement Activity Metrics
| Name | Description |
|---|---|
| Alter DB (Delta) | The total number of ALTER DATABASE statements executed. |
| Alter DB Upgrade (Delta) | The total number of ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME statements executed. |
| Alter Event (Delta) | The total number of ALTER EVENT statements executed. |
| Alter Function (Delta) | The total number of ALTER FUNCTION statements executed. |
| Alter Procedure (Delta) | The total number of ALTER PROCEDURE statements executed. |
| Alter Server (Delta) | The total number of ALTER SERVER statements executed. |
| Alter Table (Delta) | The total number of ALTER TABLE statements executed. |
| Alter Tablespace (Delta) | The total number of ALTER TABLESPACE statements executed. |
| Create DB (Delta) | The total number of CREATE DATABASE statements executed. |
| Create Event (Delta) | The total number of CREATE EVENT statements executed. |
| Create Function (Delta) | The total number of CREATE FUNCTION statements executed for stored functions. |
| Create Index (Delta) | The total number of CREATE INDEX statements executed. |
| Create Procedure (Delta) | The total number of CREATE PROCEDURE statements executed. |
| Create Server (Delta) | The total number of CREATE SERVER statements executed. |
| Create Table (Delta) | The total number of CREATE TABLE statements executed. |
| Create Trigger (Delta) | The total number of CREATE TRIGGER statements executed. |
| Create Udf (Delta) | The total number of CREATE FUNCTION statements executed for user defined functions. |
| Create User (Delta) | The total number of CREATE USER statements executed. |
| Create View (Delta) | The total number of CREATE VIEW statements executed. |
| Drop DB (Delta) | The total number of DROP DATABASE statements executed. |
| Drop Event (Delta) | The total number of DROP EVENT statements executed. |
| Drop Function (Delta) | The total number of DROP FUNCTION statements executed. |
| Drop Index (Delta) | The total number of DROP INDEX statements executed. |
| Drop Procedure (Delta) | The total number of DROP PROCEDURE statements executed. |
| Drop Server (Delta) | The total number of DROP SERVER statements executed. |
| Drop Table (Delta) | The total number of DROP TABLE statements executed. |
| Drop Trigger (Delta) | The total number of DROP TRIGGER statements executed. |
| Drop User (Delta) | The total number of DROP USER statements executed. |
| Drop View (Delta) | The total number of DROP VIEW statements executed. |
| Grant (Delta) | The total number of GRANT statements executed. |
| Rename Table (Delta) | The total number of RENAME TABLE statements executed. |
| Rename User (Delta) | The total number of RENAME USER statements executed. |
| Truncate (Delta) | The total number of TRUNCATE TABLE statements executed. |