Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA_EXTENTS problem
or more accurately -
select count(*) from sys.uet$;
-----Original Message-----
Sent: Thursday, May 09, 2002 2:03 PM
To: 'ORACLE-L_at_fatcity.com'
what does
select count(*) from uet$
return?
-----Original Message-----
Sent: Thursday, May 09, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
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).
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).
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). Received on Thu May 09 2002 - 14:13:53 CDT