Partitioning [message #676046] |
Wed, 08 May 2019 07:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c8072d8add266af9ff68a64d89590a4f?s=64&d=mm&r=g) |
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 #676064 is a reply to message #676046] |
Wed, 08 May 2019 12:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8938 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13925 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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 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".
|
|
|