Problem pulling up Views

[rbackmann]

I use both PL/SQL 5.1... and TOAD
the only problem that I have with the functionality of this tool is when pulling views up to review the SQL that creates those views. Some return immediately some take minutes to return.

Is there a setting that I need to update or is this a problem with PL/SQL.

Oracle 9 database
Win 2K & NT operating System
Novell Network

 

[Marco Kalter]

Could it be that this view is invalid and depends on other objects that are invalid and require an implicit recompilation? This can take some time if many large objects require recompilation.

------------------
Marco Kalter
Allround Automations