Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 14 Mar 2004 00:51:02 GMT
Message-ID: <W%N4c.8202$1p.175738@attbi_s54>

Following is a summary of articles spanning a 7 day period, beginning at 07 Mar 2004 03:07:37 GMT and ending at 13 Mar 2004 23:02:37 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: 179
Articles: 621 (181 with cutlined signatures) Threads: 134
Volume generated: 1837.0 kb

headers: 658.0 kb (11,218 lines)
bodies: 1132.9 kb (26,603 lines)
original: 798.4 kb (16,976 lines)
signatures: 45.5 kb (1,494 lines)

Original Content Rating: 0.705

Averages

Posts per poster: 3.5

     median: 2 posts
     mode:   1 post - 86 posters
     s:      7.1 posts
Posts per thread: 4.6
     median: 3.0 posts
     mode:   1 post - 29 threads
     s:      5.1 posts
Message size: 3029.1 bytes


     - header:     1085.0 bytes (18.1 lines)

     - body:       1868.0 bytes (42.8 lines)

     - original:   1316.5 bytes (27.3 lines)

     - signature:  75.1 bytes (2.4 lines)

Top 10 Threads by Number of Posts

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

    28 MS SQL Server Evaluation
    22 Alert Log Monitoring / Notification     21 UTL_FILE.RENAME
    16 Audit command help
    14 how to find if a session is resumable     13 Monster Update
    13 Select all tables from schema
    12 alter session set sql_trace inside a procedure     12 LENTEZZA SU SUSE
    11 Oracle continues outsourcing jobs

These threads accounted for 26.1% of all articles.

Top 10 Threads by Volume

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

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

  240.7 (  0.9/239.8/239.7)      1  Hi, devel, congratulations!
  240.7 (  0.9/239.8/239.7)      1  here<B4>s the archive you requested
  103.4 ( 32.3/ 66.9/ 28.8)     28  MS SQL Server Evaluation
   46.8 ( 24.5/ 14.3/  8.0)     22  Alert Log Monitoring / Notification
   41.4 ( 23.3/ 15.5/  6.1)     21  UTL_FILE.RENAME
   39.8 ( 16.3/ 21.6/  8.6)     16  Audit command help
   35.6 ( 15.4/ 18.0/  5.3)     12  alter session set sql_trace inside a
                                    procedure
   30.1 ( 15.6/ 14.1/  4.3)     14  how to find if a session is resumable
   28.8 (  9.3/ 19.2/ 11.7)      9  SQL Serious Challenge # 1 - Probably
                                    Not Much Fun
   28.8 ( 13.1/ 15.5/  4.2)     13  Monster Update

These threads accounted for 45.5% of the total volume.

Top 10 Targets for Crossposts

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

       13  comp.databases.oracle.misc
        5  microsoft.public.sqlserver.datawarehouse
        5  microsoft.public.sqlserver.olap
        5  comp.databases.oracle.marketplace
        5  comp.databases.olap
        3  comp.databases.oracle.tools
        3  comp.databases.oracle
        2  comp.sys.hp.hpux
        2  comp.database.oracle
        1  microsoft.public.dotnet.framework.adonet

Received on Sat Mar 13 2004 - 18:51:02 CST

Statistics for comp.databases.oracle.server - WE 03/13/2004