Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 29 Sep 2003 00:31:12 GMT
Message-ID: <k3Ldb.457710$cF.146643@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 22 Sep 2003 00:40:02 GMT and ending at 06 Jan 2004 00:41:03 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: 219
Articles: 737 (213 with cutlined signatures) Threads: 161

Volume generated: 1831.9 kb


     - headers:    826.3 kb (13,176 lines)

     - bodies:     863.2 kb (26,840 lines)

     - original:   430.5 kb (14,083 lines)

     - signatures: 141.7 kb (4,071 lines)


Original Content Rating: 0.499

Averages

Posts per poster: 3.4

     median: 1 post
     mode:   1 post - 121 posters
     s:      8.1 posts
Posts per thread: 4.6
     median: 3 posts
     mode:   1 post - 41 threads
     s:      5.0 posts
Message size: 2545.3 bytes


     - header:     1148.0 bytes (17.9 lines)

     - body:       1199.4 bytes (36.4 lines)

     - original:   598.1 bytes (19.1 lines)

     - signature:  196.9 bytes (5.5 lines)

Top 10 Threads by Number of Posts

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

    36 Suggestions for first exam ...
    32 LMT advice
    22 Does Oracle 10G new database still need an DBA to manage it?     20 DB recovery after OS crash, ORA-01210, ORA-01251     17 Problem with Decode fuction
    17 Is this a good situation for an Index ?     15 Memory leak
    13 What's fast way to get total of records     12 confused between explain plan and analyze table     12 viewing the definition of a trigger

These threads accounted for 26.6% of all articles.

Top 10 Threads by Volume

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

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

  134.9 ( 51.3/ 68.3/ 37.2)     36  Suggestions for first exam ...
  115.2 ( 40.8/ 53.4/ 23.7)     32  LMT advice
   59.5 ( 13.1/ 45.5/ 12.9)     12  Help getting past missing archivelog
                                    file
   52.2 ( 22.3/ 17.2/  7.7)     17  Is this a good situation for an Index
                                    ?
   38.0 ( 23.2/ 13.9/  6.9)     20  DB recovery after OS crash,
                                    ORA-01210, ORA-01251
   36.9 ( 25.6/  8.9/  5.7)     22  Does Oracle 10G new database still
                                    need  an DBA to manage it?
   36.3 (  5.7/ 23.9/ 13.3)      5  Replication and RAC
   34.7 (  8.6/ 25.7/  9.7)      8  star transformation not chosen
                                    because of bind variables
   34.3 ( 19.2/ 10.3/  5.2)     17  Problem with Decode fuction
   32.8 (  9.8/ 23.0/ 10.2)      7  Please help: Oracle9i/AIX5.2/Veritas
                                    vxvm raw devices Problem

These threads accounted for 31.4% of the total volume.

Top 10 Targets for Crossposts

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

       15  comp.databases.oracle.misc
        9  comp.databases.oracle.tools
        3  comp.lang.java.databases
        2  comp.databases.oracle.marketplace
        1  comp.lang.java.programmer
        1  alt.linux.suse
        1  comp.databases.oracle
        1  alt.os.linux.suse

Received on Sun Sep 28 2003 - 19:31:12 CDT

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