Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 09 May 2004 17:42:43 GMT
Message-ID: <n4unc.13547$iF6.1386052@attbi_s02>

Following is a summary of articles spanning a 7 day period, beginning at 02 May 2004 18:19:23 GMT and ending at 09 May 2004 16:11:55 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: 158
Articles: 476 (121 with cutlined signatures) Threads: 112
Volume generated: 1576.3 kb

headers: 506.9 kb (8,657 lines)
bodies: 1038.1 kb (24,807 lines)
original: 606.3 kb (14,702 lines)
signatures: 30.8 kb (1,110 lines)

Original Content Rating: 0.584

Averages

Posts per poster: 3.0

     median: 1.0 post
     mode:   1 post - 92 posters
     s:      6.2 posts
Posts per thread: 4.2
     median: 3.0 posts
     mode:   1 post - 27 threads
     s:      5.5 posts
Message size: 3391.0 bytes


     - header:     1090.5 bytes (18.2 lines)

     - body:       2233.3 bytes (52.1 lines)

     - original:   1304.3 bytes (30.9 lines)

     - signature:  66.2 bytes (2.3 lines)

Top 10 Threads by Number of Posts

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

    45 Index management
    25 Maybe we did some good here....
    14 What so special about PostgreSQL and other RDBMS?     13 indexes reserve too much extents     13 Index maintenance...
    12 Oracle Report Generator - SPAMMERS needed     12 Instance won't start up after powerfail     11 Graphical statspack utility
    10 OCP - Finish the 8i exams or startover on 9i track      9 SQL Tuning Question (8.1.7)

These threads accounted for 34.5% of all articles.

Top 10 Threads by Volume

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

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

  460.4 ( 13.9/446.2/291.5)     13  indexes reserve too much extents
  150.5 ( 54.0/ 92.3/ 53.5)     45  Index management
   67.5 ( 14.4/ 53.1/ 25.4)     12  Oracle Report Generator - SPAMMERS
                                    needed
   59.0 ( 30.5/ 26.1/ 13.9)     25  Maybe we did some good here....
   33.2 ( 13.1/ 19.3/  7.0)     12  Instance won't start up after
                                    powerfail
   30.1 ( 16.1/ 13.5/  7.2)     14  What so special about PostgreSQL and
                                    other RDBMS?
   25.9 ( 14.4/ 10.5/  6.3)     13  Index maintenance...
   24.0 (  9.2/ 14.7/  7.9)      9  SQL Tuning Question (8.1.7)
   23.2 (  8.3/ 14.7/  9.9)      8  RAC for Reporting...!
   20.4 ( 10.7/  9.1/  3.6)     10  OCP - Finish the 8i exams or
                                    startover on 9i track

These threads accounted for 56.7% of the total volume.

Top 10 Targets for Crossposts

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

       24  comp.databases.oracle.misc
       12  comp.databases.oracle.tools
        5  comp.soft-sys.powerbuilder
        3  comp.databases.ms-sqlserver
        3  comp.databases.sybase
        2  comp.database.oracle.misc
        2  alt.php.sql
        1  comp.lang.php
        1  comp.databases.oracle.marketplace
        1  comp.lang.ruby

Received on Sun May 09 2004 - 12:42:43 CDT

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