We were using Ubuntu 9.1 (Desktop) as a server with Oracle Application Express running on Oracle XE for last few months. Initially the server configuration was PIV 2.8 ghz with 1.25 gb RAM. We noticed slow response from the Database that time. Many times queries took too much time.
Then we upgraded the hardware to Xeon 3 ghz (dual processor) with 4GB RAM and reinstalled Ubuntu and Oracle. Even then we could not get the satisfactory performance.
So we removed Ubuntu and installed Fedora 12 with Oracle XE on the same hardware and now getting better results.
We were using Ubuntu Desktop since the server does not provide GUI by default and installing it becomes an additional and time consuming step with slower internet connection.
I want Opinions of experts that is slow database performance really an issue due to Ubuntu or there was something else doing so? Which one is better for Oracle, Ubuntu or Fedora?
I don't think the difference come from the different linux distribution.
But you may have different kernel parameters. Maybe async i/o was set on one system and not the other.
If you need to understand
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
As many people are interested in Linux but not as many are interested or knowledgeable (enough) to install Linux on their system, here is a safe way to try out Linux on your existing (Windows) system.
The idea is that you insta…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…