on 09-23-2008 9:08 AM
Hi there,
We are running MaxDB 7.6.05.09 64bit on an SLES 9 64bit.
MAXCPU is 2.
sdb 6978 0.0 0.0 108616 6120 ? Ssl Sep20 0:00 /sapdb/PF1/db/pgm/kernel PF1
sdb 6984 4.4 11.9 1887800 976996 ? Sl Sep20 195:23 /sapdb/PF1/db/pgm/kernel PF1
Question:
Why does the second database kernel Process not use any CPU Time?
Is this normal? (0:00 vs 195:23 seconds)
Regards
Manuel
Yes.
MaxDB is a multi-THREADED database, you will see only one process but it has many threads. The fist process is just the "starter", it forks the second one which is then the actual database.
You can check the threads by using
ps -ef -L
To see what the database threads are doing, login as sqd<SID> and execute
x_cons <SID> sh ac 1
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.