Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 02 Jun 2003 03:41:42 GMT
Message-ID: <WHzCa.15357$DV.17892@rwcrnsc52.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 26 May 2003 04:09:02 GMT and ending at 02 Jun 2003 03:24: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: 201
Articles: 743 (88 with cutlined signatures) Threads: 159

Volume generated: 1793.0 kb


     - headers:    814.4 kb (13,163 lines)

     - bodies:     942.7 kb (28,355 lines)

     - original:   507.3 kb (16,037 lines)

     - signatures: 35.1 kb (1,222 lines)


Original Content Rating: 0.538

Averages

Posts per poster: 3.7

     median: 2 posts
     mode:   1 post - 91 posters
     s:      6.7 posts
Posts per thread: 4.7
     median: 3 posts
     mode:   1 post - 45 threads
     s:      10.7 posts
Message size: 2471.0 bytes


     - header:     1122.4 bytes (17.7 lines)

     - body:       1299.2 bytes (38.2 lines)

     - original:   699.2 bytes (21.6 lines)

     - signature:  48.4 bytes (1.6 lines)

Top 10 Threads by Number of Posts

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

    31 How do you grant connection permission to a user?     29 Transaction Gradually Slows to a crawl! (please help)     20 Worst of the worst
    20 What kind of a DBA are you?
    19 query performance -- revised!
    18 Find Empty Tables
    17 10i
    16 Linux beats out M$
    16 suspicious standard Oracle Linux start/stop script     15 variable column table

These threads accounted for 27.1% of all articles.

Top 10 Threads by Volume

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

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

   78.5 ( 34.3/ 42.7/ 16.3)     29  Transaction Gradually Slows to a
                                    crawl! (please help)
   66.4 ( 35.8/ 27.2/ 15.5)     31  How do you grant connection
                                    permission to a user?
   57.0 ( 18.8/ 34.0/ 15.2)     16  suspicious standard Oracle Linux
                                    start/stop script
   54.6 ( 22.2/ 32.0/ 14.2)     20  Worst of the worst
   50.6 ( 22.0/ 26.4/ 11.2)     19  query performance -- revised!
   44.9 (  5.4/ 39.5/ 16.3)      5  UTL_FILE help appending
   39.2 ( 19.2/ 18.0/ 12.4)     14  Oh, this is so microsoftish ...
   39.0 ( 16.2/ 22.5/  9.5)     15  shutdown database(s) from root user
   38.6 ( 19.7/ 18.9/ 11.5)     18  Find Empty Tables
   38.5 (  7.8/ 30.8/ 12.6)      7  Oracle 9i Limitation (Bug?) in
                                    Identifying Key Preserved Tables in
                                    Views

These threads accounted for 28.3% of the total volume.

Top 10 Targets for Crossposts

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

       17  comp.databases.oracle.tools
       10  comp.database.oracle
        8  comp.databases.oracle
        8  comp.database.oracle.server
        7  comp.databases.oracle.misc
        6  comp.lang.java.databases
        2  comp.databases.oracle.marketplace
        1  comp.databases.paradox
        1  ibm.software.websphere.application-server
        1  comp.databases.pick

Received on Sun Jun 01 2003 - 22:41:42 CDT

Statistics for comp.databases.oracle.server - WE 06/01/2003