Page 1 of 1
Issue Opening SQL Builder - Oracle Enterprise Stage
Posted: Mon Feb 26, 2007 4:56 pm
by 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
Posted: Mon Feb 26, 2007 5:04 pm
by Bill_G
One other thing to note, the client machine - laptop, experiences cpu utiliztion of 100%. We have tested this on two laptops.
Posted: Mon Feb 26, 2007 6:28 pm
by 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.
Issue resolved by using ecase 86365 - patch
Posted: Tue Feb 27, 2007 10:31 am
by 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.