Statistics for comp.databases.oracle.server - WE 08/24/2003

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 25 Aug 2003 03:20:21 GMT
Message-ID: <Vff2b.250874$Ho3.32425@sccrnsc03>

Following is a summary of articles spanning a 7 day period, beginning at 18 Aug 2003 04:28:38 GMT and ending at 24 Aug 2003 22:11:07 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: 201
Articles: 602 (113 with cutlined signatures) Threads: 147

Volume generated: 1475.1 kb


     - headers:    700.9 kb (10,641 lines)

     - bodies:     744.1 kb (22,530 lines)

     - original:   385.9 kb (12,518 lines)

     - signatures: 29.5 kb (1,028 lines)


Original Content Rating: 0.519

Averages

---

Posts per poster: 3.0

     median: 1 post
     mode:   1 post - 103 posters
     s:      4.5 posts
Posts per thread: 4.1
     median: 3 posts
     mode:   1 post - 38 threads
     s:      6.2 posts
Message size: 2509.2 bytes


     - header:     1192.3 bytes (17.7 lines)

     - body:       1265.8 bytes (37.4 lines)

     - original:   656.5 bytes (20.8 lines)

     - signature:  50.1 bytes (1.7 lines)

Top 10 Posters by Number of Posts

---

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

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

    27    53.7 ( 32.0/ 21.7/ 13.9)  Noons
    25    58.1 ( 28.5/ 29.6/  9.9)  Daniel Morgan
    25    79.6 ( 29.8/ 43.5/ 13.8)  Brian Peasland
    24    56.7 ( 29.4/ 27.3/  9.3)  Harald Maier
    21    38.8 ( 23.5/ 15.2/  7.7)  Tanel Poder
    18    67.8 ( 19.7/ 47.9/ 17.3)  quarkman
    18    31.5 ( 18.3/ 13.1/  7.2)  postbus
    15    40.1 ( 19.7/ 15.6/  8.3)  Niall Litchfield

    15 49.2 ( 24.9/ 24.2/ 15.7) Guido Stepken     13 30.9 ( 16.1/ 14.8/ 11.5) Billy Verreynne

These posters accounted for 33.4% of all articles.

Top 10 Posters by Volume

---

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

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

   79.6 ( 29.8/ 43.5/ 13.8)     25  Brian Peasland
   67.8 ( 19.7/ 47.9/ 17.3)     18  quarkman
   67.2 (  6.3/ 60.9/ 56.1)      5  orietta.valota
   58.1 ( 28.5/ 29.6/  9.9)     25  Daniel Morgan
   56.7 ( 29.4/ 27.3/  9.3)     24  Harald Maier
   53.7 ( 32.0/ 21.7/ 13.9)     27  Noons
   49.2 ( 24.9/ 24.2/ 15.7)     15  Guido Stepken
   40.1 ( 19.7/ 15.6/  8.3)     15  Niall Litchfield
   38.8 ( 23.5/ 15.2/  7.7)     21  Tanel Poder
   31.5 ( 18.3/ 13.1/  7.2)     18  postbus

These posters accounted for 36.8% of the total volume.

Top 10 Threads by Number of Posts

---

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

    18 Datatype in stored functions
    18 MTS not workin ??
    17 Avoiding any locks in SQL Servers - read and understand....its

        magic.
    17 Oracle Recovery Scenarios
    16 not able to turn on sql_trace for an instance     15 Avoiding any locks in SQL Servers - read and

        understand....itsmagic.
    13 Avoiding any locks in SQL Servers - read and understand....its

        magic.
    13 Which one is better, Oracle or SQL server - clear answer !     12 Process Documentation and Engineering - In Use?     11 technical wet dreams and SQL fantasies

These threads accounted for 24.9% of all articles.

Top 10 Threads by Volume

---

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

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

   79.8 ( 19.1/ 59.9/ 19.0)     17  Oracle Recovery Scenarios
   53.1 ( 28.0/ 22.0/ 11.6)     17  Avoiding any locks in SQL Servers -
                                    read and understand....its  magic.
   51.7 ( 18.9/ 32.8/ 16.1)     18  MTS not workin ??
   45.4 ( 23.9/ 20.1/ 10.4)     15  Avoiding any locks in SQL Servers -
                                    read and understand....itsmagic.
   41.8 ( 21.7/ 19.2/  9.1)     16  not able to turn on sql_trace  for an
                                    instance
   39.5 ( 20.0/ 18.5/ 10.3)     13  Avoiding any locks in SQL Servers -
                                    read and understand....its magic.
   37.6 ( 19.8/ 17.8/  8.1)     18  Datatype in stored functions
   35.9 (  3.4/ 32.5/ 32.1)      3  Oracle Install Matrix
   35.7 ( 17.5/ 18.2/  9.7)     13  Which one is better, Oracle or SQL
                                    server - clear answer !
   32.8 ( 15.6/ 17.2/  8.0)     11  technical wet dreams and SQL
                                    fantasies

These threads accounted for 30.7% of the total volume.

Top 10 Targets for Crossposts

---

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

       86  comp.databases.oracle.misc
       80  microsoft.public.sqlserver.server
       77  comp.databases
       76  comp.databases.object
        3  comp.databases.oracle.tools
        3  microsoft.public.win2000.developer
        2  comp.databases.oracle.marketplace
        2  comp.databases.oracle
        2  comp.databases.ibm-db2
        1  microsoft.public.de.sqlserver

Top 10 Crossposters

---

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

       51 Guido Stepken

(couldn't resist :-) ) Received on Sun Aug 24 2003 - 22:20:21 CDT