From: "Terék Robin" <robin.terek@buchmann.hu>
Subject: Forms: slow login with some users
Date: 2000/07/07
Message-ID: <8k4qmf$sb6$1@newsgate.elender.hu>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: usenet@newsgate.elender.hu
X-Trace: newsgate.elender.hu 962981391 29030 212.108.198.34 (7 Jul 2000 14:49:51 GMT)
Organization: Elender Rt.
X-MSMail-Priority: Normal
NNTP-Posting-Date: 7 Jul 2000 14:49:51 GMT
Newsgroups: comp.databases.oracle.tools


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@buchmann.hu