Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Mon, 26 Jul 2004 01:31:26 GMT
Message-ID: <O9ZMc.163239$IQ4.8088@attbi_s02>

Following is a summary of articles spanning a 7 day period, beginning at 19 Jul 2004 01:25:02 GMT and ending at 26 Jul 2004 00:43:07 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: 172
Articles: 523 (108 with cutlined signatures) Threads: 115

Volume generated: 1167.8 kb


     - headers:    559.6 kb (9,362 lines)

     - bodies:     577.9 kb (17,570 lines)

     - original:   292.9 kb (9,303 lines)

     - signatures: 29.8 kb (1,085 lines)


Original Content Rating: 0.507

Averages

Posts per poster: 3.0

     median: 1.0 post
     mode:   1 post - 94 posters
     s:      6.3 posts
Posts per thread: 4.5
     median: 3 posts
     mode:   2 posts - 27 threads
     s:      5.9 posts
Message size: 2286.5 bytes


     - header:     1095.6 bytes (17.9 lines)

     - body:       1131.4 bytes (33.6 lines)

     - original:   573.4 bytes (17.8 lines)

     - signature:  58.4 bytes (2.1 lines)

Top 10 Threads by Number of Posts

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

    43 oracle - mysql comparison
    33 maximum number of columns per table     19 10046 Trace Overhead
    15 It makes me go nuts!!!!!!!!
    15 connecting automatically as sys
    13 10g database dev edition available on CD?     13 REe: OMLET: The Ultimate Oracle Monitoring Tool     12 backup - openVMS 7.3-1 and Oracle 8.1.7     12 Alert log
    11 stored procedures?

These threads accounted for 35.6% of all articles.

Top 10 Threads by Volume

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

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

  133.7 ( 62.7/ 69.0/ 26.2)     43  oracle - mysql comparison
   82.9 ( 35.1/ 47.5/ 18.2)     33  maximum number of columns per table
   42.5 ( 23.5/ 11.2/  6.8)     19  10046 Trace Overhead
   38.6 ( 11.8/ 26.7/  7.8)     10  Database won't start Automatic, balks
                                    at datafile mount
   35.5 ( 17.4/ 17.6/  9.6)     15  connecting automatically as sys
   32.2 ( 12.8/ 11.5/  7.3)     12  backup - openVMS 7.3-1 and Oracle
                                    8.1.7
   29.5 ( 14.8/ 14.6/  8.1)     13  10g database dev edition available on
                                    CD?
   26.5 (  8.0/ 18.3/  5.4)      9  query help
   24.1 ( 10.3/ 13.5/  7.7)     11  Control File Sequential Read - top
                                    wait
   23.7 ( 13.9/  9.5/  5.8)     12  Alert log

These threads accounted for 40.2% of the total volume.

Top 10 Targets for Crossposts

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

       41  mailing.database.mysql
       33  comp.databases.oracle.misc
       22  comp.databases.oracle.tools
        9  comp.databases.oracle
        9  alt.solaris.x86
        5  comp.databases.oracle.marketplace
        4  comp.databases.paradox
        3  comp.databases.pick
        2  comp.databases.ms-sqlserver
        2  comp.databases.orcale

Received on Sun Jul 25 2004 - 20:31:26 CDT

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