Asif, I already knew that bug mentioned in Note:4583442.8. Fortunately, the table doesn't have any LOB columns. Regarding the metalink discussion, one was about behavior in 8i and other one shows the query/index issues. However, what I am really looking for is the behavior on RAC database and any 10g improvement regarding hash algorthm. On 12/12/07, Asif Momen <asif_oracle@xxxxxxxxx> wrote: > > Hi, > > Please check out the following notes/discussions on Metalink: > > 1) > https://metalink.oracle.com/metalink/plsql/f?p=200:27:10138389227343044570::::p27_id,p27_show_header,p27_show_help:29019.996,1,1 > * > 2) > https://metalink.oracle.com/metalink/plsql/f?p=200:27:10138389227343044570::::p27_id,p27_show_header,p27_show_help:299978.999,1,1 > > 3) Note:4583442.8 > > Regards > > Asif Momen > http://momendba.blogspot.com > * > *Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>* wrote: > > Hi, > > We are planning to make use of hash partition to one of the heavily > accessed table on a RAC database(Oracle 10gR2). > > Are there any serious bugs/performance issues assosiates with hash > partition on Oracle 10gR2 ? > > > > > > -- > Best Regards, > Syed Jaffar Hussain > Oracle ACE > 8i,9i & 10g OCP DBA > > http://jaffardba.blogspot.com/ > > http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 > > ---------------------------------------------------------------------------------- > "Winners don't do different things. They do things differently." > > > ------------------------------ > Never miss a thing. Make Yahoo your > homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs> > > -- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."