Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 15 Feb 2004 18:23:26 GMT
Message-ID: <yOOXb.188071$U%5.933201@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 08 Feb 2004 18:22:09 GMT and ending at 15 Feb 2004 17:52:23 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: 188
Articles: 704 (225 with cutlined signatures) Threads: 144

Volume generated: 1833.9 kb


     - headers:    766.6 kb (12,834 lines)

     - bodies:     962.1 kb (28,564 lines)

     - original:   485.1 kb (15,238 lines)

     - signatures: 104.5 kb (3,235 lines)


Original Content Rating: 0.504

Averages

Posts per poster: 3.7

     median: 1.0 post
     mode:   1 post - 96 posters
     s:      8.3 posts
Posts per thread: 4.9
     median: 3.0 posts
     mode:   2 posts - 35 threads
     s:      5.9 posts
Message size: 2667.5 bytes


     - header:     1115.1 bytes (18.2 lines)

     - body:       1399.4 bytes (40.6 lines)

     - original:   705.6 bytes (21.6 lines)

     - signature:  152.0 bytes (4.6 lines)

Top 10 Threads by Number of Posts

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

    42 How to calibrate the CBO
    30 I think too many people are downloading 10g database     21 Is it just me?
    19 Creating Table as select...
    18 For the SQL Gurus out there, a question     15 yipeee!
    15 Personal Oracle Patch for XP
    15 rman recover/restore from backup     14 SERVEROUTPUT Status
    14 Oracle 10g kills 8i listener

These threads accounted for 28.8% of all articles.

Top 10 Threads by Volume

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

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

  177.0 ( 49.6/115.6/ 48.6)     42  How to calibrate the CBO
  122.1 ( 10.8/ 82.1/ 55.1)      9  reduce wait times
   82.5 ( 39.4/ 41.1/ 12.2)     30  I think too many people are
                                    downloading 10g database
   54.2 ( 21.0/ 30.6/ 16.0)     21  Is it just me?
   54.1 ( 20.4/ 28.7/ 13.2)     19  Creating Table as select...
   50.7 ( 14.6/ 28.2/ 16.0)     14  The Admin's point of view on DB users
                                    best practices
   47.4 ( 16.7/ 29.9/  7.2)     15  Personal Oracle Patch for XP
   45.4 ( 19.6/ 25.6/ 10.2)     15  rman recover/restore from backup
   39.6 ( 18.0/ 19.8/  9.0)     14  Oracle 10g kills 8i listener
   38.8 ( 22.1/ 15.2/ 10.7)     18  For the SQL Gurus out there, a
                                    question

These threads accounted for 38.8% of the total volume.

Top 10 Targets for Crossposts

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

       20  comp.databases.ms-sqlserver
       16  comp.databases.ibm-db2
       12  comp.databases.oracle
        6  comp.databases.oracle.marketplace
        6  ba.jobs.offered
        6  comp.jobs.offered
        5  comp.databases.oracle.tools
        4  comp.databases.oracle.misc
        3  comp.databases
        3  comp.database.oracle

Received on Sun Feb 15 2004 - 12:23:26 CST

Statistics for comp.databases.oracle.server - WE 02/15/2004