Re: FTS in SQL Query ... Advice please?
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Mon, 5 Mar 2007 23:17:21 +1000
Your query didn't return any single row? What filter predicates on
GENERAL_ACCT_MAST_TABLE made this to happen? Is this a common behavior
(not to return any data)?
Mixing histograms with cursor_sharing=force isn't a very good idea
unless you are certain that optimizer will _always_ pick suitable bind
variable values during the hard parse (bind variable peeking). Or is
that "similar"?
Alexander Fatkulin,
Senior Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
