Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 22 Sep 2003 06:22:28 GMT
Message-ID: <Eywbb.402938$Oz4.196158@rwcrnsc54>

Following is a summary of articles spanning a 7 day period, beginning at 15 Sep 2003 06:38:19 GMT and ending at 22 Sep 2003 05:26:26 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: 190
Articles: 677 (184 with cutlined signatures) Threads: 138

Volume generated: 1795.5 kb


     - headers:    742.6 kb (12,021 lines)

     - bodies:     910.2 kb (27,026 lines)

     - original:   474.0 kb (15,063 lines)

     - signatures: 142.1 kb (4,107 lines)


Original Content Rating: 0.521

Averages

Posts per poster: 3.6

     median: 1.0 post
     mode:   1 post - 97 posters
     s:      7.3 posts
Posts per thread: 4.9
     median: 3.0 posts
     mode:   1 post - 38 threads
     s:      6.5 posts
Message size: 2715.7 bytes


     - header:     1123.2 bytes (17.8 lines)

     - body:       1376.7 bytes (39.9 lines)

     - original:   716.9 bytes (22.2 lines)

     - signature:  214.9 bytes (6.1 lines)

Top 10 Threads by Number of Posts

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

    24 Tom Kyte a false idol?
    23 Fed Up with being a DBA
    23 need help tuning a very large delete     22 Is Richard Niemiec Right
    21 Physical Layout of disk to use Oracle     21 INDEX and DATA Tablespaces.....
    16 Performance base line
    15 Database Upgrade: 9i Or 10g
    14 strange select issue
    13 I'm being subjected to a DOS attack...

These threads accounted for 28.4% of all articles.

Top 10 Threads by Volume

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

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

  115.4 ( 32.1/ 53.2/ 27.2)     23  Fed Up with being a DBA
   92.6 ( 24.2/ 57.5/ 31.9)     22  Is Richard Niemiec Right
   72.2 ( 24.5/ 44.0/ 20.6)     21  Physical Layout of disk to use Oracle
   59.7 ( 25.8/ 31.0/ 15.0)     24  Tom Kyte a false idol?
   56.3 ( 25.7/ 29.8/ 11.2)     23  need help tuning a very large delete
   56.3 ( 17.4/ 27.9/ 12.3)     13  Please help: Oracle9i/AIX5.2/Veritas
                                    vxvm raw devices Problem
   55.5 ( 17.3/ 31.1/ 18.1)     16  Performance base line
   55.3 ( 11.8/ 42.2/ 18.8)     11  Hot backup- want to group tablespaces
                                    in script during off-hours
   50.5 ( 24.1/ 19.3/ 10.7)     21  INDEX and DATA Tablespaces.....
   48.5 ( 14.3/ 34.1/ 16.0)     13  resolving buffer busy waits

These threads accounted for 36.9% of the total volume.

Top 10 Targets for Crossposts

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

        6  comp.databases.oracle.misc
        5  comp.databases.oracle.tools
        2  relcom.comp.dbms.oracle
        2  comp.database.oracle

Received on Mon Sep 22 2003 - 01:22:28 CDT

Statistics for comp.databases.oracle.server - WE 09/21/2003