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]> 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]>:
>
> > 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>>
>
=== message truncated ===
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
