Single Instance 4 Database - System is Slow?

From: <captain_2010_at_yahoo.com>
Date: 13 Jul 2005 08:53:41 -0700
Message-ID: <1121270021.948527.222440@g43g2000cwa.googlegroups.com>

HI,

I have oracle 8i installed on WindowsXp and running one instance with 4 Oracle Database.

Problem

---

The system is running slow and I do not understand why it is slow ? Have tuned all parameters in init.ora have even increase blocked size still no improvement.

Planning for below action

---

Now planning to change mode from dedicated to share mode. Before changing to share mode wanted to know the effects of changing it.

Information gathered on dedicated and share mode

---

Though below are the few points that have been gathered 1) A dedicated server only serves one session. A shared server can serve many sessions. If there are going to be a large number of concurrent sessions, use shared server.

2) Shared Server does two things:
1. It allows you to use some functionality that would not otherwise be available (like Connection Manager and connection pooling) 2. It gets around resource shortfalls by having fewer processes at the back end.

3) For long queries and transactions, dedicated servers will be more appropriate.

Captain Received on Wed Jul 13 2005 - 10:53:41 CDT