Babu,
execute dbms_utility.analyze_schema('system','delete') this would do. -Shaibal >From: Janardhana Babu Donga <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: DBA_EXTENTS problem >Date: Thu, 09 May 2002 11:41:16 -0800 > >I used to run the following analyze every week: >statement which included SYSTEM schema, >Two weeks back it was changed to >dbms_stats.gather_database_stats(); > >Is there anyway to de-analyze SYSTEM schema? > >Thanks, >-- Babu > > >-----Original Message----- >Sent: Thursday, May 09, 2002 11:04 AM >To: 'Janardhana Babu Donga' > > >Babu - Among the suggestions you have received, the one that seems to have >the most merit is whether any of your system tables have been analyzed. >Were >I in your position, I would check that out. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-----Original Message----- >Sent: Thursday, May 09, 2002 12:51 PM >To: '[EMAIL PROTECTED]' >Cc: DENNIS WILLIAMS > > >Dennis, > >It is happenning for any table in the database. I have just created a new >table: >create table x1 (col1 number) tablespace data_ts, inserted one row and >run: >select * from dba_extents where segment_name = 'X1'; It is still sitting >there. The response to any other dictionary view is spontaneous except this >dba_extents, which is confusing me. >I issued: select * from dba_objects where ..., select * from dba_segments >where .... etc. They are all responding fine. > >There are not many users at the moment. System tablespace is 500M size and >300MB is free. DB is 40Gig in size. It is on HP_UX 11.0 and Oracle >8.1.7.2.0 >(64bit) database. > >Any other ideas? > >Thanks, >-- Babu > >-----Original Message----- >Sent: Thursday, May 09, 2002 11:29 AM >To: Multiple recipients of list ORACLE-L > > >Babu - Wow, never had that one. Of course, I don't use that table much. How >many rows are in this table? Mine has 12,937 rows, and is kinda slow to >respond compared to the other system tables. Do you have a test database to >compare with? Is it possible that your system tablespace has become badly >fragmented? What is your system load, is it possibly a contention problem >of >some type. Why not run STATSPACK (or utlbstat) while you do this query and >see what is being waited for? Why don't I shut up and send this? >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-----Original Message----- >Sent: Thursday, May 09, 2002 12:58 PM >To: Multiple recipients of list ORACLE-L > > >Dear List, > >When I query dba_extents , Iam getting response after half an hour to 40 >minutes, but when I query any other dictionary view it is spontaneous. >Everything else is fine in the database and there are no problems, except >the above problem. Iam not getting any clue how to fix this. Iam thinking >of >running catalog.sql and catproc.sql as a last resort. Iam not sure it would >fix the problem. Please let me know if there is any other way to fix this >problem. > >Thanks, >Babu > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Janardhana Babu Donga > 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: DENNIS WILLIAMS > 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: Janardhana Babu Donga > 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: Shaibal Talukder 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).