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
