10 FROM DBA_AUDIT_POLICIES
11 WHERE OBJECT_SCHEMA = SYS_CONTEXT('USERENV','CURRENT_USER')
12 /
View created.
SQL>
SQL> create or replace view USER_AUDIT_POLICY_COLUMNS(OBJECT_SCHEMA, OBJECT_NAME,
2 POLICY_NAME, POLICY_COLUMN)
3 as
4 select OBJECT_SCHEMA, OBJECT_NAME,
5 POLICY_NAME, POLICY_COLUMN
6 from DBA_AUDIT_POLICY_COLUMNS
7 WHERE OBJECT_SCHEMA = SYS_CONTEXT('USERENV','CURRENT_USER')
8 /
View created.
SQL>
SQL> CREATE OR REPLACE VIEW user_scheduler_job_log
2 ( LOG_ID, LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, JOB_CLASS, OPERATION, STATUS,
3 USER_NAME, CLIENT_ID, GLOBAL_UID, CREDENTIAL_OWNER, CREDENTIAL_NAME,
4 DESTINATION_OWNER, DESTINATION, ADDITIONAL_INFO)
5 AS
6 (SELECT
7 LOG_ID, LOG_DATE, OWNER,
8 DECODE(instr(e.NAME,'"'),0, e.NAME,substr(e.NAME,1,instr(e.NAME,'"')-1)),
9 DECODE(instr(e.NAME,'"'),0,NULL,substr(e.NAME,instr(e.NAME,'"')+1)),
10 co.NAME, OPERATION,e.STATUS, USER_NAME, CLIENT_ID, GUID,
11 decode(e.credential, NULL, NULL,
12 substr(e.credential, 1, instr(e.credential, '"')-1)),
13 decode(e.credential, NULL, NULL,
14 substr(e.credential, instr(e.credential, '"')+1,
15 length(e.credential) - instr(e.credential, '"'))),
16 decode(bitand(e.flags, 1), 0, NULL,
17 substr(e.destination, 1, instr(e.destination, '"')-1)),
18 decode(bitand(e.flags, 1), 0, e.destination,
19 substr(e.destination, instr(e.destination, '"')+1,
20 length(e.destination) - instr(e.destination, '"'))),
21 ADDITIONAL_INFO
22 FROM scheduler$_event_log e, obj$ co
23 WHERE e.type# = 66 and e.dbid is null and e.class_id = co.obj#(+)
25 /
View created.
SQL>
SQL> CREATE OR REPLACE VIEW user_scheduler_job_run_details
2 ( LOG_ID, LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, STATUS, ERROR#, REQ_START_DATE,
3 ACTUAL_START_DATE, RUN_DURATION, INSTANCE_ID, SESSION_ID, SLAVE_PID,
4 CPU_USED, CREDENTIAL_OWNER, CREDENTIAL_NAME, DESTINATION_OWNER,
5 DESTINATION, ADDITIONAL_INFO)
6 AS
7 (SELECT
8 j.LOG_ID, j.LOG_DATE, e.OWNER,
9 DECODE(instr(e.NAME,'"'),0, e.NAME,substr(e.NAME,1,instr(e.NAME,'"')-1)),
10 DECODE(instr(e.NAME,'"'),0,NULL,substr(e.NAME,instr(e.NAME,'"')+1)),
11 e.STATUS, j.ERROR#, j.REQ_START_DATE, j.START_DATE, j.RUN_DURATION,
12 j.INSTANCE_ID, j.SESSION_ID, j.SLAVE_PID, j.CPU_USED,
13 decode(e.credential, NULL, NULL,
14 substr(e.credential, 1, instr(e.credential, '"')-1)),
15 decode(e.credential, NULL, NULL,
16 substr(e.credential, instr(e.credential, '"')+1,
17 length(e.credential) - instr(e.credential, '"'))),
18 decode(bitand(e.flags, 1), 0, NULL,
19 substr(e.destination, 1, instr(e.destination, '"')-1)),
20 decode(bitand(e.flags, 1), 0, e.destination,
21 substr(e.destination, instr(e.destination, '"')+1,
22 length(e.destination) - instr(e.destination, '"'))),
23 j.ADDITIONAL_INFO
24 FROM scheduler$_job_run_details j, scheduler$_event_log e
25 WHERE j.log_id = e.log_id
26 AND e.dbid is null
27 AND e.type# = 66
28 AND e.owner = SYS_CONTEXT('USERENV','CURRENT_USER'))
29 /
View created.
SQL>
SQL> CREATE OR REPLACE VIEW all_scheduler_job_log
2 ( LOG_ID, LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, JOB_CLASS, OPERATION, STATUS,
3 USER_NAME, CLIENT_ID, GLOBAL_UID, CREDENTIAL_OWNER, CREDENTIAL_NAME,
4 DESTINATION_OWNE