| 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: Table not reusing deleted space
Here are the stats if you're interested. I can't run dbms_space on the table because it will lock up the application. This table is accessed ALL the time. It grabbed another 100M today! Extent management is LOCAL with UNIFORM SIZE of 100M.
24th Sep 2003
OWNE SEGMENT_NAME TABLESPACE_NAME KB NEXTKB EXT[MAX] % Inc ---- --------------------------------- -------------------- ------------ ------------ -------------------- ---------- CCA CONNECT_TASK[T] CC_TASK_TABS 3,891,200 102,400 38[2147483645] 0 CCA CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 CCA CONNECT_TASK_CRN[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 CCA PK_CONNECT_TASK[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 OWNE TABLE_NAME NUM_ROWS AVG_ROW_LEN BLOCKS EMPTY_BLOCKS CHAIN_CNT ---- ------------------------------ ---------- ----------- ---------- ------------ ---------- CCA CONNECT_TASK 185583 4898 484189 2210 1445
2nd Oct 2003
OWNER SEGMENT_NAME TABLESPACE_NAME KB NEXTKB EXT[MAX] -------------------- --------------------------------- -------------------- ------------ ------------ -------------------- CCA CONNECT_TASK[T] CC_TASK_TABS 4,198,400 102,400 41[2147483645] CCA CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] CCA CONNECT_TASK_CRN[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] CCA PK_CONNECT_TASK[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] OWNE TABLE_NAME NUM_ROWS AVG_ROW_LEN BLOCKS EMPTY_BLOCKS CHAIN_CNT ---- ------------------------------ ---------- ----------- ---------- ------------ ---------- CCA CONNECT_TASK 184113 4958 512699 12100 1528 --------------------------------------------------------------------------------From: "Sinardy Xing" <SinardyXing_at_bkgcomsvc.com> Date: Wed, 1 Oct 2003 14:51:40 +0800
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kaing, Leng
INET: Leng.Kaing_at_team.telstra.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 02 2003 - 00:49:32 CDT
 |
 |