Re: recommendation

Jeff Kish wrote:

> Hi.
> I am running XP Pro.
> I have Oracle 10.1.0.2.0 installed.
>
> I had installed a new database (sid?) recently about a gig in table
> space size.
>
> I noticed that now my machine just 'cranks' the disk drive for about
> 15 minutes and it is so relentless that my pc is pretty unusable for
> that initial startup period of time.
>
> I did a ctrl-alt-delete to look at task manager and saw that oracle
> and java seem to be near or at the very top of the cpu consumption,
> though I realize that is not necessarily indicative of what is
> chewing up the disk accesses.
>
> My suspicion is that it is related to the Oracle installation.
>
> - can someone suggest what to do to figure out the cause of the
> problem and a possible solution?

> OracleServicefirst Started Automatic
> OracleServicesecond Started Automatic
> OracleServicethird Started Automatic

My guess is it's disk-swapping like crazy trying to free up enough memory, unless you've got a huge amount of RAM & small SGAs. Can't you just use one instance with three schemas instead? Three instances means three SGAs - add on three lots of DBConsole & you're asking for trouble.

-- 
Preston.