Re: oracle 9.0.1 on solaris 8 VERY slow

Mark wrote:

> I have done the vanilla install on two separate machines ( both Netra
> T1 w/512M and 9 gig scsi ). The first I choose "transactional"
> database, and the second install I choose "generic". Here are the
> additions I made to /etc/system:
>
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmsl=256
> set semsys:seminfo_semmns=1000
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
> When I say things are very slow, is when our application makes about
> 10 connections and starts reading from the database. The data I am
> using is from a perfectly fine working 8.1.5 database (Netra X1 --
> slower processor, ide, 256M). I did an exp/imp to get the data moved
> over.
>
> Thanks
> Mark

Which part of reading the Oracle installation docs is causing a problem?

http://docs.oracle.com/DOCS_DOT_PDF_Storage/a90351.pdf

clearly states: SHMMNI = 512 ... you have 100 and SHMSEG = 32 ... you have 10

and I stopped looking for discrepancies after two so there are likely lots more.

Please read and follow the installation guide on the CD and also at http://docs.oracle.com

While this may not solve your speed problem it will keep you from collecting ORA-03113's.

With respect to speed one needs to ask things like have you been using DBMS_STATS to run and maintain current statistics. Have you run EXPLAIN PLAN and TKPROF? Have your run DBMS_PROFILER? Until you have there is little that can do to help you other than to suggest that you need to start with the basics.

Daniel Morgan Received on Wed Sep 18 2002 - 11:11:50 CDT