Re: Statistics for comp.databases.oracle.server - WE 12/1/2003

Mark Townsend wrote:

> Following is a summary of articles spanning a 7 day period,
> beginning at 06 Jan 2003 02:00:03 GMT and ending at
> 13 Jan 2003 00:45:27 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: 269
> Articles: 756 (54 with cutlined signatures)
> Threads: 181
> Volume generated: 2125.5 kb
> - headers: 827.3 kb (13,339 lines)
> - bodies: 1291.6 kb (37,086 lines)
> - original: 574.6 kb (18,141 lines)
> - signatures: 5.9 kb (182 lines)
>
> Original Content Rating: 0.445
>
> Averages
> ========
>
> Posts per poster: 2.8
> median: 1 post
> mode: 1 post - 151 posters
> s: 5.4 posts
> Posts per thread: 4.2
> median: 3 posts
> mode: 1 post - 45 threads
> s: 5.1 posts
> Message size: 2879.0 bytes
> - header: 1120.5 bytes (17.6 lines)
> - body: 1749.5 bytes (49.1 lines)
> - original: 778.3 bytes (24.0 lines)
> - signature: 8.0 bytes (0.2 lines)
>
> Top 10 Posters by Number of Posts
> =================================
>
> (kb) (kb) (kb) (kb)
> Posts Volume ( hdr/ body/ orig) Address
> ----- -------------------------- -------
>
> 68 227.6 ( 75.4/152.1/ 23.5) DA Morgan
> 25 68.0 ( 38.7/ 29.3/ 15.5) Karsten Farrell
> 19 39.7 ( 18.6/ 20.2/ 10.5) Noons
> 17 31.3 ( 18.3/ 13.0/ 5.8) Paul Brewer
> 15 26.9 ( 14.7/ 12.1/ 5.5) postbus_at_sybrandb.demon.nl
> 15 59.4 ( 15.7/ 43.7/ 10.7) Jim Kennedy
> 14 35.0 ( 16.2/ 18.8/ 10.8) Niall Litchfield
> 14 41.4 ( 14.5/ 26.9/ 17.5) Jonathan Lewis
> 13 34.4 ( 14.9/ 19.5/ 7.4) Richard Foote
> 13 54.5 ( 15.3/ 39.2/ 18.6) Howard J. Rogers
>
> These posters accounted for 28.2% of all articles.
>
> Top 10 Posters by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Address
> -------------------------- ----- -------
>
> 227.6 ( 75.4/152.1/ 23.5) 68 DA Morgan
> 97.0 ( 3.2/ 93.9/ 73.1) 3 Nagarajan
> 68.0 ( 38.7/ 29.3/ 15.5) 25 Karsten Farrell
> 60.7 ( 2.1/ 58.7/ 1.0) 2 dias
> 59.4 ( 15.7/ 43.7/ 10.7) 15 Jim Kennedy
> 54.5 ( 15.3/ 39.2/ 18.6) 13 Howard J. Rogers
> 48.7 ( 11.1/ 35.6/ 16.8) 9 timx_at_spamto.devnul.com
> 41.4 ( 14.5/ 26.9/ 17.5) 14 Jonathan Lewis
> 39.7 ( 18.6/ 20.2/ 10.5) 19 Noons
> 36.4 ( 9.9/ 26.5/ 6.2) 9 servant
>
> These posters accounted for 34.5% of the total volume.
>
> Top 10 Posters by OCR (minimum of five posts)
> ==============================================
>
> (kb) (kb)
> OCR orig / body Posts Address
> ----- -------------- ----- -------
>
> 1.000 ( 1.7 / 1.7) 5 srivenu
> 0.990 ( 11.8 / 11.9) 10 Norman Dunbar
> 0.821 ( 3.5 / 4.3) 5 ~MINOLTA a303si~
> 0.747 ( 4.2 / 5.7) 6 Niall Litchfield
> 0.715 ( 9.9 / 13.9) 12 Dusan Bolek
> 0.681 ( 4.6 / 6.7) 8 100.17706_at_germanynet.de
> 0.672 ( 2.5 / 3.7) 8 Galen Boyer
> 0.663 ( 5.1 / 7.7) 5 FC
> 0.649 ( 17.5 / 26.9) 14 Jonathan Lewis
> 0.591 ( 5.1 / 8.6) 5 Sean M
>
> Bottom 10 Posters by OCR (minimum of five posts)
> =================================================
>
> (kb) (kb)
> OCR orig / body Posts Address
> ----- -------------- ----- -------
>
> 0.381 ( 7.4 / 19.5) 13 Richard Foote
> 0.335 ( 2.6 / 7.8) 7 David Sharples
> 0.304 ( 3.1 / 10.1) 7 johng_at_mm.nospam.com
> 0.289 ( 1.8 / 6.1) 5 Pete Sharman
> 0.266 ( 2.0 / 7.5) 6 Detlef Jockheck
> 0.246 ( 10.7 / 43.7) 15 Jim Kennedy
> 0.234 ( 6.2 / 26.5) 9 servant
> 0.228 ( 5.0 / 21.9) 9 Alex Filonov
> 0.190 ( 1.7 / 8.9) 5 Peter van Rijn
> 0.154 ( 23.5 /152.1) 68 DA Morgan
>
> 35 posters (13%) had at least five posts.
>
> Top 10 Threads by Number of Posts
> =================================
>
> Posts Subject
> ----- -------
>
> 37 Comparison of Java, C# for development on Windows and future for them
> 29 9i streams vs triggers
> 19 Oracle stored procedures vs Running from a flat .sql file
> 19 Locally Managed Tablespaces ... again!!!
> 18 Oracle and Java. Does Oracle know something some of us don't?
> 17 using rman
> 15 What do these terms mean?
> 13 Install Oracle817 on linux (suse72,redhat80)
> 12 Performance issue while loading large amount of data
> 12 dbms_jobs versus cron
>
> These threads accounted for 25.3% of all articles.
>
> Top 10 Threads by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Subject
> -------------------------- ----- -------
>
> 157.8 ( 5.2/152.5/ 74.1) 5 Help: large "cache buffers lru chain",
> large performace degradation
> 123.6 ( 50.1/ 72.8/ 36.5) 37 Comparison of Java, C# for development on
> Windows and future for them
> 123.0 ( 30.8/ 92.1/ 17.5) 29 9i streams vs triggers
> 73.2 ( 22.5/ 50.0/ 26.8) 18 Oracle and Java. Does Oracle know
> something some of us don't?
> 66.8 ( 23.8/ 42.6/ 13.7) 19 Oracle stored procedures vs Running from
> a flat .sql file
> 50.1 ( 21.3/ 28.7/ 16.9) 19 Locally Managed Tablespaces ... again!!!
> 48.9 ( 19.5/ 29.3/ 14.4) 17 using rman
> 41.2 ( 7.6/ 33.5/ 23.9) 7 Temporary tablespace near 100% full, smon
> is not freeing up, Oracle 7.3.4.5 ---->
> URGENT
> 38.3 ( 11.0/ 27.2/ 5.9) 10 Intercepting Oracle traffic
> 36.3 ( 5.1/ 31.2/ 5.2) 4 Why SAP is doing well when Oracle is not
>
> These threads accounted for 35.7% of the total volume.
>
> Top 10 Threads by OCR (minimum of five posts)
> ==============================================
>
> (kb) (kb)
> OCR orig / body Posts Subject
> ----- -------------- ----- -------
>
> 0.809 ( 2.3/ 2.8) 5 Can i use command mode to install Oracle?
> 0.718 ( 7.9/ 10.9) 10 Unable to extend temp on non temp tablespace
> 0.714 ( 23.9/ 33.5) 7 Temporary tablespace near 100% full, smon is
> not freeing up, Oracle 7.3.4.5 ----> URGENT
> 0.696 ( 4.9/ 7.0) 5 Guidelines for using Oracle 9i Object
> Relational Features
> 0.682 ( 1.4/ 2.1) 5 8i client for W2k
> 0.652 ( 2.5/ 3.9) 5 Why it doesn't start ?
> 0.649 ( 3.4/ 5.2) 7 autocommit ON but no commits visible in
> v$sqlarea
> 0.632 ( 4.4/ 6.9) 7 archivelog or not
> 0.609 ( 2.7/ 4.4) 5 basic oracle questions.
> 0.607 ( 2.1/ 3.4) 5 Connecting to Oracle 8.0.4 Database using
> 8.1.7 client
>
> Bottom 10 Threads by OCR (minimum of five posts)
> =================================================
>
> (kb) (kb)
> OCR orig / body Posts Subject
> ----- -------------- ----- -------
>
> 0.325 ( 1.7 / 5.3) 8 Accessing the Seed databse
> 0.322 ( 13.7 / 42.6) 19 Oracle stored procedures vs Running from a
> flat .sql file
> 0.317 ( 1.7 / 5.3) 6 Can't run external procedure
> 0.304 ( 2.4 / 8.0) 5 ORA-01092
> 0.292 ( 4.3 / 14.6) 9 How to do this as a singleton select?
> 0.272 ( 1.7 / 6.1) 5 Question to oracle products newest version?
> 0.253 ( 2.9 / 11.3) 8 Peferred Credentials on OEM
> 0.218 ( 2.2 / 9.9) 7 CLUSTER TABLES
> 0.217 ( 5.9 / 27.2) 10 Intercepting Oracle traffic
> 0.190 ( 17.5 / 92.1) 29 9i streams vs triggers
>
> 56 threads (30%) had at least five posts.
>
> Top 10 Targets for Crossposts
> =============================
>
> Articles Newsgroup
> -------- ---------
>
> 45 comp.lang.visual.basic
> 42 comp.databases.oracle.misc
> 41 microsoft.public.dotnet.languages.csharp
> 41 comp.lang.java.programmer
> 41 comp.lang.java.developer
> 19 comp.databases.oracle.tools
> 7 comp.databases.oracle
> 6 comp.databases.oracle.marketplace
> 5 comp.databases.olap
> 5 microsoft.public.sqlserver.datawarehouse
>
> Top 10 Crossposters
> ===================
>
> Groups Address
> -------- -------
>
> 24 kim bruning
> 24 Chad Myers
> 13 DA Morgan
> 12 Ingo Pakleppa
> 12 Mark Thornton
> 12 Karsten Farrell
> 8 A Bag Of Memes
> 8 James
> 8 Tim Ward
> 8 Frans Bouma

Interesting. Any chance you could separate original posters from responders?

I doubt I post am the original poster of more than one item every few months.

Daniel Morgan Received on Mon Jan 13 2003 - 02:00:21 CST