Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 18 May 2003 17:57:21 GMT
Message-ID: <5QPxa.926686$S_4.939499@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 11 May 2003 18:08:11 GMT and ending at 18 May 2003 17:00:32 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: 224
Articles: 756 (96 with cutlined signatures) Threads: 164
Volume generated: 1878.6 kb

headers: 824.9 kb (13,290 lines)
bodies: 1017.0 kb (30,995 lines)
original: 546.9 kb (17,593 lines)
signatures: 35.9 kb (1,234 lines)

Original Content Rating: 0.538

Averages

Posts per poster: 3.4

     median: 1.0 post
     mode:   1 post - 119 posters
     s:      6.4 posts
Posts per thread: 4.6
     median: 3.0 posts
     mode:   1 post - 36 threads
     s:      5.8 posts
Message size: 2544.6 bytes


     - header:     1117.4 bytes (17.6 lines)

     - body:       1377.6 bytes (41.0 lines)

     - original:   740.8 bytes (23.3 lines)

     - signature:  48.6 bytes (1.6 lines)

Top 10 Posters by Volume

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

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

  199.2 ( 78.5/120.6/ 65.8)     63  Howard J. Rogers
  100.5 ( 49.3/ 51.1/ 31.4)     47  Hans Forbrich
   85.6 ( 37.4/ 48.1/ 16.9)     35  Daniel Morgan
   75.3 ( 28.4/ 46.9/ 28.0)     22  Richard Foote
   44.1 ( 14.6/ 29.5/ 22.0)     13  Jonathan Lewis
   42.0 ( 13.8/ 28.2/  8.1)     12  Ryan Gaffuri
   38.6 ( 16.6/ 20.7/ 13.1)     16  Mladen Gogala
   36.7 ( 15.1/ 19.8/  3.3)     15  Connor McDonald
   36.5 ( 21.9/ 14.5/  9.9)     19  Nuno Souto
   35.2 ( 17.4/ 17.8/  5.6)     17  postbus

These posters accounted for 36.9% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

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

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

1.000  (  3.5 /  3.5)      9  JustAnotherDBA
1.000  (  8.7 /  8.7)      6  Anton Buijs
0.958  ( 16.0 / 16.7)     12  Norman Dunbar
0.946  (  8.8 /  9.3)      6  =?ISO-8859-1?Q?Andreas_M=FCller?=
0.932  (  2.7 /  2.9)      8  Jim Kennedy
0.879  (  4.9 /  5.6)      5  100.17706
0.807  (  3.7 /  4.6)      8  Kamal
0.748  ( 22.0 / 29.5)     13  Jonathan Lewis
0.681  (  9.9 / 14.5)     19  Nuno Souto
0.634  ( 13.1 / 20.7)     16  Mladen Gogala

Top 10 Threads by Number of Posts

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

    29 Rich Niemiec live at ODTUG!
    27 Segment management auto clause
    21 Australian trip.
    20 9i RAC External shared hard disks     19 "pretty Oracle SQL" utility
    17 Reboot your server regularly to gain better performance     17 New trend in modern IT consultancy - use your relational database

        as flat file
    14 authid current_user and loops
    12 Taking tablespace and datafiles offline     12 Transferring a DB to a new platform WITHOUT export/import

These threads accounted for 24.9% of all articles.

Top 10 Threads by Volume

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

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

  120.8 ( 35.2/ 85.3/ 48.8)     27  Segment management auto clause
   62.1 ( 19.1/ 39.8/ 18.4)     17  New trend in modern IT consultancy -
                                    use your relational database as flat
                                    file
   59.9 ( 30.6/ 28.1/ 15.4)     29  Rich Niemiec live at ODTUG!
   58.1 ( 28.4/ 29.5/ 12.0)     21  Australian trip.
   51.6 ( 23.0/ 27.8/ 10.4)     20  9i RAC External shared hard disks
   48.0 ( 22.1/ 25.8/  9.8)     19  "pretty Oracle SQL" utility
   37.9 (  7.6/ 30.0/ 29.0)      7  Oracle versus MS Sqlserver 2000 :
                                    Technical Comparison
   34.6 ( 12.8/ 19.4/ 10.1)     12  Transferring a DB to a new platform
                                    WITHOUT export/import
   33.9 ( 14.7/ 19.3/  8.3)     12  Taking tablespace and datafiles
                                    offline
   32.4 ( 12.5/ 19.9/  8.1)     11  Multiple DATABASES on the same RAC
                                    cluster

These threads accounted for 28.7% of the total volume.

Top 10 Targets for Crossposts

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

       14  comp.databases.oracle.misc
       10  comp.databases.oracle
        9  comp.databases.oracle.tools
        7  comp.database.oracle
        7  comp.unix.solaris
        3  alt.solaris.x86
        2  comp.databases.paradox
        2  de.comp.datenbanken.misc
        2  comp.os.linux.development.apps

Received on Sun May 18 2003 - 12:57:21 CDT

Statistics for comp.databases.oracle.server - WE 05/18/2003