Re: Session priorities

From: Ron Boggs <rboggs_at_endian-networks.com>
Date: 25 Feb 2003 06:40:06 -0800
Message-ID: <e53f59be.0302250640.46eb82ba@posting.google.com>

> You are not giving us much to go on here. What version/release of
> Oracle.

Oracle 9.2.0.2; Solaris 8

> If you are not using 100% CPU what is your problem?

When combined, the two databases are expected to have peaks in the 100-150% range. During the peaks, it would be unacceptable for the switch to wait on reporting.

> Are you
> talking about two SIDs reporting and switch, or are they two
> applications accessing the same db, or are they seperate scheams?

1 switch, 1 reporting. Currently, they are on separate SID's on 2 boxes. Preference would be to keep 2 SID's for tuning purposes, but if there is a 'good' solution which requires them to be on 1 SID/2 schemas, that could be an option. Received on Tue Feb 25 2003 - 08:40:06 CST