Database Tuning (MOSC)

MOSC Banner

Can I shrink a LOB column for a Advanced Queue table?

edited Aug 4, 2021 12:46PM in Database Tuning (MOSC) 2 commentsAnswered

Oracle 11.2

I create AQ

BEGIN

 SYS.DBMS_AQADM.CREATE_QUEUE_TABLE

 (

  QUEUE_TABLE      => 'MY_Q_TABLE'

  ,QUEUE_PAYLOAD_TYPE  => 'SYS.AQ$_JMS_TEXT_MESSAGE'

  ,COMPATIBLE      => '8.1'

  ,STORAGE_CLAUSE    => 'TABLESPACE DATA'

  ,SORT_LIST       => 'PRIORITY,ENQ_TIME'

  ,MULTIPLE_CONSUMERS  => FALSE

  ,MESSAGE_GROUPING   => 0

  ,SECURE        => FALSE

 );

 SYS.DBMS_AQADM.CREATE_QUEUE

 (

  QUEUE_NAME     =>  'MY_Q_TABLE'

  ,QUEUE_TABLE     =>  'MY_Q_TABLE'

  ,QUEUE_TYPE     =>  SYS.DBMS_AQADM.NORMAL_QUEUE

  ,MAX_RETRIES     =>  0

  ,RETRY_DELAY     =>  0

  ,RETENTION_TIME   =>  1209600

  );

 SYS.DBMS_AQADM.START_QUEUE

 (

  QUEUE_NAME => 'MY_Q_TABLE'

  ,ENQUEUE => TRUE

  ,DEQUEUE => TRUE

  );

End;

When I read https://docs.oracle.com/database/121/ADQUE/aq_admin.htm#ADQUE0800

Note:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center