Home -> Usenet -> comp.databases.oracle -> latches and alter table freelist

latches and alter table freelist

From: willevolve <member27377_at_dbforums.com>
Date: Fri, 02 May 2003 09:11:30 +0000
Message-ID: <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


--
Posted via http://dbforums.com


Received on Fri May 02 2003 - 11:11:30 CEST












Original text of this message