Could I benefit from a materialized view?

From: Martin <martin.j.evans_at_gmail.com>
Date: Thu, 24 Feb 2011 03:18:39 -0800 (PST)
Message-ID: <155b206b-a664-40ed-902a-835546279dfc_at_e9g2000vbi.googlegroups.com>

Hi,

I have Oracle 11g r1 and applications running on remote machines using InstantClient. These applications read the same table repeatedly as part of a function which performs a calculation. The table in question is small with a primary key and is unlikely to get any more than 175 rows (it is 8 columns 3 numbers, 3 timestamps and 2 varchar(128)). I would want a refresh on commit but believe if I create the log table properly I'll get that.