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.
|
|
|