We have a very small (1.7M) database that is accessed through a web application. This application was once a spreadsheet until someone in marketing thought it would be cool to put it on the web. The entire database is in memory and is used exclusively for queries. It has been up since 2/8/2004. There are no known performance issues but here are some really large numbers: no work consistent read gets 18,446,744,052,251,242,798 similar numbers for enqueue requests and releases, consistent gets, sorts(memory). Sorts(disk) is zero. The code is probably really inefficient, but everyone is happy. It's just that some of the performance numbers are monsterous. ===== Pete Barnett Lead Database Administrator The Regence Group pnbarne@xxxxxxxxxxx __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------