Re: Strategy for partitioning a huge OLTP table

Thanks a lot. I will get that information from the app tema.

On Wed, Sep 29, 2021 at 3:11 PM l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> 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_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
>
>
>

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l