RE: Undocumented Init.Ora Parms

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-----
Scott.Shafer_at_dcpds.cpms.osd.mil
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:mark_at_cool-tools.co.uk]
> 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: Scott.Shafer_at_dcpds.cpms.osd.mil

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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).