Home » RDBMS Server » Performance Tuning » awr snapshots (oracle 10g,unix)
awr snapshots [message #450857] Fri, 09 April 2010 14:23 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
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
Re: awr snapshots [message #450860 is a reply to message #450858] Fri, 09 April 2010 14:41 Go to previous messageGo to next message
ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...
Junior Member

Every second...
Re: awr snapshots [message #450861 is a reply to message #450860] Fri, 09 April 2010 14:47 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This information does not exist.

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


Current Time: Fri Nov 22 08:20:20 CST 2024