Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 25 Apr 2004 21:15:01 GMT
Message-ID: <pTVic.33866$IW1.1514880@attbi_s52>

Following is a summary of articles spanning a 7 day period, beginning at 18 Apr 2004 21:51:45 GMT and ending at 25 Apr 2004 16:41:51 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: 148
Articles: 399 (63 with cutlined signatures) Threads: 110
Volume generated: 890.6 kb

headers: 415.2 kb (7,202 lines)
bodies: 450.7 kb (13,243 lines)
original: 225.4 kb (7,123 lines)
signatures: 24.3 kb (790 lines)

Original Content Rating: 0.500

Averages

Posts per poster: 2.7

     median: 2.0 posts
     mode:   1 post - 73 posters
     s:      4.0 posts
Posts per thread: 3.6
     median: 3.0 posts
     mode:   1 post - 31 threads
     s:      4.1 posts
Message size: 2285.6 bytes


     - header:     1065.7 bytes (18.1 lines)

     - body:       1156.6 bytes (33.2 lines)

     - original:   578.6 bytes (17.9 lines)

     - signature:  62.3 bytes (2.0 lines)

Top 10 Threads by Number of Posts

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

    21 Percentage of who's on what...
    15 Suggestions please
    12 Oracle client for DOS
    11 TKPROF: Long CPU time on Execute     11 oracle standard vs oracle enterprise     11 Multiple installations of oracle on a single unix system     10 table stats

     9  Metalink Problems
     8  How to move Oracle database to a new machine?
     8  short of memory ?

These threads accounted for 29.1% of all articles.

Top 10 Threads by Volume

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

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

   37.9 ( 22.9/ 14.7/  5.7)     21  Percentage of who's on what...
   37.6 ( 15.8/ 18.8/  9.7)     15  Suggestions please
   33.3 (  2.9/ 29.5/ 14.7)      3  optimizer_max_permutations not valid
                                    anymore in 10g
   31.6 ( 11.6/ 19.1/  6.1)     11  TKPROF: Long CPU time on Execute
   29.4 (  7.9/ 21.5/  8.6)      7  ORA-00202: controlfile:
                                    '/var/opt/oracle/oradata/orcl/
                                    control03.ctl'
   28.2 (  8.7/ 19.5/  7.1)      8  How to move Oracle database to a new
                                    machine?
   26.3 ( 10.6/ 11.4/  4.3)     10  table stats
   25.4 ( 14.2/ 10.7/  5.4)     12  Oracle client for DOS
   21.4 ( 12.3/  8.2/  3.6)      9  Metalink Problems
   19.7 ( 11.5/  7.9/  5.5)     11  Multiple installations of oracle on a
                                    single unix system

These threads accounted for 32.6% of the total volume.

Top 10 Targets for Crossposts

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

       14  comp.databases.oracle.misc
       13  comp.databases.oracle.tools
        3  comp.databases.oracle
        2  comp.database.oracle
        1  comp.lang.java.databases
        1  comp.databases.informix

Received on Sun Apr 25 2004 - 16:15:01 CDT

Statistics for comp.databases.oracle.server - WE 04/25/2004