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

Is it beneficial to switch from dedicated to shared mode?

We are using Oracle 9i on Windows 2000 Server with 2GB RAM. When we restart the database, it's running fine, but as soon as users connect with the database they get very slow results; some queries take an hour to get results. We are running this in dedicated mode. Is it beneficial to convert to shared server mode?

We are using Oracle 9i on Windows 2000 Server with 2GB RAM. Database size is more than 60 GB. System tablespace, temp tablespace and index tablespaces are using 99%. When we restart the database, it's running fine, but as soon as users connect with the database they get very slow results; some queries take an hour to get results. We are running this in dedicated mode. Is it beneficial to convert to shared server mode? Please suggest how to tune this database.
I doubt that moving to shared server mode would solve your problem. You should start by running Statspack and examining its report to find out where database server sessions are spending most of their time. Next, you should trace some sessions that are performing poorly, to determine what operations are consuming the most time. You'll then be in a position to decide on application changes, schema changes or server configuration changes that can improve performance.

Dig Deeper on Oracle database performance problems and tuning

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close