Master Detail problem (automatic m/d confuguartione very sloow)

[Sergio Sette]

Delphi7 (and 7.1) DOA 4 and Oracle 8.1.6.0.0 Net 8.0.6.3.4 I have 2 oracle home in this client (1 for sql net and one for net 8).

When i set the master property of a TOracleDataset then Delphi hangs. After 5 - 6 minutes (!!) then i receive the DOA dialog that informs there are not foreign keys available for an automatica M/D configuration.
Where can be the problem ? I've trieded to obtain the same metadata infos with Pl/sql developer and all works fine.

Regards

 

[Marco Kalter]

There must be something wrong with the dictionary views in this database. This should not take 5 minutes. Can you verify which query is running during these 5 minutes?

 

[Sergio Sette]

Can you verify which query is running during these 5 minutes? [/QUOTE]

How can i verify wich query is running ? Is there a way to see wich query a component executes a run-time ?
I also suspect there should be a database problem but if use pl/sql developer to see the key definitions for the same table all works very fast.

Regards

sergio sette

 

[Uli Kobsa]

I was also able to reproduce this. D7.1/DOA4/Oracle 8.1.7

Testcase for me:
- new application
- drop a session on form, set it to user 'scott'
and set connected = true
- drop two OracleDatasets:
- first: select * from dept
- second: select * from emp
- now set the master property of the emp-dataset to dept.

here it didn