Question about Oracle pipes sizes and the messages at the queue
- From: Hanan Hit <hithanan@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Mon, 17 Mar 2014 14:13:30 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
