Re: hash partitions on 10gR2 RAC database
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: "Asif Momen" <asif_oracle@xxxxxxxxx>
- Date: Wed, 12 Dec 2007 17:17:47 +0300
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."
Other related posts:
