You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for AQ


1 to 20 of 709 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 11g Release 2 (11.2)

V$AQ

V$AQdisplays statistics for the queues in the database. Column Datatype Description QID NUMBER Unique queue identifier WAITING NUMBER Number of messages in the queue in the state ' WAITING ' READY NUMBER Number of messages in the queue in the state ' READY ' EXPIRED NUMBER Number of messages in the queue the state ' EXPIRED ' TOTAL_WAIT NUMBER Total wait time of all ' READY ' messages in the queue AVERAGE_WAIT

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_RECIPIENT_LIST_T Typeis enabled for multiple dequeues. See Also: \"AQ$_AGENT Type\" Syntax TYPE SYS.AQ$_RECIPIENT_LIST_T IS TABLE OF SYS.AQ$_AGENT INDEX BY BINARY_INTEGER;

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_SUBSCRIBER_LIST_T TypeIdentifies the list of subscribers that subscribe to a queue. See Also: \"AQ$_AGENT Type\" Syntax

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_PURGE_OPTIONS_T TypeProcedure. Syntax TYPE AQ$_PURGE_OPTIONS_T is RECORD ( block BOOLEAN DEFAULT FALSE delivery_mode … PLS_INTEGER DEFAULT PERSISTENT); Table 244-5 AQ$_PURGE_OPTIONS_T Type Attributes Attribute Description

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_AGENT Type( name VARCHAR2(30), address VARCHAR2(1024), protocol NUMBER DEFAULT 0); Attributes Table 244-1 AQ … number is in the range 128 - 255, the address of the recipient is not interpreted by Oracle Streams AQ.

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_REG_INFO_LIST TypeIdentifies the list of registrations to a queue. See Also: \"AQ$_REG_INFO Type\" Syntax TYPE SYS.AQ$_REG_INFO_LIST AS VARRAY(1024) OF SYS.AQ$_REG_INFO;

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_DESCRIPTOR TypeThis type specifies the Oracle Streams AQ descriptor received by the AQ PL/SQL callbacks upon … ( queue_name VARCHAR2(61), consumer_name VARCHAR2(30), msg_id RAW(16), msg_prop MSG_PROP_T, gen_desc AQ … $_NTFN_DESCRIPTOR, msgid_array SYS.AQ$_NTFN_MSGID_ARRAY, ntfnsRecdInGrp NUMBER); Attributes Table 244-2 AQ

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

JMS Types

cast_to_bytes_msg RETURN aq$_jms_bytes_messageCasts an aq$_jms_message to an aq$_jms_bytes_message. Returns an aq$_jms_bytes_message or if … the message_type attribute of the aq$_jms_message is not DBMS_AQ.JMS_BYTES_MESSAGE. This function … raises ORA-24198 if the message_type field of the aq$_jms_message is not DBMS_AQJMS.JMS_BYTES_MESSAGE

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_POST_INFO_LIST TypeIdentifies the list of anonymous subscriptions to which you want to post messages. See Also: AQ

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_NTFN_DESCRIPTOR Type… Syntax TYPE SYS.AQ$_NTFN_DESCRIPTOR IS OBJECT( ntfn_flags NUMBER) Attributes Table 244-3 AQ

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_POST_INFO Type244-4 AQ$_POST_INFO Attributes Attribute Description name Name of the anonymous subscription to

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_AGENT_LIST_T TypeThis type identifies the list of agents for which DBMS_AQ. LISTEN listens. See Also: \"AQ$_AGENT

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_NTFN_MSGID_ARRAY TypeThis type is for storing grouping notification data for AQ namespace, value 2 30 which is the max

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

AQ$_REG_INFO Type, ntfn_grouping_repeat_count NUMBER); Attributes Table 244-6 AQ$_REG_INFO Type Attributes Attribute Description name Specifies … Oracle Streams AQ queues, the namespace must be DBMS_AQ.NAMESPACE_AQ. To receive notifications from

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

JMS Types

STATIC FUNCTION construct (text_msg IN aq$_jms_text_message) RETURN aq$_jms_messageCreates an aq$_jms_message from an aq$_jms_text_message. STATIC FUNCTION construct (bytes_msg IN aq … $_jms_bytes_message) RETURN aq$_jms_message; Creates an aq$_jms_message from an aq … $_jms_bytes_message. STATIC FUNCTION construct (stream_msg IN aq$_jms_stream_message)

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Oracle Streams AQ TYPEs

244 Oracle Streams AQ TYPEsThis chapter describes the types used with Oracle Streams Advanced Queuing (AQ) packages for PL/SQL … about using Oracle Streams AQ. This chapter contains the following topics: Summary of Types

Database Utilities, 11g Release 2 (11.2)

Original Export

Exporting Advanced Queue (AQ) TablesQueues are implemented on tables. The export and import of queues constitutes the export and import of the underlying queue tables and related dictionary tables. You can export and import queues only at queue table granularity. When you export a queue table, both the table definition information and queue data are exported. Because the queue table data and the table definition is exported, the user

Database Utilities, 11g Release 2 (11.2)

Original Import

Importing Advanced Queue (AQ) TablesImporting a queue table also imports any underlying queues and the related dictionary information. A queue can be imported only at the granularity level of the queue table. When a queue table is imported, export pre-table and post-table action procedures maintain the queue dictionary. See Also: Oracle Streams Advanced Queuing User's Guide

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_AQADM

Oracle Streams AQ Agent SubprogramsTable 23-8 Oracle Streams AQ Agent Subprograms Subprograms Description ALTER_AQ_AGENT Procedure … Alters an agent registered for Oracle Streams AQ Internet access, and an Oracle Streams AQ agent that … accesses secure queues CREATE_AQ_AGENT Procedure Registers an agent for Oracle Streams AQ Internet … access using

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Triggers for Publishing EventsStreams Advanced Queuing (AQ) For information about the DBMS_AQ package, see Oracle Database PL/SQL … Packages and Types Reference. For information about AQ, see Oracle Streams Advanced Queuing User's … modified trigger. When a trigger fires and invokes AQ, AQ publishes the event and passes to the trigger … event