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: 68650
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 12 09:38:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.