Forms: slow login with some users
Date: 2000/07/07
Message-ID: <8k4qmf$sb6$1_at_newsgate.elender.hu>#1/1
There is a very long (more than 1 min) connect-time if I try to access an
Oracle 8.0.4 with Forms 5.0 client.
The only exception: if I login with the user who is the owner of the used
tables.
In TopSessions I can see that when I start to login, this select runs on some public synonyms:
select OBJ.OBJECT_TYPE ,OBJ.OBJECT_NAME ,OBJ.OWNER into :b0,:b1,:b2 from
ALL_SYNONYMS SYN ,ALL_OBJECTS OBJ where ((((SYN.SYNONYM_NAME=:b1 and
SYN.OWNER=:b2) and SYN.TABLE_NAME=OBJ.OBJECT_NAME) and
SYN.TABLE_OWNER=OBJ.OWNER) and OBJ.OBJECT_TYPE in
('TABLE','VIEW','SYNONYM'))
And this takes a while.....
I have about 1000 records in ALL_SYNONYMS, about 7000 records n
ALL_OBJECTS.
But how I know these object numbers not so high in an Oracle database.
Any suggestions?
Robin
robin.terek_at_buchmann.hu
Received on Fri Jul 07 2000 - 00:00:00 CEST