Re: typical active table count

On 6/27/23 1:00 PM, Jonathan Lewis wrote:
> I can't come up with any meaningful value, though I'd certainly expect
> the answer to be more than "10 or so", given how many tables a little
> bit of Oracle background activity can modify and how frequently little
> background activities take place.

The original context was a conversation related to logical replication of DB changes, and that particular conversation was concerned with user tables and not system ones.

But then I got interested in the general question and topic - and system tables are a really good point which hadn't occurred to me. Thanks!

Besides partitioning, another interesting dimension of the conversation has been thinking about different categories of workloads. For example: SaaS or multitenant applications with many copies of a similar schema, and ISVs or large enterprise databases with lots of development history, and the ERPs that Clay mentioned. All of these categories can easily ramp up the counts too.

And naturally, those millions of tiny databases behind wordpress websites might easily stay under 10 tables being updated within a 10 second window of time. :)

-Jeremy

PS. I haven't been regularly reading this list and hadn't posted in awhile. What fun to see so many familiar names around here!

-- 
http://about.me/jeremy_schneider

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