Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 11 Jul 2004 22:14:24 GMT
Message-ID: <4ZiIc.70369$XM6.24953@attbi_s53>

Following is a summary of articles spanning a 7 day period, beginning at 04 Jul 2004 22:27:00 GMT and ending at 11 Jul 2004 21:19:40 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: 166
Articles: 477 (66 with cutlined signatures) Threads: 108

Volume generated: 1177.6 kb


     - headers:    513.1 kb (8,626 lines)

     - bodies:     648.0 kb (19,644 lines)

     - original:   317.3 kb (9,999 lines)

     - signatures: 16.1 kb (639 lines)


Original Content Rating: 0.490

Averages

Posts per poster: 2.9

     median: 1.5 posts
     mode:   1 post - 83 posters
     s:      4.2 posts
Posts per thread: 4.4
     median: 3.0 posts
     mode:   2 posts - 24 threads
     s:      9.3 posts
Message size: 2528.0 bytes


     - header:     1101.4 bytes (18.1 lines)

     - body:       1391.1 bytes (41.2 lines)

     - original:   681.2 bytes (21.0 lines)

     - signature:  34.5 bytes (1.3 lines)

Top 10 Threads by Number of Posts

Posts Subject
----- -------

    40 Very long "WHERE" list.
    32 Has poetry ever got you laid?
    17 Oracle 10G: Grid Control Install Problems. 64 Bit Windows     15 Eliminating Combinatorial Relationship Multiplication     14 Query not using indexes
    12 Questioning Oracle Documentation     12 Poor Performance after 9i migration on Windows     11 opinion solicited
    11 Oracle won't release locks - ever!     10 Is David Rutkowski a bot?

These threads accounted for 36.5% of all articles.

Top 10 Threads by Volume

(kb) (kb) (kb) (kb)
Volume ( hdr/ body/ orig) Posts Subject

--------------------------  -----  -------

   89.1 ( 44.7/ 38.4/ 20.1)     40  Very long "WHERE" list.
   68.4 ( 38.0/ 29.6/  9.2)     32  Has poetry ever got you laid?
   62.5 ( 12.1/ 50.3/ 12.9)     11  opinion solicited
   51.1 ( 21.8/ 29.0/ 11.4)     15  Eliminating Combinatorial
                                    Relationship Multiplication
   50.7 ( 19.6/ 31.1/ 10.8)     17  Oracle 10G: Grid Control Install
                                    Problems. 64 Bit Windows
   47.3 ( 14.1/ 27.9/ 17.4)     12  Questioning Oracle Documentation
   34.3 (  4.2/ 30.1/ 28.5)      4  Spatial Insert Performance
   33.1 ( 15.3/ 17.8/  5.7)     14  Query not using indexes
   32.4 (  7.1/ 25.3/ 11.1)      7  ORA-01034 and ORA-01034, if starting
                                    oracle from script
   31.8 ( 12.2/ 19.3/  5.8)     11  Oracle won't release locks - ever!

These threads accounted for 42.5% of the total volume.

Top 10 Targets for Crossposts

Articles Newsgroup
-------- ---------

       42  alt.arts.poetry.comments
       42  rec.arts.poems
       36  rec.photo.digital
       32  alt.writing
       20  comp.databases.theory
       19  comp.databases.ms-sqlserver
       19  comp.databases
       10  alt.2600
        8  comp.database.oracle
        6  mailing.database.mysql

Received on Sun Jul 11 2004 - 17:14:24 CDT

Statistics for comp.databases.oracle.server - WE 07/11/2004