| Manual database creation [message #63511] |
Tue, 12 October 2004 03:22  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi All, I am creating a Database (9i) on Win 2k machine manually. I created the service, pfile, etc
To run the CREATE DATABASE script when i gave
SQL> Startup nomount
I got this message:
ORA-27102: out of memory
OSD-00026: Message 26 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1455) The paging file is too small for this operation to complete
Plez tell me wat to do to solve the problem
Vivek
|
|
|
|
| Re: Manual database creation [message #63524 is a reply to message #63511] |
Wed, 13 October 2004 04:23  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
First, on Win2K Pro and Win2K Server, your pagefile.sys should be 2 or 3 times the size of your RAM. If you have 4 GB RAM, and Windows only allows 4 GB of pagefile per partition, then you would need to partition your disk into two or more pieces with 4 GB on each.
Second, if you are using more than some percentage of RAM (like 60%) then Windows will become more aggresive in paging your processes/threadspace to disk. This compounds my first point.
-Mark
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
