Pinning Objects

[jaxtell]

I'd like to understand pinning objects better than I do right now. Based on this link , I have an idea. Will the

select owner,name,type,sharable_mem from v$db_object_cache where kept='YES'

show all pinned objects? I see mostly table names and index names with type 'INVALID TYPE'. I was expecting to see some function/procedures/packages. Out DBA is gone now, and I'm just trying to make sense of what I'm seeing and possibly improve things. I'd appreciate any comments or suggestions you can offer. Thanks.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[AngieDBA]

INVALID is used as for cursors as they are not real types.