Dennis...
not enough from (for) the Oracle
and too much (used) from the OS perspective.
That's why you can get swapped data to disk!
JL
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Jose - Not enough allocated or too much allocated
> (from the Oracle
> perspective)?
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Monday, March 31, 2003 10:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> You didn't send your SHARED_POOL_SIZE parameter
> value...
> but...
>
> usually, when the machine swaps is due to not enough
> memory allocated!
>
> I would check your shared_pool_size, sort_area_size,
> and db_block_buffer for verifying that there's
> enough
> memory asigned.
>
> Of course, you should diagnose memory problems on
> your
> OS and Oracle.
>
> HTH
> JL
>
> --- Arvind Kumar <arvindk_at_sqlstarintl.com> wrote:
> >
> > Hello all,
> >
> > i am facing swapping problem ..below is the
> > details
> >
> >
> > System - IBM RS 6000, two CPU,2GB RAM,AIX
> 4.3,4GB
> > SWAP SPACE
> >
> > DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER
> > CACHE HIT RATIO IS ABOVE
> > 93%
> >
> > Now the problem is of swapping there are about
> 70
> > oracle users using this
> > database ,swap utilization is always above 1.5gb.
> >
> > what could be the problem...
> >
> >
> > Thanks
> > Arvind Kumar
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Arvind Kumar
> > INET: arvindk_at_sqlstarintl.com> (by way of Jared
> > Still <jkstill_at_cybcon.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web
> > hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jose Luis Delgado
> INET: joseluis_delgado_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
INET: joseluis_delgado_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Mar 31 2003 - 12:53:40 CST