Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 15 Sep 2003 01:01:54 GMT
Message-ID: <6c89b.343712$Oz4.129110@rwcrnsc54>

Following is a summary of articles spanning a 7 day period, beginning at 08 Sep 2003 01:31:02 GMT and ending at 15 Sep 2003 00:45:30 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: 179
Articles: 577 (148 with cutlined signatures) Threads: 125

Volume generated: 1651.0 kb


     - headers:    634.2 kb (10,202 lines)

     - bodies:     858.6 kb (25,084 lines)

     - original:   447.6 kb (13,952 lines)

     - signatures: 157.6 kb (4,282 lines)


Original Content Rating: 0.521

Averages

Posts per poster: 3.2

     median: 1 post
     mode:   1 post - 95 posters
     s:      6.2 posts
Posts per thread: 4.6
     median: 3 posts
     mode:   1 post - 27 threads
     s:      6.1 posts
Message size: 2930.1 bytes


     - header:     1125.6 bytes (17.7 lines)

     - body:       1523.8 bytes (43.5 lines)

     - original:   794.4 bytes (24.2 lines)

     - signature:  279.7 bytes (7.4 lines)

Top 10 Threads by Number of Posts

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

    40 Fed Up with being a DBA
    20 sqllder hangs at 99-100% CPU on select of fet$     17 OT - with PL/SQL in 10G,
    16 Automatic startup of multiple instances on one Win2k-Machine??     15 Holy Smoke!
    14 Tom kyte's New book
    14 Case sensitive Tablenames
    13 Label Security: Maybe I missed another naming but ...     12 This small query kills oracle 9.2.0.3 (nightmare)     12 Oracle 9i on Windows Server 2003 64 bit

These threads accounted for 30.0% of all articles.

Top 10 Threads by Volume

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

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

  229.1 ( 48.2/122.8/ 59.2)     40  Fed Up with being a DBA
   66.2 ( 25.6/ 40.3/ 18.9)     20  sqllder hangs at 99-100% CPU on
                                    select of fet$
   59.8 ( 19.1/ 27.3/  9.2)     16  Automatic startup of multiple
                                    instances on one Win2k-Machine??
   39.6 ( 14.0/ 22.0/ 13.1)     12  This small query kills oracle 9.2.0.3
                                    (nightmare)
   38.0 ( 14.9/ 14.4/  6.0)     14  Tom kyte's New book
   37.0 ( 11.7/ 15.4/  5.9)     10  SQLPlus & TNSListener
   36.7 ( 13.1/ 19.8/  8.0)     11  SYSTEM Tablespace is FULL
   36.5 ( 16.3/ 19.9/ 11.8)     15  Holy Smoke!
   35.5 ( 19.9/ 10.6/  6.2)     17  OT - with PL/SQL in 10G,
   34.3 (  5.6/ 28.6/ 17.1)      5  What are the differences between Real
                                    Application Clusters, Guard I and
                                    Guard II?

These threads accounted for 37.1% of the total volume.

Top 10 Targets for Crossposts

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

       22  comp.databases.oracle.tools
       17  comp.databases.oracle.misc
        6  comp.databases.oracle
        2  microsoft.public.project
        1  comp.databases.db2
        1  comp.databases.informix

Received on Sun Sep 14 2003 - 20:01:54 CDT

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