RE: Cary's query, on oracle 9.2

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 24 Feb 2004 13:41:04 -0600
Message-ID: <003e01c3fb0e$2447b920$e56a8640@CVMLAP02>

Here's what it looks like on 9.2.0.4.0 on Windows XP:

13:38:12 v92> show rel
release 902000400
13:38:17 v92> select count(*) from v$event_name;

COUNT(*)

399

It might be interesting to see a side-by-side diff of event names for a given version across platforms. But not interesting enough for me to actually *do*. :)

Sounds like a good thing for a museum in Måløv to have.

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

Upcoming events:

- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
- Hotsos Symposium 2004: March 7-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 Mladen Gogala Sent: Tuesday, February 24, 2004 1:32 PM To: Multiple recipients of list ORACLE-L Subject: Cary's query, on oracle 9.2

Just for fun, I counted the events in 9.2. Here's the result:

SQL> show release
release 902000400
SQL> select count(*) from v$event_name;

COUNT(*)

401

SQL> In 10g, there are 808 different events. Wow, more then double! It's going to be interesting.

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

Received on Tue Feb 24 2004 - 13:40:54 CST