RE: How can I

Turn auditing on and use it for that table. Obviously, this won't tell you the last time it was accessed, but you will be able to found out stuff like that in the future.

Audit it through the application.

You can _TRY_ v$sqlarea or v$open_cursors connected with v$session. That will tell you who is running what SQL statements at the moment and which ones are still in the SGA, respectively.

HTH
Lyall

------Original Message------
From: Adam Bisley <ABISLEY_at_invensys-energy.co.nz> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 15, 2000 4:14:14 AM GMT
Subject: How can I

Find out the last time a table was accessed ? Ie Read From.

regards ..... Adam.

Adam Bisley
Database Administrator

Invensys Energy Systems (NZ) Limited
39 Princess Street,
PO Box 11-188,
Christchurch 8030,
New Zealand
Phone (+64)3 3433314 Fax (+64)3 3488871 DDI Phone (+64)3 3437479
Email abisley_at_invensys-energy.co.nz
Website www.invensys-energy.co.nz

--
Author: Adam Bisley
INET: ABISLEY_at_invensys-energy.co.nz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

______________________________________________
FREE Personalized Email at Mail.com