typical active table count
From: Jeremy Schneider <schneider_at_ardentperf.com>
Date: Tue, 27 Jun 2023 08:56:27 -0700
Message-ID: <CA+fnDAaiy7y2eg3+f78Ln+AD2nx2q9v-UbEnLuOHOMoTN_X54w_at_mail.gmail.com>
Question for other Oracle users
http://about.me/jeremy_schneider
Date: Tue, 27 Jun 2023 08:56:27 -0700
Message-ID: <CA+fnDAaiy7y2eg3+f78Ln+AD2nx2q9v-UbEnLuOHOMoTN_X54w_at_mail.gmail.com>
Question for other Oracle users
On your moderately busy DB, how many different tables might receive at least one change/DML during a 10 second window?
10? 50? 100? More? Ballpark guess off the top of your head.
I'm in a discussion & there's questions about whether it's unusual to have more than 10 or so. The answer isn't clear to me.
Probably worthwhile to call out partitioning explicitly (ie. if this factors into an answer then mention that fact)
-Jeremy
--
http://about.me/jeremy_schneider
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 27 2023 - 17:56:27 CEST