SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 12096M
memory_target big integer 12096M
shared_memory_address integer 0
[oracle@ORACLE ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p2 24G 4,0G 19G 18% /
/dev/cciss/c0d0p5 766G 345G 382G 48% /opt
/dev/cciss/c0d0p1 190M 18M 163M 10% /boot
tmpfs 13G 7,7G 5,4G 60% /dev/shm
shmfs 13G 7,7G 5,4G 60% /dev/shm
[root@ORACLE ~]# cat /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/opt /opt ext3 defaults 1 2
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SW-cciss/c0d0p3 swap swap defaults 0 0
shmfs /dev/shm tmpfs size=13g 0
[root@ORACLE ~]# umount /dev/shm
umount: zařízení /dev/shm je již používáno
umount: zařízení /dev/shm je již používáno
umount: zařízení /dev/shm je již používáno
SQL> shutdown immediate
Databaze zavrena.
Databaze odpojena (dismounted).
Instance ORACLE uzavrena.
[root@ORACLE ~]# umount /dev/shm
mount -t tmpfs shmfs -o size=18g /dev/shm
[root@ORACLE ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p2 24G 4,0G 19G 18% /
/dev/cciss/c0d0p5 766G 345G 382G 48% /opt
/dev/cciss/c0d0p1 190M 18M 163M 10% /boot
tmpfs 18G 0 18G 0% /dev/shm
shmfs 18G 0 18G 0% /dev/shm
SQL> startup
SQL> alter system set memory_target=18G scope=both;
System zmenen.
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 18G
memory_target big integer 18G
shared_memory_address integer 0
Komentáře