Re: Strategy for partitioning a huge OLTP table

Hi Kunwar,
in order to suggest a way to partition this Table I need to know how it is used. What data is stored there? What is the business meaning? What data is read? (e.g. mostly the newest rows, or random?) How is decided to delete a row? You wrote there is no date, but is there some flag? Anything else? regards
Lothar
----Ursprüngliche Nachricht----

Von : krishsingh.111_at_gmail.com
Datum : 29/09/2021 - 10:21 (MS)
An : oracle-l_at_freelists.org
Betreff : Strategy for partitioning a huge OLTP table  

  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  

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 29 2021 - 11:41:57 CEST