OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Partitions (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitions [message #469711]

Thu, 05 August 2010 10:59

ravi214u
Messages: 153
Registered: February 2008
Location: CANADA

Senior Member

Hi All,

I have to create a hash partition on fact tables..can you pls suggest we can use temp tablespace or permanent tablespace.

Thanks

Report message to a moderator

Re: Partitions [message #469712 is a reply to message #469711]

Thu, 05 August 2010 11:06

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your question is completly ununderstandable.
Explain your problem.

Regards
Michel

Report message to a moderator

Re: Partitions [message #469722 is a reply to message #469712]

Thu, 05 August 2010 11:46

ravi214u
Messages: 153
Registered: February 2008
Location: CANADA

Senior Member

i want to create partition on fact tables.. Want to understand .. which tablespace we use for partiton.

Report message to a moderator

Re: Partitions [message #469727 is a reply to message #469722]

Thu, 05 August 2010 11:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Want to understand .. which tablespace we use for partiton.
I would use tablespace PARTITIONED_FACT, but you may decided to use a different tablespace.

Report message to a moderator

Re: Partitions [message #469728 is a reply to message #469722]

Thu, 05 August 2010 11:49

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same as for tables.

Regards
Michel

Report message to a moderator

Re: Partitions [message #469740 is a reply to message #469728]

Thu, 05 August 2010 12:11

ravi214u
Messages: 153
Registered: February 2008
Location: CANADA

Senior Member

Thanks for feedback.
Below is the example of the partition i am going to use.

partition by hash (ad_id)
(
  partition ad1 tablespace ad1,
  partition ad2 tablespace ad2,
  partition ad3 tablespace ad3,
  partition ad4 tablespace ad4
)

So in this case i have to break the existing permanent table space into ad1 to ad4 to do the partition.

Report message to a moderator

Re: Partitions [message #469742 is a reply to message #469740]

Thu, 05 August 2010 12:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So in this case i have to break the existing permanent table space into ad1 to ad4 to do the partition.
WHY? To what advantage?

Report message to a moderator

Re: Partitions [message #469752 is a reply to message #469742]

Thu, 05 August 2010 13:03

ravi214u
Messages: 153
Registered: February 2008
Location: CANADA

Senior Member

I think it will help in performace improvement if we split the existing partition in to many small segments..
I am not sure about it.

Report message to a moderator

Re: Partitions [message #469754 is a reply to message #469752]

Thu, 05 August 2010 13:04

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I think it will help in performace improvement if we split the existing partition in to many small segments..
I am not sure about it.

So make tests and run benchmarks.
But before, read Oracle documentation about partitioning this will prevent you from wasting your time.

Regards
Michel

Report message to a moderator

Re: Partitions [message #469756 is a reply to message #469752]

Thu, 05 August 2010 13:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is it better to cut pizza into 6, 8, or 12 slices?
Since I am not that hungry, better make only 6 slices; since I am not hungry enough to eat 12 slices.

>I think it will help in performace improvement if we split the existing partition in to many small segments..
SEGMENT is not the same as TABLESPACE. With DB words matter!
Having multiple tablespaces on same volume has NO impact on performance!

Report message to a moderator

Re: Partitions [message #469811 is a reply to message #469756]

Thu, 05 August 2010 21:34

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

BlackSwan wrote on Thu, 05 August 2010 13:09

Is it better to cut pizza into 6, 8, or 12 slices?
Since I am not that hungry, better make only 6 slices; since I am not hungry enough to eat 12 slices.

Indeed.

Report message to a moderator

Previous Topic:	Force Subquery To Use index
Next Topic:	create table statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 22 09:20:10 CST 2026