audit sql statement/DDL from procedure
Oracle version: 11.2.0.4
OS: Linux; 5.0
I need to audit when the following Procedure and SQL / DDL runs everyday. How would set up an audit for this purpose only?
1. Procedure: PRODCL.PBC_DATA_LOAD
2. -- Build indexes (staging)
EXECUTE IMMEDIATE 'alter session set skip_unusable_indexes=true';
EXECUTE IMMEDIATE 'alter index X_DT_LOAD_TXNNUM rebuild compute statistics nologging';
EXECUTE IMMEDIATE 'alter index X_DT_LOAD_DUP rebuild compute statistics nologging';
EXECUTE IMMEDIATE 'alter index X_DT_LOAD_TRANID rebuild compute statistics nologging';
EXECUTE IMMEDIATE 'alter index X_DT_LOAD_SPID rebuild compute statistics nologging';
3. DBMS_STATS.GATHER_TABLE_STATS(user,'STAGE_DATA_LD'