RE: Know anyone?

On version 9.2 all it takes to 'install' statspack is to run $ORACLE_HOME/rdbms/admin/spcreate from the sqlplus prompt as user SYS. If dbms_job and dbms_pool already exist on your system edit spcusr.sql and comment out the calls to them.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Magnus Andersen Sent: Friday, July 22, 2005 8:26 AM
To: 'Sudhi'; Magnus Andersen
Cc: Oracle-L (E-mail)
Subject: RE: Know anyone?

I don't have statspack installed.

-----Original Message-----
From: Sudhi [mailto:sudhi_at_yahoo-inc.com] Sent: Friday, July 22, 2005 8:26 AM
To: Magnus.Andersen_at_WalkerFirst.com
Cc: Oracle-L (E-mail)
Subject: Re: Know anyone?

How about we start off with a simple 15 min statspack interval when you see the spikes. also another sp report during the off-spike period ?

Magnus Andersen wrote:
> Hi All,
>
> I am in need of a consultant that is heavy on RedHat Linux real world
> experience for an emergency situation.
>
> Here is the situation: I have recently gone live with our production
> database on RedHat Linux 3 AS and I am having a few issues. My
> biggest problem right now is that I am seeing spikes in my load
> average, resulting in my system slowing down, throughout the day as
> soon as I have 6 - 7 or more two tier connections to the database.
>
> Hardware: HP DL 580, 4 3 GHZ CPUs with 512k L1 Cache and 4 MB L2
> Cache, HDDs is in RAID 10 config, all Ultra 320 36 GB 15000RPM.
>
> Thanks in advance,
>
> Magnus Andersen
> Systems Administrator / Oracle DBA
> Walker & Associates, Inc.
>

--
Legal Disclaimer: The statements expressed here are of my own and do not
represent those of Yahoo Inc !
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l