Oracle DB 18.104.22.168
How can we list the objects, such views, packages etc owned by a schema, with the last executed time or touched in the database?
moreajays wrote:No. which will not give the last executed or access times.
select owner,object_name,object_type,last_ddl_time,created from dba_objects where owner='&owner';