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

[Predrag Zecevic - Solaris System Administrator]

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
>  
>

-- 
| Predrag Zecevic | e-Mail: Predrag.Zecevic at 2e-Systems.COM |
| 2e Systems GmbH |              Tel: (+49)[0]6107 989 415 |
|Im Taubengrund 12|              Fax: (+49)[0]6107 989 494 |
|65451 Kelsterbach|                                        |
|     Germany     |         Cellular: (+49)[0]174 3109 288 |
+=================+
How should I know if it works? That's what beta testers are for. I only coded it. -- Attributed to Linus Torvalds, somewhere in a posting