Re: Extremly slow performance with Oracle and Linux

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: Mon, 30 Aug 1999 11:31:15 +0200
Message-ID: <7qdipb$b9n$1@opal.hamburg.cityline.net>

Jill,

I can't set the autotrace option. I get the following error message:

Unable to verify PLAN_TABLE format or existence Error enabling EXPLAIN report

???

Regards

Roger

Jill <jc_va_at_hotmail.com> schrieb in im Newsbeitrag: 7qc7sg$ns0$1_at_bgtnsc02.worldnet.att.net...
> Can you set autotrace on in sqlplus and see what Oracle is doing? Is the
> table analyzed? I run 8.0.5 on a old Dell Pentium 90 with 48 MB of RAM
and
> RH 5.2. I just use the demo ORCL database with the small SGA, but I
never
> notice any bottlenecks, except with log buffers.
>
>
> Roger wrote in message <7qc2lh$rif$1_at_opal.hamburg.cityline.net>...
> >Gene,
> >
> >according to "show sga" Oracle needs about 35 MByte Ram. After Oracle has
> >started about 40 MByte are still free. I think this should be enough.
> >
Received on Mon Aug 30 1999 - 04:31:15 CDT