Problem solve Get help with specific problems with your technologies, process and projects.

Server load problems after moving from Oracle 10g XE to 11g SE One

Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland.

I am working in a software firm as the Oracle DBA. I need some assistance regarding my Oracle 11g Database.

We used to run Oracle 10g XE on an Ubuntu machine and it used to run without giving any load issues on the server. Later on we installed a fresh copy of Oracle 11g Standard Edition One ( and from then onwards are experiencing server load issues on the Ubuntu machine.

Please provide me with the steps to resolve this issue.

If your database and your application usage have not changed, then going from XE to SE should not put a bigger load on your server. If I were experiencing this problem, I would rerun the $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/rdbms/admin/catproc.sql scripts as SYS on my database. If that does not resolve the issue, then I would try to pinpoint the thing that is putting extra load on the server. Is it one specific process consuming large amounts of CPU?

Have a question for Brian Peasland? Send an e-mail to editor@searchoracle.com

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.