Oracle table(range) partition with sub-partition strategy ..

===> Should have expert knowledge in Oracle table partitioning and performance tuning

NOTE: Confidential


For purging sub-partitions, we shall have purge profiles.

We have around 2000 bank's... should be distributed among the purge profiles...

purge profile

30 days...

60 days...

90 days...

we shall have column retprofile as sub-partition & continue with partition key as "createdate".

We need to evaluate the queries response time and query execution plan for the new table

The query which includes only the partition key

Query with partition + sub-partition key

Query without partition + sub-partition key

Query with joining other tables. ( application queries)

Decide on partition strategy based on the query performance stats

a. Non-partition table

b. Partition table

c. Partition & sub-partition

&&&&&& AND ...

Should have expert practical knowledge Oracle performance tuning ( AWR, ADDM, ASH reports), long-running query tuning

NOTE: Good to have knowledge in - ant builds , WBI , Jetty , WAS.

Keahlian: Administrasi Basis Data, Pengembangan Database, Java, Oracle, SQL

Lihat lebih lanjut: table partitioning in oracle 11g, range partition in oracle, list partition in oracle, advantages and disadvantages of table partitioning in oracle, how to query partition table in oracle, oracle partitioning license, oracle table partitioning best practices, oracle partitioning 12c

ID Proyek: #17829783