CPUs/memory

ashley75 · 02-06-2006, 12:21 PM

hi all,

what command can you use to find out which session use the most CPU and memory on the server???

thanks so much to all.

jlliagre · 02-06-2006, 12:25 PM

It would help if you tell more about what sessions are these.

ashley75 · 02-06-2006, 01:06 PM

that's what I am trying to find out.

I have about 15 databases running on this Linux server and it's max out CPU so I am trying to find out which database or who is doing what on the server.

thanks,

jlliagre · 02-06-2006, 02:48 PM

Quote:

Originally Posted by ashley75

that's what I am trying to find out.

I have about 15 databases running on this Linux server and it's max out CPU so I am trying to find out which database or who is doing what on the server.

thanks,

Please explain what do you first call a session and perhaps now a database. It's hard to provide help when you give so little clue about what is running on your system.

Have you tried the "top" command ?

Tinkster · 02-06-2006, 03:38 PM

Well "top" should help hunting down the culprit in terms
of the PID that hogs CPU. As for the actual DB session:
it all depends on the database system.

Cheers,
Tink