Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Mon, 23 Feb 2004 00:50:50 GMT
Message-ID: <K7c_b.40556$4o.57901@attbi_s52>

Following is a summary of articles spanning a 7 day period, beginning at 15 Feb 2004 23:59:37 GMT and ending at 22 Feb 2004 23:05:41 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: 189
Articles: 607 (156 with cutlined signatures) Threads: 129
Volume generated: 2008.4 kb

headers: 677.5 kb (11,075 lines)
bodies: 1255.3 kb (35,662 lines)
original: 757.5 kb (22,016 lines)
signatures: 75.0 kb (2,505 lines)

Original Content Rating: 0.603

Averages

Posts per poster: 3.2

     median: 1 post
     mode:   1 post - 104 posters
     s:      5.8 posts
Posts per thread: 4.7
     median: 3 posts
     mode:   1 post - 30 threads
     s:      6.6 posts
Message size: 3388.1 bytes


     - header:     1142.9 bytes (18.2 lines)

     - body:       2117.6 bytes (58.8 lines)

     - original:   1277.9 bytes (36.3 lines)

     - signature:  126.5 bytes (4.1 lines)

Top 10 Threads by Number of Posts

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

    43 rman recover/restore from backup     39 tools for PL/SQL development
    19 What is the best way to copy 2G table data between two databases     17 Solaris Hardware
    16 Linux vs. Windows performance.
    15 Java Stored Procedures
    13 Personal Oracle Patch for XP
    12 PEAR DB 1.6.0 has been released
    11 RAC over NFS
    10 Options for wide-area database?

These threads accounted for 32.1% of all articles.

Top 10 Threads by Volume

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

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

  178.7 (  2.9/175.7/145.4)      3  Timesheet and Invoice - Period ending
                                    Feb 15
  153.9 ( 60.7/ 92.9/ 35.7)     43  rman recover/restore from backup
  138.5 (  1.8/136.5/136.0)      2  RMAN backup archivelog hangs on SuSe
                                    Linux 8.0
  135.7 ( 13.1/122.6/ 53.8)     10  reduce wait times
   93.6 ( 47.1/ 42.3/ 25.3)     39  tools for PL/SQL development
   72.7 (  6.4/ 46.0/ 19.3)      5  SAP BW compared to
                                    Essbase/SQLServer/Oracle as a
                                    Enterprise Data
   57.8 ( 24.8/ 25.3/ 11.1)     19  What is the best way to copy 2G table
                                    data between two databases
   53.4 (  7.9/ 45.3/ 35.0)      8  fastest way to determine if 0 or more
                                    records are present in table?
   42.1 ( 18.4/ 23.3/ 10.1)     13  Personal Oracle Patch for XP
   37.0 ( 17.3/ 19.1/  8.5)     16  Linux vs. Windows performance.

These threads accounted for 48.0% of the total volume.

Top 10 Targets for Crossposts

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

       15  comp.databases.oracle.misc
       14  comp.lang.java.databases
       13  comp.databases.ibm-db2
       12  comp.databases.informix
       11  comp.databases.oracle
        5  comp.databases.olap
        5  microsoft.public.sqlserver.datawarehouse
        5  comp.databases.oracle.marketplace
        5  microsoft.public.sqlserver.olap
        3  marcostang2002_at_yahoo.com

Received on Sun Feb 22 2004 - 18:50:50 CST

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