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]>: > 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>> > 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>> wrote: > > > > > @ pak Leonard, > > > > > > saya mau tanya bagaimana dengan temporary tablespace > > > pak? > > > > > > 2008/1/15 Leonard Sukendro <[EMAIL PROTECTED]<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>> > 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>> 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>> > > > > > > wrote: > > > > > > > > > > > > > > Dear All, > > > > > > > > > > > > > > Untuk meng-clear tablespace undo cara-nya > > > > > gimana? Ada yg bisa ngasih > > > > > > > penjelasan..!!! > > > > > > > > > > > > > > Terima kasih, > > > > > > > > > > > > > > Best regards > > > > > > > Moch Firman N > > > > > > > > > > > > > > [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] > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________________ > > > > Looking for last minute shopping deals? > > > > Find them fast with Yahoo! Search. > > > > > > > > > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > > > > > > > > > > > > > > > > -- > > > i love being baud wanderer > > > > > > > __________________________________________________________ > > Be a better friend, newshound, and > > know-it-all with Yahoo! Mobile. Try it now. > > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > > > > -- > i love being baud wanderer > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
