RE: Question about Oracle pipes sizes and the messages at the queue

Is this the sort of thing you'd be interested in:


http://jonathanlewis.wordpress.com/2009/01/30/pipes/


Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

________________________________________
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Hanan Hit [hithanan_at_gmail.com]
Sent: 17 March 2014 21:13
To: Oracle-L_at_FreeLists.org
Cc: Hanan Hit
Subject: Question about Oracle pipes sizes and the messages at the queue

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 ,
short_name
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
/



Best,
        Hanan


--
http://www.freelists.org/webpage/oracle-l


--