Oracle Server :: Last Table Access Timestamp


	Last Table Access Timestamp I could have sworn there was a feature internal to Oracle that tagged a last access timestamp. I'm not talking about a column in the table itself, but something in Oracle's system tables or something. Does anyone know if this ever was/is a feature, and if so, how to access it? thanks very much. Jordan On May 11, 10:30 am, jred@gmail.com wrote: > I could have sworn there was a feature internal to Oracle that tagged > a last access timestamp. I'm not talking about a column in the table > itself, but something in Oracle's system tables or something. > Does anyone know if this ever was/is a feature, and if so, how to > access it? > thanks very much. > Jordan As far as I know that would be statement auditing. Check the manuals at http://tahiti.oracle.com or go out to www.psoug.org/library.html for information and examples. David Fitzjarrell -----------------------------------------------Reply----------------------------------------------- jred@gmail.com wrote: > I could have sworn there was a feature internal to Oracle that tagged > a last access timestamp. I'm not talking about a column in the table > itself, but something in Oracle's system tables or something. > Does anyone know if this ever was/is a feature, and if so, how to > access it? > thanks very much. > Jordan Define what you mean and the version. -- Daniel A. Morgan University of Washington damor@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org -----------------------------------------------Reply----------------------------------------------- jred@gmail.com wrote: > I could have sworn there was a feature internal to Oracle that tagged > a last access timestamp. I'm not talking about a column in the table > itself, but something in Oracle's system tables or something. > Does anyone know if this ever was/is a feature, and if so, how to > access it? If you mean insert/update/merge then check ora_rowscn with table created with rowdependencies. Actually AFAIK it is just like additional column, only Oracle itself maintains it :) Gints Plivna http://www.gplivna.eu -----------------------------------------------Reply----------------------------------------------- -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 jred@gmail.com schreef: > I could have sworn there was a feature internal to Oracle that tagged > a last access timestamp. I'm not talking about a column in the table > itself, but something in Oracle's system tables or something. > Does anyone know if this ever was/is a feature, and if so, how to > access it? > thanks very much. > Jordan Hmmm.. You mean last_ddl on sources? - -- Regards, Frank van Bortel Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) iD8DBQFGSe8dLw8L4IAs830RAjxVAJ0dC9T0UcalQBfNbyhnmhk/PAaFAgCgkBTn esGNYspF0SgOXkMGzhc5mXY= =dPDg -----END PGP SIGNATURE-----

MS Dynamics CRM 3.0

Oracle Server

Last Table Access Timestamp