What is the TRANSACTION_AUDITING parameter?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the TRANSACTION_AUDITING parameter?
Rating:
The TRANSACTION_AUDITING parameter is used to write a special redo record, which can be used to trace the changes made in a database, if a log analysis tool (Log Miner) is used. If any log analysis tool is not in use, the value of the parameter is set to FALSE to avoid unnecessary overhead for each transaction in a database.
Following information are contained in a redo record:
- Logon name
- User name
- Session ID
- Operating system information
- Client information
- Parameter type: Boolean
- Default type: True
- Modifiable: ALTER SYSTEM....DEFERRED
- Range of values: True to False
Rating:
Was this information helpful?
Other articles
- What are advisors?
- What is a cancel-based recovery?
- What is the SHARED_POOL_SIZE parameter?
- What is the dba_tab_stats_history view?
- What is the DB_RECOVERY_FILE_DEST_SIZE initialization parameter?