Home » Infrastructure » Windows » Gathering resource usage (Windows server,10.2.0.3)
Gathering resource usage [message #472609] Mon, 23 August 2010 00:39 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi I want to find out how much system resources are utilised on my DB server during a particular point of time.How can I check that?

Report message to a moderator

Re: Gathering resource usage [message #472613 is a reply to message #472609] Mon, 23 August 2010 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Windows monitor.

Regards
Michel

Report message to a moderator

Re: Gathering resource usage [message #472633 is a reply to message #472613] Mon, 23 August 2010 02:02 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
U mean Task manager??But I also need to know how much transactions where at that time and number of disk I/O s .

Report message to a moderator

Re: Gathering resource usage [message #472640 is a reply to message #472633] Mon, 23 August 2010 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I mean Windows performances monitoring tool: %SystemRoot%\system32\perfmon.msc
You can even add Oracle performances counter in it.

Regards
Michel

Report message to a moderator

Re: Gathering resource usage [message #472646 is a reply to message #472640] Mon, 23 August 2010 02:29 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Can we see things like number of transactions,I/o during the transaction,SGA usage during that period using this?Can you tel me how

Report message to a moderator

Re: Gathering resource usage [message #472666 is a reply to message #472646] Mon, 23 August 2010 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For this use Statspack/AWR and/or query v$ views.

Regards
Michel

Report message to a moderator

Re: Gathering resource usage [message #472669 is a reply to message #472666] Mon, 23 August 2010 03:29 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Can you give me some link where I can get a detailed study of these...

Report message to a moderator

Re: Gathering resource usage [message #472671 is a reply to message #472669] Mon, 23 August 2010 03:33 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Can we see the performance in enterprise manager for that database....

Report message to a moderator

Re: Gathering resource usage [message #472676 is a reply to message #472671] Mon, 23 August 2010 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ I don't use EM
2/ Database Performance Tuning Guide

Regards
Michel

Report message to a moderator

Re: Gathering resource usage [message #472686 is a reply to message #472676] Mon, 23 August 2010 04:29 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Michel thanks for the link but actually I am in a hurry.

If you dont mind can you give me the query for finding number of transactions,resource using that period(cpu,memory,I/O's).It will be very helpful because if I go through the doc it will take time..

Report message to a moderator

Re: Gathering resource usage [message #472690 is a reply to message #472686] Mon, 23 August 2010 04:48 Go to previous message
Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But if you do not, you will also be in a hurry the next time and so on, and we will do your work for you forever.

Regards
Michel

Report message to a moderator

Previous Topic: export with dynamic file name
Next Topic: Error Message - ORA-27101
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 30 08:12:44 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.