RE: Really Huge Numbers

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 13 Apr 2004 10:22:23 -0500
Message-ID: <002401c4216b$22d7ecd0$6601a8c0@CVMLAP02>

Let me guess: you're on 64-bit HP-UX?

If so, then this is a known bug in how the porting group chose to emit numbers. Both Oracle's tkprof and our Hotsos Profiler know how to extract the right value from the wrong number.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22
Pittsburgh
- SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego

Hotsos Symposium 2005: March 6-10 Dallas
Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Barnett Sent: Tuesday, April 13, 2004 9:36 AM
To: Oracle-l_at_freelists.org
Subject: Really Huge Numbers

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_at_regence.com

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 13 2004 - 11:07:30 CDT