Kirti, I speak to a fair number of DBAs daily, and even bring this up with a fair few of them, and have yet to come across a single person that uses this package. We have a tool (DBExpert which is a spin-off of SQLExpert from Leccotech) that has a "Stored Outline Manager", which is basically a graphical front end that aids managing, creating, updating of Stored Outlines.
Not one person I have spoken to has lit on to this at all.. I have to say that it *does* work as advertised - we've used it to test this new function in the tool quite extensively for beta testing.. Whether it's just not widely known about (a *lot* of people ask what it actually is), or just not worth implementing I'm not sure.. I think there could be quite a good scope for them with those apps that *still* run RULE based, and want to be migrated quickly and easily to COST / CHOOSE with minimal tuning / re-write requirements.. I had no issues with them at all.. The section "Using Plan Stability" in the 8i Tuning & Performance manual was very helpful in playing with them, and explains in good detail.. HTH Mark -----Original Message----- Kirti Sent: 04 February 2002 16:40 To: Multiple recipients of list ORACLE-L Anyone really using this feature? Care to share the experience? Does it work as advertised? Any issues? Thanks. - Kirti -----Original Message----- Sent: Monday, February 04, 2002 10:17 AM To: Multiple recipients of list ORACLE-L Interesting observation: Listers are much less objecting to answer some really 'simple' questions (which could be RTFMed), if those questions touch upon relatively new oracle features (like OUTLN). Should have to do with people's curiosity? Igor Neyman, OCP DBA [EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
