Grokbase › Groups › Oracle › oracle-l › August 2001
FAQ
We are having a problem with our database - it is using 100% of the CPU.
This has only started happening recently, and restarting the database
temporarily
stops it happening - it usually recurrs a few hours later.
There are no jobs running, and at the moment there are no active
connections.
Obviously something has kicked this off, can anyone shed any light on this
or
suggest how to find out what is running on the db?

Thanks in advance,

Steven H.

(Oracle 8.1.6.0.0 EE on NT 4 SP5)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Hovington
INET: steven.hovington_at_procession.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Search Discussions

  • Vergara, Michael (TEM) at Aug 17, 2001 at 4:31 pm ⇧
    Steven:

    I also have this happen on one of our smaller DBs running NT. I haven't
    found a cause yet either. Rebooting seems (so far) to be the only cure.
    If you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Christopher Spence at Aug 17, 2001 at 4:31 pm ⇧
    Have you looked at the event tables?

    Perhaps running a statspack report from now to the next 10 minutes and look
    at the biggest waiters.

    If it is unix, look for the process which is eating up the resources, query
    v$process to get the process address, then use that to get the session, then
    use the sql address to find the sql.\

    Also query v$session for active sessions which are active for a long time.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 12:41 PM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Boivin, Patrice J at Aug 17, 2001 at 4:47 pm ⇧
    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be the only
    cure.
    If you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Christopher Spence at Aug 17, 2001 at 5:03 pm ⇧
    It is nt, it is because it is unstable and crashes every 1 second, you just
    haven't noticed it.

    Seriously though, first verify the processes are oracle and not something
    else using task manager.

    Then if they are oracle. Look into v$session and find active sessions.
    Trace them back with their sql addresses.

    Also look into dba_jobs_running for any running jobs.

    I have seen similar problems where a job was scheduled as interval 'sysdate'
    which has it run continously right after another, a few of these will do
    such a thing.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 1:41 PM
    To: Multiple recipients of list ORACLE-L

    Steven:

    I also have this happen on one of our smaller DBs running NT. I haven't
    found a cause yet either. Rebooting seems (so far) to be the only cure. If
    you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Steven Hovington at Aug 17, 2001 at 5:58 pm ⇧
    Which are the event tables, and how do I run the statspack report?
    There are no jobs and no active sessions (except mine, and its not me...).

    Thanks,

    Steven H.

    -----Original Message-----
    Spence
    Sent: 17 August 2001 18:35
    To: Multiple recipients of list ORACLE-L

    Have you looked at the event tables?

    Perhaps running a statspack report from now to the next 10 minutes and look
    at the biggest waiters.

    If it is unix, look for the process which is eating up the resources, query
    v$process to get the process address, then use that to get the session, then
    use the sql address to find the sql.\

    Also query v$session for active sessions which are active for a long time.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863

    -----Original Message-----
    Sent: Friday, August 17, 2001 12:41 PM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Vergara, Michael (TEM) at Aug 17, 2001 at 6:04 pm ⇧
    In my case, I have a Preproduction environment that is an almost-exact
    copy of production. The Production server executes this query in about 20
    seconds. The PREproduction machine takes 5-6 minutes. I have watched the
    WinNT 'Perfmon' tool monitor the system.

    The query is a full table scan of a view which returns 49245 rows. Not
    very many. I have exampled the execution plans from Prod and PREprod -
    they're the same. The tables have all be analyzed recently, and growth
    is minimal.

    When the query is executed, CPU goes to 100% and stays there. The Oracle
    process (ORACLE.EXE) goes to 100% and stays there. There's a
    short-duration spike in the disk, and then it settles back down to a
    negligible state.

    There are no jobs running in DBA_JOBS. Matter of fact the job queue is
    disabled on this server. I 'think' physical memory is OK on this machine;
    I don't remember at this moment. I don't have any of those cool GIU tools
    to monitor the database - I'm using SQL and my (often-dim) wits.

    I have not looked at the event views yet. Thanks for y'all's help!

    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:18 AM
    To: Multiple recipients of list ORACLE-L

    It is nt, it is because it is unstable and crashes every 1 second, you just
    haven't noticed it.

    Seriously though, first verify the processes are oracle and not something
    else using task manager.

    Then if they are oracle. Look into v$session and find active sessions.
    Trace them back with their sql addresses.

    Also look into dba_jobs_running for any running jobs.

    I have seen similar problems where a job was scheduled as interval 'sysdate'
    which has it run continously right after another, a few of these will do
    such a thing.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863

    -----Original Message-----
    Sent: Friday, August 17, 2001 1:41 PM
    To: Multiple recipients of list ORACLE-L

    Steven:

    I also have this happen on one of our smaller DBs running NT. I haven't
    found a cause yet either. Rebooting seems (so far) to be the only cure. If
    you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Vergara, Michael (TEM) at Aug 17, 2001 at 6:06 pm ⇧
    I've looked at the server. Total Commit Charge is 574968. Total
    Physical Memory is 523680. I can see that it's over, but what am I looking
    at? I understand physical memory, but the help on 'Commit Memory' in
    windows is less than helpful.

    Do I need to reboot the box?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:08 AM
    To: Multiple recipients of list ORACLE-L

    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be the only
    cure.
    If you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Christopher Spence at Aug 17, 2001 at 6:27 pm ⇧
    System_event.

    Check out www.vampired.net you will find some articles on statspacks, about
    three.
    They should give you a very good understanding of statspack.

    Highly recommend you becoming familiar with it, it is a very good tool.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 2:56 PM
    To: Multiple recipients of list ORACLE-L

    Which are the event tables, and how do I run the statspack report? There are
    no jobs and no active sessions (except mine, and its not me...).

    Thanks,

    Steven H.

    -----Original Message-----
    Spence
    Sent: 17 August 2001 18:35
    To: Multiple recipients of list ORACLE-L

    Have you looked at the event tables?

    Perhaps running a statspack report from now to the next 10 minutes and look
    at the biggest waiters.

    If it is unix, look for the process which is eating up the resources, query
    v$process to get the process address, then use that to get the session, then
    use the sql address to find the sql.\

    Also query v$session for active sessions which are active for a long time.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863

    -----Original Message-----
    Sent: Friday, August 17, 2001 12:41 PM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Kathy Duret at Aug 17, 2001 at 6:27 pm ⇧
    Check to see if there are any DBMS_JOBS running.

    At one place I worked, someone installed some sort of Java monitoring tool on the
    database and that pegged the CPU.

    In your rdbms/admin directory you need to read the statspack.doc which will tell you
    everything you need to do. Very simple.

    Then

    execute statspack.snap - executes a snap or picture of your database, you need two
    snaps before you run a report. For me each snap is about 1/2 hour apart but it depends
    on the size/activity of your database.

    sqlplus perfstat/perfstat_at_yoursidhere @statsrep - to run a report, asked for ids of
    snaps you want to compare, then gives you a report. www.permon.com is good to help
    analyze the report but it is under construction right now.

    kathy

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:56 AM
    To: Multiple recipients of list ORACLE-L

    Which are the event tables, and how do I run the statspack report?
    There are no jobs and no active sessions (except mine, and its not me...).

    Thanks,

    Steven H.

    -----Original Message-----
    Spence
    Sent: 17 August 2001 18:35
    To: Multiple recipients of list ORACLE-L

    Have you looked at the event tables?

    Perhaps running a statspack report from now to the next 10 minutes and look
    at the biggest waiters.

    If it is unix, look for the process which is eating up the resources, query
    v$process to get the process address, then use that to get the session, then
    use the sql address to find the sql.\

    Also query v$session for active sessions which are active for a long time.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863

    -----Original Message-----
    Sent: Friday, August 17, 2001 12:41 PM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily stops it happening - it usually recurrs a few hours later. There
    are no jobs running, and at the moment there are no active connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).

    Confidential
    This e-mail and any files transmitted with it are the property
    of Belkin Components and/or its affiliates, are confidential,
    and are intended solely for the use of the individual or
    entity to whom this e-mail is addressed. If you are not one
    of the named recipients or otherwise have reason to believe
    that you have received this e-mail in error, please notify the
    sender and delete this message immediately from your computer.
    Any other use, retention, dissemination, forwarding, printing
    or copying of this e-mail is strictly prohibited.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kathy Duret
    INET: KathyD_at_belkin.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Boivin, Patrice J at Aug 17, 2001 at 6:50 pm ⇧
    You mentioned that rebooting the machine helps a bit, but then you are back
    to poor performance eventually.

    That is because NT allocates memory gradually, as needed.

    The only way I can see (without adding memory) of fixing this problem is to
    reduce the size of your SGA, to allocate less memory for the oracle.exe
    process(es). Remember that when users will log on, that will consume more
    memory...

    In 8i though you can't shrink the SGA down without allocating reasonable
    amounts for the various pools, including the Java pool.

    Java_pool_size (20M minimum, I would set it to 30M if you can)
    Db_block_buffers the smaller it is, the more likely your data blocks will
    get flushed to disk
    Log_buffer the smaller it is, the more you may see redo log waits.
    Large_pool_size
    Shared_pool_size

    Sort_area_size
    Sort_area_retained_size
    Hash_area_size

    On and on it goes.

    : )

    Shut down any NT services you don't think you need, change their startup
    setting to Manual in the Control Panel Services applet.

    If your server needs registered RAM that will cost you, but if you are on a
    PC you can buy 512M RAM DIMMs for almost US$50 now.

    Regards,
    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    Systems Admin & Operations | Admin. et Exploit. des systèmes
    Technology Services | Services technologiques
    Informatics Branch | Direction de l'informatique
    Maritimes Region, DFO | Région des Maritimes, MPO

    E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 4:22 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    I've looked at the server. Total Commit Charge is 574968. Total
    Physical Memory is 523680. I can see that it's over, but what am I
    looking
    at? I understand physical memory, but the help on 'Commit Memory'
    in
    windows is less than helpful.

    Do I need to reboot the box?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:08 AM
    To: Multiple recipients of list ORACLE-L

    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total
    (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because
    Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running
    NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be
    the only
    cure.
    If you get any replies would you please summarize to the

    list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100%
    of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no
    active
    connections.
    Obviously something has kicked this off, can anyone shed any
    light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858)
    538-5051
    San Diego, California -- Public Internet access /
    Mailing
    Lists

    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858)
    538-5051
    San Diego, California -- Public Internet access /
    Mailing
    Lists

    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Vergara, Michael (TEM) at Aug 17, 2001 at 6:56 pm ⇧
    But it only works at 8.1.6 and above, right? That's what it says on the
    doco, and I've been too chicken to try it elsewhere. The database I'm
    having issues with is at 8.0.5.

    Thanx,
    Mike
    ---

    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 12:38 PM
    To: Multiple recipients of list ORACLE-L

    System_event.

    Check out www.vampired.net you will find some articles on statspacks, about
    three.
    They should give you a very good understanding of statspack.

    Highly recommend you becoming familiar with it, it is a very good tool.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 2:56 PM
    To: Multiple recipients of list ORACLE-L

    Which are the event tables, and how do I run the statspack report? There are
    no jobs and no active sessions (except mine, and its not me...).

    Thanks,

    Steven H.

    -----Original Message-----
    Spence
    Sent: 17 August 2001 18:35
    To: Multiple recipients of list ORACLE-L

    Have you looked at the event tables?

    Perhaps running a statspack report from now to the next 10 minutes and look
    at the biggest waiters.

    If it is unix, look for the process which is eating up the resources, query
    v$process to get the process address, then use that to get the session, then
    use the sql address to find the sql.\

    Also query v$session for active sessions which are active for a long time.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Christopher Spence at Aug 17, 2001 at 7:22 pm ⇧
    You can set the java pool size as low as say 1mb, I have done this in the
    past when a database has only one or two functions.
    It runs fine as such.

    Although, if the database is using more than 1 or 2 small procedures, I
    agree to use 20m minimum for the java pool.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 4:00 PM
    To: Multiple recipients of list ORACLE-L

    You mentioned that rebooting the machine helps a bit, but then you are back
    to poor performance eventually.

    That is because NT allocates memory gradually, as needed.

    The only way I can see (without adding memory) of fixing this problem is to
    reduce the size of your SGA, to allocate less memory for the oracle.exe
    process(es). Remember that when users will log on, that will consume more
    memory...

    In 8i though you can't shrink the SGA down without allocating reasonable
    amounts for the various pools, including the Java pool.

    Java_pool_size (20M minimum, I would set it to 30M if you can)
    Db_block_buffers the smaller it is, the more likely your data blocks will
    get flushed to disk Log_buffer the smaller it is, the more you may see redo
    log waits. Large_pool_size
    Shared_pool_size

    Sort_area_size
    Sort_area_retained_size
    Hash_area_size

    On and on it goes.

    : )

    Shut down any NT services you don't think you need, change their startup
    setting to Manual in the Control Panel Services applet.

    If your server needs registered RAM that will cost you, but if you are on a
    PC you can buy 512M RAM DIMMs for almost US$50 now.

    Regards,
    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    Systems Admin & Operations | Admin. et Exploit. des systèmes
    Technology Services | Services technologiques
    Informatics Branch | Direction de l'informatique
    Maritimes Region, DFO | Région des Maritimes, MPO

    E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 4:22 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    I've looked at the server. Total Commit Charge is 574968. Total
    Physical Memory is 523680. I can see that it's over, but what am I
    looking
    at? I understand physical memory, but the help on 'Commit Memory'
    in
    windows is less than helpful.

    Do I need to reboot the box?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:08 AM
    To: Multiple recipients of list ORACLE-L

    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total
    (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because
    Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running
    NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be
    the only
    cure.
    If you get any replies would you please summarize to the

    list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100%
    of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no
    active
    connections.
    Obviously something has kicked this off, can anyone shed any
    light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858)
    538-5051
    San Diego, California -- Public Internet access /
    Mailing
    Lists

    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858)
    538-5051
    San Diego, California -- Public Internet access /
    Mailing
    Lists

    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Christopher Spence at Aug 17, 2001 at 7:26 pm ⇧
    It sounds like you may need more ram.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863


    -----Original Message-----
    Sent: Friday, August 17, 2001 3:22 PM
    To: Multiple recipients of list ORACLE-L

    I've looked at the server. Total Commit Charge is 574968. Total Physical
    Memory is 523680. I can see that it's over, but what am I looking at? I
    understand physical memory, but the help on 'Commit Memory' in
    windows is less than helpful.

    Do I need to reboot the box?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:08 AM
    To: Multiple recipients of list ORACLE-L

    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be the only
    cure.
    If you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Bond Mike A Contr OC-ALC/TILC at Aug 17, 2001 at 8:24 pm ⇧
    WHat type of processors are in the server. We have a bug - i think in
    8.1.5 or 8.1.6.0 that caused this very problem. Only upgrading the RDBMS
    fixed it.

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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.com
    --
    Author: Bond Mike A Contr OC-ALC/TILC
    INET: Mike.Bond_at_tinker.af.mil

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Vergara, Michael (TEM) at Aug 17, 2001 at 8:55 pm ⇧
    According to Control Panel -> System, it's a "x86 Family 6 Model8 Stepping
    6". And there are two CPUs.

    What's the nature of the bug? Can I find out more about it on MetaLink?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 2:36 PM
    To: Multiple recipients of list ORACLE-L

    WHat type of processors are in the server. We have a bug - i think in
    8.1.5 or 8.1.6.0 that caused this very problem. Only upgrading the RDBMS
    fixed it.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • H elp_me at Aug 18, 2001 at 9:05 am ⇧
    Hi,
    Check whether SMON is active ? What is your tablespace status ? Fragmented ? If yes, SMON would be trying to coalesce. Check for the PCTINCREASE at the tablespace level ... if it is greater than 0.. you will have to let SMON clear the fragmentation at tablespace level.
    EVEN if you shutdown and restart the instance.. SMON will again the entire process of defragmentation from SCRATCH.. and hence take even longer to clean up...

    Check for v$fet or fet$ (Hope i remember the name correctly.. ) You should be able to check for the fragmentation fo tablespaces there and as it is cleared.. that number of count(*) should come down..


    If it is on UNIX.. I can say.. check for the Process ID from within ORACLE... and then query the same with
    ps -ef | grep

    It should show you.. what process it is ..

    OR the other way.. run TOP or some utility which says.. what process is taking maximum CPU time.. and check for that process_id in ORACLE.

    It seems SMON has kicked off.

    Hope this helps..

    Bye

    Check which process is taking the maximum CPU TIME.
    From: Bond Mike A Contr OC-ALC/TILC
    Reply-To: ORACLE-L@fatcity.com
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU
    Date: Fri, 17 Aug 2001 13:36:24 -0800

    WHat type of processors are in the server. We have a bug - i think in
    8.1.5 or 8.1.6.0 that caused this very problem. Only upgrading the RDBMS
    fixed it.






    -----Original Message-----
    Sent: Friday, August 17, 2001 11:41 AM
    To: Multiple recipients of list ORACLE-L


    We are having a problem with our database - it is using 100% of the CPU.
    This has only started happening recently, and restarting the database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light on this
    or
    suggest how to find out what is running on the db?


    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington@procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru@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.com
    --
    Author: Bond Mike A Contr OC-ALC/TILC
    INET: Mike.Bond@tinker.af.mil

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru@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).
    Get your FREE download of MSN Explorer at http://explorer.msn.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: H elp_me
    INET: good_dba@hotmail.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru@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).
  • Tday6_at_csc.com at Aug 20, 2001 at 1:35 pm ⇧
    Are you using the OEM that came with 8.1.6? I have a dim memory that the
    JAVA executable that powers that version of OEM had a flaw that could
    consume 100% of the CPU. Personally, I don't use OEM versions after 8.1.5.

    HTH




    Christopher

    Spence To: Multiple recipients of list ORACLE-L

    Spot.com> cc:

    Sent by: Subject: RE: Database using 100% of CPU

    root_at_fatcity.

    com

    08/17/2001

    04:34 PM

    Please

    respond to

    ORACLE-L

    It sounds like you may need more ram.

    "Do not criticize someone until you walked a mile in their shoes, that way
    when you criticize them, you are a mile a way and have their shoes."

    Christopher R. Spence
    Oracle DBA
    Phone: (978) 322-5744
    Fax: (707) 885-2275

    Fuelspot
    73 Princeton Street
    North, Chelmsford 01863

    -----Original Message-----
    Sent: Friday, August 17, 2001 3:22 PM
    To: Multiple recipients of list ORACLE-L

    I've looked at the server. Total Commit Charge is 574968. Total Physical
    Memory is 523680. I can see that it's over, but what am I looking at? I
    understand physical memory, but the help on 'Commit Memory' in
    windows is less than helpful.

    Do I need to reboot the box?

    Thanx,
    Mike

    ---
    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 11:08 AM
    To: Multiple recipients of list ORACLE-L

    How much memory is being used, vs. available physical RAM?

    Check Task Manager | Performance tab, compare Commit Charge Total (LL
    corner) vs. Physical Memory Total (UR corner).

    You should stay below physical RAM as much as possible, because Oracle
    really does not like NT virtual memory.

    Patrice Boivin
    Systems Analyst (Oracle Certified DBA)

    -----Original Message-----
    From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent: Friday, August 17, 2001 2:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database using 100% of CPU

    Steven:

    I also have this happen on one of our smaller DBs running NT. I
    haven't
    found a cause yet either. Rebooting seems (so far) to be the only
    cure.
    If you get any replies would you please summarize to the list?

    Thanx,
    Mike

    ---

    ===========================================================================
    Michael P. Vergara
    Oracle DBA
    Guidant Corporation
    (909) 914-2304

    -----Original Message-----
    Sent: Friday, August 17, 2001 9:41 AM
    To: Multiple recipients of list ORACLE-L

    We are having a problem with our database - it is using 100% of the
    CPU.
    This has only started happening recently, and restarting the
    database
    temporarily
    stops it happening - it usually recurrs a few hours later.
    There are no jobs running, and at the moment there are no active
    connections.
    Obviously something has kicked this off, can anyone shed any light
    on this
    or
    suggest how to find out what is running on the db?

    Thanks in advance,

    Steven H.

    (Oracle 8.1.6.0.0 EE on NT 4 SP5)

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Hovington
    INET: steven.hovington_at_procession.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing
    Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Boivin, Patrice J
    INET: BoivinP_at_mar.dfo-mpo.gc.ca

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Christopher Spence
    INET: cspence_at_FuelSpot.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author:
    INET: tday6_at_csc.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • JOE TESTA at Aug 20, 2001 at 3:26 pm ⇧
    the OEM with 9i, works beautifully(at least on linux) :)

    joe
    tday6_at_csc.com 08/20/01 10:51AM >>>Are you
    using the OEM that came with 8.1.6?  I have a dim memory that theJAVA
    executable that powers that version of OEM had a flaw that couldconsume 100%

    of the CPU.  Personally, I don't use OEM versions after
    8.1.5.HTH

    Christopher

    Spence
    To:     Multiple recipients of list
    ORACLE-L




    Spot.com>
    cc:

    Sent by:
    Subject:     RE: Database using 100% of

    CPU



    root_at_fatcity.

    com



    08/17/2001


    04:34

    PM

    Please


    respond

    to

    ORACLE-L



    It sounds like you may need more ram."Do not
    criticize someone until you walked a mile in their shoes, that waywhen you
    criticize them, you are a mile a way and have their shoes."Christopher
    R. SpenceOracle DBAPhone: (978) 322-5744Fax:    (707)
    885-2275Fuelspot73 Princeton StreetNorth, Chelmsford
    01863-----Original Message-----Sent: Friday, August 17,
    2001 3:22 PMTo: Multiple recipients of list ORACLE-LI've looked
    at the server.  Total Commit Charge is 574968.  Total
    PhysicalMemory is 523680.  I can see that it's over, but what am I
    looking at?  Iunderstand physical memory, but the help on 'Commit
    Memory' inwindows is less than helpful.Do I need to reboot the

    box?Thanx,Mike---===========================================================================Michael

    P. VergaraOracle DBAGuidant Corporation(909)
    914-2304-----Original Message-----Sent: Friday, August 17, 2001
    11:08 AMTo: Multiple recipients of list ORACLE-LHow much memory
    is being used, vs. available physical RAM?Check Task Manager |
    Performance tab, compare Commit Charge Total (LLcorner) vs. Physical Memory
    Total (UR corner).You should stay below physical RAM as much as
    possible, because Oraclereally does not like NT virtual
    memory.Patrice BoivinSystems Analyst (Oracle Certified
    DBA)     -----Original
    Message-----     From:     Vergara,
    Michael (TEM) [SMTP:mvergara_at_guidant.com]
    Sent:     Friday, August 17, 2001 2:41
    PM     To:  Multiple recipients of list
    ORACLE-L     Subject:  RE: Database using 100% of
    CPU     Steven:     I
    also have this happen on one of our smaller DBs running NT.
    Ihaven't     found a cause yet either.
    Rebooting seems (so far) to be the onlycure.     If
    you get any replies would you please summarize to the
    list?     Thanx,
    Mike

    ---===========================================================================

    Michael P. Vergara     Oracle
    DBA     Guidant Corporation
    (909) 914-2304     -----Original
    Message-----     Sent: Friday, August 17, 2001 9:41
    AM     To: Multiple recipients of list
    ORACLE-L     We are having a problem with our
    database - it is using 100% of theCPU.     This has
    only started happening recently, and restarting
    thedatabase
    temporarily     stops it happening - it usually recurrs
    a few hours later.     There are no jobs running, and at
    the moment there are no active
    connections.     Obviously something has kicked this
    off, can anyone shed any lighton this
    or     suggest how to find out what is running on the
    db?     Thanks in
    advance,     Steven
    H.     (Oracle 8.1.6.0.0 EE on NT 4
    SP5)     --     Please see
    the official ORACLE-L FAQ: http://www.orafaq.com" rel="nofollow">http://www.orafaq.com">http://www.orafaq.com
    --     Author: Steven
    Hovington       INET:
    steven.hovington_at_procession.com     Fat City Network

    Services    -- (858) 538-5051  FAX: (858)
    538-5051     San Diego,
    California        -- Public Internet access /

    MailingLists

    --------------------------------------------------------------------

    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.com" rel="nofollow">http://www.orafaq.com">http://www.orafaq.com
    --     Author: Vergara, Michael
    (TEM)       INET:

    mvergara_at_guidant.com     Fat City Network

    Services    -- (858) 538-5051  FAX: (858)
    538-5051     San Diego,
    California        -- Public Internet access /

    MailingLists

    --------------------------------------------------------------------

    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.com--Author:" rel="nofollow">http://www.orafaq.com">http://www.orafaq.com--Author: Boivin,
    Patrice J  INET: BoivinP_at_mar.dfo-mpo.gc.caFat City Network
    Services    -- (858) 538-5051  FAX: (858) 538-5051San
    Diego, California        -- Public Internet
    access / Mailing

    Lists--------------------------------------------------------------------To

    REMOVE yourself from this mailing list, send an E-Mail messageto:
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage
    BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list
    you want to be removed from).  You may also send the HELPcommand for
    other information (like subscribing).--Please see the official ORACLE-L
    FAQ: http://www.orafaq.com--Author:
    Vergara, Michael (TEM)  INET: mvergara_at_guidant.comFat City
    Network Services    -- (858) 538-5051  FAX: (858)
    538-5051San Diego, California        --
    Public Internet access / Mailing

    Lists--------------------------------------------------------------------To

    REMOVE yourself from this mailing list, send an E-Mail messageto:
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage
    BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list
    you want to be removed from).  You may also send the HELPcommand for
    other information (like subscribing).--Please see the official ORACLE-L
    FAQ: http://www.orafaq.com--Author:
    Christopher Spence  INET: cspence_at_FuelSpot.comFat City Network
    Services    -- (858) 538-5051  FAX: (858) 538-5051San
    Diego, California        -- Public Internet
    access / Mailing

    Lists--------------------------------------------------------------------To

    REMOVE yourself from this mailing list, send an E-Mail messageto:
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
    BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
    you want to be removed from).  You mayalso send the HELP command for
    other information (like subscribing).-- Please see the official
    ORACLE-L FAQ: http://www.orafaq.com--
    Author:   INET: tday6_at_csc.comFat City Network
    Services    -- (858) 538-5051  FAX: (858) 538-5051San
    Diego, California        -- Public Internet
    access / Mailing

    Lists--------------------------------------------------------------------To

    REMOVE yourself from this mailing list, send an E-Mail messageto:
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
    BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
    you want to be removed from).  You mayalso send the HELP command for
    other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 17, '01 at 3:58p
activeAug 20, '01 at 3:26p
posts19
users9
websiteoracle.com

9 users in discussion

Christopher Spence: 5 posts Vergara, Michael (TEM): 5 posts Boivin, Patrice J: 2 posts Steven Hovington: 2 posts Tday6_at_csc.com: 1 post JOE TESTA: 1 post H elp_me: 1 post Kathy Duret: 1 post Bond Mike A Contr OC-ALC/TILC: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase