A view has been created on server A pointing to a single table on server B using dblink. In pl/sql developer, when the a select(*) from the view is run the first page is returned ok. When the icon to return all rows is clicked, the rows are returned but pl/sql developer then hangs for 10 minutes(until the process times out) SQL Plus returns the rows as expected. About 3000 rows are involved. Pl/SQL developer ver is 7.0.3.1123, Oracle 10.2.0.1.0. Thanks in advance
select from dblink
- Thread starter Jack
- Start date
To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:
"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql
Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.
"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql
Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.
Similar threads
- Discussion
