Oracle AQ monitoring questions

From: Basavaraja, Ravindra <Ravindra.Basavaraja_at_T-Mobile.com>
Date: Mon, 28 Jul 2003 19:29:24 -0800
Message-ID: <F001.005C78A1.20030728192924@fatcity.com>

Hi,

I am looking at using Oracle AQ to post messages.I know they are just like any other database table but with some limitations.i have some concerns from what I have heard from users who have previously used AQ

1.Are there any serious concerns in using AQ.My purpose of using AQ is just to act like a messager of message and to have JMS features implemented with the Application.Are there any known issues? or any advantages.?

2.Are there any monitoring scripts/features within oracle database to monitor the AQ for their growth/size/length or corruption.?

3.Does AQ get corrupted more often than other oracle tables?How can we find out if AQ is getting corrupted.This question may be related to the previous one .

Pls advice.

Thanks
Ravindra
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Basavaraja, Ravindra
  INET: Ravindra.Basavaraja_at_T-Mobile.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 28 2003 - 22:29:24 CDT