[SunHELP] Poor Performace when running Oracle 9i on Solaris

[Tige D. Chastain]

The problem is not your hardware, rather the lack of understanding why
Oracle is spending so much time during the import of the data.

If you are using Oracle's export/import tool, you need to understand
what kind of objects you are importing and sequence them properly.  I
use a stepped import process that first imports table structures
(ROWS=n) and PL/SQL objects without verifying relational integrity.
Then run in the rows in a second export.  Then run a script to enable
all constraints without validation.  Also, make sure you do NOT import
statistics of a database, as they are useless - you need to either
calculate or estimate your own statistics (I HIGHLY recommend estimate -
see Oracle tuning docs for why) for the schemas.

If you follow these general guidelines, you will find Oracle performs
just fine on V880s.

It sounds like you are new to Oracle and how it operates.  If that is
the case, I HIGHLY recommend you get ahold of a qualified Oracle DBA to
assist in performance tuning issues.  Oracle can be a great DBMS if you
know to how care and feed it correctly.

Hope this helps.

Tige


On Wed, 2005-07-20 at 07:07 +0200, Predrag Zecevic - Solaris System
Administrator wrote:
> Hi,
> 
> we had similar problem, but it was because poor Oracle DB design!
> So, I would suggest tuning of Oracle (if not done) - specially avoiding 
> import of statistics - and then focusing on OS issues (I would try to 
> make Oracle to use raw devices instead of FS).
> 
> Best regards ;-)
> 
> ymui at royalsunalliance.ca wrote:
> 
> >Hello Administrators,
> >
> >We have a couple of Sun Fire V880 machines installed with Solaris 8 
> >(10/01)
> >and we have installed Oracle 9i on those servers.
> >The problem is that when we're importing a 3.5 GB database in Oracle, it
> >takes up hours to import that database.  We've tried the process on both 
> >RAID 1 and no RAID at all, but the result is similar.
> >
> >Does anyone have similar experience ?  Any tips/hints are appreciated ! 
> >
> >Regards, Y. Mui
> >Tel. 416-366-7600 Ext 2624
> >Email: ymui at royalsunalliance.ca
> >
> >--------------------------------------------------
> >THIS EMAIL COMMUNICATION IS INTENDED ONLY FOR THE PERSON OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN CONFIDENTIAL AND/OR PRIVILEGED INFORMATION. ANY USE OF THIS INFORMATION BY PERSONS OR ENTITIES OTHER THAN THE INTENDED RECIPIENT IS PROHIBITED.  IF YOU RECEIVED THIS IN ERROR, PLEASE CONTACT THE SENDER AND DELETE THE EMAIL AND ALL COPIES (ELECTRONIC OR OTHERWISE) IMMEDIATELY.
> >
> >CE COURRIEL EST DESTINE UNIQUEMENT A LA PERSONNE OU A L'ENTITE A LAQUELLE IL EST ENVOYE ET PEUT CONTENIR DE L'INFORMATION CONFIDENTIELLE OU PRIVILEGIEE.  TOUTE UTILISATION DE L'INFORMATION PAR UNE PERSONNE OU UNE ENTITE AUTRE QUE CELLE A LAQUELLE ELLE EST DESTINEE EST INTERDITE. SI VOUS RECEVEZ CE COURRIEL PAR ERREUR,  VEUILLEZ COMMUNIQUER AVEC SON EXPEDITEUR ET  SUPPRIMER CE COURRIEL ET TOUTE COPIE (ELECTRONIQUE OU AUTRE) IMMEDIATEMENT.
> >_______________________________________________
> >SunHELP maillist  -  SunHELP at sunhelp.org
> >http://www.sunhelp.org/mailman/listinfo/sunhelp
> >  
> >
>