Saturday, August 16, 2008

# coalesce qmn queues

# coalesce qmn queues

Select 'alter table applsys.aq$_'||queue_table||'_I coalesce;'
From dba_queues
Where owner = 'APPLSYS'
Union
Select 'alter table applsys.aq$_'||queue_table||'_T coalesce;'
From dba_queues
Where owner = 'APPLSYS'
Union
Select 'alter table applsys.aq$_'||queue_table||'_H coalesce;'
From dba_queues
Where owner = 'APPLSYS';