AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
Question Sir, Kindly give me the difference between the Tracing and Auditing in SQL
Answer Hi Jasvinder,
When you're performing a trace you are following step by step what the SQL is doing. This is typcially used when trying to debug, optimize or improve the performance of a piece of SQL code.
When you're audting an SQL, you are reviewing the actions that have been performed by (or the result of executing) the SQL. Auditing can be used for forensic investigation, routine check, or verification of the data integrity.
