[Appendix C] C.4 DBMS_DDLAppendix CBuilt-In Packages C.4 DBMS_DDLThe DBMS_DDL package provides access to some of the SQL DDL statements from within stored procedures. C.4.1 The ALTER_COMPILE procedureThe ALTER_COMPILE procedure can be used to programmatically force a recompile of a stored object. The specification is: PROCEDURE DBMS_DDL.ALTER_COMPILE (type VARCHAR2, schema VARCHAR2, name VARCHAR2);C.4.2 The ANALYZE_OBJECT procedureA call to ANALYZE_OBJECT lets you programmatically compute statistics for the specified object. The specification is: PROCEDURE DBMS_DDL.ANALYZE_OBJECT (type VARCHAR2, schema VARCHAR2, name VARCHAR2, method VARCHAR2, estimate_rows NUMBER DEFAULT NULL, estimate_percent NUMBER DEFAULT NULL);C.3 Oracle AQ, the Advanced Queueing FacilityC.5 DBMS_ JOB Copyright (c) 2000 O'Reilly & Associates. All rights reserved.