Posted by Mahendran Manickam
Introduction:
We are going to see how to resolve ORA-27102: out of memory
Solution:
You have started up with pfile.
1. Remove SGA_* parameters from your pfile.
In pfile, Change your MEMORY_MAX_TARGET=500M
MEMORY_TARGET=500M
Save the file.
2. Perform the following:
SQL> startup nomount pfile=’\u01\app\oracle\pfile\pfile.ora’;
SQL> alter database mount;
SQL> alter database open;
NOTE :
- MEMORY_TARGET is a database initialization parameter (introduced in Oracle 11g) that can be used for automatic PGA and SGA memory sizing.
- We can increase the value of MEMORY_TARGET parameter to MEMORY_MAX_TARGET, if we will try to increase it more from the size of max parameter it will throw error.
Recommended Posts