Question about Oracle pipes sizes and the messages at the queue

From: Hanan Hit <>
Date: Mon, 17 Mar 2014 14:13:30 -0700
Message-Id: <>

Hi All,

I have a quick question about Oracle pipes sizes and the messages at the queue.

Basically what I am looking for is a method to identify the size of the pipe in the the shared pool as well as to identify the number of messages (queue size) and possibly their content.

I am using the below query (extracted and modified from an Hotsos) presentation about Shared pool , which lets me see the memory usage of the different Pipes but just wanted to check whether there is other option and still looking at the messages at the queue.

select row_within ,
namespace ,
sharable_mem ,
from ( select row_number () over ( partition by namespace order by sharable_mem desc ) row_within, namespace, sharable_mem/1024/1024 sharable_mem,
substr(name, 1,60 ) as short_name
from v$db_object_cache order by sharable_mem desc ) where namespace like '%PIPE'
 order by sharable_mem desc, namespace, row_within /



Received on Mon Mar 17 2014 - 22:13:30 CET

Original text of this message