Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index