Strategy for partitioning a huge OLTP table

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Wed, 29 Sep 2021 13:51:54 +0530
Message-ID: <CAJSrDUpJiyChBCk5GVCUHTU9Ucn6GUxhEnAp2vgyOauVJ2VAEg_at_mail.gmail.com>

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 - 10:21:54 CEST

This message: [ Message body ]
Next message: Mohamed Houri: "Re: High usage of temp tablespace by TEMP TEMPORARY LOB_DATA through JDBC connections"
Previous message: Jacek Gębal: "Re: High usage of temp tablespace by TEMP TEMPORARY LOB_DATA through JDBC connections"
Next in thread: l.flatz_at_bluewin.ch: "Re: Strategy for partitioning a huge OLTP table"
Reply: l.flatz_at_bluewin.ch: "Re: Strategy for partitioning a huge OLTP table"
Reply: Mark W. Farnham: "RE: Strategy for partitioning a huge OLTP table"
Reply: Mladen Gogala: "Re: Strategy for partitioning a huge OLTP table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message