Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 08 Feb 2004 19:31:38 GMT
Message-ID: <u8wVb.254620$na.416584@attbi_s04>

Following is a summary of articles spanning a 7 day period, beginning at 01 Feb 2004 19:37:29 GMT and ending at 08 Feb 2004 19:02:50 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: 208
Articles: 667 (194 with cutlined signatures) Threads: 141

Volume generated: 1563.4 kb


     - headers:    739.8 kb (12,083 lines)

     - bodies:     770.5 kb (23,054 lines)

     - original:   409.0 kb (12,781 lines)

     - signatures: 52.5 kb (1,853 lines)


Original Content Rating: 0.531

Averages

Posts per poster: 3.2

     median: 1.0 post
     mode:   1 post - 113 posters
     s:      6.7 posts
Posts per thread: 4.7
     median: 3 posts
     mode:   2 posts - 35 threads
     s:      8.8 posts
Message size: 2400.1 bytes


     - header:     1135.7 bytes (18.1 lines)

     - body:       1182.9 bytes (34.6 lines)

     - original:   628.0 bytes (19.2 lines)

     - signature:  80.6 bytes (2.8 lines)

Top 10 Threads by Number of Posts

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

    82 yipeee!
    34 Oracle For Fun
    31 The Denis Prize
    15 oradim
    15 Avoiding any locks in SQL Servers - read and understand....its

        magic.
    12 Complex Query
    12 Oracle 9i features?
    12 Storing oracle procedures on server from inside.     11 How to calibrate the CBO
    11 Global Temporary Table Scalability Problem

These threads accounted for 35.2% of all articles.

Top 10 Threads by Volume

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

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

  186.4 (101.4/ 76.8/ 35.6)     82  yipeee!
   89.3 ( 47.0/ 40.1/ 14.6)     34  Oracle For Fun
   88.0 ( 34.4/ 51.5/ 22.6)     31  The Denis Prize
   57.7 ( 25.1/ 32.0/ 10.2)     15  Avoiding any locks in SQL Servers -
                                    read and understand....its magic.
   47.4 ( 11.9/ 35.4/ 12.8)     12  Complex Query
   45.8 ( 12.1/ 28.6/ 11.7)     11  How to calibrate the CBO
   36.8 ( 12.5/ 21.8/ 17.3)     11  Global Temporary Table Scalability
                                    Problem
   36.8 ( 18.7/ 16.4/  8.3)     15  oradim
   32.9 ( 12.4/ 17.9/  9.9)      9  Space Usage Question
   28.5 ( 14.2/ 13.7/  8.0)     12  Oracle 9i features?

These threads accounted for 41.6% of the total volume.

Top 10 Targets for Crossposts

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

       70  comp.databases.ibm-db2
       35  comp.databases.oracle.misc
       22  comp.databases.oracle
       20  comp.databases
       18  comp.databases.oracle.tools
        2  comp.sys.sun.admin
        2  comp.databases.ms-sqlserver
        1  comp.lang.java.databases
        1  comp.databases.oracle.marketplace
        1  comp.databases.paradox

Received on Sun Feb 08 2004 - 13:31:38 CST

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