Bad Performance at code search

[franzl]

Hello,

can some on give me a hint?
Full-text search will take approx. 10 - 15 Min.
I cant see anything at the DB server as reason for this, client is Idle too.

Client. WIN XP 32 bit, 3 GB RAM, 2.53 GHz Dual core
DB Server: AIX 5.3
DB: Oracle 10.2.0.4
PL/SQL Developer Version 8.0.1.1502

Regars,

FRanzl

 

[Marco Kalter]

The full text search will fetch all matching database object definitions and will do a search on the client. If this is slow, it must be caused by the database operations or by a slow network.

How many objects match the selection criteria?