long response time - how to track?
631937Apr 16 2008 — edited Apr 18 2008Hi!
Application, that was using oracle got much slower after I reinstalled Oracle. It was reinstalled on the same hardware, OS was not changed Oracle version did not change. I just reinstalled oracle software to new location without creating database. Later I created general purpose database, with oracle controlled files and same character set as before. Than I imported application data. And from then on I struggle to find out why is it so slow.
When you type more letters in application window they appear with 3-4 seconds delay. With TCPDUMP I find out that application is communicating with database after each taped letter (quite stupid).
I moved database to backup server, there the application is running normally with the same database configuration without this problem. But this database was created few month ago. When I created the new one on the backup server I experienced the same problem. I have now idea what did I do differently now.
I really do not see any important difference between this two databases, yet there is some.
Can somebody advise me how to track the problem? For example to measure response time with sqlplus command and see where the problem is? I have already spent a lot of time comparing this two databases without result. So I do not file like comparing any more.
Thanks.
Viliam