Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 07 Sep 2003 15:07:54 GMT
Message-ID: <eRH6b.381577$Ho3.57454@sccrnsc03>

Following is a summary of articles spanning a 7 day period, beginning at 31 Aug 2003 15:07:28 GMT and ending at 07 Sep 2003 13:54:34 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: 201
Articles: 555 (110 with cutlined signatures) Threads: 138

Volume generated: 1624.9 kb


     - headers:    603.1 kb (9,889 lines)

     - bodies:     953.4 kb (27,658 lines)

     - original:   422.9 kb (13,313 lines)

     - signatures: 67.9 kb (1,908 lines)


Original Content Rating: 0.444

Averages

Posts per poster: 2.8

     median: 1 post
     mode:   1 post - 110 posters
     s:      6.5 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 46 threads
     s:      4.7 posts
Message size: 2998.1 bytes


     - header:     1112.7 bytes (17.8 lines)

     - body:       1759.0 bytes (49.8 lines)

     - original:   780.3 bytes (24.0 lines)

     - signature:  125.4 bytes (3.4 lines)

Top 10 Threads by Number of Posts

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

    27 Why so many Gay Oracle people?
    25 News from Oz
    24 Importing huge data
    22 Oracle performance with Microsoft Project     14 Temporary tables in memory
    14 Direct Path Export vs. Conventional Path Export     13 Who's going to OracleWorld?
    12 Oracle can be Case Insensitive ?     11 Optimal degree of parallelism
    10 9.2.0.4 Patchset

These threads accounted for 31.0% of all articles.

Top 10 Threads by Volume

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

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

  300.3 (  6.3/294.0/ 68.9)      6  URGENT: Slow Performance after
                                    migration to 9.2.0.3 from 8.1.7
   67.4 ( 26.5/ 31.0/ 10.6)     24  Importing huge data
   55.5 ( 29.4/ 23.4/ 15.0)     27  Why so many Gay Oracle people?
   53.2 ( 24.4/ 25.4/ 12.3)     22  Oracle performance with Microsoft
                                    Project
   52.1 ( 16.7/ 25.0/ 12.0)     14  Temporary tables in memory
   47.7 ( 27.1/ 17.8/  9.3)     25  News from Oz
   33.9 ( 13.1/ 20.4/ 14.1)     11  Optimal degree of parallelism
   33.2 ( 11.7/ 21.5/ 10.0)     10  SQL*Loader - Commit point reached -
                                    logical record count 27
   31.7 ( 15.4/ 13.3/  5.7)     14  Direct Path Export vs. Conventional
                                    Path Export
   30.2 (  9.2/ 20.8/  6.7)      8  Newbie help with explain plans

These threads accounted for 43.4% of the total volume.

Top 10 Targets for Crossposts

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

       15  comp.databases.oracle.misc
       14  microsoft.public.project
        9  comp.databases.oracle.tools
        7  comp.databases.oracle
        5  comp.databases.object
        5  comp.databases
        5  microsoft.public.sqlserver.server
        4  comp.databases.orace.tools
        1  comp.databases.sybase
        1  news.announce.newgroups

Received on Sun Sep 07 2003 - 10:07:54 CDT

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