[oracle@rh6 ~]$ ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 0 root 644 52 2
0x00000000 32769 root 644 16384 2
0x00000000 65538 root 644 268 2
0x4b4218ec 622600 oracle 660 4096 0
------ Semaphore Arrays --------
key semid owner perms nsems
0xbe61d9cc 1114115 oracle 660 154
------ Message Queues --------
key msqid owner perms used-bytes messages
发现分配给Oracle的共享内存仍然很小，看来不是memory_target 参数的问题！
2、尝试调整memory_max_target参数，将其恢复到系统默认值：
16:39:49 SYS@ test3 >alter system set sga_max_size=300m scope=spfile;
System altered.
16:40:06 SYS@ test3 >alter system reset memory_max_target scope=spfile sid='*';
System altered.
16:40:40 SYS@ test3 >startup force nomount;
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 205524056 bytes
Database Buffers 100663296 bytes
Redo Buffers 6336512 bytes
16:40:52 SYS@ test3 >show parameter mem
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
16:40:59 SYS@ test3 >show parameter sga
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 180M
查看系统共享内存:
[oracle@rh6 ~]$ ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 0 root 644 52 2
0x00000000 32769 root 644 16384 2
0x00000000 65538 root 644 268 2
0x4b4218ec 884744 oracle 660 316669952 16
------ Semaphore Arrays --------
key semid owner perms nsems
0xbe61d9cc 1638403 oracle 660 154
------ Message Queues --------
key msqid owner perms used-bytes messages
看来是设置了memory_max_target参数的原因，导致通过ipcs查看到分配给Oracle的内存为4096Bytes！