Dicas ORACLE DBA

Here is an example to enable Audit Trail on HZ_PARTIES and HZ_CUST_ACCOUNTS tables: a. (R)System Administrator, (N) Profile -> System Query Profile: 'AuditTrail:Activate'. Click FIND Set it to 'Yes' at Site level. b) Enable Audit Installations (AR) -- Got System Admin: Security:AuditTrail:Install -- Enable Audit Installation for AR c) Define Audit tables and desired columns. -- Got System Admin: Security: Audit Trail: Tables -- Query for user table name 'HZ_PARTIES' and add columns on which you want to enable trail -- do the same for table HZ_CUST_ACCOUNTS d) Define an Audit Group and associated tables -- Got System Admin: Security: Audit Trail: Groups -- Create Audit group for table defined in 'C' e) Run Concurrent program 'AuditTrail Report for Audit Group Validation' with parameter as your Audit Group. f) Define an Industry Template contain Audit Group -- Got System Admin: Security: Audit Trail Reporting: Audit Industry Template g) Run conc...

select u.user_name, r.responsibility_name, f.user_function_name, s.function_type, to_char(s.first_connect, 'DD-MON HH24:MI:SS') "First Connect", to_char(s.last_connect, 'DD-MON HH24:MI:SS') "Last Connect", n.node_name from icx_sessions s, fnd_user u, fnd_responsibility_vl r, fnd_form_functions_vl f, fnd_nodes n where u.user_id(+) = s.user_id AND f.function_id(+) = s.function_id AND r.responsibility_id(+) = s.responsibility_id AND n.node_id(+) = s.node_id AND s.disabled_flag != 'Y' and s.pseudo_flag = 'N' and (s.last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,s.limit_time, 0,s.limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate and s.counter < s.limit_connects