Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_messaging026.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Viewing Persistent Queue Statistics</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Viewing Persistent Queue Statistics" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpii_messaging025.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_messaging027.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpii_messaging025.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging027.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABCJJGF" name="BABCJJGF"></a><a id="TDPII165" name="TDPII165"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Viewing Persistent Queue Statistics<a id="sthref662" name="sthref662"></a><a id="sthref663" name="sthref663"></a><a id="sthref664" name="sthref664"></a><a id="sthref665" name="sthref665"></a><a id="sthref666" name="sthref666"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>If you are using persistent messaging mode, then messages are stored in queue table on hard disk. This topic describes viewing statistics for messages that were enqueued in persistent mode into a persistent queue.</p> <p class="orderedlisttitle">To view persistent queue statistics: </p> <ol> <li> <p>In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Data Movement</span> to open the Data Movement subpage.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('STREAMS_MESSAGING');"><span class="bold">Manage Advanced Queues</span></a> to open the Streams page.</p> </li> <li> <p>Select the queue that contains the messages. If necessary, use the search tool to find the queue, and then select it.</p> </li> <li> <p>Select <span class="bold">Queue Statistics</span> in the Actions list.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> </li> <li> <p>On the Queue Statistics page, click <span class="bold">Message Statistics</span> to view the persistent queue statistics for the queue.</p> </li> </ol> <p>The message statistics show the number of messages in each state in the persistent queue. They also show the total wait time and the average wait time for messages to be dequeued.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span><ul> <li> <p>Messages can also be enqueued in buffered mode. In this case, the messages are stored in memory in a buffered queue. See <a href="tdpii_adcont026.htm#CHDEHBJF">"Viewing Buffered Queue Statistics"</a> for information about viewing statistics for these messages.</p> </li> <li> <p>You can also query the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30004','newWindow').focus()"><code>V$AQ</code></a> dynamic performance view for queue statistics.</p> </li> </ul> </p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_messaging021.htm#CHDEBJHA">Modifying Queues</a></p> <p><a href="tdpii_messaging001.htm#CHDIJFHB">About Messaging</a></p> <p><a href="tdpii_messaging024.htm#CHDDICBF">Monitoring a Messaging Environment</a></p> <p><a href="tdpii_messaging025.htm#BABBAHDB">Viewing the Messages in a Queue</a></p> <p><a href="tdpii_messaging027.htm#BABBJDHF">Viewing the Consumers Who Can Dequeue Messages</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpii_messaging025.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging027.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de