Statistics for comp.databases.oracle.server - WE 2/2/2003

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 02 Feb 2003 20:58:56 GMT
Message-ID: <BA62C68F.8B70%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 26 Jan 2003 20:53:16 GMT and ending at 02 Feb 2003 20:37:01 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: 250
Articles: 826 (67 with cutlined signatures) Threads: 184
Volume generated: 2069.0 kb

• headers: 902.6 kb (14,431 lines)
• bodies: 1154.2 kb (36,356 lines)
• original: 598.5 kb (20,277 lines)
• signatures: 11.4 kb (333 lines)

Original Content Rating: 0.519

Averages

---

Posts per poster: 3.3

    median: 1.0 post
    mode: 1 post - 126 posters
    s: 6.2 posts
Posts per thread: 4.5

    median: 3.0 posts
    mode: 1 post - 50 threads
    s: 5.8 posts
Message size: 2565.0 bytes

• header: 1119.0 bytes (17.5 lines)
• body: 1430.8 bytes (44.0 lines)
• original: 742.0 bytes (24.5 lines)
• signature: 14.2 bytes (0.4 lines)

Top 10 Posters by Number of Posts

---

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

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

   51   156.4 ( 64.1/ 92.3/ 52.6)  Howard J. Rogers
   41   105.9 ( 46.4/ 59.5/ 16.1)  DA Morgan
   31    78.0 ( 35.5/ 42.5/ 13.8)  Telemachus
   31    88.5 ( 37.6/ 50.9/ 46.2)  Norman Dunbar
   25    94.8 ( 30.8/ 63.9/ 37.3)  Richard Foote
   22    48.1 ( 25.0/ 23.1/  8.2)  Paul Brewer
   19    55.6 ( 20.6/ 35.0/ 21.6)  Jonathan Lewis
   19    51.4 ( 23.6/ 27.7/ 15.4)  Niall Litchfield

   16 31.4 ( 15.7/ 15.8/ 6.9) postbus    15 29.7 ( 14.6/ 14.5/ 10.6) Noons

These posters accounted for 32.7% of all articles.

Top 10 Posters by Volume

---

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

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

 156.4 ( 64.1/ 92.3/ 52.6)     51  Howard J. Rogers
 105.9 ( 46.4/ 59.5/ 16.1)     41  DA Morgan
  94.8 ( 30.8/ 63.9/ 37.3)     25  Richard Foote
  88.5 ( 37.6/ 50.9/ 46.2)     31  Norman Dunbar
  78.0 ( 35.5/ 42.5/ 13.8)     31  Telemachus
  55.6 ( 20.6/ 35.0/ 21.6)     19  Jonathan Lewis
  51.4 ( 23.6/ 27.7/ 15.4)     19  Niall Litchfield
  48.1 ( 25.0/ 23.1/  8.2)     22  Paul Brewer
  40.9 ( 15.0/ 22.9/  9.3)     14  timx
  32.5 ( 19.9/ 12.6/  6.7)     13  Karsten Farrell

These posters accounted for 36.4% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

---

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

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

1.000  (  2.7 /  2.7)      6  Lukasz Feldman
1.000  ( 11.2 / 11.2)      5  Anton Buijs
0.913  (  9.1 / 10.0)      6  Mark Townsend
0.908  ( 46.2 / 50.9)     31  Norman Dunbar
0.850  (  4.3 /  5.0)      5  Don Burleson
0.794  (  8.7 / 10.9)      7  Brian Peasland
0.730  ( 10.6 / 14.5)     15  Noons
0.618  ( 21.6 / 35.0)     19  Jonathan Lewis
0.584  ( 37.3 / 63.9)     25  Richard Foote
0.581  (  9.3 / 15.9)      9  Jan Gelbrich

Top 10 Threads by Number of Posts

---

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

   38 index rebuilding...
   30 OCP - Performance Tuning
   25 how to tune up this query?
   22 tricky SQL SELECT - help!
   21 How are you backing up your V,VLDB????    20 Turn on Archivelog mode..
   18 A bit of Linux advice yet again??    17 Statistics for comp.databases.oracle.server - WE 26/1/2003    16 oracle 9i
   13 Can't install Oracle PE 9i?

These threads accounted for 26.6% of all articles.

Top 10 Threads by Volume

---

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

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

 158.7 ( 49.9/108.5/ 49.7)     38  index rebuilding...
  69.8 ( 32.2/ 37.1/ 18.6)     30  OCP - Performance Tuning
  52.2 ( 21.6/ 30.6/ 17.8)     21  How are you backing up your V,VLDB????
  51.9 ( 30.3/ 21.6/ 10.7)     25  how to tune up this query?
  51.0 ( 21.3/ 29.7/ 14.2)     20  Turn on Archivelog mode..
  49.9 ( 18.8/ 30.0/ 14.5)     18  A bit of Linux advice yet again??
  47.8 ( 23.9/ 23.9/ 15.7)     22  tricky SQL SELECT - help!
  47.0 ( 21.1/ 25.4/ 17.0)     17  Statistics for
                                   comp.databases.oracle.server
                                   - WE 26/1/2003
  33.2 ( 17.0/ 16.3/  6.1)     13  Can't install Oracle PE 9i?
  32.2 ( 11.0/ 21.2/  7.3)     10  Confusing blocking issue - More Details

These threads accounted for 28.7% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

---

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

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

0.823  (  6.4/   7.8)      5  Add datafile to a tablespace while EXP utility
                              is running?
0.773  (  8.7/  11.2)     10  What is exactly Oracle Financial
0.729  (  4.9/   6.7)      7  why rman?
0.722  (  4.1/   5.7)      8  Help please !
0.714  (  9.6/  13.4)      7  Kill Session question #2
0.702  (  3.8/   5.4)      5  What is a cursor EXACTLY?(internals question)
0.693  (  2.5/   3.7)      5  PROBLEM WITH CREATING A FUNCTION
0.676  (  3.1/   4.6)      6  LMT and DMT
0.671  ( 17.0/  25.4)     17  Statistics for comp.databases.oracle.server -
                              WE 26/1/2003
0.659  ( 15.7/  23.9)     22  tricky SQL SELECT - help!

Top 10 Targets for Crossposts

---

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

      44  comp.databases.oracle.misc
      31  comp.databases.oracle
      13  comp.database.oracle
      12  comp.databases.oracle.tools
      10  info-oracle
       7  de.alt.comp.sap-r3
       4  comp.databases.ms-sqlserver
       3  comp.lang.java.databases
       3  comp.programming.threads
       3  comp.os.linux

Received on Sun Feb 02 2003 - 14:58:56 CST