Q
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 (11.1.0.6.0) 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

This was last published in October 2010

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close