OOPS. v$sysstat.
"Robert Fazio" <rfazio_at_home.com.nospam> wrote in message
news:4Ok27.8190$Y6.2924226_at_news1.rdc2.pa.home.com...
> Tuning is a complicated process, but you signs are pretty convincing that
> DB_BLOCK_BUFFER needs increased.
>
> Get these parameters from v$sgastat
> select name,value from V$SGASTAT where name class =8;
>
> Find the consistent gets, db block gets and phyical reads.
> 100-100*(physical reads/(consistent gets+db block gets + physical reads))
> if less than 95% increase db_block_buffers.
>
> If less than 70% (I suspect you are below that) Double the number you
have.
> Keep increasing this number (one bouce at a time) until you are greater
than
> 95% for 1 full day.
>
> You can use utlbstat/utlestat to monitor snapshots during the day.
>
> "Solo" <bsddd_at_hotmail.com> wrote in message
> news:9hv0jh$1ade$1_at_as201.hinet.hr...
> > First let me say I am new in Oracle;
> >
> > Here is problem:
> >
> > I have a machine server :2*400MHz Intel Xeon, 640MB ,3*4GB HDD, WinNT
4.0
> > sp6, Oracle Server 7.3.4, about 100 users connecting on it....
> >
> > Recently we got incresed amount of job and data, and performance of
server
> > are significantly decresed.
> >
> > Most of the time processors are about 60-80% busy in peaks, RAM is only
> > about 35%used,
> > but hard disks are working like crazy.
> >
> > My question is:
> > What can I do to make better performance ? Should I do something to
use
> > big amount of RAM wich I have free?
> > Increase "Shared pool size" maybe? Or something else?
> >
> > I understand this is complex thing to manage, and I am sure that for any
> > opinion much more information is needed, but I kindly asking you for
some
> > tips in which directions I should search for solutions.
> >
> > Any help is highly appreciated !
> >
> > Tanks,
> > Tony
> >
> >
>
>
Received on Mon Jul 09 2001 - 11:21:04 CDT
