AIX Oracle Tuning

From: MMorley1 <mmorley1_at_aol.com>
Date: 1995/05/26
Message-ID: <3q52o0$n3r_at_newsbf02.news.aol.com>#1/1

Looking for help tuning Oracle on an RS6000 running AIX. The environment is 10 tables each with potentially 5 million rows. The data is query only and it is unlikely that each record will be queried more than once in a 24 hour period. This would seem to reduce the effects of changes in cache (or SGA) size. Is there a way to just cache indexes? Each table has a single 24 byte key. We are looking for the highest throughput possible for single returned record selects. Thanks in advance for any ideas.

Mike Morley
Equifax Inc.
Tampa Received on Fri May 26 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: CRMHERNDON: "Re: Need advice: small system platform & dba responsibilities"
Previous message: Jonathan Wayne Ingram: "Re: Tables accessed from forms/triggers ?"
Next in thread: Ganesh Puranik: "Re: AIX Oracle Tuning"
Reply: Ganesh Puranik: "Re: AIX Oracle Tuning"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message