Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 20 Jul 2003 17:28:33 GMT
Message-ID: <5jASa.93478$GL4.26450@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 13 Jul 2003 18:54:23 GMT and ending at 20 Jul 2003 17:12:43 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: 210
Trolls: 1
Articles: 654 (67 with cutlined signatures) Threads: 154
Volume generated: 2475.3 kb

headers: 720.0 kb (11,553 lines)
bodies: 1716.2 kb (37,073 lines)
original: 1353.0 kb (27,022 lines)
signatures: 38.4 kb (1,058 lines)

Original Content Rating: 0.788

Averages

Posts per poster: 3.1

     median: 1 post
     mode:   1 post - 109 posters
     s:      5.5 posts
Posts per thread: 4.2
     median: 3.0 posts
     mode:   1 post - 41 threads
     s:      5.1 posts
Message size: 3875.7 bytes


     - header:     1127.4 bytes (17.7 lines)

     - body:       2687.2 bytes (56.7 lines)

     - original:   2118.4 bytes (41.3 lines)

     - signature:  60.1 bytes (1.6 lines)

Top 10 Threads by Number of Posts

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

    33 Orbitz blames Oracle for site outage     19 'Unbreakable' marketing strategy irresponsible?     17 bitmap join index error
    16 ORACLE RAC CRASHES ORBITZ
    16 Sure-fire "kill"
    15 Orbitz dumps RAC for better reliability     14 Restricting user access to a database?     13 tracking changes on a table through ODBC application     13 PGSQL wins Linux Journal Awards...     12 Bending the rules using MERGE INTO

These threads accounted for 25.7% of all articles.

Top 10 Threads by Volume

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

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

  904.1 (  1.4/902.7/898.1)      1  Oracle Intelligent Agent Executable
   70.5 ( 38.1/ 30.8/ 16.0)     33  Orbitz blames Oracle for site outage
   46.6 ( 19.8/ 26.2/ 10.8)     16  Sure-fire "kill"
   41.3 ( 18.4/ 22.9/ 13.0)     17  bitmap join index error
   41.2 ( 19.2/ 21.8/ 12.8)     15  Orbitz dumps RAC for better
                                    reliability
   38.8 ( 23.2/ 15.3/  8.7)     19  'Unbreakable' marketing strategy
                                    irresponsible?
   37.8 ( 11.2/ 26.5/ 18.7)     10  Ghost index prevents DROP USER
                                    CASCADE
   37.1 ( 13.9/ 22.9/ 12.5)     14  Restricting user access to a
                                    database?
   36.7 ( 14.7/ 22.0/  9.3)     13  tracking changes on a table through
                                    ODBC application
   35.4 (  7.2/ 28.2/ 16.5)      6  Tunning Indexes

These threads accounted for 52.1% of the total volume.

Top 10 Targets for Crossposts

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

       71  comp.databases.oracle.tools
       66  comp.databases.oracle.misc
       29  comp.databases.oracle
       14  comp.database.oracle
        9  comp.databases.ibm-db2
        9  comp.databased.oracle.misc
        8  comp.databases.informix
        6  comp.databases.ms-sqlserver
        5  comp.database.oracle.misc
        5  comp.os.linux.security

Received on Sun Jul 20 2003 - 12:28:33 CDT

Statistics for comp.databases.oracle.server - WE 07/20/2003