Tuesday, December 22, 2009

V$DB_PIPES

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

======================================================================


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:
  • PUBLIC
  • PRIVATE
PIPE_SIZE
NUMBER
Amount of memory the pipe uses

Oracle data dictionary views

Last updated: 2009-12-22 Tuesday

No comments:

Post a Comment