Search | View Active Threads | View New Posts
Current Time: 12:43 PM

 

+ Reply to Thread
Results 1 to 2 of 2
  1. #1

    Thumbs up What is The ALTER_QUEUE procedure

    The ALTER_QUEUE procedure modifies properties of an existing message queue. It returns an error if the
    message queue does not exist. Currently, you can alter only the maximum retries, retry delay, retention time, rentention delay and auto−commit properties; Oracle will augment this list in future releases. The
    specification is:

    Code:
    PROCEDURE DBMS_AQADM.ALTER_QUEUE (
    queue_name IN VARCHAR2,
    max_retries IN NUMBER default NULL,
    retry_delay IN NUMBER default NULL,
    retention_time IN NUMBER default NULL,
    auto_commit IN BOOLEAN default TRUE);

  2. #2
    Join Date
    May 2019
    Posts
    25
    ALTER QUEUE <object>
    queue_settings
    | queue_action
    [ ; ]

    <object> : :=
    { database_name.schema_name.queue_name | schema_name.queue_name | queue_name }

    <queue_settings> : :=
    WITH
    [ STATUS = { ON | OFF } [ , ] ]
    [ RETENTION = { ON | OFF } [ , ] ]
    [ ACTIVATION (
    { [ STATUS = { ON | OFF } [ , ] ]
    [ PROCEDURE_NAME = <procedure> [ , ] ]
    [ MAX_QUEUE_READERS = max_readers [ , ] ]
    [ EXECUTE AS { SELF | 'user_name' | OWNER } ]
    | DROP }
    ) [ , ]]
    [ POISON_MESSAGE_HANDLING (
    STATUS = { ON | OFF } )
    ]

    <queue_action> : :=
    REBUILD [ WITH <query_rebuild_options> ]
    | REORGANIZE [ WITH (LOB_COMPACTION = { ON | OFF } ) ]
    | MOVE TO { file_group | "default" }

    <procedure> : :=
    { database_name.schema_name.stored_procedure_name | schema_name.stored_procedure_name | stored_procedure_name }

    <queue_rebuild_options> : :=
    {
    ( MAXDOP = max_degree_of_parallelism )
    }


    Digital Signage Solution | Drive Thru Speaker Post | Drive Thru Technology

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  

Sponsors

Trellian Direct Search Network
Domain Escrow Services
Above.com Domain Registrar, Marketplace and Revenue Optimizer

Industry Events

11-14 August 2019
Affiliate Summit East
New York, NY

4-6 March 2019
LeadsCon
Las Vegas

15-18 September 2018
MERGE 2018
Orlando, FL

Poll

How do you invest in domains?
to see the Poll results!
DomainState.com
Domain Tools | Domain Directory | Registrar Stats | Domain Glossary | Industry Events | FAQ | Members | Terms | RSS | Link To Us | Advertise | Contact Us
Other Related Trellian Services:
Above.com Registrar  |  Above.com Marketplace  |  Above.com Domain Manager  |  Free Search Toolbar  |  Free Webpage Builder  |  Keyword Research
Direct Search Navigation  |  Search Engine Submission and SEO Tools
Copyright © 2002 DomainState.com a Trellian Company 2014 Bronze Sponsor - Internet Commerce Association