Mungkin saja "records" yg ada di data dictionary (DBA_FREE_SPACE)-nya terlalu banyak. Coba dicheck: SQL> select count(*) from dba_free_space; Kalau " ya " ... Hal ini bisa saja disebabkan: 1. Banyak extent yg kosong (pernah terpakai)::: biasanya pada DICTIONARY MANAGED TABLESPACE 2. terjadi fragmentasi ::: biasanya pada DICTIONARY MANAGED TABLESPACE 3. Extent size yg pernah dipakai oleh object (table, index ...) terlalu kecil dan data yg dipakai cukup besar (puluhan/ratusan giga bytes). Solusi(kalau jawaban di atas "ya"): - Buat tablespace dengan extent management local - buat uniform size yg besar, khususnya utk table/index yg besar - letakkan object (table/index) pada tablespace tsb - lakukan reorganisasi table/index/tablespace ::: utk tablespace -> COALESCE ... any other ideas ??? CMIIW Bowo --- In [email protected], "adhika_rexuss" <[EMAIL PROTECTED]> wrote: > > halo semua... > saya punya query seperti ini nih : > > COL TABLESPACE_NAME FORMAT A15 > COL NAME FORMAT A45 > COL TOTAL_SIZE FORMAT 9,999,999,999,999.00 > COL FREE_SPACE FORMAT 9,999,999,999,999.00 > COL USED_SPACE FORMAT 9,999,999,999,999.00 > > SELECT > A.TABLESPACE_NAME, > B.BYTES TOTAL_SIZE, > A.FREE_SPACE, > B.BYTES - A.FREE_SPACE USED_SPACE, > B.NAME > FROM > ( > SELECT > TABLESPACE_NAME, > SUM(BYTES) FREE_SPACE, > RELATIVE_FNO > FROM > DBA_FREE_SPACE > GROUP BY RELATIVE_FNO, TABLESPACE_NAME > ) A, > V$DATAFILE B > WHERE > A.RELATIVE_FNO = B.FILE# > > kalo dijalanin kok jalannya lambat banget, > baru 1 menitan lebih keluarnya... > aneh banget yah ? > > ada yang bisa bantu ? > > > thanks > > > Adhika -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- 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/
