High CPU usage by Oracle
Hi, I would like help with this problem I am grappling with since yesterday. One of the test boxes with Sun Solaris 2.7 OS and Oracle 8.1.7.2 on it has started showing 97% and above CPU usage mostly by Oracle . It has slowed down the application to a point where the testers can not test. Does any one have any idea why Oracle would suddenly hog CPU so much? The normal CPU usage on these boxes is 2%-3%. All help is greatly appreciated. Thanks in advance. Thanks, Uma Mohoni Consultant, CDI Corporation @ iKimbo Inc. 500-A Huntmar Park Drive Herndon, VA 20170 (703) 904-4150 Ext:237 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: High CPU usage by Oracle
Yeah there was a sudden burst of activity in data insert, updates and deletes over the weekend as a result of a new app module being tested. But the client app uses Java code and is not in the database. So its nothing I can ask them to remove. On the other hand sudden bursts of data activity is something that might very well happen in the normal course of the application so I guess I need to be prepared for it..Thanks, for the suggestion. -Uma -Original Message- Sent: Tuesday, January 22, 2002 11:31 AM To: Multiple recipients of list ORACLE-L Has there been any changes in the applications? I had someone put in new code this weekend and it sent my CPU up over 80%. When I saw that Monday morning, I had the developer take the code out and my CPU dropped back down to around the 5 - 10%. From my little experience I have quickly learned that when you see something like your CPU go up, check what modifications to applications have occurred. Dave -Original Message- Sent: Tuesday, January 22, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Hi, I would like help with this problem I am grappling with since yesterday. One of the test boxes with Sun Solaris 2.7 OS and Oracle 8.1.7.2 on it has started showing 97% and above CPU usage mostly by Oracle . It has slowed down the application to a point where the testers can not test. Does any one have any idea why Oracle would suddenly hog CPU so much? The normal CPU usage on these boxes is 2%-3%. All help is greatly appreciated. Thanks in advance. Thanks, Uma Mohoni Consultant, CDI Corporation @ iKimbo Inc. 500-A Huntmar Park Drive Herndon, VA 20170 (703) 904-4150 Ext:237 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.1.7 on W2K
I created the database on NT using scripts and I did use auto start for the service. Sorry for the delay in reply..was out over the long weekend. - Uma -Original Message- Sent: Friday, August 31, 2001 9:28 AM To: Multiple recipients of list ORACLE-L Who created the DBs on NT? How? When you created the 817 DBs, did you use the GUI or did you use the command line and a script? did you use autostart? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 30 Aug 2001 09:03:47 Uma Mohoni wrote: Guys, I have an just finished upgrading to 8.1.7 on all my boxes some of which are Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0. But on Windows2000, every time the box is rebooted the instance does not come up automatically. However the service shows as running. I checked the registry to make sure I had ORACLE_SID set right. I have to manually start the instance every time and its a pain in the 'you know what'. If anyone has had this problem and solved it please let me know the solution. Thanks, Uma Mohoni Consultant, CDI Corporation @ iKimbo Inc. 500-A Huntmar Park Drive Herndon, VA 20170 (703) 904-4150 Ext:237 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
8.1.7 on W2K
Guys, I have an just finished upgrading to 8.1.7 on all my boxes some of which are Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0. But on Windows2000, every time the box is rebooted the instance does not come up automatically. However the service shows as running. I checked the registry to make sure I had ORACLE_SID set right. I have to manually start the instance every time and its a pain in the 'you know what'. If anyone has had this problem and solved it please let me know the solution. Thanks, Uma Mohoni Consultant, CDI Corporation @ iKimbo Inc. 500-A Huntmar Park Drive Herndon, VA 20170 (703) 904-4150 Ext:237 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB2 vs Oracle
Mark, I'd like to have a copy of that document too.. - Uma -Original Message- Sent: Thursday, May 31, 2001 3:24 PM To: Multiple recipients of list ORACLE-L Ditto -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I wouldn't mind a copy of that doc Mark? -Original Message- Sent: 31 May 2001 13:34 To: Multiple recipients of list ORACLE-L Hi people, A few weeks back somebody posted a message regarding an eval they are doing comparing Oracle/DB2/SQLServer. I came across a great document today for an Oracle/DB2 comparison, so if that person - sorry I can't remember who it was - is interested, contact me back channel, and I'll send it over to you. Regards Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Uma Mohoni INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).