Monday, October 13, 2008

 

What Do a Few Bits Matter

I’ve mentioned several times that I strongly recommend running Oracle for Windows using 64-bit. I’ve had a number of questions about this, so I wanted to clarify the importance of 64-bit Oracle on Windows. If you look back, you will see that this is the subject of my first blog back in May of 2006.

Oracle on Microsoft Windows is unlike any other platform that Oracle supports. When Oracle was originally ported to windows, the decision was made to take advantage of Windows threads. A thread, sometimes known as a lightweight process shares the same context as the calling process, thus the context switch is replaced by a thread switch (which uses much less CPU resources). With Oracle for windows, all traditional processes (background and server) are implemented as threads. This provides for more efficient processing, but causes another problem.

Within the thread model, all threads within a process share the same virtual memory address space. With Windows 32-bit, this virtual address space is 3 GB in size (with /3GB flag, 2 GB otherwise). Thus all of the Oracle processes share the same 3 GB virtual memory limit. In a process environment such as Unix, each process has its own 3 GB virtual memory address space. This limitation can cause the virtual memory space to be completely used, thus causing failures. The symptom of this in 32-bit Oracle is a failure to allocate memory for new dedicated server processes.

This problem has been solved with the 64-bit version of Oracle for Windows. The 64-bit version of Oracle for Windows supports a 16 Terabyte virtual memory limit. In addition, memory above 4 GB can be accessed directly, indirect data buffers need not be used. This makes the use of memory above 4 GB much more efficient and faster.
When implementing Oracle with an SGA that is more than 4 GB in size I always recommend the use of large memory pages. Large memory pages are much more efficient for large SGAs and makes a huge performance difference, but that’s going to be the subject of my next blog. For information on how to use large memory pages in Oracle on Windows see Metalink note 422844.1.

The limitations in this article lead me to strongly recommend the use of 64-bit Oracle on 64-bit Windows. So, "Just say no, to Oracle on 32-bit Windows".

Comments:
放鬆心情自由自在的來一趟花蓮旅遊,可以感受花蓮民宿各種不同的風味,所以來花蓮一定要住花蓮民宿哦!因為可從花蓮民宿主人那裡分享到不一樣的花蓮旅遊經驗及花蓮美食道地的花蓮小吃,所以來花蓮旅遊不一定就要享受花蓮高級餐廳的花蓮美食也可以多試試道地古早味的花蓮美味哦!來花蓮民宿可以放鬆整個心情,來花蓮電腦住宿也可以放空自已,來花蓮也可以了解在地的文化哦!住民宿其實是很輕鬆的,住花蓮民宿其實是很容易,還有就是現在是高油價的時代,還自行開車來花蓮嗎?來花蓮租車會比較輕鬆哦!來花蓮房屋租車會比較省錢哦!或是可以請花蓮計程車帶您包車旅遊喔!!歡迎來住住美麗的花蓮民宿囉!!一定要讓您來花蓮旅遊並且讓您愛上花蓮民宿,還有團購美食好吃的蜂蜜蛋糕、養顏美容的蜂王乳以及蜂膠喔!!
 
WOW!!This is the information which I was looking forward.
Thanks you so much for sharing such a useful information over here.This is really a great blog have you written.I really enjoyed reading your article.I will be look forward to read your next post.
Silagra
 
Hello,

Great information you have shared with us. I just want to leave a little comment to support you. Your post is great. Thanks for sharing this post....

Thanks & Regards,
Generic Viagra

 
Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?