The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: Noons <wizofo...@gmail.com>
Date: Sun, 11 Nov 2012 20:34:06 -0800 (PST)
Local: Sun, Nov 11 2012 11:34 pm
Subject: Re: Large pages
On Nov 12, 11:24 am, Mladen Gogala <gogala.mla...@gmail.com> wrote:
> > In Unix (unless you use intimate shared memory) you get one map per
Actually, that is not correct. The problem has to do with the memory
> > process - so an Oracle system with 1,000 processes would end up using as > > much memory for maps of the SGA as it would on the SGA itself if it were > > using standard pages. In Windows Oracle runs as a single process with map for ALL physical memory, the number of virtual memory processes using it is irrelevant. > Yup, that's precisely why I ask. Windows do not have SYSVR4 IPC
Should be exactly the same. The problem has to do with mapping
> mechanisms, probably because they do not belong to that family of > operating systems, and have completely different architecture. I played > with that once, but I no longer have access to the database I have built, > so I am asking around. virtual to physical memory for very large physical memory sizes. At 4K map per entry, a memory size of say, 50GB will easily force a TLA table that has in excess of 10 million entries, which have to be searched and resolved by the virtual memory firmware as well as the OS, for normal memory management as well as statement execution and branching. It's got nothing to do with the number of processes. The number of entries in the TLA table maps physical addresses to virtual addresses, how many processes use those virtual addresses is immaterial. The total size of the mapped physical memory does not change because a process is using it or not. You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||