How to audit stored procs with parameters
2. shutdown
3. startup
4. audit execute procedure by access;
5. select USERNAME, obj_name,ACTION_NAME,to_char(TIMESTAMP, 'MM:DD:YYYY:HH24:MI:SS') time from dba_audit_objec;
YSMAN DBMS_APPLICATION_INFO EXECUTE PROCEDURE 10:07:2013:16:40:37
FIRE_GAL_1 COMMON_STPS EXECUTE PROCEDURE 10:07:2013:16:41:02
FIRE_GAL_1 STANDARD EXECUTE PROCEDURE 10:07:2013:16:41:02