Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 27 Jul 2003 21:58:54 GMT
Message-ID: <yWXUa.143735$wk6.37722@rwcrnsc52.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 20 Jul 2003 21:45:40 GMT and ending at 27 Jul 2003 21:25:09 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: 215
Articles: 695 (100 with cutlined signatures) Threads: 142

Volume generated: 1769.8 kb


     - headers:    757.5 kb (12,001 lines)

     - bodies:     981.7 kb (27,940 lines)

     - original:   552.4 kb (16,472 lines)

     - signatures: 29.9 kb (988 lines)


Original Content Rating: 0.563

Averages

Posts per poster: 3.2

     median: 1 post
     mode:   1 post - 123 posters
     s:      6.4 posts
Posts per thread: 4.9
     median: 3.0 posts
     mode:   2 posts - 27 threads
     s:      6.1 posts
Message size: 2607.6 bytes


     - header:     1116.1 bytes (17.3 lines)

     - body:       1446.5 bytes (40.2 lines)

     - original:   813.9 bytes (23.7 lines)

     - signature:  44.0 bytes (1.4 lines)

Top 10 Threads by Number of Posts

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

    33 2 Oracle doubts
    29 Upgrade to big SUN box or RAC for data warehouse?     26 Restoring & recovering in NOARCHIVELOG     23 Need SQL Server Temp Table equivalent (challenge!)     22 What is Oracle10G?
    20 Storing GUIDs in Oracle
    19 Migrate 200 Million of rows
    18 anyone use BEA WebLogic or IBM Websphere against an Oracle

database?
13 'drop tablespace' produces a file/table lock?? 11 read consistency question

These threads accounted for 30.8% of all articles.

Top 10 Threads by Volume

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

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

  130.8 (  2.4/128.4/108.6)      2  (corrected) 2 Oracle doubts
  125.4 ( 38.8/ 86.0/ 48.6)     33  2 Oracle doubts
   83.8 ( 32.3/ 42.8/ 17.7)     29  Upgrade to big SUN box or RAC for
                                    data warehouse?
   70.6 ( 28.2/ 39.7/ 17.6)     26  Restoring & recovering in
                                    NOARCHIVELOG
   68.7 ( 30.5/ 34.5/ 16.6)     23  Need SQL Server Temp Table equivalent
                                    (challenge!)
   57.6 ( 29.6/ 27.5/ 14.3)     22  What is Oracle10G?
   47.9 ( 20.2/ 27.4/ 10.1)     19  Migrate 200 Million of rows
   46.3 ( 21.6/ 21.8/ 11.3)     20  Storing GUIDs in Oracle
   40.2 ( 21.3/ 18.8/  8.2)     18  anyone use BEA WebLogic or IBM
                                    Websphere against an Oracle database?
   30.4 ( 11.5/ 18.9/  6.5)     11  read consistency question

These threads accounted for 39.6% of the total volume.

Top 10 Targets for Crossposts

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

        9  comp.databases.oracle.misc
        3  comp.databases.oracle.tools
        3  comp.databases.ibm-db2
        3  comp.databases.oracle
        3  comp.database.oracle
        2  comp.databases.informix
        1  comp.databases.olap
        1  comp.os.linux.advocacy

Received on Sun Jul 27 2003 - 16:58:54 CDT

Statistics for comp.databases.oracle.server - WE 07/27/2003