DUHHH!! Now why didn't I think of that!! Having had to deal with installs of
our products on a couple of NUMA-Qs it should have sprung to mind - Guess
I'm still in holiday mode - or coffee deprived (I suspect both :)
Having said that - I still didn't know what NUMA stood for - Thanks for the
info Scott, Jared & Hannibal!
Regards
Mark
-----Original Message-----
[EMAIL PROTECTED]
Sent: Friday, June 22, 2001 06:02
To: Multiple recipients of list ORACLE-L
Non Uniform Memory Access (aka, Sequent machines? NUMA-Q?) Check O'Reilly's
website, they have an excerpt from Oracle Parallel Processing:
"Non Uniform Memory Access systems Non Uniform Memory Access (NUMA) systems
consist of several SMP systems that are interconnected in order to form a
larger system. All of the memory in all of the SMP systems are connected
together to form a single large memory space. NUMA systems run one copy of
the operating system across all nodes."
http://www.oreilly.com/catalog/oraclepp/chapter/ch01.html
Scott Shafer
San Antonio, TX
210-581-6217
"Do not throw cigarette butts in the urinal. It makes them soggy and hard
to light."
> -----Original Message-----
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 10:11 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Undocumented Init.Ora Parms
>
> Taking a look at these parameters, I notice that the first two relate to a
> "NUMA POOL"? What is this? If anyone has read any of Clive Custlers novels
> -
> they would think "National Underwater & Marine Agency" :)
>
> Any insight oh list gurus?
>
> Cheers
>
> Mark
>
> -----Original Message-----
> Gramolini
> Sent: Friday, June 22, 2001 03:21
> To: Multiple recipients of list ORACLE-L
>
>
> Here is a script that will list all of the undocumented parameters. I got
> is from one of the lists.
>
> select KSPPINM,
> nvl(KSPPSTVL,'NULL'),
> KSPPDESC
> from x$ksppi x, x$ksppcv y
> where x.INDX = y.INDX
> and translate(KSPPINM,'_','#') like '#%'
> order by KSPPINM;
>
> HTH,
> Ruth
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
