Dynamic Performance (V$) Views, 40 of 179

V$DB_PIPES

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

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