Strategy for partitioning a huge OLTP table

  • From: kunwar singh <krishsingh.111@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Sep 2021 13:51:54 +0530

Hi Listers,

Can you please suggest to me a reference for deciding how to partition a
online OLTP table which is 300GB currently and going to grow upto 1TB soon .

Roughly 300k deletes /hour . inserts 1M /hour. Table having 500M records so
far.
other than ease of maintenance/purge records in a better way than delete,
i dont see any other benefit of partitioning . But would like to hear your
opinion.

DB version :12.2.0.1

The table doesnt have a date column worthy of partitioning .


-- 
Cheers,
Kunwar

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2021