Re: performance turning

There are many factors to making ORACLE perform very well. As you referenced in your message, caching all of the tables in the SGA will give you the fastest access time, but you still have to tune the instance to perform well. Do you have a budget for this kind of performance? Use a massively parallel processor box (16+) or a Connection Machine (1024). Use a Cray-YMP. There are many options, limited only by the dollars.

Steve
804-262-6332

In <4qc7g7$kkf_at_yakko.cs.rose-hulman.edu> tangm_at_cs.rose-hulman.edu (Min Tang) writes:
>
>Hi,
> We are going to develop a mission critical application which
>need to do a lot of database access. I want to explore the ways to
>increase to speed of disk I/O. I heard one way is to setup the oracle
>so that when you read a table, the whole data in that table will be
>put in the SGA. The other way is to run the oracle on the ramdisk.
>Any other ways? Suggestion and recommendation is appreciated.
>
>Kevin Tang(tangm_at_cs.rose-hulman.edu)
Received on Sat Jun 22 1996 - 00:00:00 CEST