Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: High % sys after Installing Solaris 8 on APP Server - SOLVED

Re: High % sys after Installing Solaris 8 on APP Server - SOLVED

From: Don Granaman <granaman_at_cox.net>
Date: Mon, 15 Jul 2002 20:18:20 -0800
Message-ID: <F001.00498B38.20020715201820@fatcity.com>


It is not necessary to run Oracle trace - from 7.3.2 on, these files are created by default. See Metalink Note: 45482.1 and Note:1020763.6

Synopsis:

For any connection without EPC_DISABLED=TRUE in the environment, regid.dat/process.dat will be appended - if they exist.

So, options include:

  1. Disable it entirely for all instances running against a particular $ORACLE_HOME via "rm $ORACLE_HOME/otrace/admin/*.dat". This eliminates the problem once and for all - if the files don't exist, they are not automatically recreated. To recreate these files, simply run the $ORACLE_HOME/bin/otrccref program.
  2. Disable for specific connections - by setting EPC_DISABLED=TRUE in the environment. Note that this is per session. It can be set for Net8/SQL*Net/OracleNet sessions via a (ENVS='EPC_DISABLED=TRUE') clause in the SID_DESC clause of listener.ora.

There also appears to be an open issue, on some platforms at least, with ORACLE_TRACE_ENABLE=TRUE (the default is FALSE) in init.ora and EPC_DISABLED=TRUE (the default is FALSE) in the environment.

Don Granaman
[OraSaurus]

Sounds like you had oracle trace running. A seldom useful and sometimes problem causing utility.

Bryan Rodrigues

-----Original Message-----

Sent: Wednesday, July 10, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L

process.dat & regid.dat Files Existing in $ORACLE_HOME/otrace/admin on APPLICATION Server
were Causing the High %sys Utilization .

Deleted the 2 whereafter %sys returned to Normal

NOTE - These files were get created as part of Oracle Installation .

Hope this helps

-----Original Message-----

Sent: Sunday, July 07, 2002 6:51 AM
To: VIVEK_SHARMA

hi Vivek,

i hope your problem got resolved as you didn't summarize as yet. keep in touch.

Regards,
Amit

System Administrator

Office: 510.252.4338
Mobile: 510.825.4356
E-mail: amahajan_at_santelnet.com

www.santelnet.com


Experience is that marvelous thing that enables you recognize a mistake when you make it again.

"Il y a des fleurs partout pour qui veut bien les voir."
-Henri Matisse

-----Original Message-----

Sent: Monday, June 17, 2002 11:34 PM
To: amahajan_at_santelnet.com; sunmanagers_at_sunmanagers.org; oracledba_at_lazydba.com; ORACLE-L_at_fatcity.com

E10K Specific Patches + Generic Solaris 8 Patches have been applied by the Sys Admin
/etc/system parameters have Also been Changed NOW

Unfortunately I am NOT much acquainted with Sys Administration , So if you have Any Specific Pach Numbers OR /etc/system parameters please tell them Explicitly

Also the DB & APP Servers have been interchanged i.e. Application S/w moved to the machine which was previously Containing the Database & vice-versa to see if it is a machine specific Issue & whether HIGH % sys Utilization Occurs after interchange too .

This was done Because % sys Utilization on DB Server machine was observed to be LOW (10 to 15 %)
when the same was High (50 to 90 %) on APP Server

Under Load We have yet to see How the %sys will be after moving the Application to the machine which was previously Containing the Database

NOTE - DB Server is also an E10K machine like APP Server

Thanks

-----Original Message-----

Sent: Tuesday, June 18, 2002 3:54 AM
To: VIVEK_SHARMA

Hi Vivek,

i am not an Oracle expert but check with Sun for Solaris 8 release compatibilty with the Starfire(E10K)
as some of the older E10K's sold with Solaris 2.6 were never tested for Solaris 8 performance and i suspect
your E10K is one of that lot of Starfire's sold.i may be wrong but still check it out as it may help you isolate the cause.

Please also do check your /etc/system shared memory and semaphore parameters too.

Regards,
Amit

-----Original Message-----

[mailto:sunmanagers-admin_at_sunmanagers.org]On Behalf Of VIVEK_SHARMA Sent: Monday, June 17, 2002 12:09 PM
To: sunmanagers_at_sunmanagers.org; oracledba_at_lazydba.com; ORACLE-L_at_fatcity.com

% sys Shot up to Values Ranging from 50% to 90 % (of sar Command) on Installing Solaris 2.8 after Removing the previously Existant Solaris 2.6 on APP Server under Load .

Previous % sys Utilization were 15% to 20 % on Solaris 2.6 under Similar Load

Application Software & Oracle Exes remained UNChanged

Oracle ver 7.3.4
m/c E10000

Problems happenign on a LIVE Productionm/c



sunmanagers mailing list
sunmanagers_at_sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.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: Rodrigues, Bryan
  INET: BRodrigues_at_elcom.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: Don Granaman
  INET: granaman_at_cox.net

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). Received on Mon Jul 15 2002 - 23:18:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US