Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 04 Aug 2003 00:32:13 GMT
Message-ID: <hQhXa.57604$Ho3.8636@sccrnsc03>

Following is a summary of articles spanning a 7 day period, beginning at 27 Jul 2003 19:57:11 GMT and ending at 03 Aug 2003 19:31:37 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: 202
Articles: 619 (98 with cutlined signatures) Threads: 154

Volume generated: 1537.5 kb


     - headers:    704.0 kb (10,735 lines)

     - bodies:     801.4 kb (23,514 lines)

     - original:   436.4 kb (13,570 lines)

     - signatures: 31.4 kb (1,107 lines)


Original Content Rating: 0.545

Averages

Posts per poster: 3.1

     median: 1.0 post
     mode:   1 post - 103 posters
     s:      4.5 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 41 threads
     s:      6.0 posts
Message size: 2543.4 bytes


     - header:     1164.6 bytes (17.3 lines)

     - body:       1325.8 bytes (38.0 lines)

     - original:   722.0 bytes (21.9 lines)

     - signature:  52.0 bytes (1.8 lines)

Top 10 Threads by Number of Posts

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

    34 Migrate 200 Million of rows
    34 ORACLE RAC CRASHES ORBITZ
    15 Howto do undo a default clause?
    15 Need SQL Server Temp Table equivalent (challenge!)     14 Storing trailing zeros in mantissa     12 Metalink down
    11 dropping analyze objects from data dictionary     11 'drop tablespace' produces a file/table lock??     11 audit response
    10 How to programatically/dynamically update tnsnames.ora

These threads accounted for 27.0% of all articles.

Top 10 Threads by Volume

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

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

   96.9 ( 50.1/ 46.4/ 18.8)     34  ORACLE RAC CRASHES ORBITZ
   77.7 ( 46.4/ 30.8/ 15.2)     34  Migrate 200 Million of rows
   46.2 (  1.2/ 45.0/ 26.5)      1  <Spam>
   42.3 ( 21.5/ 20.4/ 10.6)     15  Need SQL Server Temp Table equivalent
                                   (challenge!)
   37.8 ( 16.8/ 20.9/ 10.5)     14  Storing trailing zeros in mantissa
   35.1 ( 11.6/ 21.1/ 13.2)      9  8i (8.1.7.4.2) hangs on SHUTDOWN
                                    ABORT (WIN2000,SP3)
   34.3 (  9.5/ 24.6/  7.6)      9  triggers, sequence - need advice
   31.2 ( 17.2/ 13.7/  8.5)     15  Howto do undo a default clause?
   30.2 ( 13.1/ 16.5/  8.2)     11  audit response
   27.7 (  5.3/ 22.4/  7.0)      5  problem with listener on oracle 8.1.7

These threads accounted for 29.9% of the total volume.

Top 10 Targets for Crossposts

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

       45  comp.databases.ibm-db2
       28  comp.databases.informix
       13  comp.databases.oracle.misc
        9  comp.databases.oracle
        4  comp.database.oracle
        3  comp.databases.theory
        3  comp.databases.sybase
        2  comp.lang.java.databases
        2  comp.databases.ms-sqlserver
        1  comp.databases.oracle.tools

Received on Sun Aug 03 2003 - 19:32:13 CDT

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