Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 25 Jan 2004 20:25:14 GMT
Message-ID: <KCVQb.19595$U%5.152055@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 18 Jan 2004 21:24:56 GMT and ending at 25 Jan 2004 19:32:58 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: 194
Articles: 564 (177 with cutlined signatures) Threads: 135

Volume generated: 1491.7 kb


     - headers:    631.5 kb (10,286 lines)

     - bodies:     784.9 kb (23,028 lines)

     - original:   383.3 kb (11,848 lines)

     - signatures: 74.8 kb (2,456 lines)


Original Content Rating: 0.488

Averages

Posts per poster: 2.9

     median: 1.0 post
     mode:   1 post - 114 posters
     s:      6.8 posts
Posts per thread: 4.2
     median: 3 posts
     mode:   1 post - 33 threads
     s:      5.2 posts
Message size: 2708.4 bytes


     - header:     1146.6 bytes (18.2 lines)

     - body:       1425.0 bytes (40.8 lines)

     - original:   695.8 bytes (21.0 lines)

     - signature:  135.8 bytes (4.4 lines)

Top 10 Threads by Number of Posts

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

    40 Hmmm, it's starting....
    21 10g News
    20 Buffer cache statistics (ratios) and CBO SQL optimization?     19 Oracle Table Spanning
    19 Fuzzy search
    14 choices regarding where to place code - in the database or

middletier
11 Data block and buffer busy quite high, suggestions?

     9  hint injection in 10g??
     8  Oracle expert please help. Slow insert in Oracle 8i and 9i.
        Urgent!
     8  ODM ( Oracle Disk Manager )

These threads accounted for 30.0% of all articles.

Top 10 Threads by Volume

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

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

  124.8 ( 53.0/ 67.6/ 33.4)     40  Hmmm, it's starting....
   79.7 (  8.0/ 47.4/ 21.4)      7  All bitmap indexes not being used in
                                    a query where they should be
   51.5 ( 27.3/ 22.7/  8.6)     20  Buffer cache statistics (ratios) and
                                    CBO SQL optimization?
   51.2 (  7.2/ 36.8/  7.5)      7  Strange IO problem on T3
   50.9 ( 20.8/ 29.3/ 13.8)     14  choices regarding where to place code
                                    - in the database or middletier
   47.3 ( 23.8/ 21.0/  9.1)     21  10g News
   46.6 ( 20.0/ 24.9/  7.2)     19  Fuzzy search
   44.4 ( 23.2/ 19.7/  9.1)     19  Oracle Table Spanning
   33.9 ( 12.5/ 17.7/  7.4)     11  Data block and buffer busy quite
                                    high, suggestions?
   33.0 (  6.2/ 26.8/ 11.4)      5  choices regarding where to place code
                                    - in the database or middle tier

These threads accounted for 37.8% of the total volume.

Top 10 Targets for Crossposts

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

       35  comp.lang.java.databases
       35  comp.lang.java.programmer
       31  comp.databases.oracle.tools
       21  comp.database.oracle
        6  comp.databases.oracle.misc
        2  comp.databases

Received on Sun Jan 25 2004 - 14:25:14 CST

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