database i kapat
su - oracle
sqlplus
sys as sysdba
shutdown immediate;
tmpfs boyutunu artır
[root@localhost:~]# cat /etc/fstab | egrep "^tmpfs"
tmpfs /dev/shm tmpfs size=8000m 0 0
umount /dev/shm && mount /dev/shm
[root@localhost:~]# df -kh | grep tmpfs
tmpfs 7,9G 3,6G 4,3G 46% /dev/shm
database i aç
su - oracle
sqlplus
sys as sysdba
startup
database ayarlarını gerçekleştir.
su - oracle
sqlplus
sys as sysdba
create pfile='/tmp/calisan_pfile_backup.ora' from spfile;
alter system set memory_target=6G SCOPE=SPFILE;
alter system set memory_max_target=6G SCOPE=SPFILE;
database i kapat ve tekrar aç
su - oracle
sqlplus
sys as sysdba
shutdown immediate;
startup
No comments:
Post a Comment