Re: latches and alter table freelist

willevolve <member27377_at_dbforums.com> wrote in message news:<2832793.1051866690_at_dbforums.com>...
> Hello,
>
> For requiring purposes I have table: FINDER with PK of individual PK's
> of other tables in database.(and additional officer PK in front of them)
> OfficerID number(6), TableTypeID number(4), TableID number(9)...
>
> If user is stupid and use query with low condition- lot of PK's will be
> inserted into FINDER table (I have almost 40 users).
> In some cases in operative sense I have few hundred to 400 thousand and
> more rows in FINDER.
>
> During this requiring from users, I have problem with bad parameters
> from Table (freelist) and latches in my ORACLE instance.
>
> Any suggestions?
>
> Thanks in advance
>
> MB

MB, do you mean "reporting" instead of requiring?

How do queries by users cause rows to appear in the FINDER table?

What are you looking at that makes you think you have a latching problem?

I think that in order to get good advice you need to expain the processing involved, at least at a high level, and possibly post some query results related to the problem statistics.

IMHO -- Mark D Powell -- Received on Mon May 05 2003 - 15:58:25 CEST