Issue Opening SQL Builder - Oracle Enterprise Stage

[Bill_G]

We use SQL builder extensively in the Oracle Enterprise Stage (we use the 10g syntax), but began having issues opening SQL Builder this afternoon. Generally in jobs where a multiple join(s) exist. SQL builder will open, but may take 10-15 minutes in some cases. This has not been the case until today.

Has anyone experienced this? Any solutions?

Thanks

Bill

[Bill_G]

One other thing to note, the client machine - laptop, experiences cpu utiliztion of 100%. We have tested this on two laptops.

[lstsaur]

It sounds like that virus scan is running on your laptop. I have pretty much the same configuration as yours, but NO way to take 10-15 minutes to open up the SQL Builder.

[Bill_G]

If you use more than 2 tables or have multiple criteria in the where clause, you apparently need a client patch for sql builder to function properly.

Lookup ecase 86365 for more information.