Object Cache Locks

Create Or Replace Force View Sys.Av_lock_object_cache (Owner,
                                                       Name,
                                                       Db_link,
                                                       Namespace,

                                                       Type,
                                                       Sharable_mem,
                                                       No_of_locks
                                                      )
As
   Select   Owner, Name, Db_link, Namespace, Type, Sharable_mem,
            Locks No_of_locks
       From V$db_object_cache O
      Where O.Owner Like 'HOME%'
        And O.Locks Not In (0)
   Order By Name;