| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dropping table is not completing
Rick,
Open up another sqlplus session and check the activivity of sys.uet$ and
sys.fet$ as Joe suggested. If you had a large number of extents in this
table you could be doing a lot of deletes and inserts into these
tables. (UET$ = Used Extent Table, FET$ = Free Extent Table). To
check this do the following:
select count(u.ts#) UET_COUNT, count(f.ts#) FET_COUNT from sys.uet$ u, sys.fet$ f, v$tablespace t
where u.ts# = t.ts#
and f.ts# = t.ts#
and t.name = 'USERS'; /*or whatever tablespace name your table
is in*/
UET_COUNT FET_COUNT
1 row selected.
Run this a few times and see how much the numbers are changing. This will let you know where you are with your truncate.
Rodd Holman
"Cale, Rick T (Richard)" wrote:
> Joe,It is just sitting there. I am trying to truncate then drop but
> truncating is just sitting there. There are no constraints on this
> table and I am the only one accessingdatabase currently. ThanksRick
>
> -----Original Message-----
> From: JOE TESTA [mailto:JTESTA_at_longaberger.com]
> Sent: Thursday, October 04, 2001 2:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Dropping table is not completing
>
> Richard, is it just sitting there? could it have a large
> numebr of extents that oracle is deleting entries from uet$
> and inserting back to fet$? joe
>
> >>> RICHARD.T.CALE_at_saic.com 10/04/01 01:55PM >>>
> Hi All,
>
> I am trying to drop a table. It is not locked and has very
> few records in
> it. I am trying to drop it but it will not.
> What can I check to find out why it will not drop?
>
> Thanks
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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: Rodd Holman INET: rodney.holman_at_lodgenet.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).Received on Thu Oct 04 2001 - 13:47:32 CDT
 |
 |