Re: typical active table count

I would just check the execution plans for recently executed updates/inserts/merge.

select distinct object_owner, object_name from (select sc.command_name, s.sql_id, sp.object_owner, sp.object_name

       from   v$sql s
       join   v$sql command sc
         on   s.command_type = sc.command_type
       join   v$sql_plan sp
         on   s.sql_id = sp.sql_id
        and   s.child_number = sp.child_number
        and   sp.id = 1
       where  sc.command_name in ('INSERT','UPDATE','MERGE')
       and    s.last_active_time > sysdate-interval'10'second
      )

On Tue, Jun 27, 2023 at 6:27 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 6/27/23 16:00, 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",
>
> In that case, the answer is 42.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

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