RE: DBA_EXTENTS problem

analyzing SYSTEM is not the same as analyzing SYS, which is what you have done by using gather_database_stats

run dbms_stats.delete_schema_stats('SYS') to remove the statistics

then either always run the delete after the gather_database_stats or switch to gather_schema_stats

|--------+----------------------->


|        |                       |

|        |                       |

|        |          jbdonga_at_ucdav|

|        |          is.edu       |

|        |                       |

|        |          05/09/2002   |

|        |          03:41 PM     |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------------|
  |                                                    |
  |       To:     ORACLE-L_at_fatcity.com                 |
  |       cc:     (bcc: Rachel Carmichael)             |
  |       Subject:     RE: DBA_EXTENTS problem         |
  >----------------------------------------------------|

I used to run the following analyze every week: dbms_utility.analyze_schema(...) 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.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 09, 2002 12:51 PM
To: 'ORACLE-L_at_fatcity.com'
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.
dwilliams_at_lifetouch.com

-----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: jbdonga_at_ucdavis.edu

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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: Janardhana Babu Donga
  INET: jbdonga_at_ucdavis.edu

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: 
  INET: Rachel_Carmichael_at_Sonymusic.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).