OraFAQ Forum: Windows » Gathering resource usage

Home » Infrastructure » Windows » Gathering resource usage (Windows server,10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Gathering resource usage [message #472609]

Mon, 23 August 2010 00:39

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 03:03:41 CDT 2025