OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » awr snapshots (oracle 10g,unix)

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

awr snapshots [message #450857]

Fri, 09 April 2010 14:23

ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...

Junior Member

I have a oracle 10g database for which i am running an awr snapshot. The os is unix. Now the snapshot is giving me the shared pool statistics. This has the memory utilisation at the beginning and the ending of the snapshot.How can i get the memory utilisation not just at the beginning and the end of the process but uniformly throughout the process??

[Updated on: Fri, 09 April 2010 14:25] by Moderator

Report message to a moderator

Re: awr snapshots [message #450858 is a reply to message #450857]

Fri, 09 April 2010 14:27

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

Senior Member
Account Moderator

What does "uniformly" means? every hour? every quarter? every minute? every second? every nanosecond?

Regards
Michel

Report message to a moderator

Re: awr snapshots [message #450860 is a reply to message #450858]

Fri, 09 April 2010 14:41

ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...

Junior Member

Every second...

Report message to a moderator

Re: awr snapshots [message #450861 is a reply to message #450860]

Fri, 09 April 2010 14:47

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

Senior Member
Account Moderator

This information does not exist.

Regards
Michel

Report message to a moderator

Previous Topic:	hash join vs nested loops
Next Topic:	Using 9i stored outlines by 11g SPM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 14 07:35:47 CDT 2025