keliatannya, row chaining tidak ada, tapi dgn sql di bawah ini, bahwa ada
fragmentasi/coalesced di level block dan extent....apa itu terjadi karena
gak seluruh block kepakai oleh data (each row), terus yg extent fragmentasi
? ada yg bisa lebih spesifik, menceritakannya?
select tablespace_name,extents_coalesced,total_blocks,blocks_coalesced
from dba_free_space_coalesced;
SELECT dfsc.tablespace_name tablespace_name,
DECODE (
dfsc.percent_extents_coalesced,
100,
(DECODE (
GREATEST ((SELECT COUNT (1)
FROM dba_free_space dfs
WHERE dfs.tablespace_name =
dfsc.tablespace_name),
1),
1,
'No Frag',
'Bubble Frag'
)
),
'Possible Honey Comb Frag'
)
fragmentation_status
FROM dba_free_space_coalesced dfsc
ORDER BY dfsc.tablespace_name;
/
J
----- Original Message -----
From: "Yulius Wibowo" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, March 06, 2006 10:11 AM
Subject: [indo-oracle] Re: bingung pctfree dan pctused
> Melihat ROW-CHAINNING
>
>
> SQL> CREATE TABLE test_chain(A VARCHAR2(100));
>
> Table created.
>
> SQL> BEGIN
> 2 FOR i IN 1..1000 LOOP
> 3 INSERT INTO test_chain VALUES('ABC');
> 4 END LOOP;
> 5 END;
> 6 /
>
> PL/SQL procedure successfully completed.
>
> SQL> ANALYZE TABLE test_chain COMPUTE STATISTICS;
>
> Table analyzed.
>
> Melihat jumlah row-chainning ... (chain_cnt)
>
> SQL> SELECT table_name, num_rows, chain_cnt FROM user_tables WHERE
> table_name='TEST_CHAIN';
>
> TABLE_NAME NUM_ROWS
> CHAIN_CNT
> ------------------------------ ---------- ----------
>
> TEST_CHAIN 1000
> 0
>
> SQL> UPDATE test_chain SET a = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
>
> 1000 rows updated.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> ANALYZE TABLE test_chain COMPUTE STATISTICS;
>
> Table analyzed.
>
> SQL> SELECT table_name, num_rows, chain_cnt FROM user_tables WHERE
> table_name='TEST_CHAIN';
>
> TABLE_NAME NUM_ROWS
> CHAIN_CNT
> ------------------------------ ---------- ----------
>
> TEST_CHAIN 1000
> 921
>
> SQL>
> SQL> ALTER TABLE test_chain MOVE TABLESPACE example;
>
> Table altered.
>
> SQL> ANALYZE TABLE test_chain COMPUTE STATISTICS;
>
> Table analyzed.
>
> SQL> SELECT table_name, num_rows, chain_cnt FROM user_tables WHERE
> table_name='TEST_CHAIN';
>
> TABLE_NAME NUM_ROWS
> CHAIN_CNT
> ------------------------------ ---------- ----------
>
> TEST_CHAIN 1000
> 0
>
>
> Bowo
>
Send instant messages to your online friends http://asia.messenger.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
