Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance Optimization
In article <01bc15e0$f587b320$323452ca_at_hkstar.com>,
Cybird <rohitkamat_at_hotmail.com> wrote:
>I am facing some problems with Oracle in terms of speed. The server is
>extremely high end (take my word for it - its got in excess of 200 meg RAM)
>but the performance is lousy.
Actually 200 MB of DRAM is not all that much these days. I regularly see systems running 1 - 2 GB of DRAM.
>Is it something that I have to do while installing the software? Oracle did
>not come with SmartStart, btw.
The disk layout can be critical for performance in Oracle.
>I ran ANALYZE on all the tables and that enhanced the throughput a bit but
>I am still not satisfied with the speed.
Additional, indexes, tuning Oracle and kernel parameters are things to look at. Oracle press and Oreilly both have good tuning books.
Good Luck
Mark Rosenbaum Otey-Rosenbaum & Frazier, Inc. mjr_at_netcom.com Consultants in High Performance and (303) 727-7956 Scalable Computing and Applications POB 1397 ftp://ftp.netcom.com/pub/mj/mjr/resume/Boulder CO 80306 Received on Sat Feb 08 1997 - 00:00:00 CST