Před

[root@dbserver ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
 28G 11G 15G 42% /
/dev/sda1 99M 27M 68M 29% /boot
tmpfs 3.9G 0 3.9G 0% /dev/shm
/dev/mapper/VolGroup01-LogVol00
 296G 276G 5.3G 99% /oradata
/dev/mapper/VolGroup02-LogVol00
 20G 4.3G 15G 23% /oracle
/dev/sdd1 197G 90G 98G 48% /dump

[root@dbserver ~]# cat /proc/meminfo
MemTotal: 8174448 kB

Úprava

[root@gtxe1d5 ~]# vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=6g 0 0

[root@dbserver ~]# mount -o remount /dev/shm
[root@dbserver ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
 28G 11G 15G 42% /
/dev/sda1 99M 27M 68M 29% /boot
tmpfs 6.0G 0 6.0G 0% /dev/shm

SQL> show parameter memory

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
SQL> alter system set memory_max_target=6g scope=spfile;

System altered.

SQL> alter system set memory_target=6g scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size 2265224 bytes
Variable Size 4563406712 bytes
Database Buffers 1828716544 bytes
Redo Buffers 19292160 bytes
Database mounted.
Database opened.

Potom

SQL> show parameter memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 6G
memory_target big integer 6G
shared_memory_address integer 0

Komentáře