terima kasih atas pencerahaannya pak bos Leo.. hehehehe..
On Jan 22, 2008 4:17 PM, Leonard Sukendro <[EMAIL PROTECTED]> wrote: > > to pak andes... > > menurut saya sech perlu, boss... > emang bner sech, tp klo emank kebetulan ada bbrp > proses sorting yg jalan bareng n proses itu perlu tmpt > pdhl tablespace TEMPnya gk bisa di extend, bakal ada > error "cannot extend ... on tablespace TEMP", boss.. > tp emank extend nya juga mesti kira2, takutnya stlh > proses2 extend itu selesai, spacenya jadi idle.. nach, > utk perhitungan kira2nya itu, saya jg bln bisa, boss > hehe. > bnernya akan lbh bagus klo smua proses sortingnya bisa > dilakuin di sort_area_size (di oracle9i) sech, jd gk > prlu ampe ke tablespace TEMP, tp khan jadinya boros > memory :D.. > > moga2 membantu, boss... > > CMIIW, > [L] > > --- Andes Febrian <[EMAIL PROTECTED] <pejantan4u%40gmail.com>> wrote: > > > Pak dan bos, ikutan nanya nie.. jadi sebenarnya klo > > tablespace temp udah > > mencapai limit, sebenernya perlu gak di extend ? > > atau dibiarin aja karena > > proses sorting kan di flush nanti klo udah selesai ? > > dan tablespace temp > > akan berkurang kan ? begitu jg tablespace undotbs. > > begitu bukan ? > > > > terima kasih > > 2008/1/17 Eko Febriyanto <[EMAIL PROTECTED] <kelinciku%40gmail.com>>: > > > > > wah tengkyu om :D soalnya baru nih make2 oracle > > :D dan bingung kalo > > > temp nya udah mendekati limit datafile nya, ya > > saya set extend aja > > > atau saya modifikasi size nya heheheheheh > > > > > > > > > On Jan 17, 2008 11:07 AM, Leonard Sukendro > > <[EMAIL PROTECTED] <leon_190699%40yahoo.com><leon_190699%40yahoo.com>> > > > > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > to pak eko, > > > > > > > > temporary tablespace gmana? baek2 aja, boss hehe > > > > maksudnya gmana ya, boss? > > > > klo secara cara kerja sech kira2 sama dgn undo, > > > > boss... stlh proses sortingnya selesai, bakal di > > > > flush. > > > > seinget saya, klo ada proses sorting yg lbh > > besar dr > > > > temporary tablespacenya, proses sortingnya bakal > > di > > > > pecah, boss.. (tp ini seinget saya lho hehe) > > > > > > > > klo mo liat pemakaian tempfile bisa pake script > > ini, > > > > boss.. > > > > select substr(a.username,1,10) username, > > > > substr(b.TABLESPACE,1,15) TEMP_ts, > > > > substr(c.temporary_tablespace,1,15) > > > > Def_TEMP_ts, > > > > a.sid, > > > > a.serial#, > > > > substr(a.module,1,15) module, > > > > (b.blocks*8192)/(1024*1024) "temp used by sort > > > > (MB)", > > > > temp.bytes/(1024*1024) "total temp tbspc > > > > (MB)", > > > > temp.maxbytes/(1024*1024) "autoextnd max temp > > > > tbspc (MB)", > > > > to_char(logon_time,'dd-mm-yyyy hh24:mi:ss') > > > > logon_time, > > > > a.STATUS > > > > from v$session a, > > > > v$sort_usage b , > > > > dba_users c, > > > > dba_temp_files temp > > > > where a.saddr=b.session_addr > > > > and c.username = a.username > > > > and b.TABLESPACE = temp.tablespace_name > > > > order by b.blocks desc, decode(a.STATUS, > > 'ACTIVE', 1, > > > > 'INACTIVE', 2, > > > > 'KILLED', 3); > > > > > > > > ato ini, boss: > > > > > > > > SELECT b.tablespace, > > > > b.segfile#, > > > > b.segblk#, > > > > b.blocks, > > > > a.sid, > > > > a.serial#, > > > > a.username, > > > > a.osuser, > > > > a.status > > > > FROM v$session a, > > > > v$sort_usage b > > > > WHERE a.saddr = b.session_addr > > > > ORDER BY b.tablespace, > > > > b.segfile#, > > > > b.segblk#, > > > > b.blocks; > > > > > > > > moga2 bisa membantu, pak.. > > > > > > > > regards, > > > > [L] > > > > > > > > > > > > > > > > --- Eko Febriyanto <[EMAIL PROTECTED] <kelinciku%40gmail.com> > > <kelinciku%40gmail.com>> wrote: > > > > > > > > > @ pak Leonard, > > > > > > > > > > saya mau tanya bagaimana dengan temporary > > tablespace > > > > > pak? > > > > > > > > > > 2008/1/15 Leonard Sukendro > > <[EMAIL PROTECTED] <leon_190699%40yahoo.com><leon_190699%40yahoo.com> > > > > > >: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > to pak firman... > > > > > > > > > > > > setau saya (n moga2 saya gk salah :D), isi > > > > > undotbs itu > > > > > > jg tgantung dr parameter undo_retention.. > > > > > > klo mo cepet2 di clear isinya, nilai dr > > parameter > > > > > > undo_retention itu di kecilin aja, boss... > > > > > > cmn kemungkinan efeknya klo nanti ada proses > > DML > > > > > yg > > > > > > lama.. pas proses itu bln kelar, waktu > > > > > > undo_retentionnya dh tercapai, prosesnya > > bakal > > > > > error.. > > > > > > biasanya kluar error "snapshot too old.. > > bla2" > > > > > > > > > > > > tp selama masi ada proses DML, undo gk > > mungkin > > > > > bner2 > > > > > > kosong, pasti masi ada isinya.. klo mo bner2 > > > > > kosong, > > > > > > mesti ikutin cara pak Syamsul, boss... > > > > > > > > > > > > moga2 membantu, boss... > > > > > > > > > > > > CMIIW, > > > > > > [L] > > > > > > > > > > > > --- Moch Firman N <[EMAIL PROTECTED] <mochfirman%40gmail.com> > > <mochfirman%40gmail.com>> > > > wrote: > > > > > > > > > > > > > Thanx ya atas feedback nya..., > > > > > > > klw soal googling sudah mas.... :D > > > > > > > > > > > > > > Oh iya, > > > > > > > Apa ada cara yg lebih halus.. tanpa > > meng-drop > > > > > undo > > > > > > > yg lama.. :) > > > > > > > cuma nge-clear ? > > > > > > > > > > > > > > danke, > > > > > > > > > > > > > > > > > > > > > On Jan 9, 2008 3:31 PM, Trio Syamsul Benny > > > > > > > <[EMAIL PROTECTED] <trio198%40gmail.com><trio198%40gmail.com>> > > > wrote: > > > > > > > > > > > > > > > Udah coba googling mas? > > > > > > > > > > > > > > > > Dulu pernah juga ngelakuin ini, caranya > > > > > kira2: > > > > > > > > - Login as sys. > > > > > > > > - Create undo tablespace ke dua. > > > > > > > > SQL> create undo tablespace UNDOTBS2 > > datafile > > > > > > > > "/oracle/oradata/codotdb/undotbs2.dbf" > > size > > > > > 1000m; > > > > > > > > - Set undo tablespace ke tablespace yang > > baru > > > > > itu > > > > > > > > SQL> alter system set > > > > > undo_tablespace=UNDOTBS2; > > > > > > > > - Drop old undo tablespace lam > > > > > > > > SQL> drop tablespace UNDOTBS1 including > > > > > contents; > > > > > > > > > > > > > > > > Klo didrop gak bisa, berarti masih > > dipake > > > > > > > undotbs1, coba force switch ke > > > > > > > > log > > > > > > > > berikutnya. > > > > > > > > > > > > > > > > -benny- > > > > > > > > > > > > > > > > > > > > > > > > On 1/9/08, Moch Firman N > > > > > <[EMAIL PROTECTED] <mochfirman%40gmail.com><mochfirman%40gmail.com> > > > > > > > <mochfirman%40gmail.com>> > > > === message truncated === > > __________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
