[dicipulofer]

Hello..

My database's very slow... I'd like know if there are some sql to know what process's more slow..... and what is getting more memory...


Thanks..
Fernando.

[dicipulofer]

I ran the sql.... and see that my phylog percent free's just in 2 percent..

It's bad to my database ?


select name[1,8] dbspace, -- name truncated to fit on one line
sum(chksize) Pages_size, -- sum of all chunks size pages
sum(chksize) - sum(nfree) Pages_used,
sum(nfree) Pages_free, -- sum of all chunks free pages
round ((sum(nfree)) / (sum(chksize)) * 100, 2) percent_free
from sysdbspaces d, syschunks c
where d.dbsnum = c.dbsnum
group by 1
order by 1;



dbspace percent free
loglog 18.99
phylog 2.23
prddbs 26.10
prdtmp1 99.45
prdtmp2 99.48
rootdbs 84.44

[gurey]

Hi,

I suggets that run update statistics for all database, next run:
set explain on avoide_execute;
SELECT ..........

Then verify performance.

Gustavo.

[ceinma]

onstat -g ses
onstat -g mem