Re: typical active table count

Wouldn't monitoring the number of rows in V$ACCESS be useful here?

On 6/27/2023 8:56 AM, Jeremy Schneider wrote:
> 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