Print Thread
References very slow in 10.2
#21858 03/02/06 06:41 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Access to references
a) Table Editor -> Keys -> Referencing Table
b) Synonym -> References
are very slow when using an Oracle 10.2 database in opposite to a 10.1 database.

Re: References very slow in 10.2
#21859 03/02/06 07:57 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Seems like a database tuning issue. Perhaps your DBA can find out why the query that is executed during this delay is so slow?


Marco Kalter
Allround Automations
Re: References very slow in 10.2
#21860 03/02/06 08:39 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Both databases are starter databases (option "Multi purpose") created with Oracle Database Configuration Assistant.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.081s Queries: 13 (0.046s) Memory: 2.5028 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-18 04:33:12 UTC
Valid HTML 5 and Valid CSS