Oracle on Windows

[ptheriault]

We currently have an Oracle 10g install running on a windows 2003 server. 64 Bit. There is 28GB of RAM on the server with 13 gb free. the page file size is only 4 gb. I have the following quote from Oracle.

Oracle recommends that total combined size of your page files be at least equal to physical RAM on your computer. Configurations where combined size is two to four times the size of physical RAM are not uncommon. Minimize paging as much as possible. But situations in which the operating system runs out of or low on paging space are to be avoided at all costs. Adequately-sized paging files spaced across physical disks spread out I/O most efficiently, because the operating system spreads paging evenly across page files.

I am the SR SQL Server DBA our Oracle DBA is suggesting that he would rather reduce the size of the page file to 200K and set the LOCK_SGA flag. We are experiencing excessive paging and I think this is going to make matters worse. Am I wrong? would the LOCK_SGA flag work?

- Paul
- Database performance looks fine, it must be the Network!

 

[raygg]

Does the Oracle DBA tell you how to run your SQL server databases?

 

[ptheriault]

We try to help each other out and offer advice! We work as a team. I would not turn down advice from someone just because SQL Server isn't their primary focus. I am trying to learn as much as I can about LOCK_SGA and how it interacts with Windows. from what I've been reading it might not be supported. I'm not trying to tell anyone how to set things up. But as a Sr DBA I have a responsibility to the company to get things right, SQL or Oracle. If you can help that would be great and I would be greatful, if not then don't bother posting again.

- Paul
- Database performance looks fine, it must be the Network!

 

[oradba101]

Hi, Paul

Perhaps this link will provide some insight

http://www.quest.com/whitepapers/orcl_db_mgmt.pdf

Or perhaps you can post your inquiry with Ask Tom on the Oracle website. He is very good at answering these types of questions. The link is:

http://asktom.oracle.com

Regards,



William Chadbourne
Oracle DBA

 

[ptheriault]

Thanks for the links Oradba. They were very helpful.

- Paul
- Database performance looks fine, it must be the Network!