Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Initialization Parameters, 183 of 188


TRANSACTION_AUDITING

Parameter type: 

Boolean 

Parameter class: 

Dynamic. Scope = ALTER SYSTEM ... DEFERRED. 

Default value: 

TRUE 

Range of values: 

TRUE | FALSE 

If TRANSACTION_AUDITING is TRUE, Oracle generates a special redo record that contains the user logon name, user name, the session ID, some operating system information, and client information. For each successive transaction, Oracle generates a record that contains only the session ID. These subsequent records link back to the first record, which also contains the session ID.

These records might be useful if you are using a redo log analysis tool. You can access the records by dumping the redo log.

If TRANSACTION_AUDITING is FALSE, no redo record will be generated. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index