maksudnya? 2008/7/8 dody osmon <[EMAIL PROTECTED]>:
> hai, > kira2 beda tidak sama performance db dengan size datafile ? > > thx, > Dody > > > --- On Tue, 7/8/08, Yoel Susanto <[EMAIL PROTECTED]<yoel.susanto%40gmail.com>> > wrote: > From: Yoel Susanto <[EMAIL PROTECTED] <yoel.susanto%40gmail.com>> > Subject: Re: [indo-oracle] resize tablepsace system > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Tuesday, July 8, 2008, 2:38 AM > > Asalkan anda punya job yang monitor free space di SYSTEM tablespace. yah > > aman2 aja.. > > kalo anda dapet email alert tinggal di gedein. > > Pastikan aja di SYSTEM tablespace tidak ada object lain selain punya SYSTEM > > user. > > biasanya kita2 gatel aja pak kalo liat database kita buang2 space :) > > 2008/7/8 m Ilhami <[EMAIL PROTECTED] com>: > > > Kalau untuk pencegahan, tablespace system di set, misalnya max 1GB dan > > > no autoextend, bahaya nggak? > > > > > > btw, Kenapa sih TS masalah banget dgn tablespace 4GB..Padahal jaman > > > sekarang harddisk murah. :) > > > > > > 2008/7/8 Yoel Susanto <yoel.susanto@ gmail.com <yoel.susanto% > 40gmail.com> >: > > > > > > > Check this link > > > > > > > > > > > http://www.oracle- base.com/ articles/ 10g/SpaceObjectT ransactionManage > ment10g.php# online_segment_ shrink > > > > > > > > Lakukan SHRINK SPACE untuk table2 yang ada di tablespace untuk mereset > > > HWM > > > > (cuman available di Oracle10g or higher). > > > > Sehingga bisa lebih me-reclaim wasted space. > > > > > > > > Tapi seperti dari awal saya katakan, ini tidak applicable untuk SYSTEM > > > > tablespace. > > > > > > > > 2008/7/8 dody osmon <dodytanjung79@ yahoo.com <dodytanjung79% > 40yahoo.com> > > > >: > > > > > > > >> yang jelas sih, saya bisa gunakan space lebih efisien, masalah itu di > > > >> atas HWM, saya tidak bisa komentar , oo yaa .., kalau emang bisa pakai > > > >> reset , emang model script reset pak yoel bagaimana ? > > > >> > > > >> thx, > > > >> Dody > > > >> > > > >> --- On Mon, 7/7/08, Yoel Susanto <yoel.susanto@ gmail.com<yoel.susanto% > 40gmail.com> > > > <yoel.susanto% 40gmail.com> > > > > >> wrote: > > > >> From: Yoel Susanto <yoel.susanto@ gmail.com <yoel.susanto% > 40gmail.com> <yoel.susanto% > > > 40gmail.com> > > > > > > > >> > > > >> Subject: Re: [indo-oracle] resize tablepsace system > > > >> To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. > com><indo- oracle% > > > > 40yahoogroups. com> > > > >> Date: Monday, July 7, 2008, 11:59 PM > > > >> > > > >> SELECT #4 akan menghasilkan command ALTER TABLESPACE.. . > > > >> > > > >> Tapi yang pak Dodi kasih hanya akan meresize datafile diatas HWM > > > datafile, > > > >> > > > >> tidak akan mereset HWM datafile. > > > >> > > > >> Jadi misal datafile 3 GB, HWM ada di 2GB, actuall used space cuman > > > 500MB. > > > >> > > > >> Jika HWM tidak di reset, Anda akan hanya akan bisa meresizenya ke 2GB. > > > >> > > > >> 2008/7/8 hendra chen <h3ndr4ch3n@ yahoo. com.sg>: > > > >> > > > >> > Pak Dodi, > > > >> > > > >> > > > > >> > > > >> > cara yang bapak berikan itu bisa untuk resize tablespace system? > > > >> > > > >> > command yang mana ya yang bisa untuk meresize tablespace system nya > ? > > > >> > > > >> > yang bapak berikan setau saya itu cuma command select saja. > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > --- On Mon, 7/7/08, dody osmon <dodytanjung79@ yahoo.com > > > <dodytanjung79% > > > >> 40yahoo.com> > > > > >> > > > >> > wrote: > > > >> > > > >> > From: dody osmon <dodytanjung79@ yahoo.com <dodytanjung79% > > > 40yahoo.com> > > > >> > > > > >> > > > >> > Subject: Re: [indo-oracle] resize tablepsace system > > > >> > > > >> > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > > >> > > > >> > > > >> > Date: Monday, 7 July, 2008, 1:41 PM > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > hai, > > > >> > > > >> > > > > >> > > > >> > terimakasih, tapi ini bisa di lakukan dan saya sudah mencoba , > berikut > > > >> step > > > >> > > > >> > nya: > > > >> > > > >> > > > > >> > > > >> > 1. > > > >> > > > >> > > > > >> > > > >> > set verify off > > > >> > > > >> > > > > >> > > > >> > column file_name format a50 word_wrapped > > > >> > > > >> > > > > >> > > > >> > column smallest format 999,990 heading "Smallest|Size| Poss." > > > >> > > > >> > > > > >> > > > >> > column currsize format 999,990 heading "Current|Size" > > > >> > > > >> > > > > >> > > > >> > column savings format 999,990 heading "Poss.|Savings" > > > >> > > > >> > > > > >> > > > >> > break on report > > > >> > > > >> > > > > >> > > > >> > compute sum of savings on report > > > >> > > > >> > > > > >> > > > >> > column value new_val blksize > > > >> > > > >> > > > > >> > > > >> > 2. > > > >> > > > >> > > > > >> > > > >> > select file_name, > > > >> > > > >> > > > > >> > > > >> > ceil( (nvl(hwm,1)* &&blksize) /1024/1024 ) smallest, > > > >> > > > >> > > > > >> > > > >> > ceil( blocks*&&blksize/ 1024/1024) currsize, > > > >> > > > >> > > > > >> > > > >> > ceil( blocks*&&blksize/ 1024/1024) - > > > >> > > > >> > > > > >> > > > >> > ceil( (nvl(hwm,1)* &&blksize) /1024/1024 ) savings > > > >> > > > >> > > > > >> > > > >> > from dba_data_files a, > > > >> > > > >> > > > > >> > > > >> > ( select file_id, max(block_id+ blocks-1) hwm > > > >> > > > >> > > > > >> > > > >> > from dba_extents > > > >> > > > >> > > > > >> > > > >> > group by file_id ) b > > > >> > > > >> > > > > >> > > > >> > where a.file_id = b.file_id(+) > > > >> > > > >> > > > > >> > > > >> > / > > > >> > > > >> > > > > >> > > > >> > 3. > > > >> > > > >> > > > > >> > > > >> > column cmd format a75 word_wrapped > > > >> > > > >> > > > > >> > > > >> > 4. > > > >> > > > >> > > > > >> > > > >> > select 'alter database datafile '''||file_name| |''' resize ' || > > > >> > > > >> > > > > >> > > > >> > ceil( (nvl(hwm,1)* &&blksize) /1024/1024 ) || 'm;' cmd > > > >> > > > >> > > > > >> > > > >> > from dba_data_files a, > > > >> > > > >> > > > > >> > > > >> > ( select file_id, max(block_id+ blocks-1) hwm > > > >> > > > >> > > > > >> > > > >> > from dba_extents > > > >> > > > >> > > > > >> > > > >> > group by file_id ) b > > > >> > > > >> > > > > >> > > > >> > where a.file_id = b.file_id(+) > > > >> > > > >> > > > > >> > > > >> > and ceil( blocks*&&blksize/ 1024/1024) - > > > >> > > > >> > > > > >> > > > >> > ceil( (nvl(hwm,1)* &&blksize) /1024/1024 ) > 0 > > > >> > > > >> > > > > >> > > > >> > / > > > >> > > > >> > > > > >> > > > >> > thx, > > > >> > > > >> > > > > >> > > > >> > Dody > > > >> > > > >> > > > > >> > > > >> > --- On Mon, 6/30/08, Rudy <[EMAIL PROTECTED] com> wrote: > > > >> > > > >> > > > > >> > > > >> > From: Rudy <[EMAIL PROTECTED] com> > > > >> > > > >> > > > > >> > > > >> > Subject: Re: [indo-oracle] resize tablepsace system > > > >> > > > >> > > > > >> > > > >> > To: indo-oracle@ yahoogroups. com > > > >> > > > >> > > > > >> > > > >> > Date: Monday, June 30, 2008, 1:05 AM > > > >> > > > >> > > > > >> > > > >> > Hi, utk tablespace system yg sdh disetting sebesar 3 GB , sebaiknya > > > >> jangan > > > >> > > > >> > dikecilkan. > > > >> > > > >> > > > > >> > > > >> > Apabila memang kurang dan file system nya sdh mencapai 3 GB, > sebaiknya > > > >> > > > >> > dibuatkan ke file lain dengan tablespace yg sama. > > > >> > > > >> > > > > >> > > > >> > Adapun langkahbnya sbb : > > > >> > > > >> > > > > >> > > > >> > Cek Space Masing-masing table space: > > > >> > > > >> > > > > >> > > > >> > select sum(bytes)/( 1024*1024) ,tablespace_ name,file_ name > > > >> > > > >> > > > > >> > > > >> > from dba_data_files > > > >> > > > >> > > > > >> > > > >> > where tablespace_name like '%SYS%' > > > >> > > > >> > > > > >> > > > >> > group by tablespace_name, file_name; > > > >> > > > >> > > > > >> > > > >> > Sedangkankan utk cek Free Space Tablespace sbb : > > > >> > > > >> > > > > >> > > > >> > select sum(bytes)/( 1024*1024) ,tablespace_ name > > > >> > > > >> > > > > >> > > > >> > from dba_free_space > > > >> > > > >> > > > > >> > > > >> > where tablespace_name like '%SYS%' > > > >> > > > >> > > > > >> > > > >> > group by tablespace_name > > > >> > > > >> > > > > >> > > > >> > Dan utk menambahkan size table space bisa mengunakan resize > tablespace > > > >> sbb > > > >> > > > >> > : > > > >> > > > >> > > > > >> > > > >> > alter database datafile '/data/applmgr/ proddata/ fax01.dbf' resize > > > 500m; > > > >> > > > >> > > > > >> > > > >> > Sedangkan utk menambahkan file utk table space sbb : > > > >> > > > >> > > > > >> > > > >> > alter tablespace GLD add datafile '/data/appltest/ testdata/ > > > gld02.dbf' > > > >> > > > >> > size 10m; > > > >> > > > >> > > > > >> > > > >> > Regard's > > > >> > > > >> > > > > >> > > > >> > Rudy > > > >> > > > >> > > > > >> > > > >> > --- On Mon, 6/30/08, dody osmon <dodytanjung79@ yahoo.com> wrote: > > > >> > > > >> > > > > >> > > > >> > From: dody osmon <dodytanjung79@ yahoo.com> > > > >> > > > >> > > > > >> > > > >> > Subject: [indo-oracle] resize tablepsace system > > > >> > > > >> > > > > >> > > > >> > To: indo-oracle@ yahoogroups. com > > > >> > > > >> > > > > >> > > > >> > Date: Monday, June 30, 2008, 11:17 AM > > > >> > > > >> > > > > >> > > > >> > Hai, > > > >> > > > >> > > > > >> > > > >> > salam kenal semua, bagaimana cara untuk resize tablepspace system yg > > > >> besar > > > >> > > > >> > nya sudah 3 giga, padahal yang ke pakai cuma 500 M, sudah di coba > pake > > > >> alter > > > >> > > > >> > tablespace resize, tetapi tidak bisa . > > > >> > > > >> > > > > >> > > > >> > Thx > > > >> > > > >> > > > > >> > > > >> > [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] > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > Yahoo! Toolbar is now powered with Search Assist.Download it now! > > > >> > > > >> > http://sg.toolbar. yahoo.com/ > > > >> > > > >> > > > > >> > > > >> > [Non-text portions of this message have been removed] > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> -- > > > >> > > > >> Cheers, > > > >> > > > >> Yoel Susanto > > > >> > > > >> www.indo-oracletech .com > > > >> > > > >> [Non-text portions of this message have been removed] > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> [Non-text portions of this message have been removed] > > > >> > > > >> > > > >> > > > > > > > > > > > > > > > > -- > > > > Cheers, > > > > Yoel Susanto > > > > > > > > www.indo-oracletech .com > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ------------ --------- --------- ------ > > > > > > > > -- > > > > -----------I. N.D.O - O.R.A.C.L.E- --------- ----- > > > > Keluar: indo-oracle- unsubscribe@ yahoogroups. com<indo-oracle- > unsubscribe% 40yahoogroups. com> > > > > Website: http://indooracle. wordpress. com > > > > ------------ --------- --------- --------- -------- > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > http://indo- thin.blogspot. comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > -- > > Cheers, > > Yoel Susanto > > www.indo-oracletech .com > > [Non-text portions of this message have been removed] > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
