Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

        
 

 Oracle Enable_db_access
Oracle Tips by Burleson Consulting

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by the top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan).  The following is an excerpt from the book.

Enable_db_access is a procedure that grants AQ Internet agent privileges to a specified database user.

  

Argument

Type

In / Out

Default Value

AGENT_NAME

VARCHAR2

IN

 

DB_USERNAME

VARCHAR2

IN

 

Table 6.76:  Enable_db_access Parameters

Enable_jms_types is a procedure that when called after set_up_queue, permits SYS.ANYDATA streams work for JMS types and XML types.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

Table 6.77:  Enable_jms_types Parameter

Enable_propagation_schedule is a procedure that enables a propagation schedule. If the destination parameter for the destination database link is NULL, then the destination is the local database and all messages are propagated to other local database queues.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

DESTINATION

VARCHAR2

IN

NULL

DESTINATION_QUEUE

VARCHAR2

IN

NULL

Table 6.78:  Enable_propagation_schedule Parameters

Get_watermark is a procedure that returns the watermark value in megabytes set by set_watermark.

 

Argument

Type

In / Out

Default Value

WMVALUE

NUMBER

OUT

 

Table 6.79:  Get_watermark Parameter

Grant_queue_privilege is a procedure for granting regular queue privileges to database users and roles. The privilege parameter access the following: ALL, ENQUEUE, and DEQUEUE.

 

Argument

Type

In / Out

Default Value

PRIVILEGE

VARCHAR2

IN

 

QUEUE_NAME

VARCHAR2

IN

 

GRANTEE

VARCHAR2

IN

 

GRANT_OPTION

BOOLEAN

IN

FALSE

Table 6.80:  Grant_queue_privilege Parameters

Grant_system_privilege is a procedure for granting special queue privileges to database users and roles. The privilege parameter accesses the following: MANAGE_ANY, ENQUEUE_ANY, and DEQUEUE_ANY.

 

Argument

Type

In / Out

Default Value

PRIVILEGE

VARCHAR2

IN

 

GRANTEE

VARCHAR2

IN

 

GRANT_OPTION

BOOLEAN

IN

FALSE

Table 6.81:  Grant_system_privilege Parameters

Migrate_queue_table is a procedure for upgrading and downgrading queue tables between Oracle 8.0 and 8.1 compatible formats. Note that these are the two permissible values for the compatible parameter.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

COMPATIBLE

VARCHAR2

IN

 

Table 6.82:  Migrate_queue_table Parameters

Purge_queue_table is a procedure that purges queue table messages, plus it generates a trace file in user_dump_dest that details what the procedure did. The purge_options parameter requires using the special purge record type shown just below. When BLOCK=TRUE, then an exclusive lock is held on all queues within that queue table during the purge.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

PURGE_CONDITION

VARCHAR2

IN

 

PURGE_OPTIONS

AQ$_PURGE_OPTION_T

IN

 

Table 6.83:  Purge_queue_table Parameters

TYPE aq$_purge_options_t IS RECORD(

  block          boolean      DEFAULT FALSE,

  delivery_mode  PLS_INTEGER  DEFAULT dbms_aqadm.PERSISTENT

);

 

Remove_subscriber is a procedure that simply drops a subscriber from a queue. It takes immediate effect, i.e. is committed.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

SUBSCRIBER

SYS.AQ$_AGENT

IN

 

Table 6.84:  Remove_subscriber Parameters

Revoke_queue_privilege is a procedure for revoking regular queue privileges from database users and roles. The privilege parameter accesses the following: ALL, ENQUEUE, and DEQUEUE.

  

Argument

Type

In / Out

Default Value

PRIVILEGE

VARCHAR2

IN

 

QUEUE_NAME

VARCHAR2

IN

 

GRANTEE

VARCHAR2

IN

 

Table 6.85:  Revoke_queue_privilege Parameters

Revoke_system_privilege is a procedure for revoking special queue privileges from database users and roles. The privilege parameter accesses the following: MANAGE_ANY, ENQUEUE_ANY, and DEQUEUE_ANY.

 

Argument

Type

In / Out

Default Value

PRIVILEGE

VARCHAR2

IN

 

GRANTEE

VARCHAR2

IN

 

Table 6.86:  Revoke_system_privilege Parameters

Schedule_Propagation is a procedure that defines a propagation schedule. If the destination parameter for the destination database link is NULL, then the destination is the local database and all messages are propagated to other local database queues.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

DESTINATION

VARCHAR2

IN

NULL

START_TIME

DATE

IN

SYSDATE

DURATION

NUMBER

IN

NULL

NEXT_TIME

VARCHAR2

IN

NULL

LATENCY

NUMBER

IN

60

DESTINATION_QUEUE

VARCHAR2

IN

NULL

Table 6.87:  Schedule_propagation Parameters

Set_watermark is a procedure that defines the watermark value in megabytes, which is used to control and/or limit memory use.

 

Argument

Type

In / Out

Default Value

WMVALUE

NUMBER

OUT

 

Table 6.88:  Set_watermark Parameter

Start_queue is a procedure that enables enqueuing and dequeuing for the specified queue.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

ENQUEUE

BOLLEAN

IN

TRUE

DEQUEUE

BOOLEAN

IN

TRUE

Table 6.89:  Start_queue Parameters

Stop_queue is a procedure that disables enqueuing and dequeuing for the specified queue.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

ENQUEUE

BOLLEAN

IN

TRUE

DEQUEUE

BOOLEAN

IN

TRUE

Table 6.90:  Stop_queue Parameters

Unschedule_Propagation is a procedure that undefines a propagation schedule. If the destination parameter for the destination database link is NULL, then the destination is the local database and all messages are propagated to other local database queues.

  

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

DESTINATION

VARCHAR2

IN

NULL

DESTINATION_QUEUE

VARCHAR2

IN

NULL

Table 6.91:  Unschedule_propagation Parameters

     


Fo
r more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress.

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.