Database optimization

avatar

Hello,
We are using RDMS 11.1.0.0 and I access it over a VPN. Offline mode works with cached but when we go online we have a significant delays for any changes and searches, 45-60 seconds.
There are a lot of session we have created.
Is there some kind of DB optimization that we should be using or is that the typical delay?

All Comments (1)

avatar

Hi,
Could you try to open the Profiler in Help->Profiler

Just clear the profiler content before going online and post the result. We will be able to see what takes a long time.

David Hervieux