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]> 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]> wrote: > > > @ pak Leonard, > > > > saya mau tanya bagaimana dengan temporary tablespace > > pak? > > > > 2008/1/15 Leonard Sukendro <[EMAIL PROTECTED]>: > > > > > > > > > > > > > > > > > > > > > > > > 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]> 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]> 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>> > > > > > 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
