| SGA and Memory Mapping [message #244535] |
Wed, 13 June 2007 04:30  |
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 #244547 is a reply to message #244535] |
Wed, 13 June 2007 05:02  |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
