Oracle-L: Re: AQ query from dequeuw procedure not using index -URGENT

From: orafaq <shgarg_orafaq_at_hotmail.com>
Date: Mon, 09 Dec 2002 13:44:14 -0800
Message-ID: <F001.00515A0E.20021209134414@fatcity.com>

RE: AQ query from dequeuw procedure not using index -URGENTThis database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173?

Thanks
Shaleen

Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 12:39 PM Subject: RE: AQ query from dequeuw procedure not using index -URGENT

Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT

Shaleen,

Have you considered using Outlines?
John Kanagaraj

--

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

Author: orafaq
INET: shgarg_orafaq_at_hotmail.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 Dec 09 2002 - 15:44:14 CST