For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.

Purpose

This package provides a table function FG_ELEMENTS that translates the fine-grain dependency information stored in dependency$ into a user readable format.

AUTHID

CURRENT_USER

Data Types

TYPE fg_rec IS RECORD(element_num IN NUMBER, element_desc IN VARCHAR2(30));

TYPE fg_tab IS TABLE OF fg_rec;

Dependencies

DBA_FINE_GRAIN_DEPENDENCIES

PUBLIC_FINE_GRAIN_DEPENDENCY

UTL_RAW

DEPENDENCY$

Documented

No

First Available

11.2.0.2

Security Model

Owned by SYS with no privileges granted

Source

$ORACLE_HOME/rdbms/admin/dbmsfgd.sql
This package is not part of the default installation. To create the object package and associated views the script must be run manually.