Looking at DBA_SOURCE, where are are those lines actually stored?
SYS.DBA_SOURCE is a view that depends on SYS.int$dba_source, which is a union SYS.source$ (PL/SQL) and SYS.x$joxscd (JAVA). SYS.source$ is the actual segment where PL/SQL code is stored.
SYS.source$ can be joined to SYS.obj$ to get the actual owner. Actually, dba_source joins to sys.“_CURRENT_EDITION_OBJ” to get the correct edition.
Though PL/SQL objects appear as part of a schema, this one segment holds PL/SQL for the entire database.
Kommentar verfassen