Thanks a lot. I will get that information from the app tema.
On Wed, Sep 29, 2021 at 3:11 PM l.flatz@xxxxxxxxxx <l.flatz@xxxxxxxxxx>
wrote:
Hi Kunwar,
in order to suggest a way to partition this Table I need to know how it is
used.
1. What data is stored there? What is the business meaning?
2. What data is read? (e.g. mostly the newest rows, or random?)
3. 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@xxxxxxxxx
Datum : 29/09/2021 - 10:21 (MS)
An : oracle-l@xxxxxxxxxxxxx
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
