Path: utzoo!attcan!uunet!lll-winken!uwm.edu!uwvax!ai.cs.wisc.edu!beverly
From: beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung))
Newsgroups: comp.databases
Subject: ORACLE SQL*PLUS auditing tables
Message-ID: <10893@spool.cs.wisc.edu>
Date: 26 Jul 90 19:40:37 GMT
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 19

In SQL*PLUS how does one turn on auditing?
I tried the following to try to see if a table
was getting locked:

   SQL> Audit all on SHIFT by access;
	
		Audit succeeded

   SQL> lock table SHIFT in exclusive mode;

		Table locked

   SQL>  select * from audit_trail;

		No records selected


Shouldn't locking the table SHIFT leave a record in the audit trail?
Am I looking at the wrong audit table?