Re: Optimizer issue in 11g
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Wed, 3 Feb 2010 14:44:19 -0800 (PST)
Message-ID: <290c1ebf-8a1c-4ac4-925e-a6660b7e2a0c_at_a17g2000pre.googlegroups.com>
Hmm, so the plan changed even for queries with literal values (no bind variables)
where none of the tables in the query was analyzed? What's about so- called system statistics?
What is value of parameter TIMED_OS_STATISTICS? Received on Wed Feb 03 2010 - 16:44:19 CST
Date: Wed, 3 Feb 2010 14:44:19 -0800 (PST)
Message-ID: <290c1ebf-8a1c-4ac4-925e-a6660b7e2a0c_at_a17g2000pre.googlegroups.com>
Hmm, so the plan changed even for queries with literal values (no bind variables)
where none of the tables in the query was analyzed? What's about so- called system statistics?
What is value of parameter TIMED_OS_STATISTICS? Received on Wed Feb 03 2010 - 16:44:19 CST