Simple is Hard

SQL> oradebug help HELP [command] Describe one or all commands SETMYPID Debug current process SETOSPID Set OS pid of process to debug SETORAPID ['force'] Set Oracle pid of process to debug SHORT_STACK Dump abridged OS stack DUMP [addr] Invoke named dump DUMPSGA [bytes] Dump fixed SGA DUMPLIST Print a list of available dumps EVENT Set trace event in process SESSION_EVENT Set trace event in sessio..

9i부터 오라클에 자체 감사 기능이 추가 되었다. 다음은 http://www.oracle-base.com/articles/10g/DatabaseSecurityEnhancements10g.php#uniform_audit_trail 에서 참고한 자료다. 쉬운 영문 이기 때문에 번역없이 원문을 그대로 남겨 놓는다. Uniform Audit TrailThe DBA_COMMON_AUDIT_TRAIL view has been added to display the complete audit trail: DBA_AUDIT_TRAIL - Standard auditing only (from AUD$). DBA_FGA_AUDIT_TRAIL - Fine-grained auditing only (from FGA_LOG$). D..