Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 21 Mar 2004 18:29:09 GMT
Message-ID: <U9l7c.51726$JL2.691415@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 14 Mar 2004 18:35:02 GMT and ending at 21 Mar 2004 17:45:24 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: 180
Articles: 584 (127 with cutlined signatures) Threads: 152

Volume generated: 1420.0 kb


     - headers:    609.4 kb (10,336 lines)

     - bodies:     753.3 kb (23,149 lines)

     - original:   417.4 kb (13,283 lines)

     - signatures: 56.7 kb (1,905 lines)


Original Content Rating: 0.554

Averages

Posts per poster: 3.2

     median: 1.0 post
     mode:   1 post - 93 posters
     s:      6.7 posts
Posts per thread: 3.8
     median: 3.0 posts
     mode:   1 post - 44 threads
     s:      4.9 posts
Message size: 2489.8 bytes


     - header:     1068.6 bytes (17.7 lines)

     - body:       1320.8 bytes (39.6 lines)

     - original:   731.9 bytes (22.7 lines)

     - signature:  99.4 bytes (3.3 lines)

Top 10 Threads by Number of Posts

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

    25 Poor mans RAID10...
    24 Multi Threaded server not working for many inserts?     19 SQL Serious Challenge # 1 - Probably Not Much Fun     19 MS SQL Server Evaluation
    16 How to create an user "INTERNAL" in Oracle9i ???     11 real applicaton cluster
    11 archivelog leads to crashes...?
    10 creating a foreign key referencing a non-primary key     10 Excessive Logical and Physical I/O     10 Problems installing Oracle9i on Fedora with 256 RAM

These threads accounted for 26.5% of all articles.

Top 10 Threads by Volume

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

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

   67.0 ( 29.0/ 37.3/ 22.7)     24  Multi Threaded server not working for
                                    many inserts?
   65.2 ( 28.1/ 34.7/ 15.7)     19  MS SQL Server Evaluation
   47.9 ( 26.7/ 18.8/  8.4)     25  Poor mans RAID10...
   42.3 ( 25.7/ 13.4/  5.3)     19  SQL Serious Challenge # 1 - Probably
                                    Not Much Fun
   35.7 ( 16.8/ 17.5/  7.8)     16  How to create an user "INTERNAL" in
                                    Oracle9i ???
   29.8 (  7.7/ 19.8/  5.9)      8  SESSION INFO VIA AUDITING + LOGON
                                    TRIGGERS
   29.6 ( 11.3/ 17.9/  7.1)     11  archivelog leads to crashes...?
   28.6 (  9.6/ 18.7/  7.5)      9  Remote login on closed database
                                    ORA-01031
   26.0 (  5.1/ 20.9/  9.3)      5  Idea for database migration using
                                    parallelism at the table level
   25.3 ( 10.9/ 14.2/  8.2)     11  real applicaton cluster

These threads accounted for 28.0% of the total volume.

Top 10 Targets for Crossposts

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

       43  comp.databases.oracle.misc
       17  comp.databases.oracle
       13  comp.database.oracle
        6  comp.databases.oracle.tools
        4  comp.databases.oracle.marketplace
        3  comp.lang.java.databases
        3  comp.databases.misc
        1  microsoft.public.sqlserver.datawarehouse
        1  comp.databases.ms-sqlserver
        1  microsoft.public.dotnet.framework.adonet

Received on Sun Mar 21 2004 - 12:29:09 CST

Statistics for comp.databases.oracle.server - WE 03/21/2004