Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 14 Dec 2003 23:01:07 GMT
Message-ID: <TY5Db.546868$Tr4.1484213@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 07 Dec 2003 23:09:45 GMT and ending at 14 Dec 2003 22:27:28 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: 173
Articles: 519 (168 with cutlined signatures) Threads: 123

Volume generated: 1255.9 kb


     - headers:    592.2 kb (9,341 lines)

     - bodies:     627.8 kb (17,474 lines)

     - original:   328.4 kb (9,391 lines)

     - signatures: 35.3 kb (1,167 lines)


Original Content Rating: 0.523

Averages

Posts per poster: 3.0

     median: 1 post
     mode:   1 post - 91 posters
     s:      5.4 posts
Posts per thread: 4.2
     median: 3 posts
     mode:   1 post - 28 threads
     s:      4.0 posts
Message size: 2477.9 bytes


     - header:     1168.5 bytes (18.0 lines)

     - body:       1238.7 bytes (33.7 lines)

     - original:   648.0 bytes (18.1 lines)

     - signature:  69.7 bytes (2.2 lines)

Top 10 Threads by Number of Posts

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

    31 developer privs in development (old thread inaccessible)     17 Improve query performance
    16 Caching within packages..
    14 OCP Certification
    11 Internal lock
    11 terabytes of storage
    11 Deadly sins againts database performance/scalability     10 Multi-Master Replication over an air-gap

     9  kill session actually nicely ask for suicide ...
     9  Auditing question

These threads accounted for 26.8% of all articles.

Top 10 Threads by Volume

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

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

   87.5 ( 39.0/ 46.5/ 19.3)     31  developer privs in development (old
                                    thread inaccessible)
   49.6 ( 20.6/ 26.6/  9.2)     17  Improve query performance
   43.0 (  9.6/ 33.3/  9.6)      7  benefits of multiple switch logfile
                                    calls?
   39.4 ( 15.5/ 20.2/  8.2)     14  OCP Certification
   34.2 ( 20.0/ 13.3/  6.4)     16  Caching within packages..
   27.8 ( 16.0/ 11.1/  5.4)     11  Deadly sins againts database
                                    performance/scalability
   27.7 ( 12.1/ 13.5/  4.9)     11  terabytes of storage
   25.9 ( 11.0/ 14.3/  5.9)      8  Oracle's Mission Statement
   22.2 ( 10.3/ 11.4/  4.8)      9  Which index to create ?
   21.6 ( 12.4/  9.0/  3.1)     11  Internal lock

These threads accounted for 30.2% of the total volume.

Top 10 Targets for Crossposts

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

       10  comp.databases.oracle.tools
        8  comp.databases.oracle.marketplace
        8  comp.databases.oracle.misc
        2  comp.databases.oracle
        1  rec.autos.makers.ford.mustang
        1  comp.databases.ibm-db2
        1  rec.arts.comics.strips
        1  rec.games.computer.doom.editing

Received on Sun Dec 14 2003 - 17:01:07 CST

Statistics for comp.databases.oracle.server - WE 12/14/2003