Re: Statistics for comp.databases.oracle.server - WE 06/20/2004

Mark Townsend wrote:

> Following is a summary of articles spanning a 7 day period,
> beginning at 14 Jun 2004 00:27:03 GMT and ending at
> 20 Jun 2004 23:38:36 GMT.
>
> Notes
> =====
>
> - A line in the body of a post is considered to be original if it
> does *not* match the regular expression /^\s{0,3}(?:>|:|\S+>|\+\+)/.
> - All text after the last cut line (/^-- $/) in the body is
> considered to be the author's signature.
> - The scanner prefers the Reply-To: header over the From: header
> in determining the "real" e-mail address and name.
> - Original Content Rating (OCR) is the ratio of the original content
> volume to the total body volume.
> - Find the News-Scan distribution on the CPAN!
> <URL:http://www.perl.com/CPAN/modules/by-module/News/>
> - Please send all comments to Greg Bacon <gbacon_at_cs.uah.edu>.
> - Copyright (c) 1998 Greg Bacon. All Rights Reserved.
> Verbatim copying and redistribution is permitted without royalty;
> alteration is not permitted. Redistribution and/or use for any
> commercial purpose is prohibited.
>
> Totals
> ======
>
> Posters: 199
> Articles: 712 (160 with cutlined signatures)
> Threads: 152
> Volume generated: 1910.1 kb
> - headers: 817.6 kb (12,807 lines)
> - bodies: 1048.5 kb (33,039 lines)
> - original: 471.0 kb (14,514 lines)
> - signatures: 43.3 kb (1,519 lines)
>
> Original Content Rating: 0.449
>
> Averages
> ========
>
> Posts per poster: 3.6
> median: 2 posts
> mode: 1 post - 86 posters
> s: 7.0 posts
> Posts per thread: 4.7
> median: 2.0 posts
> mode: 1 post - 46 threads
> s: 10.8 posts
> Message size: 2747.1 bytes
> - header: 1175.8 bytes (18.0 lines)
> - body: 1508.0 bytes (46.4 lines)
> - original: 677.4 bytes (20.4 lines)
> - signature: 62.3 bytes (2.1 lines)
>
> Top 10 Posters by Number of Posts
> =================================
>
> (kb) (kb) (kb) (kb)
> Posts Volume ( hdr/ body/ orig) Address
> ----- -------------------------- -------
>
> 70 196.2 ( 74.4/121.7/ 71.4) Howard J. Rogers
> 44 134.8 ( 61.9/ 64.0/ 19.0) Daniel Morgan
> 25 69.7 ( 26.8/ 42.9/ 17.3) Joel Garry
> 21 58.6 ( 31.1/ 27.4/ 14.9) Mark A
> 17 61.3 ( 28.5/ 31.8/ 18.7) Serge Rielau
> 16 41.5 ( 26.2/ 15.3/ 10.2) markbtownsend
> 15 30.9 ( 22.1/ 8.1/ 3.6) Noons
> 14 37.4 ( 18.9/ 18.5/ 9.8) Noons
> 12 28.1 ( 15.7/ 12.1/ 2.9) fvanbortel
> 11 38.9 ( 16.2/ 22.7/ 7.5) Michael Austin
>
> These posters accounted for 34.4% of all articles.
>
> Top 10 Posters by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Address
> -------------------------- ----- -------
>
> 196.2 ( 74.4/121.7/ 71.4) 70 Howard J. Rogers
> 134.8 ( 61.9/ 64.0/ 19.0) 44 Daniel Morgan
> 106.2 ( 1.1/105.2/ 0.0) 1 .
> 69.7 ( 26.8/ 42.9/ 17.3) 25 Joel Garry
> 61.3 ( 28.5/ 31.8/ 18.7) 17 Serge Rielau
> 58.6 ( 31.1/ 27.4/ 14.9) 21 Mark A
> 41.5 ( 26.2/ 15.3/ 10.2) 16 markbtownsend
> 38.9 ( 16.2/ 22.7/ 7.5) 11 Michael Austin
> 37.4 ( 18.9/ 18.5/ 9.8) 14 Noons
> 35.0 ( 9.3/ 4.1/ 3.8) 8 Jonathan Lewis
>
> These posters accounted for 40.8% of the total volume.
>
> Top 10 Threads by Number of Posts
> =================================
>
> Posts Subject
> ----- -------
>
> 108 database market share 2003
> 60 tough choices
> 19 OMLETv4 The Ultimate Visual Real Time Oracle Monitoring Tool
> 15 Weired problem when using serializable transaction in 10g
> 14 Toad alternative?
> 14 Can't start lsnrctl
> 12 clustering and high availability?
> 12 Please help: stuck with ORA-12514
> 12 How to make Oracle10g on Windows *not* start on every boot?
> 11 OEM - 9i Windows XP -
>
> These threads accounted for 38.9% of all articles.
>
> Top 10 Threads by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Subject
> -------------------------- ----- -------
>
> 291.0 (173.0/115.2/ 59.2) 108 database market share 2003
> 207.8 ( 81.7/120.9/ 51.8) 60 tough choices
> 106.2 ( 1.1/105.2/ 0.0) 1 n8Nmn
> 74.7 ( 15.2/ 51.8/ 10.9) 15 Weired problem when using
> serializable transaction in 10g
> 67.1 ( 23.1/ 43.8/ 15.8) 19 OMLETv4 The Ultimate Visual Real Time
> Oracle Monitoring Tool
> 51.2 ( 13.5/ 37.5/ 19.8) 12 Please help: stuck with ORA-12514
> 41.8 ( 18.2/ 23.2/ 12.9) 12 clustering and high availability?
> 40.7 ( 8.6/ 28.0/ 18.8) 8 When the DBA sequels - simple
> (phfilosophical ?) tuning question
> 39.9 ( 3.4/ 36.5/ 29.5) 4 How to TC lock?
> 38.0 ( 16.1/ 21.4/ 10.3) 14 Can't start lsnrctl
>
> These threads accounted for 50.2% of the total volume.
>
> Top 10 Targets for Crossposts
> =============================
>
> Articles Newsgroup
> -------- ---------
>
> 173 comp.databases.ibm-db2
> 62 comp.databases.informix
> 49 rec.arts.poems
> 23 comp.databases.oracle.misc
> 19 comp.dcom.sys.cisco
> 17 alt.certification.cisco
> 16 rec.photo.digital
> 9 alt.2600
> 6 comp.databases.oracle.tools
> 4 comp.database.oracle.misc
>

How about stats on the other usenet groups to which you post? Just kidding.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)