up vote 1 down vote favorite
1
share [g+] share [fb]

I want to preface this with the fact that I am a developer and I am not even close to a DBA, plus I am new to Oracle. OK, here it goes:

I have a Java application which uses spring and hibernate. Its a simple CRUD app and I will leave the details out as I don't think they are the issue. I have noticed that my app runs fine when I use MySql, but when I use an Oracle 10.2 server every 7th-10th hangs for 5-10 seconds.

My Oracle installation was done by me using all defaults, same as the mysql install. I don't even know where to start looking. Any ideas?

Thanks in advance and sorry that I lack the details that are most likely required for help.

link|improve this question
feedback

2 Answers

up vote 0 down vote

Oracle 10G comes with a web interface called Enterprise Manager. It is very helpfull for beginners.

The URL depend of the version you use and the number of database you have on the server. Try http://servername%3A1158/em if you have an enterprise/standart edition (use https if you have 10.2.0.4) or http://servername%3A8080/apex if you have the XE edition.

link|improve this answer
1  
You can find out exactly what URL to access the DBConsole on with the following 2 shell commands: SET ORACLE_SID=YOURSID then EMCTL STATUS DBCONSOLE – Cephas Sep 15 '09 at 4:33
feedback
up vote 0 down vote

You are right, without specifics any answer will have to be fairly general. You could use Enterprise Manager or DBControl to see the statements being run as Benoit and Cephas suggest. Perhaps one of them is slow. Those tools would also allow you to see other activity on the system that may be slowing things down.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.