Sekedar menambahkan utk besarnya table: SQL> select segment_name, bytes from user_segments where segment_type = 'TABLE';
Utk besarnya alokasi space yg terpakai utk data: SQL> select table_name, blocks from user_tables; (lalu kalikan nilai blocks dengan nilai db_block_size parameter) Utk besarnya alokasi space dari table yg BELUM terpakai : SQL> select table_name, empty_blocks from user_tables; (lalu kalikan nilai empty_blocks dengan nilai db_block_size parameter) CMIIW Bowo --- In [email protected], Pandu W Perwira <[EMAIL PROTECTED]> wrote: > > saya biasa menggunakan cara begini (tricky) : > > 1. buat tabel > 2. masukkan 1 baris kesemua kolom ( jangan ada kolom yang diisi null ), dan kalau bisa masukkan nilainya sesuai dengan maksimum value yang bisa ditampung kolom tsb. > 3. lakukan perintah "analyze table <nama tabel> compute statistics" > 4. lakukan query "select avg_row_len from user_Tables where table_name='<nama tabel' " > > maka anda akan dapatkan 1 record length dalam satuan bytes, untuk tau berapa besar ukuran tabel ya tinggal kali dengan jumlah baris (estimasi aja). > > semoga membantu > > Toni Iskandar <[EMAIL PROTECTED]> wrote: > Dear Millis, > > saya mau tanya bagaimana caranya untuk mengetahui ukuran record length > dari suatu table dan besarnya data dari suatu table. > terimakasih. > > [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.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS > Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in one click. > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
