Home » RDBMS Server » Server Administration » Table Partitioning (oracle 12c Windows 2012)
Table Partitioning [message #673731] Thu, 06 December 2018 22:40 Go to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi All,

We have a table with a size of 85GB, now we want to make a partition on it.

From where to start, what are the things to be considered.

Kindly guide me.

Regards
krish
Re: Table Partitioning [message #673732 is a reply to message #673731] Thu, 06 December 2018 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
muthukrish104 wrote on Thu, 06 December 2018 20:40
Hi All,

We have a table with a size of 85GB, now we want to make a partition on it.

From where to start, what are the things to be considered.

Kindly guide me.

Regards
krish
What problem does partition solve?
Post SQL & results that quantifies the benefit of partition.
Re: Table Partitioning [message #673734 is a reply to message #673732] Fri, 07 December 2018 00:55 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Blackswan,

Thats what I want.

We have many bigger tables.

How to consider them to implement partition or not.

Thanks and Regards
Krish
Re: Table Partitioning [message #673735 is a reply to message #673734] Fri, 07 December 2018 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database VLDB and Partitioning Guide

And generally speaking:
Database Development Guide, Chapter 1, Design Basics

Re: Table Partitioning [message #673736 is a reply to message #673735] Fri, 07 December 2018 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also I never received a feedback from you in your topic http://www.orafaq.com/forum/m/673085/#msg_673085
I hope I will here.

Re: Table Partitioning [message #673737 is a reply to message #673731] Fri, 07 December 2018 01:41 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
muthukrish104 wrote on Fri, 07 December 2018 04:40
Hi All,

We have a table with a size of 85GB, now we want to make a partition on it.

From where to start, what are the things to be considered.

Kindly guide me.

Regards
krish
What you need to consider is the potential for disaster. If you get partitioning right, there may be benefits; get it wrong, and there will be problems. Do not use partitioning because you can - use it to address a defined problem.

And do not say "the problem is that the table is big". In this case, size doesn't matter. It is your SQLs and business processes that you need to look a.
Re: Table Partitioning [message #673765 is a reply to message #673737] Sun, 09 December 2018 22:23 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi All,

Thanks



Hi John,

Yes I agreed,

But I wanted to know, why and when to use partitioning tech.

Hope the above mentioned docs are having it.

Regards
Krish
Re: Table Partitioning [message #673770 is a reply to message #673765] Mon, 10 December 2018 01:02 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
As I said, you are approaching this from the wrong direction. You first need to identify a problem. Examples:

A screen refresh is too slow.
A overnight batch job doesn't finish until lunchtime.
A report takes ten minutes, you need it in one.

Then you can consider if (and it is only "if") some partitioning strategy would help.
Previous Topic: Finding Skip Scan
Next Topic: nls_numeric_characters doesn't change after reboot
Goto Forum:
  


Current Time: Thu Mar 28 07:56:32 CDT 2024