Marcos Andres Vera Yañez wrote:
>
> Hi
> About your question in Oracle Group :
> Look, almost 50% of the cpu's work time is related with disk i/o, so you
> must to check
> how much disk activity are there in your plattform. If you find a high
> level disk activity maybe your Oracle SGA is a little small, in this
> case you must to increase the parameter shared_pool_size about 20 or 30%
> and try a again.
> Hope this help you
>
> Michael Rothwell wrote:
>
> > I have an old system running Oracle 7.2.2 and HPUX 9.4. The
> > hardware is old and slow, but lately seems even slower.
> > Even when I run a query against the data dictionary to view
> > a list of indexes, it takes 25 to 30 seconds to return a
> > list of 81 indexes. Whenever a query is run, the CPU pegs
> > it'self to 100% and stays there for much too long for the
> > type of query being run.
> >
> > Does anyone know what I should be looking for?
> >
> > Michael.
> >
>
> --
> *********************************************************************
> Marcos Vera Yanez
> Oracle Database Adminstrator
> Email : mvera_at_rdc.cl, Phone : 56-2-4406953
>
> "Smell the Flower While you can"
>
> *********************************************************************
You might want to look at the infamous Oracle otrace, installed
automatically with Oracle 7.2.2.
Good Luck!
Joel Baumer
Oracle/PeopleSoft DBA
Received on Tue Sep 22 1998 - 21:39:15 CDT
