| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 9iAS error ORA-27101 shared memory realm does not exist
Dba's
I got the following error during the cache config portion of Oracle 9iAS:
ORA-27101 shared memory realm does not exist
Am I missing a kernel parameter, the error message text is useless:
%> oerr ora 27101
27101, 00000, "shared memory realm does not exist"
// *Cause: Unable to locate shared memory realm
// *Action: Verify that the realm is accessible
...JIM...
jhowerton_at_uabmc.edu
From: Jay Mehta <Jmehta_at_ctisinc.com>
Date: Thu, 19 Oct 2000 12:20:22 -0400
Subject: CACHE/NOCACHE and _SMALL_TABLE_THRESHOLD
Hi All,
Does Oracle apply CACHE/NOCACHE option along with the _SMALL_TABLE_THRESHOLD parameter to determine whether to place data blocks at the MRU or LRU end of the buffer cache? Is _SMALL_TABLE_THRESHOLD parameter applicable in Oracle8? If Oracle8 uses both CACHE/NOCACHE option and _SMALL_TABLE_THRESHOLD parameter, then which one takes precedence? For example, if a table is created with NOCACHE, but it's size is less than _SMALL_TABLE_THRESHOLD, then how Oracle is going to determine whether to place it at the LRU or MRU end of the buffer cache?
Thanks,
Jay
From: Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com Date: Thu, 19 Oct 2000 12:24:16 -0400
Gurus,
In all the years that I have dealt with Oracle (both as a developer and a
DBA --
altogether 3 years) I never stopped to pay much attention to the fact that
when
you define a field in a table as NUMERIC, no matter what precision and
scale you
define for it, you are always going to get 22 bytes allocated for this
field in
the table. While I see the benefit of being able to store really large
numbers
in the database, most of the time it's a waste.
Let's say I wanted to store a record for each person living on the planet
-- ~
7bln records.
The record would only have one field -- a unique ID of this person,
starting
with 1,2,3, ...
Thus the max number I would want to store would be 7,000,000,000, plus
planning
for potential population growth - ~35 bln in 10 years.
If I allocate 22 bytes for each of these numbers I would end up needing
approx.
140Gb right away.
If there was a way for me to only allocate 6 bytes (plenty of space for
billions), I would only need 40Gb.
My question is: is there a way to do it in Oracle?
I just went through documentation for 7.3.4 and this is the only data type
available (there others but they are just synonyms of NUMERIC).
If somebody can shed the light on this I would be very appreciative.
Thanks,
Val Gamerman.
From: Praful Thakkar <thakkar_praful_at_yahoo.com> Date: Thu, 19 Oct 2000 09:28:44 -0700 (PDT) Subject: Oracle Names
Can ORACLE NAMES SERVER be implemented on Oracle Standard Edition (8.1.5)?
I have tried it unsuccesfully and read in one of the forums that it cannot be implemented, but not sure of it. I have followed steps from some of the papers from Metalink to imelement it. It works fine and names server starts fine, but starting listener after registering it with name server returns ORA-12537/ORA-12560. TIA.
From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 19 Oct 2000 09:20:37 -0700
Subject: RE: Oracle statistics management report
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
------_=_NextPart_001_01C039E8.84419270
Content-Type: text/plain
In the old days (7.3.4), Oracle had a GUI tool called Performance Manager. It did exactly what you're looking for. You could do a screen shot of the Performance Charts and graphs and submit them to Management.
Regards,
Satar
> -----Original Message----- > From: > Sent: Thursday, October 19, 2000 10:46 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle statistics management report > > > > > Hi All, > > > I've been collecting and evaluating oracle stats for months now and have > been quite content doing so. However mangement in there infinite wisdom > has > now decided that they want periodic "performance" reports with nice > charts > & graphs (you know management) and as little detail as possible (Just > "ORACLE IS DOING JUST FINE" wasn't enough though). > I have no experience in this whatsoever and could use a little help, or > maybe an example of how some of you have done this > > > TIA > > > > Jack > > =================================================================== > De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor > de geadresseerde. Gebruik van deze informatie door anderen dan de > geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding > en/of verstrekking van deze informatie aan derden is niet toegestaan. > Ernst & Young staat niet in voor de juiste en volledige overbrenging van > de > inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. > =================================================================== > The information contained in this communication is confidential and may be > legally privileged. It is intended solely for the use of the individual or > entity to whom it is addressed and others authorised to receive it. If you > are not the intended recipient you are hereby notified that any > disclosure, > copying, distribution or taking any action in reliance on the contents of > this information is strictly prohibited and may be unlawful. Ernst & > Young is neither liable for the proper and complete transmission of the > information contained in this communication nor for any delay in its > receipt. > =================================================================== > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: nlzanen1_at_ey.nl > > 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).
------_=_NextPart_001_01C039E8.84419270
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
Received on Thu Oct 19 2000 - 10:48:43 CDT
 |
 |