Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 18 Apr 2004 17:56:53 GMT
Message-ID: <Fjzgc.161167$w54.1091655@attbi_s01>

Following is a summary of articles spanning a 7 day period, beginning at 11 Apr 2004 18:20:50 GMT and ending at 18 Apr 2004 17:42:47 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: 136
Articles: 382 (91 with cutlined signatures) Threads: 92
Volume generated: 891.6 kb

headers: 401.7 kb (6,874 lines)
bodies: 466.5 kb (13,847 lines)
original: 265.2 kb (8,197 lines)
signatures: 23.1 kb (771 lines)

Original Content Rating: 0.568

Averages

Posts per poster: 2.8

     median: 1.0 post
     mode:   1 post - 76 posters
     s:      4.8 posts
Posts per thread: 4.2
     median: 3.0 posts
     mode:   1 post - 24 threads
     s:      5.7 posts
Message size: 2390.1 bytes


     - header:     1076.7 bytes (18.0 lines)

     - body:       1250.5 bytes (36.2 lines)

     - original:   710.9 bytes (21.5 lines)

     - signature:  61.8 bytes (2.0 lines)

Top 10 Threads by Number of Posts

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

    44 The old raw devices chestnut.
    21 Creating datafiles for 500GB database     15 Date ... Date ...Da
    14 can wild cards be used in BETWEEN clause     12 Oracle 9i client 10g database

     9  Entry of "dispatchers" parameter on Oracle 9 - how?
     8  Newbie question on how to change Oracle 9i listener port number
     8  Converting from WE8MSWIN1252 to WE8ISO8859P1
     8  Table partitioning problem
     7  Open_Cursors

These threads accounted for 38.2% of all articles.

Top 10 Threads by Volume

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

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

  138.3 ( 56.4/ 79.0/ 48.0)     44  The old raw devices chestnut.
   48.4 ( 23.2/ 23.1/ 10.7)     21  Creating datafiles for 500GB database
   40.6 (  6.0/ 33.7/ 22.9)      6  Create RAC database manually on Linux
   34.4 ( 14.7/ 18.5/  7.8)     12  Oracle 9i client 10g database
   34.1 ( 16.2/ 17.5/ 10.2)     15  Date ... Date ...Da
   27.6 ( 13.9/ 12.0/  7.0)     14  can wild cards be used in BETWEEN
                                    clause
   22.5 (  8.6/ 11.9/  5.1)      8  Table partitioning problem
   22.3 (  4.9/ 16.9/  8.2)      5  Oracle 9i on Red Hat 9 crash with
                                    SIGSEGV periodicaly.
   21.2 (  9.8/ 11.3/  2.5)      8  Newbie question on how to change
                                    Oracle 9i listener port number
   17.7 (  9.0/  8.7/  5.4)      8  Converting from WE8MSWIN1252 to
                                    WE8ISO8859P1

These threads accounted for 45.6% of the total volume.

Top 10 Targets for Crossposts

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

       43  comp.databases.sybase
       43  comp.databases.informix
       42  comp.databases.ibm-db2
        6  comp.databases.oracle.misc
        2  comp.unix.solaris

Received on Sun Apr 18 2004 - 12:56:53 CDT

Statistics for comp.databases.oracle.server - WE 04/18/2004