makasih pak leo dan yg lain. tp klo misal bener gara2 tablespace undo yg penuh, cara terbaik di extend atau gmn ya ?
On 2/4/08, Leonard Sukendro <[EMAIL PROTECTED]> wrote: > > tp pak andes, > > utk liat retentionnya, bisa dliat di parameter > "undo_retention", boss.. "show parameter retention;" > klo emank ketinggian, di alter aja, boss... tp ati2, > takutnya ntar klo kekecilan malah jadi error "snapshot > too old...." > > utk tau tablespace undonya dr sqlplus, bisa pake > script ini, boss: > col name form a35 > > select a.tablespace_name, > a.status, > a.total_space-b.free_space as used_space, > b.free_space as free_space, > a.total_space as total_space > from (select tablespace_name, > status, > sum(bytes) as total_space > from dba_data_files > group by tablespace_name, status) a, > (select distinct tablespace_name, > sum(bytes) free_space > from dba_free_space > group by tablespace_name) b > where a.tablespace_name=b.tablespace_name; > > CMIIW, > [L] > > --- Andes Febrian <[EMAIL PROTECTED]> wrote: > > > gmn tau nya retention ketinggian ? dan klo memang, > > apa yg harus di lakukan ? > > > > 2008/1/31 Stefanus Gunawan <[EMAIL PROTECTED]>: > > > > > di cek Undo Tablespacenya mas.... mungkin full > > dan retentionnya > > > ketinggian. > > > > > > Andes Febrian <[EMAIL PROTECTED] > > <pejantan4u%40gmail.com>> wrote: Dear > > > all, mohon pencerahannya, kenapa ya ketika syntax > > update suatu row di > > > > > > jalankan, maka konsumsi memory di server jadi > > tinggi, ketika saya ketik > > > top > > > (server linux) maka %CPU jadi 99% ? tadinya tidak > > pernah seperti ini > > > ketika > > > syntax update tersebut dijalankan. menurut > > perkiiraan saya, user ada yg > > > update tp entah knp dia blm commit2, ketika ada > > user lain yg mau update, > > > ketahan, jadi bikin load CPU tinggi. tp bener ga > > yg sepert ini bisa buat > > > cpu > > > load jadi tinggi ? > > > > > > saya liat jg di top sql pada em, syntax update ini > > membuat wait jadi 98% > > > tp > > > activity hanya 48%. mohon bantuannya, apa yg harus > > saya lakukan ? > > > > > > -- > > > Cheers, > > > ^_^ Andes ^_^ > > > > > > [Non-text portions of this message have been > > removed] > > > > > > --------------------------------- > > > Looking for last minute shopping deals? Find them > > fast with Yahoo! Search. > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > -- Cheers, ^_^ Andes ^_^
