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 waiting....I 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 > >waiting....Any 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). -- 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).
