Oracle-L: Re: Last access in table

From: Adriano Freire <adriano.f_at_uol.com.br>
Date: Fri, 31 Jan 2003 04:43:46 -0800
Message-ID: <F001.005403D0.20030131044346@fatcity.com>

RE: Last access in tableOk Jerry

thanks a lot...

Adriano

Original Message ----- From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Thursday, January 30, 2003 5:34 PM Subject: RE: Last access in table

Adriano,

To see what happens from now on, turn on auditing for that table. To see what has already happened in the table, you aren't going to have too much luck unless auditing is already on. You could try running the statement below. It won't actually show the last access to that table; instead it shows the FIRST_LOAD_TIME. Of course the first and last might be one and the same if you are lucky.

select sql_text, address, FIRST_LOAD_TIME from v$sqlarea
where upper(sql_text) like upper('%table_name_here%') order by FIRST_LOAD_TIME desc;

If you see something interesting, you can post the ADDRESS into the SQL below to see more of the statement.

  select sql_text from v$sqltext
  where address = '83C984A4'
  order by piece

  Jerry Whittle
  ASIFICS DBA
  NCI Information Systems Inc.
  jerome.whittle_at_scott.af.mil
  618-622-4145

-----Original Message-----
From: Adriano Freire [SMTP:adriano.f_at_uol.com.br]

DBA's,

How can i see the last(date) access(DML) in a table?

Thanks

Adriano

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Adriano Freire
INET: adriano.f_at_uol.com.br

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Fri Jan 31 2003 - 06:43:46 CST