| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 8.1.7 on Suse 7.2
You're welcome!
Jared
"Gavin
D'mello" To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<gavin_d_at_tis.c cc:
o.in> Subject: Oracle 8.1.7 on Suse 7.2
Sent by:
root_at_fatcity.c
om
12/16/01 11:00
PM
Please respond
to ORACLE-L
Hi People anyone having problems with their installation of Oracle 8i on Suse pay heed and download JRE from www.blackdown.org.
Thanks Jared all my problems have disappeared !
Gavin
>
> Don't know about 7.2. but on 7.1 I installed the Java
> from www.blackdown.org and it took care of the problems
> I had with java.
>
> Before doing that though, just try 'unset NLS_LANG' before
> running the java stuff.
>
> See metalink for details.
>
> Jared
>
> On Saturday 15 December 2001 06:25, Gavin D'mello wrote:
> > Hi I am facing a problem on Suse 7.2 and would be grateful if anyone
could
> > help me out ....
> >
> > I am installing Oracle 8.1.7 on Suse Linux 7.2, however the JRE in this
> > bundle does not seem to work. SO before installation I changed the
default
> > JRE_DIR in oraparam.ini to /usr/lib/jdk1.1.8 ( my local jdk
installation).
> > The install ran smooth. However while doing a typical install Dbassist
> > fails to load throwing errors like
> > SIGSEGV received at bfffd530 in
> > /u01/app/prodcut/oracle/jre/1.1.8/lib/linux/native_threads/libjava
Process
> > terminated
> > dbassist line 103 : 10469 Segmentation Fault
> >
> > $JRE_EXEC -Duser.dir=USER_DIR -classpath $CLASSPATH DBCreateWizard
> > $ARGUMENTS .....
> >
> > Thank You,
> >
> > Gavin
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Saturday, December 15, 2001 5:25 PM
> >
> > > This is not outdated -- the Oracle queries against the data
dictionary
> > > tables are tuned for RULE and so analyzing the SYS tables wreaks
havoc
> > > in the database.
> > >
> > > --- Amar Kumar Padhi <TS2017_at_emirates.com> wrote:
> > > > My information on this may be a bit outdated. I had read it
somewhere
> > > > that
> > > > statistics are not to be generated for SYS tables. Oracle will
handle
> > > > the
> > > > dictionary information access, irrespective of the optimizer mode
> > > > being
> > > > used. The setting of the optimizer_mode should affect the
application
> > > > queries being generated for other schemas. So if you are using CBO,
> > > > setting
> > > > the Optimizer_mode to first_rows looks more applicable than doing
an
> > > > alter
> > > > session every time. I am not able to comment on the poor
performance
> > > > when
> > > > accessing the dict.
> > > >
> > > > rgds
> > > > amar
> > > >
> > > > -----Original Message-----
> > > > Sent: Friday, December 14, 2001 11:00 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > FYI,
> > > >
> > > > I just logged a call with Oracle re. Designer 6.0 vs.
> > > > all_cons_columns.
> > > >
> > > > A developer noticed that whenever he queries that data dictionary
> > > > table as
> > > > part of generating database from server models, the process slows
> > > > down to a
> > > > crawl.
> > > >
> > > > If the target doesn't have any constraints, no problem.
> > > >
> > > > I am starting to wonder if it isn't because FIRST_ROWS was
specified
> > > > on this
> > > > database, most of the developers are developing forms (6i) so I set
> > > > the
> > > > init.ora parameter accordingly.
> > > >
> > > > The Oracle documentation however implies that the CBO only switches
> > > > to rule
> > > > when there are no stats if optimizer_mode had been set to CHOOSE,
if
> > > > it's
> > > > either ALL_ROWS or FIRST_ROWS it tries to use the CBO against the
> > > > data
> > > > dictionary anyway. How the CBO can run when there are no stats
> > > > probably
> > > > means it defaults to full table scans (?).
> > > >
> > > > OPTIMIZER_MODE = { all_rows | first_rows | rule | choose }
> > > >
> > > > The OPTIMIZER_MODE parameter specifies the approach and mode of the
> > > > optimizer for your session.
> > > >
> > > >
> > > > See Also: Oracle8i Concepts <../../server.817/a76965/toc.htm> and
> > > > Oracle8i
> > > > Performance Guide and Reference <../../server.817/a76992/toc.htm>
> > > > for
> > > > information on how to choose a goal for the cost-based approach
based
> > > > on the
> > > > characteristics of your application
> > > >
> > > >
> > > >
> > > > * all_rows specifies the cost-based approach and optimizes for best
> > > > throughput.
> > > > * first_rows specifies the cost-based approach and optimizes for
best
> > > > response time.
> > > > * rule specifies the rule-based approach. (The rule-based optimizer
> > > > does not use function-based indexes.)
> > > > * choose causes the optimizer to choose an optimization approach
> > > > based
> > > > on the presence of statistics in the data dictionary.
> > > >
> > > > Is this correct? If so, then I suppose I should set the init.ora
> > > > parameter
> > > > back to optimizer_mode=choose, and tell each developer to put an
> > > > alter
> > > > session statement on their clients to alter their sessions
> > > > automatically to
> > > > first_rows. The developer using designer will then be able to run
it
> > > > in a
> > > > timely manner.
> > > >
> > > > Please tell me if my suspicion is correct.
> > > >
> > > > If correct, it begs the question: why are first_rows and all_rows
> > > > available
> > > > for the init.ora file???
> > > >
> > > > Regards,
> > > > Patrice Boivin
> > > > Systems Analyst (Oracle Certified DBA)
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Boivin, Patrice J
> > > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> > > > Lists
> > > >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello INET: gavin_d_at_tis.co.in 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: INET: Jared.Still_at_radisys.com 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).Received on Mon Dec 17 2001 - 12:16:27 CST
 |
 |