Home » RDBMS Server » Server Administration » Database resources
Database resources [message #684032] Fri, 26 March 2021 08:38 Go to next message
JackBauer
Messages: 24
Registered: February 2021
Junior Member
Hello,

If we have on a Linux server many instances, how can we check how much is consumed by each instance.

As far as CPU and memory?

Thanks
Re: Database resources [message #684033 is a reply to message #684032] Fri, 26 March 2021 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Linux has many tools/commands for this like top, sar, vmstat, pmap...

[Updated on: Fri, 26 March 2021 09:03]

Report message to a moderator

Re: Database resources [message #684034 is a reply to message #684032] Sat, 27 March 2021 02:15 Go to previous messageGo to next message
JackBauer
Messages: 24
Registered: February 2021
Junior Member
Yes, and which one would it be to check on the cpu and memory usage per instance?
Re: Database resources [message #684035 is a reply to message #684034] Sat, 27 March 2021 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I'd say ps (to get cpu usage), pmap (to get memory usage), sysresv (to get shared memory id), ipcs (to get shared memory size), sar...
I don't say it is easy, I say it is possible in this way but there is work to do.

Oracle had a script named "v8sppyw.ksh" and a tool named "OSWatcher" based on these tools, you can search on MOS for them (take care that some options require access to DBA_HIST option and so you have to be licensed for this).

Re: Database resources [message #684036 is a reply to message #684034] Sat, 27 March 2021 08:23 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
JackBauer wrote on Sat, 27 March 2021 00:15
Yes, and which one would it be to check on the cpu and memory usage per instance?

*NIX does a very poor job at reporting memory usage when Oracle is running on it due to the fact that SHARED GLOBAL AREA is mapped into every Oracle client memory space. Therefore if you blindly add up the MEMORY RESIDENCE size of all oracle client processes the total will be many times greater than physical memory in the system. It is a non-trivial exercise to decide when RAM is a system bottleneck & therefore when additional RAM would result in an increase is system performance & throughput.
Previous Topic: audit use of dynamic sql
Next Topic: Not able to hot clone remote pdb with same name
Goto Forum:
  


Current Time: Thu Mar 28 17:04:54 CDT 2024