This content has been marked as final. Show 3 replies
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?
Status Level: Newbie (15)
Registered: Apr 7, 2008
Total Posts: 182
Total Questions: 57 (38 unresolved)
why so many unanswered questions?
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';