Really Huge Numbers
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: Oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Apr 2004 07:36:28 -0700 (PDT)
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
-----------------------------------------------------------------
Other related posts:
