Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

About ipcs -a command

523473Oct 18 2010 — edited Oct 21 2010
Hi,

I have question about ipcs -a command on Red Hat Enterprise Linux Server release 5.5 (Tikanga).
I have two nodes with sam version of OS (Red Hat Enterprise Linux Server release 5.5 (Tikanga)).

1) First node
Oracle 10gR2 (10.2.0.5)

2) Second node
Oracle 11gR2 (11.2.0.1)

I have started instances on both nodes, and I have typed the command ipcs -a.

On the first node I have seen regular memory allocation record like this.


SQL> show sga

Total System Global Area *285212672* bytes
Fixed Size 1273276 bytes
Variable Size 176161348 bytes
Database Buffers 104857600 bytes
Redo Buffers 2920448 bytes
SQL> !ipcs -a

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 1933313 root 644 52 2
0x00000000 1966083 root 644 16384 2
0x00000000 1998852 root 644 268 2
0xda4276d4 2392079 oracle 640 *287309824* 16

------ Semaphore Arrays --------
key semid owner perms nsems
0xae3af024 131073 oracle 640 154

------ Message Queues --------
key msqid owner perms used-bytes messages


On the second node I do the same, but>


SQL> show sga

Total System Global Area *1071333376* bytes
Fixed Size 1341312 bytes
Variable Size 763365504 bytes
Database Buffers 301989888 bytes
Redo Buffers 4636672 bytes
SQL> !ipcs -a

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 2064385 root 644 52 2
0x00000000 2097155 root 644 16384 2
0x00000000 2129924 root 644 268 2
0xf51b80a8 2424838 oracle 660 *4096* 0

------ Semaphore Arrays --------
key semid owner perms nsems
0x7d144704 524289 oracle 660 154

------ Message Queues --------
key msqid owner perms used-bytes messages


Can anybody could me explain this situation.
How to see from OS on 11gr2 how much memory is allocated for SGA?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2010
Added on Oct 18 2010
3 comments
1,547 views