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

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 13 Jun 2004 18:45:48 GMT
Message-ID: <wh1zc.15465$Hg2.14318@attbi_s04>

Following is a summary of articles spanning a 7 day period, beginning at 06 Jun 2004 19:24:57 GMT and ending at 13 Jun 2004 18:25: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: 171
Articles: 627 (160 with cutlined signatures) Threads: 114

Volume generated: 1574.2 kb


     - headers:    750.2 kb (11,281 lines)

     - bodies:     793.7 kb (23,547 lines)

     - original:   400.5 kb (12,506 lines)

     - signatures: 29.7 kb (1,229 lines)


Original Content Rating: 0.505

Averages

---

Posts per poster: 3.7

     median: 2 posts
     mode:   1 post - 80 posters
     s:      7.1 posts
Posts per thread: 5.5
     median: 2.0 posts
     mode:   2 posts - 31 threads
     s:      13.0 posts
Message size: 2571.0 bytes


     - header:     1225.2 bytes (18.0 lines)

     - body:       1296.3 bytes (37.6 lines)

     - original:   654.0 bytes (19.9 lines)

     - signature:  48.5 bytes (2.0 lines)

Top 10 Posters by Number of Posts

---

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

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

    62   165.1 ( 64.6/100.5/ 57.9)  Howard J. Rogers
    52   137.2 ( 85.3/ 49.6/ 32.2)  Noons
    29    76.3 ( 36.7/ 33.6/  7.9)  Daniel Morgan
    20    54.8 ( 38.7/ 16.1/  8.5)  Mark A
    20    49.3 ( 21.4/ 27.8/ 14.2)  Joel Garry
    19    65.9 ( 36.9/ 27.9/ 16.7)  Serge Rielau
    12    29.3 ( 16.2/ 12.8/  3.7)  fvanbortel
    12    45.6 ( 14.6/ 31.0/ 22.0)  Richard Foote

    12 35.5 ( 15.0/ 7.8/ 6.8) Jonathan Lewis     11 33.5 ( 14.5/ 16.7/ 10.3) Niall Litchfield

These posters accounted for 39.7% of all articles.

Top 10 Posters by Volume

---

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

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

  165.1 ( 64.6/100.5/ 57.9)     62  Howard J. Rogers
  137.2 ( 85.3/ 49.6/ 32.2)     52  Noons
   76.3 ( 36.7/ 33.6/  7.9)     29  Daniel Morgan
   65.9 ( 36.9/ 27.9/ 16.7)     19  Serge Rielau
   54.8 ( 38.7/ 16.1/  8.5)     20  Mark A
   49.3 ( 21.4/ 27.8/ 14.2)     20  Joel Garry
   45.6 ( 14.6/ 31.0/ 22.0)     12  Richard Foote
   35.5 ( 15.0/  7.8/  6.8)     12  Jonathan Lewis
   33.5 ( 14.5/ 16.7/ 10.3)     11  Niall Litchfield
   29.7 ( 14.9/ 14.7/ 13.3)      9  markbtownsend

These posters accounted for 44.0% of the total volume.

Top 10 Threads by Number of Posts

---

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

   122 database market share 2003
    53 How about an Oracle debate?
    46 9i New Features E-book
    19 clustering and high availability?     18 OMLETv4 The Ultimate Visual Real Time Oracle Monitoring Tool     15 Oracle 10g on Fedora Core 2
    12 10g install on XP fails (dbca)
    10 which column type char,varchar2 is better for index?     10 Having Deadlock Problem
     9 Backup Recovery - Cold Backup in Archive log mode

These threads accounted for 50.1% of all articles.

Top 10 Threads by Volume

---

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

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

  357.4 (218.8/134.2/ 74.2)    122  database market share 2003
  140.5 ( 51.2/ 88.7/ 51.9)     46  9i New Features E-book
  133.1 ( 57.6/ 72.7/ 36.3)     53  How about an Oracle debate?
   47.5 ( 22.4/ 24.9/ 10.7)     18  OMLETv4 The Ultimate Visual Real Time
                                    Oracle Monitoring Tool
   47.5 ( 21.4/ 24.7/ 11.0)     19  clustering and high availability?
   43.7 (  9.5/ 33.0/  6.3)      9  Why FULL TABLE SCAN ?
   29.8 ( 17.1/ 12.6/  6.0)     15  Oracle 10g on Fedora Core 2
   28.9 ( 10.7/ 14.7/  7.6)     10  Having Deadlock Problem
   28.7 ( 12.9/ 15.5/  7.3)     12  10g install on XP fails (dbca)
   21.8 ( 11.2/  8.0/  2.8)     10  which column type char,varchar2 is
                                    better for index?

These threads accounted for 55.8% of the total volume.

Top 10 Targets for Crossposts

---

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

      122  comp.databases.ibm-db2
      104  comp.databases.informix
       18  rec.arts.poems
        9  comp.databases.oracle.misc
        6  demon.local
        2  comp.unix.solaris
        1  comp.lang.java.databases
        1  comp.databases.oracle.tools
        1  alt.arts.poetry.comments
        1  comp.databases.ms-sqlserver

Top 10 Crossposters

---

Groups Address
-------- -------

       63  Noons <wizofoz2k_at_yahoo.com.au.nospam>
       40  "Mark A" <ma_at_switchboard.net>
       28  Serge Rielau <srielau_at_ca.eye-be-em.com>
       14  markbtownsend_at_comcast.net
       11  Joel Garry <joel-garry_at_home.com>
       10  "Andrew Hamm" <ahamm_at_mail.com>
        8  Daniel Morgan <damorgan_at_x.washington.edu>
        6  Noons <wizofoz2k_at_yahoo.com.au>
        5  nobody <nobody_at_devnull.org>
        5  Jean-David Beyer <jdbeyer_at_exit109.com>

Received on Sun Jun 13 2004 - 13:45:48 CDT