Mungkin gara-gara freelists http://www.dba-oracle.com/oracle_tips_freelists.htm
On 9/8/06, Yoel <[EMAIL PROTECTED]> wrote: > > Mungkin bisa consider pakai Temporary Table nya oracle untuk transaksi > Anda. > Silakan liat disini > > http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2213 > > > On 9/8/06, Iqbal Yahoo <[EMAIL PROTECTED] <qbl2110%40yahoo.com.sg>> > wrote: > > > > Dear rekan Oracle > > > > Mohon bantuannya, > > Ceritanya begini. > > Diperusahaan tempat saya bekerja ada table yang setiap akhir hari > > diresumekan, lalu data tersebut didelete. Setiap hari data yang masuk > > sekitar 400-500ribu record. > > Yang jadi masalah adalah total byte table tersebut makin hari makin > > membesar > > (kondisi sekarang 1,8GB). sedangkan apabila saya create table as select > > dari > > table tsb (jumlah sekitar 500rb record total bytenya sekitar 30MB). > > Pertanyaannya bagaimana agar block yang terdelete dapat dipergunakan > lagi > > pada saat insert ( berdasarkan referensi yg saya baca untuk create table > > model begini set PCTFREE 5 dan PCTUSED 60 atau saya salah set untuk > > PCTFREE > > & PCTUSEDnya). > > > > Sebagai info, saya menggunakan oracle 8.17, block size di > init.ORA-nya8192 > > > > dan kalau saya eksekusi dengan DBMS_SPACE.UNUSED_SPACE, dihasilkan : > > total_blocks : 227,731 > > total_bytes : 1,865,572,352 > > unused_blocks : 1,245 > > unused_bytes : 10,199,040 (kenapa Unused bytes-nya segini ? ) > > > > Ini Script untuk create table-nya: > > > > create table APP.PERFORMANCE > > ( > > CODE VARCHAR2(5) not null, > > D_DATE DATE not null, > > CLIENT_ID NUMBER(4) not null, > > STATUS VARCHAR2(16) not null, > > TRX_TYPE VARCHAR2(8) not null, > > TRX_ID VARCHAR2(32) not null, > > TIME1 NUMBER(20) null, > > TIME2 NUMBER(20) null, > > TIME3 NUMBER(20) null, > > TIME4 NUMBER(20) null > > ) > > pctfree 5 pctused 60 initrans 255 > > storage > > ( initial 16M next 16M freelists 96 > > minextents 1 maxextents UNLIMITED pctincrease 0 > > ) > > tablespace DATA > > nologging > > / > > > > Mohon petunjuknya kepada para pakar Oracle. > > > > Atas bantuannya saya ucapkan terima kasih > > Iqbal > > > > --------------------------------- > > Yahoo! Movies - Search movie info and celeb profiles and photos. > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
