Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 25 May 2003 18:13:36 GMT
Message-ID: <kJ7Aa.458940$Si4.395158@rwcrnsc51.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 18 May 2003 18:16:17 GMT and ending at 25 May 2003 17:38:54 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: 645 (107 with cutlined signatures) Threads: 160

Volume generated: 1539.1 kb


     - headers:    703.7 kb (11,392 lines)

     - bodies:     806.6 kb (24,444 lines)

     - original:   408.7 kb (13,123 lines)

     - signatures: 28.2 kb (949 lines)


Original Content Rating: 0.507

Averages

Posts per poster: 3.2

     median: 1 post
     mode:   1 post - 103 posters
     s:      5.5 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 42 threads
     s:      8.0 posts
Message size: 2443.4 bytes


     - header:     1117.1 bytes (17.7 lines)

     - body:       1280.5 bytes (37.9 lines)

     - original:   648.9 bytes (20.3 lines)

     - signature:  44.7 bytes (1.5 lines)

Top 10 Threads by Number of Posts

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

    30 Securing isqlplus
    20 Oh, this is so microsoftish ...
    16 Why would an Insert /*+ append */ be slower than a straight

        insert?
    16 URGENT! shared memory realm does not exist     16 Rich Niemiec live at ODTUG!
    15 How to make lock escalation look good...     14 truncate command 8.1.7. locally managed tablespaces     13 What else against 9.0.1
    11 Recomended max datafile size
    11 TNS-12571 and Mcafee Virus Scan 7

These threads accounted for 25.1% of all articles.

Top 10 Threads by Volume

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

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

   90.6 ( 42.2/ 48.2/ 16.6)     30  Securing isqlplus
   58.5 ( 23.8/ 30.4/ 16.8)     20  Oh, this is so microsoftish ...
   52.3 ( 18.4/ 33.8/ 12.4)     16  Why would an Insert /*+ append */ be
                                    slower than a straight insert?
   47.9 ( 16.4/ 31.4/ 14.6)     14  truncate command 8.1.7. locally
                                    managed tablespaces
   35.0 ( 16.2/ 15.7/ 11.2)     15  How to make lock escalation look
                                    good...
   33.1 ( 17.9/ 14.5/  4.5)     16  Rich Niemiec live at ODTUG!
   32.0 ( 13.5/ 17.3/  7.0)     13  What else against 9.0.1
   31.0 ( 11.6/ 19.3/ 10.3)     10  Index query - monotonically
                                    increasing columns
   29.6 ( 10.3/ 19.2/  6.4)      8  Oracle 9.2 on RH9 Java initialisation
                                    error
   29.0 ( 17.5/ 11.5/  6.0)     16  URGENT! shared memory realm does not
                                    exist

These threads accounted for 28.5% of the total volume.

Top 10 Targets for Crossposts

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

       11  comp.databases.oracle.tools
       11  comp.databases.oracle.misc
        6  comp.databases.oracle
        2  alt.solaris.x86

Received on Sun May 25 2003 - 13:13:36 CDT

Statistics for comp.databases.oracle.server - WE 05/25/2003