Re: Pls respond...: URGENT
My one of disk showing full active...very hot!!! by bground processes accessing... hdisk51 88.7 926.6 139.3 2780 8 hdisk51 85.5 1217.0 176.2 3660 0 hdisk51 91.8 980.2 149.3 2948 From: Peter R [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: Pls respond...: URGENT Date: Tue, 03 Sep 2002 19:32:14 + Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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).
Fwd: RE: Pls respond...: URGENT
My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... From: Fink, Dan [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: Pls respond...: URGENT Date: Tue, 3 Sep 2002 13:58:02 -0600 Peter, What is the problem? What you are asking is not clear, which could be one reason you are not getting a response. Try restating the issue with exactly what the condition of the db is (up or down), what errors are being reported, etc. Dan Fink -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Pls respond...: URGENT Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Pls respond...: URGENT
What kind of reorgs did you do? -Original Message- Sent: Tuesday, September 03, 2002 4:59 PM To: Multiple recipients of list ORACLE-L My one of disk showing full active...very hot!!! by bground processes accessing... hdisk51 88.7 926.6 139.3 2780 8 hdisk51 85.5 1217.0 176.2 3660 0 hdisk51 91.8 980.2 149.3 2948 From: Peter R [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: Pls respond...: URGENT Date: Tue, 03 Sep 2002 19:32:14 + Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Seefelt, Beth 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: RE: Pls respond...: URGENT
Is it possible there is a full analyze running on the database? You said you did a reorg this weekend. If you bounced it 4 times it could be going through backout and recovery. Either one would keep it pretty busy. R. Smith -Original Message- Sent: Tuesday, September 03, 2002 4:08 PM To: Multiple recipients of list ORACLE-L My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... From: Fink, Dan [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: Pls respond...: URGENT Date: Tue, 3 Sep 2002 13:58:02 -0600 Peter, What is the problem? What you are asking is not clear, which could be one reason you are not getting a response. Try restating the issue with exactly what the condition of the db is (up or down), what errors are being reported, etc. Dan Fink -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Pls respond...: URGENT Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Smith, Ron L. 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: Pls respond...: URGENT
Try RE-Booting the Machine , if you think the behaviour is very abnormal If you are on IBM AIX , ensure that you have applied the the 1 off patch for fsync available on 8.1.7.4 (32 Bit) OR 8.1.7.2 (64 Bit) Setting Multiple db_writers might help , after turning disk_async_io = false . O.S. Other than Solaris , AIX may NOt have a proper implementation of asynchronous IO If you have a Test Machine Load the Database on that see if it is choking too -Original Message- Sent: Wednesday, September 04, 2002 2:29 AM To: Multiple recipients of list ORACLE-L My one of disk showing full active...very hot!!! by bground processes accessing... hdisk51 88.7 926.6 139.3 2780 8 hdisk51 85.5 1217.0 176.2 3660 0 hdisk51 91.8 980.2 149.3 2948 From: Peter R [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: Pls respond...: URGENT Date: Tue, 03 Sep 2002 19:32:14 + Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: VIVEK_SHARMA 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: RE: Pls respond...: URGENT
if exp/imp were used Ensure that Statistics are DELETED ( RE-Created , if needed) as they will be highly incorrect Check for DEGREE 1 of the Tables Indexes . This will also Cause Optimizer to choose BAD Plans if NO Statistics Exist -Original Message- Sent: Wednesday, September 04, 2002 3:00 AM To: Multiple recipients of list ORACLE-L Is it possible there is a full analyze running on the database? You said you did a reorg this weekend. If you bounced it 4 times it could be going through backout and recovery. Either one would keep it pretty busy. R. Smith -Original Message- Sent: Tuesday, September 03, 2002 4:08 PM To: Multiple recipients of list ORACLE-L My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... From: Fink, Dan [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: Pls respond...: URGENT Date: Tue, 3 Sep 2002 13:58:02 -0600 Peter, What is the problem? What you are asking is not clear, which could be one reason you are not getting a response. Try restating the issue with exactly what the condition of the db is (up or down), what errors are being reported, etc. Dan Fink -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Pls respond...: URGENT Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Smith, Ron L. 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