Re: PERFSTAT

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 07 Sep 2007 07:22:45 -0700
Message-ID: <1189174965.204811.211550@k79g2000hse.googlegroups.com>

On Sep 7, 4:56 am, vitalis..._at_gmail.com wrote:
> On Sep 7, 10:01 am, Joseph <papers...._at_gmail.com> wrote:
>
> > Hi Folks,
>
> > on my DB (ORACLE 9.2.0.8) PERFSTAT runs every 30 min.
>
> > Can i set other intervals like every 1h or 2h?
>
> You'll have to find out how the snapshots are scheduled. Could be by
> means of Oracle jobs, could be in crontab, could in a proprietary
> scheduler, etc.
>
> Then you'll find the answer to your question in the doco of the
> identified tool.
>
> Jerome

Jerome is right though I would look first at DBA_JOBS to see if the statspack.snap is being ran via an Oracle job. After all Oracle provides the spauto.sql script to set this job up so most DBA's use it.

HTH -- Mark D Powell -- Received on Fri Sep 07 2007 - 09:22:45 CDT