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
