This view displays the pipes that are currently represented in the shared pool for this instance.
| Column | Datatype | Description |
|---|---|---|
OWNERID |
NUMBER |
The owner ID of the owner if this is a private pipe. NULL otherwise. |
NAME |
VARCHAR2(1000) |
The name of the pipe (for example, SCOTT.PIPE) |
TYPE |
VARCHAR2(7) |
PUBLIC or PRIVATE |
PIPE_SIZE |
NUMBER |
The amount of memory the pipe uses |