Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 30 Nov 2003 20:19:28 GMT
Message-ID: <jhsyb.266433$ao4.927018@attbi_s51>

Following is a summary of articles spanning a 7 day period, beginning at 23 Nov 2003 20:27:02 GMT and ending at 30 Nov 2003 19:56:04 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: 182
Articles: 589 (191 with cutlined signatures) Threads: 135

Volume generated: 1477.3 kb


     - headers:    647.1 kb (10,664 lines)

     - bodies:     756.1 kb (22,724 lines)

     - original:   417.6 kb (12,950 lines)

     - signatures: 73.5 kb (2,301 lines)


Original Content Rating: 0.552

Averages

Posts per poster: 3.2

     median: 1.5 posts
     mode:   1 post - 91 posters
     s:      6.6 posts
Posts per thread: 4.4
     median: 3 posts
     mode:   1 post - 39 threads
     s:      7.6 posts
Message size: 2568.3 bytes


     - header:     1125.0 bytes (18.1 lines)

     - body:       1314.6 bytes (38.6 lines)

     - original:   726.1 bytes (22.0 lines)

     - signature:  127.8 bytes (3.9 lines)

Top 10 Threads by Number of Posts

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

    62 Case insensitive queries
    53 Deadly sins againts database performance/scalability     21 Design approaches about primary key     18 how to group synonyms ?
    13 Index vs. table scans in statspack reports     10 Instance vs Schema pro/cons
    10 Oracle Exceptions: Remote DB
    10 Running Instances on Windoz
    10 date insertion error
     9 Accessing data from an MS access db from an Oracle UNIX server

These threads accounted for 36.7% of all articles.

Top 10 Threads by Volume

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

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

  140.3 ( 70.2/ 65.9/ 33.5)     62  Case insensitive queries
  128.5 ( 61.6/ 61.2/ 32.3)     53  Deadly sins againts database
                                    performance/scalability
   62.7 ( 23.0/ 38.4/ 26.2)     18  how to group synonyms ?
   58.0 ( 22.3/ 31.9/ 15.4)     21  Design approaches about primary key
   40.9 ( 13.7/ 26.8/ 17.0)     10  Oracle Exceptions: Remote DB
   37.7 ( 12.4/ 24.9/ 11.8)     10  Running Instances on Windoz
   35.3 ( 14.4/ 17.0/  9.3)     13  Index vs. table scans in statspack
                                    reports
   35.2 (  5.5/ 14.1/  5.2)      5  Net8 Lookup Method Options -
                                    tnsnames(Local) vs. Hostname vs.
                                    Onames/LDAP
   30.6 (  6.7/ 17.5/  5.9)      6  Statistics for
                                    comp.databases.oracle.server - WE
                                    11/22/2003
   29.9 (  1.2/ 28.7/ 28.7)      1  Oracle 9i TNS Listener Problem

These threads accounted for 40.6% of the total volume.

Top 10 Targets for Crossposts

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

       16  comp.databases.oracle.misc
        9  comp.databases.ms-access
        5  comp.databases.oracle.marketplace
        3  comp.unix.solaris

Received on Sun Nov 30 2003 - 14:19:28 CST

Statistics for comp.databases.oracle.server - WE 11/30/2003