Wait Reason: SYSTM

[Paula J Frazer-Campbell]

HI

From this info you do not have many users on this system. and it is failry happy.



Your dbc_max_pct is allocating 1.8 Gig of approxx 1.4 gig could be released by changing it to 5 and dbc_min_pct to 1.

The attached doc will help.

The :-

? 8245 sybase 241 20 17472K 4380K run 1350:40 98.91 98.74 dataserv
3 ? 8226 sybase 241 20 17472K 4380K run 1380:32 98.88 98.71 dataserv

Seem very busy although the server is quiet.

Have you tried a reboot in order to try to resolve the delay?

Paula

[Paula J Frazer-Campbell]

Hi

In the Doc ignore the :-

"I would not be happy with a straight adjustment to 10% and feel that the safest option is to initially bring the setting down to 25% and if OK then readjust the size downwards to this "Just Enough" setting."

As I wrote this in respect of a particular server.

Paula

[Paula J Frazer-Campbell]

Gordon

From top:-

8 stopped

What are these ?

Paula