Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 15 Jun 2003 23:10:34 GMT
Message-ID: <K17Ha.39718$YZ2.202449@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 08 Jun 2003 20:39:46 GMT and ending at 15 Jun 2003 17:03:27 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: 236
Articles: 756 (112 with cutlined signatures) Threads: 184
Volume generated: 2082.2 kb

headers: 825.8 kb (13,350 lines)
bodies: 1195.0 kb (34,785 lines)
original: 490.6 kb (15,623 lines)
signatures: 60.7 kb (2,004 lines)

Original Content Rating: 0.411

Averages

Posts per poster: 3.2

     median: 2.0 posts
     mode:   1 post - 112 posters
     s:      4.3 posts
Posts per thread: 4.1
     median: 3.0 posts
     mode:   1 post - 45 threads
     s:      3.7 posts
Message size: 2820.3 bytes


     - header:     1118.5 bytes (17.7 lines)

     - body:       1618.6 bytes (46.0 lines)

     - original:   664.5 bytes (20.7 lines)

     - signature:  82.2 bytes (2.7 lines)

Top 10 Posters by Volume

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

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

  131.5 (  1.0/130.5/  0.3)      1  David Fitzjarrell
  131.4 (  1.0/130.5/  0.2)      1  Steve
   76.4 ( 39.8/ 36.6/ 12.9)     38  postbus
   61.1 ( 11.9/ 49.2/ 36.7)      9  Anurag Varma
   51.0 ( 19.8/ 31.2/ 13.8)     18  Daniel Morgan
   49.1 ( 23.2/ 25.9/  8.9)     21  Ryan Gaffuri
   46.6 ( 25.5/ 21.1/  5.3)     22  Peter
   43.0 ( 16.8/ 26.1/ 17.7)     16  Hans Forbrich
   42.3 ( 20.2/ 14.6/  7.6)     17  Niall Litchfield
   41.6 ( 13.0/  4.6/  4.6)     12  Jim Kennedy

These posters accounted for 32.4% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

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

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

1.000  (  4.6 /  4.6)     12  Jim Kennedy
1.000  (  0.9 /  0.9)      5  NorwoodThree
1.000  (  8.1 /  8.1)      5  Anton Buijs
1.000  (  4.6 /  4.6)      7  Burton Peltier
0.952  ( 11.9 / 12.5)     10  Norman Dunbar
0.817  (  1.6 /  2.0)      5  test
0.769  (  5.2 /  6.8)      8  Billy Verreynne
0.752  (  6.4 /  8.5)     11  Nuno Souto
0.746  ( 36.7 / 49.2)      9  Anurag Varma
0.689  (  2.7 /  3.9)      5  Richard Foote

Top 10 Threads by Number of Posts

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

    24 Zero Client front end to Oracle
    23 Where can I get a complete list of all SQL Hints?     15 updating sys.user$ table...
    13 Validating dynamic SQL
    13 What's wrong with SQL Server?
    12 please help with stored outlines     12 refcursor for pipeline table function?     12 Oracle backup to tape Please help....     12 Database reorg in Oracle 8?
    11 Oracle 9i install ate my Microsoft IIS 5

These threads accounted for 19.4% of all articles.

Top 10 Threads by Volume

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

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

  268.5 (  5.1/263.4/  2.1)      5  Performance issue and statspack
   84.1 (  9.0/ 75.1/ 47.4)      6  Query gives incorrect results
   58.1 ( 29.2/ 25.2/ 13.8)     24  Zero Client front end to Oracle
   53.5 ( 26.8/ 25.9/ 13.0)     23  Where can I get a complete list of
                                    all SQL Hints?
   48.5 ( 13.9/ 25.5/  7.0)     12  Oracle backup to tape Please help....
   42.6 ( 15.4/ 21.6/  8.0)     12  Database reorg in Oracle 8?
   32.8 ( 12.5/ 17.5/  9.3)     13  Validating dynamic SQL
   31.2 ( 13.4/ 13.7/  6.6)     13  What's wrong with SQL Server?
   30.5 ( 13.7/ 16.5/  7.7)     12  please help with stored outlines
   30.3 ( 12.4/ 16.1/  8.7)     11  Bit off topic : It should go faster
                                    than this...

These threads accounted for 32.7% of the total volume.

Top 10 Targets for Crossposts

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

       21  comp.databases.oracle.tools
       20  comp.databases.oracle.misc
       14  comp.lang.basic.visual.database
       14  comp.lang.basic.visual.misc
        9  microsoft.public.windows.server.general
        9  microsoft.public.inetserver.iis
        3  comp.databases.oracle.marketplace
        3  microsoft.public.vb.database.ado
        2  microsoft.public.fr.word
        2  comp.databases.oracle

Received on Sun Jun 15 2003 - 18:10:34 CDT

Statistics for comp.databases.oracle.server - WE 06/15/2003