From: Mark.Powell@eds.com (Mark D Powell)
Newsgroups: comp.databases.oracle
Subject: Re: latches and alter table freelist
Date: 5 May 2003 06:58:25 -0700
Organization: http://groups.google.com/
Lines: 33
Message-ID: <2687bb95.0305050558.2a4c40ce@posting.google.com>
References: <2832793.1051866690@dbforums.com>
NNTP-Posting-Host: 192.85.50.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1052143106 2976 127.0.0.1 (5 May 2003 13:58:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 5 May 2003 13:58:26 GMT


willevolve <member27377@dbforums.com> wrote in message news:<2832793.1051866690@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 --