OraFAQ Forum: SQL & PL/SQL » Oracle Table last access detail

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Table last access detail (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Table last access detail [message #638964]

Fri, 26 June 2015 23:40

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

hi,
I want to know, how to get the last access time of all table in schema, Can anyone give me a query for same.

Remember, last access time not a last time a DDL statement

Report message to a moderator

Re: Oracle Table last access detail [message #638965 is a reply to message #638964]

Fri, 26 June 2015 23:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ashish.tiwari wrote on Fri, 26 June 2015 21:40

hi,
I want to know, how to get the last access time of all table in schema, Can anyone give me a query for same.

Remember, last access time not a last time a DDL statement

not possible.
Can you prove me wrong?

Does "access time" mean same as SELECT?

Report message to a moderator

Re: Oracle Table last access detail [message #638966 is a reply to message #638965]

Fri, 26 June 2015 23:48

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

Quote:

Does "access time" mean same as SELECT?

Yes.

Quote:

not possible.

ok :/

Report message to a moderator

Re: Oracle Table last access detail [message #638967 is a reply to message #638966]

Fri, 26 June 2015 23:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ashish.tiwari wrote on Fri, 26 June 2015 21:48

Quote:
Does "access time" mean same as SELECT?

Yes.

Quote:
not possible.

ok :/

SELECT leaves no tracks; except for AUDIT.

Report message to a moderator

Re: Oracle Table last access detail [message #638968 is a reply to message #638967]

Fri, 26 June 2015 23:56

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

Quote:

SELECT leaves no tracks; except for AUDIT

OK

Report message to a moderator

Re: Oracle Table last access detail [message #638979 is a reply to message #638964]

Sun, 28 June 2015 00:27

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@Ashish,

Have a look at Auditing.

Report message to a moderator

Previous Topic:	default value on update in oracle 11G
Next Topic:	Execute a sql script depending on number of records in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 11:04:49 CDT 2024