V$DB_PIPES displays the pipes that are currently represented in the shared pool for this instance.
| Column | Datatype | Description |
|---|---|---|
OWNERID |
NUMBER |
Owner ID of the owner (if this is a private pipe), else NULL |
NAME |
VARCHAR2(1000) |
Name of the pipe (for example, SCOTT.PIPE) |
TYPE |
VARCHAR2(7) |
Type of the pipe:
|
PIPE_SIZE |
NUMBER |
Amount of memory the pipe uses |