| General Information |
| Purpose |
This package provides a table function FG_ELEMENTS that translates the fine-grain dependency information stored in dependency$ into a user readable format.
It is not created during database installation. |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsfgd.sql |
| First Available |
11.2.0.2 |
| Dependencies |
| DBA_FINE_GRAIN_DEPENDENCIES |
PUBLIC_FINE_GRAIN_DEPENDENCY |
| DEPENDENCY$ |
UTL_RAW |
|
| Data Types |
TYPE fg_rec IS RECORD(element_num IN NUMBER, element_desc IN VARCHAR2(30));
TYPE fg_tab IS TABLE OF fg_rec; |
| Security Model |
Owned by SYS with no granted privileges |
| |
| FG_ELEMENTS |
| Translates, into human readable form, fine grain dependency information |
fg_elements(bitvec IN RAW) RETURN fg_tab PIPELINED; |
conn / as sysdba
desc dependency$
@?/rdbms/admin/dbmsfgd.sql
desc dba_fine_grain_dependencies
SELECT COUNT(*)
FROM dba_fine_grain_dependencies;
SELECT element_desc, COUNT(*)
FROM dba_fine_grain_dependencies
GROUP BY element_desc;
col owner format a20
col type format a15
col referenced_name format a20
SELECT owner, name, type, referenced_name, element_desc
FROM dba_fine_grain_dependencies; |
