Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> flush share pool for one sql to force new plan
9.2.0.5 AIX5L Ent Ed
I have a table with appx 200000 rows and an indexed column that is
terribly skewed 3 values v1 = 80% rows, v2 = 19% and v3 = 1% of rows.
the table didn't have histograms, I analyzed using FOR ALL INDEXED
COLUMNS to generate a histogram for that column. The sql statement
that executes on this column uses a bind varible and the plan didn't
change so I'm still seeing a fts.
My question is how can I manually flush that sql statement from the
shared pool? Or is there a way to force Oracle to peek at the bind
variable again and change the plan that is used by that sql statement?
Thanks Received on Thu Feb 22 2007 - 09:17:42 CST