Re: Last access in table

2003-01-31 Thread Adriano Freire 
Title: RE: Last access in table



Ok 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. 
  [EMAIL PROTECTED] 618-622-4145 
  
-Original 
Message- From:   Adriano Freire 
[SMTP:[EMAIL PROTECTED]] 
DBA's,   How can i see the last(date) access(DML) in a 
table?   Thanks   Adriano

RE: Last access in table

2003-01-30 Thread Whittle Jerome Contr NCI 
Title: 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.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Adriano Freire [SMTP:[EMAIL PROTECTED]]


DBA's,

 

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

 

Thanks

 

Adriano

Last access in table

2003-01-30 Thread Adriano Freire 



DBA's,
 
How can i see the last(date) access(DML) in a 
table?
 
Thanks
 
Adriano