Home » RDBMS Server » Performance Tuning » Tablespace and Partition (Oracle 12C)
Tablespace and Partition [message #649196] Thu, 17 March 2016 04:22 Go to next message
deepakdot
Messages: 61
Registered: July 2015
Member
Hi

I have table with 100 Partitions. Table would have 100 Million rows.

My Question is:

should I have 1 Table space
OR
Should I have 100 Table space and each partition will have one table space each
OR
Should I have lets say 5 Table space and I allocate 20 Partitions to one table space ?

Which option would be good for the Performance? Will it be a problem if I have 1 table space and 100 partitions, so that my table space management is simple. My understanding was if I have 1 tablespace also Oracle can perform well as it knows which partition to get affected.

Please note: I don't have to take any table space backup. We are not considering the archiving process also here.

Thanks
Deepak

Report message to a moderator

Re: Tablespace and Partition [message #649197 is a reply to message #649196] Thu, 17 March 2016 04:25 Go to previous messageGo to next message
John Watson
Messages: 8454
Registered: January 2010
Location: Global Village
Senior Member
I would not expect any difference in performance between any of your suggested configurations. What you really need to consider is why you are partitioning at all, what the table partitioning strategy should be, what the index partitioning strategy should be. If you get partitioning right, it can work well; get it wrong, and the results will be disastrous. Start by defining the problem you are trying to address.

Report message to a moderator

Re: Tablespace and Partition [message #649201 is a reply to message #649197] Thu, 17 March 2016 04:56 Go to previous message
deepakdot
Messages: 61
Registered: July 2015
Member
Thanks John.

Report message to a moderator

Previous Topic: How to deal with 'Free buffer waits' event
Next Topic: Why din table fetch continued row increase after fetching every columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 17 18:57:45 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.