Objets en mode debug :

Objets  en   mode debug :
 select  OBJECT_NAME,OBJECT_TYPE  from  dba_objects , sys.idl_char$  where OBJECT_ID=obj#  and  part=1  and owner='MG';

http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams184.htm