Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 10 Aug 2003 21:49:18 GMT
Message-ID: <y5zZa.115608$uu5.17073@sccrnsc04>

Following is a summary of articles spanning a 7 day period, beginning at 03 Aug 2003 23:16:22 GMT and ending at 10 Aug 2003 16:10:57 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: 707 (87 with cutlined signatures) Threads: 178

Volume generated: 1671.7 kb


     - headers:    773.1 kb (12,318 lines)

     - bodies:     869.7 kb (25,769 lines)

     - original:   470.2 kb (14,699 lines)

     - signatures: 28.3 kb (913 lines)


Original Content Rating: 0.541

Averages

Posts per poster: 3.6

     median: 2 posts
     mode:   1 post - 98 posters
     s:      6.7 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   2 posts - 44 threads
     s:      6.5 posts
Message size: 2421.3 bytes


     - header:     1119.7 bytes (17.4 lines)

     - body:       1259.6 bytes (36.4 lines)

     - original:   681.1 bytes (20.8 lines)

     - signature:  40.9 bytes (1.3 lines)

Top 10 Threads by Number of Posts

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

    33 design question, use of partitioned tables?     32 MySQL 4
    17 SYS vs. SYSTEM
    15 Can DBA Jobs be Outsourced ???
    14 async i/o via nfs?
    13 database could not be started
    12 When DO You Use a Semicolon?
    11 Help needed with Import/Export
    10 analyzing slow connections
    10 Fine-grained Access Control and constraint violations

These threads accounted for 23.6% of all articles.

Top 10 Threads by Volume

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

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

  102.6 ( 44.5/ 58.1/ 31.9)     33  design question, use of partitioned
                                    tables?
   65.8 ( 37.2/ 27.5/ 12.4)     32  MySQL 4
   51.7 ( 15.4/ 30.6/ 19.4)     13  database could not be started
   41.6 ( 19.4/ 21.7/ 14.6)     17  SYS vs. SYSTEM
   38.9 ( 13.0/ 19.1/  9.3)     11  Help needed with Import/Export
   36.1 ( 11.2/ 24.7/  7.6)     10  analyzing slow connections
   33.7 ( 16.4/ 17.1/  9.7)     14  async i/o via nfs?
   33.7 ( 16.9/ 16.8/ 10.3)     15  Can DBA Jobs be Outsourced ???
   30.5 ( 10.6/ 19.9/  9.2)     10  Fine-grained Access Control and
                                    constraint violations
   27.3 ( 10.5/ 16.6/ 12.5)      9  A kind of... benchmark?

These threads accounted for 27.6% of the total volume.

Top 10 Targets for Crossposts

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

       18  comp.databases.oracle.misc
        7  comp.databases.oracle
        6  comp.databases.ibm-db2
        5  comp.databases.oracle.tools
        5  comp.databases.ms-sqlserver
        4  comp.databases.sybase
        4  alt.apache.configuration
        4  comp.databases.theory
        3  mailing.database.mysql
        3  comp.database.oracle

Received on Sun Aug 10 2003 - 16:49:18 CDT

Statistics for comp.databases.oracle.server - WE 08/10/2003