Connection time from application to DB
We have a big Powerbuilder/Stored Procedures applications that connect to 8i on 2000. We just promote from 8 to 8i. Now the Users complain that initial connection from application when they login is very slow but after that everything is fast enough.
Does anything I can do in server side? I mean adjuzt any init.ora settings? UGA , Sort area ... I don't know!!
How do you track down this and what's any simiklar experience please share.
An ounce of prevention is worth a pound of cure