Home » RDBMS Server » Server Administration » Partitioning (Oracle database 12.2 on Oracle Linux 7)
Partitioning [message #676046] Wed, 08 May 2019 07:49 Go to next message
armait
Messages: 14
Registered: April 2019
Junior Member
Hello, I got task about partitioning.I never did partitioning and this is new for me.I have a table size 1GB.The things which I need to do are the following:

1.reduce SGA memory on 300 MB
2.do select on table and calculate costs in explain plan
3.do partitioning as the following:
a)interval partitioning on column CREATED , and test partition pruining
b)composite partitioning to combine the interval of partitioning by column created + the subset of the column group code list, and test partition pruining
c)composite partitioning in which to compile the interval partitionin per column created + hash supartition per column ID

Please teach me how can I do this.
Re: Partitioning [message #676048 is a reply to message #676046] Wed, 08 May 2019 08:04 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
Consider to start to learn by Reading The Fine Manuals below

https://docs.oracle.com/database/121/nav/portal_booklist.htm

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Re: Partitioning [message #676061 is a reply to message #676046] Wed, 08 May 2019 09:41 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Note that 1GB is not so big.

Database Data Warehousing Guide
Chapter 3 Data Warehousing Physical Design
Section 3.2.1.2 About Partitioning in Data Warehouses

[Updated on: Wed, 08 May 2019 09:42]

Report message to a moderator

Re: Partitioning [message #676064 is a reply to message #676046] Wed, 08 May 2019 12:26 Go to previous messageGo to next message
John Watson
Messages: 8084
Registered: January 2010
Location: Global Village
Senior Member
This questionQuote:
1.reduce SGA memory on 300 MB
does not appear to be related to the others. Nor, I would say, is it possible. Perhaps I am misunderstanding - can you explain the need in greater detail?
Re: Partitioning [message #676065 is a reply to message #676064] Thu, 09 May 2019 03:55 Go to previous messageGo to next message
cookiemonster
Messages: 13759
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd say that question is syntactically meaningless.
It should either be
reduce SGA memory by 300MB
reduce SGA memory to 300MB

An SGA of 300MB is tiny, especially on a system large enough to require partitioning.
Re: Partitioning [message #676068 is a reply to message #676065] Thu, 09 May 2019 07:11 Go to previous message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
Sounds like a homework assignment. A 1gb table is pretty small and usually doesn't show any practical gains from partitioning. Your SGA "requirement" has nothing to do with partitioning, and I doubt that a db would even operate with a 300mb SGA.

If this is not a homework/learning exercise, I'd very seriously question the the entire premise of the "requirement".
Previous Topic: Split partition notes
Next Topic: FRA & DIAG (CM merged 2)
Goto Forum:
  


Current Time: Fri Dec 13 07:56:28 CST 2019