Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 01 Feb 2004 22:25:30 GMT
Message-ID: <u1fTb.161265$nt4.734173@attbi_s51>

Following is a summary of articles spanning a 7 day period, beginning at 25 Jan 2004 22:43:06 GMT and ending at 01 Feb 2004 21:47:21 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: 711 (227 with cutlined signatures) Threads: 140

Volume generated: 1739.7 kb


     - headers:    816.2 kb (12,874 lines)

     - bodies:     862.6 kb (25,594 lines)

     - original:   439.3 kb (13,523 lines)

     - signatures: 60.3 kb (2,073 lines)


Original Content Rating: 0.509

Averages

Posts per poster: 3.5

     median: 1 post
     mode:   1 post - 108 posters
     s:      8.7 posts
Posts per thread: 5.1
     median: 3.0 posts
     mode:   1 post - 38 threads
     s:      7.8 posts
Message size: 2505.6 bytes


     - header:     1175.5 bytes (18.1 lines)

     - body:       1242.3 bytes (36.0 lines)

     - original:   632.8 bytes (19.0 lines)

     - signature:  86.8 bytes (2.9 lines)

Top 10 Threads by Number of Posts

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

50 Oracle For Fun
40 choices regarding where to place code - in the database or

middletier
33 Avoiding any locks in SQL Servers - read and understand....its

        magic.
    28 Effects of framentation
    15 Book that had the most effect on you     15 add new user to oracle ??
    14 Oracle 10g Release Date?
    14 HELP! migrating from NT to UNIX
    14 How to disable '@' in SQL*Plus?
    13 Load balancing between an RAC database cluster and Top Link

These threads accounted for 33.2% of all articles.

Top 10 Threads by Volume

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

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

  146.9 ( 65.0/ 77.3/ 40.6)     40  choices regarding where to place code
                                    - in the database or middletier
  126.0 ( 58.5/ 63.6/ 22.2)     50  Oracle For Fun
  103.0 ( 54.7/ 42.7/ 21.8)     33  Avoiding any locks in SQL Servers -
                                    read and understand....its magic.
   68.0 ( 32.6/ 33.0/ 18.2)     28  Effects of framentation
   47.8 ( 18.0/ 26.0/  9.2)     14  HELP! migrating from NT to UNIX
   34.1 ( 15.8/ 17.3/  5.9)     14  How to disable '@' in SQL*Plus?
   34.0 ( 14.9/ 17.3/  9.3)     13  Load balancing between an RAC
                                    database cluster and Top Link
   33.7 (  8.3/ 25.0/ 10.9)      8  Restoring Oracle Control Files
   32.7 ( 17.2/ 14.2/  6.5)     15  add new user to oracle ??
   29.2 ( 11.4/ 17.4/  7.4)     11  Improving performance of calculations
                                    in PL/SQL

These threads accounted for 37.7% of the total volume.

Top 10 Targets for Crossposts

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

       52  comp.databases.oracle.misc
       48  comp.databases.oracle.tools
       37  comp.lang.java.databases
       36  comp.databases
       31  comp.lang.java.programmer
        9  comp.databases.oracle.marketplace
        7  comp.database.oracle
        4  comp.databases.oracle
        3  microsoft.public.sqlserver.replication
        1  comp.unix.admin

Received on Sun Feb 01 2004 - 16:25:30 CST

Statistics for comp.databases.oracle.server - WE 02/01/2004