Easily Tuning Oracle XE 10g in Linux? (Seems to be crashing)
725227Sep 30 2009 — edited Oct 6 2009+(This was previously posted on the General forum, but I was told that this might be a better one to post this question.)+
I teach a very basic database concepts class at a community college. Rather than using Access to teach SQL, I am trying to use Oracle XE 10g because it is much more ANSI-compliant. I have Oracle XE setup on a Linux box (CentOS 5.3), and we are logging in through the APEX Web interface.
I have a few questions:
1.) Originally, I had it setup on a box with only 256 MB of RAM. It worked, but when I had all 18 of my students working with it concurrently, it repeatedly asked them for their username and password. It would work for a while, then ask again. Is this a sign of low RAM or of something else? I have upgraded it to 1 GB now, so I will see how it goes tomorrow.
2.) Even with the 1 GB increase, I have noticed that I am down to 300 MB of free RAM when I login myself. Will 18 students really put a strain on the system? I need this to be available almost 24/7 because my students will be using it to create basic tables and creating SQL queries to act on those tables.
3.) Having said all that, is there a quick and dirty way to simply tune the database to run better? Anything I can turn off, for example, because I am using the bare basics (18 users, using the APEX interface, creating and manipulating tables with no more than 100 rows per table, running basic queries on tables, etc.)?
Thanks for any guidance.
Jason