| Partitioning [message #676046] |
Wed, 08 May 2019 07:49  |
 |
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  |
John Watson
Messages: 8960
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 |
cookiemonster
Messages: 13959
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 |
 |
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".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
