Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 30 Mar 2003 10:37:20 GMT
Message-ID: <BAAC08DE.ED4A%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 23 Mar 2003 11:51:47 GMT and ending at 30 Mar 2003 09:53:23 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: 207
Articles: 521 (69 with cutlined signatures) Threads: 163
Volume generated: 1135.1 kb

headers: 557.9 kb (8,990 lines)
bodies: 569.1 kb (17,677 lines)
original: 325.5 kb (10,701 lines)
signatures: 7.5 kb (274 lines)

Original Content Rating: 0.572

Averages

Posts per poster: 2.5

    median: 1 post
    mode: 1 post - 114 posters
    s: 3.6 posts
Posts per thread: 3.2

    median: 2 posts
    mode: 1 post - 50 threads
    s: 3.4 posts
Message size: 2230.9 bytes

header: 1096.6 bytes (17.3 lines)
body: 1118.5 bytes (33.9 lines)
original: 639.7 bytes (20.5 lines)
signature: 14.8 bytes (0.5 lines)

Top 10 Posters by Volume

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

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

 104.0 ( 41.8/ 62.1/ 37.2)     34  Howard J. Rogers
  51.2 ( 20.6/ 27.7/  5.4)     23  Connor McDonald
  35.1 ( 18.6/ 16.5/ 15.6)     14  Norman Dunbar
  32.0 ( 16.7/ 15.3/ 13.1)     16  Hans Forbrich
  30.5 ( 17.6/ 12.9/  4.2)     16  DA Morgan
  29.5 ( 14.3/ 15.2/  8.1)     13  Paul Brewer
  21.0 ( 12.0/  8.5/  5.4)     10  Noons
  20.2 (  8.1/ 11.5/  5.9)      9  Galen Boyer
  19.6 (  6.1/ 13.5/  4.8)      6  Yong Huang
  19.1 (  9.4/  9.7/  6.0)      7  Chuck

These posters accounted for 31.9% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

         (kb)    (kb)
OCR      orig /  body  Posts  Address

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

0.946  ( 15.6 / 16.5)     14  Norman Dunbar
0.903  (  2.8 /  3.1)      5  Daniel Roy
0.853  ( 13.1 / 15.3)     16  Hans Forbrich
0.772  (  6.1 /  7.9)      5  Billy Verreynne
0.647  (  3.8 /  5.8)      5  Nuno Souto
0.645  (  3.4 /  5.3)      7  Tim Smith
0.639  (  5.4 /  8.5)     10  Noons
0.624  (  6.0 /  9.7)      7  Chuck
0.618  (  4.9 /  7.9)      8  Ed Stevens
0.600  ( 37.2 / 62.1)     34  Howard J. Rogers

Top 10 Threads by Number of Posts

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

   18 Off Topic : VNC
   18 Looking for a way to implement SQL-92 Domain    16 Managing Oracle with R-commands vs. SSH    11 Locking Question (nowait, UPDATE etc)    11 pro C versus PL/SQL
   10 Hash join order
   10 Database link between Oracle7 and Oracle8     9 Installing Oracle on uncertified Linux, like Debian, Download RedHat,

       Gentoo ?
    9 BOOK
    8 Speed executing

These threads accounted for 23.0% of all articles.

Top 10 Threads by Volume

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

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

  53.9 ( 19.9/ 33.7/ 17.8)     18  Off Topic : VNC
  41.2 ( 17.8/ 22.7/ 14.4)     18  Looking for a way to implement SQL-92
                                   Domain
  37.1 ( 19.7/ 17.0/  9.8)     16  Managing Oracle with R-commands vs. SSH
  33.1 ( 10.9/ 21.5/ 11.0)     11  Locking Question (nowait, UPDATE etc)
  29.7 (  8.0/ 21.4/  4.6)      8  multi column range partitioning
  29.1 ( 10.8/ 18.0/  8.8)     10  Hash join order
  28.2 ( 11.6/ 16.5/  8.2)      9  Installing Oracle on uncertified Linux,
                                   like Debian, Download RedHat, Gentoo ?
  27.8 ( 12.3/ 15.3/  7.6)     11  pro C versus PL/SQL
  22.1 ( 10.9/ 11.1/  5.7)     10  Database link between Oracle7 and Oracle8
  19.9 ( 11.1/  8.8/  7.9)      8  Installing Oracle on uncertified Linux,
                                   like Debian, Download Red Hat, Gentoo ?

These threads accounted for 28.4% of the total volume.

Top 10 Targets for Crossposts

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

      32  comp.databases.oracle.misc
      23  comp.databases.oracle.tools
       3  comp.databases.theory
       1  comp.databases.oracle.marketplace
       1  comp.databases.oracle
       1  comp.database.oracle

Received on Sun Mar 30 2003 - 04:37:20 CST

Statistics for comp.databases.oracle.server - WE 3/30/2003