Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 17 Aug 2003 03:27:06 GMT
Message-ID: <eCC%a.136156$Oz4.26999@rwcrnsc54>

Following is a summary of articles spanning a 7 day period, beginning at 10 Aug 2003 04:32:20 GMT and ending at 17 Aug 2003 01:30:51 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: 175
Articles: 625 (95 with cutlined signatures) Threads: 138

Volume generated: 1431.2 kb


     - headers:    694.3 kb (10,897 lines)

     - bodies:     698.5 kb (21,138 lines)

     - original:   370.2 kb (12,072 lines)

     - signatures: 37.8 kb (1,258 lines)


Original Content Rating: 0.530

Averages

Posts per poster: 3.6

     median: 1 post
     mode:   1 post - 96 posters
     s:      11.2 posts
Posts per thread: 4.5
     median: 3.0 posts
     mode:   1 post - 36 threads
     s:      5.0 posts
Message size: 2344.8 bytes


     - header:     1137.5 bytes (17.4 lines)

     - body:       1144.5 bytes (33.8 lines)

     - original:   606.6 bytes (19.3 lines)

     - signature:  61.9 bytes (2.0 lines)

Top 10 Threads by Number of Posts

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

    31 Preferred method in creating primary key     30 someone noticed 90 percent indians posting on asktom.oracle.com     23 A few NG related questions
    19 Empty table - many extents
    17 Log file I/O throughput
    16 database could not be started
    13 Object refuses to drop
    13 Autostarting 9iAS
    13 Trace Files
    12 Tables and ring-like data structure?

These threads accounted for 29.9% of all articles.

Top 10 Threads by Volume

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

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

   81.2 ( 35.7/ 44.9/ 23.8)     30  someone noticed 90 percent indians
                                    posting on asktom.oracle.com
   78.2 ( 34.3/ 43.2/ 18.2)     31  Preferred method in creating primary
                                    key
   71.4 ( 24.0/ 30.0/ 20.4)     16  database could not be started
   57.8 ( 26.7/ 30.2/ 14.6)     23  A few NG related questions
   43.0 ( 22.3/ 20.5/ 12.5)     19  Empty table - many extents
   42.2 ( 18.7/ 23.0/ 10.1)     17  Log file I/O throughput
   38.7 ( 14.5/ 23.9/  6.0)     13  Object refuses to drop
   30.4 ( 13.6/ 16.9/  6.1)     13  Autostarting 9iAS
   30.4 ( 12.0/ 18.0/  8.5)     11  New challenge - clustering - do I
                                    understand this correctly?
   30.1 ( 13.0/ 15.1/  8.7)     12  Tables and ring-like data structure?

These threads accounted for 35.2% of the total volume.

Top 10 Targets for Crossposts

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

        5  comp.databases.oracle.tools
        3  comp.databases.oracle
        3  comp.databases.oracle.misc
        2  comp.unix.solaris
        1  comp.databases.orcale.marketplace

Received on Sat Aug 16 2003 - 22:27:06 CDT

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