How to find the last access time of a schema in oracle?

by darrion.kuhn , in category: MySQL , 8 months ago

How to find the last access time of a schema in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by haylee.mertz , 8 months ago

@darrion.kuhn 

To find the last access time of a schema in Oracle, you can query the USER_TAB_MODIFICATIONS view. This view contains information about when tables were last accessed or modified.


Here is an example query to find the last access time of a schema:

1
2
3
SELECT MAX(LAST_DDL_TIME) AS LAST_ACCESS_TIME
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'TABLE';


This query will return the last access time of the tables in the schema. You can modify the query based on the specific object type you are interested in (e.g. VIEW, PROCEDURE, etc).