Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 02 May 2004 18:43:36 GMT
Message-ID: <rjblc.16729$kh4.923582@attbi_s52>

Following is a summary of articles spanning a 7 day period, beginning at 25 Apr 2004 21:15:01 GMT and ending at 02 May 2004 18:22:48 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: 160
Articles: 489 (84 with cutlined signatures) Threads: 120

Volume generated: 1248.7 kb


     - headers:    501.4 kb (8,790 lines)

     - bodies:     643.7 kb (19,966 lines)

     - original:   392.0 kb (12,577 lines)

     - signatures: 103.1 kb (2,793 lines)


Original Content Rating: 0.609

Averages

Posts per poster: 3.1

     median: 2.0 posts
     mode:   1 post - 72 posters
     s:      5.6 posts
Posts per thread: 4.1
     median: 3.0 posts
     mode:   1 post - 29 threads
     s:      4.5 posts
Message size: 2614.8 bytes


     - header:     1049.9 bytes (18.0 lines)

     - body:       1347.9 bytes (40.8 lines)

     - original:   820.8 bytes (25.7 lines)

     - signature:  215.9 bytes (5.7 lines)

Top 10 Threads by Number of Posts

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

    24 W2000 connect / as sysdba problem     18 Index management
    17 Incorrect Migrated/Chained rows...     17 delete from a view
    17 Can Oracle save a tree?
    15 Any thoughts?
    13 - determine Operating system using pl/sql??     11 Can someone briefly refresh my memory...     10 Oracle 7 > Oracle 9 question
    10 LTM These threads accounted for 31.1% of all articles.

Top 10 Threads by Volume

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

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

  136.5 (  6.7/ 66.6/ 62.3)      7  Statspack
   80.3 ( 26.2/ 54.1/ 24.3)     24  W2000  connect / as sysdba problem
   57.7 ( 21.1/ 28.0/ 19.2)     18  Index management
   47.0 ( 17.9/ 20.7/ 14.5)     17  Incorrect Migrated/Chained rows...
   42.7 ( 17.7/ 23.8/ 13.7)     17  Can Oracle save a tree?
   39.0 (  5.0/ 34.0/ 28.8)      4  ORA-00202: controlfile:'/var/opt 

                                    /oracle/oradata /orcl/control03.ctl'
   37.3 ( 21.8/ 14.7/  6.1)     17  delete from a view
   35.3 ( 15.4/ 18.6/  6.5)     15  Any thoughts?
   26.3 ( 13.7/ 12.4/  5.8)     13  - determine Operating system using
                                    pl/sql??
   24.3 ( 10.0/ 13.7/  6.2)     10  Oracle 7 > Oracle 9 question

These threads accounted for 42.2% of the total volume.

Top 10 Targets for Crossposts

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

       18  comp.databases.oracle.misc
        9  comp.databases.oracle.tools
        6  comp.databases
        6  comp.databases.ms-sqlserver
        4  comp.databases.oracle
        3  comp.databases.oracle.marketplace
        2  alt.hypnotherapy
        2  alt.animals.giraffes

Received on Sun May 02 2004 - 13:43:36 CDT

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