Stored Outline
From: Stalin <stalinsk_at_gmail.com>
Date: Wed, 22 Jul 2009 17:13:53 -0700
Message-ID: <c5363d3a0907221713u5f773907m2acb99fa62d4ec4f_at_mail.gmail.com>
All,
Date: Wed, 22 Jul 2009 17:13:53 -0700
Message-ID: <c5363d3a0907221713u5f773907m2acb99fa62d4ec4f_at_mail.gmail.com>
All,
We recently had a performance issue on a SQL for which we had stored outlined defined for it. Wondering if oracle an skip stored outline by any means.
We created outline using create_outline(hash_value, child_number) from the child cursor in shared pool which had the good plan. And enabled outline at system level and also to kept persistent across DB restart via DB startup trigger.
The SQL in question is using bind variables though. Something along the lines of "Select * from tablename where col1 = :1 and col2 = :2 and col3 = :3"
Thanks,
Stalin
Platform: 10gR2 (10.2.0.4), Sol10.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 22 2009 - 19:13:53 CDT