SQL> startup mount pfile='/tmp/initdlfasp12.ora'
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
This as you can see is on Linux x86 with 64 bit processor. We got this error after we changed SGA on 10gR2 database. So was sure that this is something to do with the OS.
Parameters to check for this are shmall.
shmall is the total amount of shared memory, in pages, that the system can use at one time.
$cat /proc/sys/kernel/shmmax
53687091200
$ getconf PAGE_SIZE
4096
As per Oracle SHMALL should be set to the total amount of physical RAM divided by page size.
Our system has 64GB memory, so change kernel.shmall = 1024 * 1024 * 1024 * 64 / 4096 = 16777216
Once this value is calculated you can modify Linux system configuration file directly.
$ su - root
vi /etc/sysctl.conf file:
kernel.shmall=16777216
and
# sysctl -p
Once this is done the database was started without any problem.
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
This as you can see is on Linux x86 with 64 bit processor. We got this error after we changed SGA on 10gR2 database. So was sure that this is something to do with the OS.
Parameters to check for this are shmall.
shmall is the total amount of shared memory, in pages, that the system can use at one time.
$cat /proc/sys/kernel/shmmax
53687091200
$ getconf PAGE_SIZE
4096
As per Oracle SHMALL should be set to the total amount of physical RAM divided by page size.
Our system has 64GB memory, so change kernel.shmall = 1024 * 1024 * 1024 * 64 / 4096 = 16777216
Once this value is calculated you can modify Linux system configuration file directly.
$ su - root
vi /etc/sysctl.conf file:
kernel.shmall=16777216
and
# sysctl -p
Once this is done the database was started without any problem.
Comments
please.
my mail: kfirdabush@gmail.com
Thanks a lot.
Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.
I am trying to browse my tabular model using SSMS Tabular model Browse option wherein I am pulling up measures on measure panel and dimension attributes on rows and filtering data using SLICERS however when I am executing that, it is taking time almost 1 min and when I wrote Summarize DAX for the combination, it executed in less time around 15 sec.....Is this is expected behavior and why it is so big difference.
It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
Keep up the good work!
Thank you,
Irene Hynes