Home » RDBMS Server » Server Administration » SGA and Memory Mapping
SGA and Memory Mapping [message #244535] Wed, 13 June 2007 04:30 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

OS - HP Unix
Ver - 9.2.0.7

Following is my SGA
SQL> show sga

Total System Global Area 1034907984 bytes
Fixed Size                   737616 bytes
Variable Size             385875968 bytes
Database Buffers          637534208 bytes
Redo Buffers               10760192 bytes


From above, I'm using around 1GB as SGA.

How can I findout which process's using this memory. Basically I want to co-relate the SGA and OS process memory.

Brayan.
Re: SGA and Memory Mapping [message #244539 is a reply to message #244535] Wed, 13 June 2007 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SGA is Shared Area, so every process is using it.
It is not in a process memory, it is a shared segment.

Regards
Michel

[Updated on: Wed, 13 June 2007 04:44]

Report message to a moderator

Re: SGA and Memory Mapping [message #244540 is a reply to message #244535] Wed, 13 June 2007 04:47 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi Michel,
Quote:
SGA is Shared Area, so every process is using it.



Is this means, in this case the Entire SGA is not occupied the memory??

Brayan
Re: SGA and Memory Mapping [message #244545 is a reply to message #244540] Wed, 13 June 2007 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The entire SGA IS in memory (otherwise you have a problem).
But it is not attached to a process.

Regards
Michel
Re: SGA and Memory Mapping [message #244547 is a reply to message #244535] Wed, 13 June 2007 05:02 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Yes, For SGA the momory is allocated.

Now, I want to find how much SGA is allocated from OS Angle, but not as a DBA from SQL PROMPT.

At the end, I want to match these both.

Brayan.
Re: SGA and Memory Mapping [message #244562 is a reply to message #244547] Wed, 13 June 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show sga gives you the size of shared segment minus a block size.
SQL> show sga
Total System Global Area  536870912 bytes
Fixed Size                  2030264 bytes
Variable Size             167773512 bytes
Database Buffers          360710144 bytes
Redo Buffers                6356992 bytes
SQL> !ipcs -ma | grep 5368
m         14   0x70f92334 --rw-rw----   ... 536879104 ...
SQL> !echo 536879104-536870912 | bc
8192

(Sensitive data were removed and replaced by ...)

Regards
Michel

[Updated on: Wed, 13 June 2007 06:45]

Report message to a moderator

Re: SGA and Memory Mapping [message #244565 is a reply to message #244535] Wed, 13 June 2007 06:29 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi Michel,

Thanks a lot.

Regards,
Ronald.
Re: SGA and Memory Mapping [message #244581 is a reply to message #244565] Wed, 13 June 2007 07:39 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hi Michel,

In your above example, How you have get the process ID 5368....

!ipcs -ma | grep 5368
Re: SGA and Memory Mapping [message #244587 is a reply to message #244581] Wed, 13 June 2007 08:01 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
He was grepping for the amount of Total System Global Area, not needing to type the entire string.
Re: SGA and Memory Mapping [message #244612 is a reply to message #244587] Wed, 13 June 2007 08:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct!

Regards
Michel
Previous Topic: Regarding Oracle Achitecture
Next Topic: A bit confused with the constraints
Goto Forum:
  


Current Time: Sun Dec 04 22:41:31 CST 2016

Total time taken to generate the page: 0.20940 seconds