Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Mon, 09 Aug 2004 03:51:59 GMT
Message-ID: <zxCRc.253064$JR4.238632@attbi_s54>

Following is a summary of articles spanning a 7 day period, beginning at 02 Aug 2004 04:43:35 GMT and ending at 08 Aug 2004 07:39:29 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: 153
Articles: 534 (128 with cutlined signatures) Threads: 113

Volume generated: 1180.1 kb


     - headers:    559.9 kb (9,468 lines)

     - bodies:     605.4 kb (18,736 lines)

     - original:   313.4 kb (10,015 lines)

     - signatures: 14.3 kb (623 lines)


Original Content Rating: 0.518

Averages

Posts per poster: 3.5

     median: 1 post
     mode:   1 post - 77 posters
     s:      7.4 posts
Posts per thread: 4.7
     median: 3 posts
     mode:   2 posts - 25 threads
     s:      6.2 posts
Message size: 2262.9 bytes


     - header:     1073.6 bytes (17.7 lines)

     - body:       1160.9 bytes (35.1 lines)

     - original:   600.9 bytes (18.8 lines)

     - signature:  27.4 bytes (1.2 lines)

Top 10 Threads by Number of Posts

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

    50 Is Raid 5 really that bad for Oracle?     29 Which is better: Oracle or SQLServer     23 Dynamic SGA and pinned
    18 First
    16 What Java tools/application should I use for this... pls help..     14 Block DML!?
    13 Control File Sequential Read - top wait     12 oracle table to flat file?
    11 Simple question ...
    11 Separate foreign keys with shared ID space

These threads accounted for 36.9% of all articles.

Top 10 Threads by Volume

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

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

  124.2 ( 59.9/ 61.7/ 27.1)     50  Is Raid 5 really that bad for Oracle?
   70.9 ( 26.1/ 43.9/ 24.8)     23  Dynamic SGA and pinned
   50.1 ( 31.7/ 16.0/  7.1)     29  Which is better: Oracle or SQLServer
   40.0 ( 17.6/ 21.7/  6.2)     18  First
   33.1 ( 18.7/ 14.0/  6.1)     16  What Java tools/application should I
                                    use for this... pls help..
   32.1 ( 16.5/ 15.3/ 12.7)     11  Separate foreign keys with shared ID
                                    space
   29.6 (  7.1/ 22.6/ 10.1)      7  Odd maximum elapsed event times in
                                    raw 10046 trace
   29.0 ( 14.1/ 14.5/  5.0)     14  Block DML!?
   28.6 ( 16.8/ 11.5/  6.4)     13  Control File Sequential Read - top
                                    wait
   25.5 ( 12.5/ 13.0/  5.9)     12  oracle table to flat file?

These threads accounted for 39.2% of the total volume.

Top 10 Targets for Crossposts

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

       18  comp.databases.oracle.tools
       11  comp.databases
       11  comp.databases.ms-sqlserver
       11  comp.databases.theory
       10  comp.databases.oracle.misc
        8  comp.databases.oracle
        5  comp.databases.oracle.marketplace
        4  comp.database.oracle.misc
        4  comp.database.oracle.server
        4  comp.databases.olap

Received on Sun Aug 08 2004 - 22:51:59 CDT

Statistics for comp.databases.oracle.server - WE 08/08/2004