Performance-optimizing Oracle 10g on a server that is also a Tomcat JSP app server?
- by PKHunter
I have inherited a simple RedHat 5 - 64bit platform.
It has SCSI disks on RAID1, with 16GB of RAM. Double Core CPU.
Oracle 10g, Release 2.
This would be a decent platform for running the DB only, perhaps, but the same server in an "A-A mode" clustering (very simple) also runs Tomcat and there are several Java servlets running on this.
Sadly there is no caching platform etc. We only use an external CDN for some html caching.
I am personally more familiar with web environments on the LAMPP platform (apache, php, mysql, postgresql).
PROBLEM:
Because the server has both Tomcat JSP/Java and Oracle 10g running on the same server, with no caching, I have some issues of the server going down. Often, sadly.
QUESTION:
What are my options in terms of improving performance of all these different apps?
Connection Pooling? Example, in Postgresql world we have PgBouncer, which really helps things. Does Oracle have something similar? Or is there a famous Java-based external pooler that people use in production environments? (I'm not familiar with Java)
Any "SQL cache" as in the MySQL and Postgresql world?
Any other kind of application cache, as "APC" or "eAccelarator" in the PHP world?
The "OSCache" stuff from the Java world (JSP thingie I found on Google: http://onjava.com/pub/a/onjava/2005/01/05/jspcache.html?page=2)
...
What else?
Sorry if this is a noob question. I have googled and googled, but problem is I don't know what to google for, other than the broad general concepts above. So if not full answers, I would even appreciate basic pointers and I am happy to JFGI myself.
Thanks!