Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 12 Oct 2003 06:26:32 GMT
Message-ID: <su6ib.99544$%h1.96346@sccrnsc02>

Following is a summary of articles spanning a 7 day period, beginning at 05 Oct 2003 07:40:05 GMT and ending at 12 Oct 2003 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: 179
Articles: 636 (177 with cutlined signatures) Threads: 132

Volume generated: 1838.8 kb


     - headers:    716.6 kb (11,440 lines)

     - bodies:     989.2 kb (29,085 lines)

     - original:   497.5 kb (15,252 lines)

     - signatures: 132.4 kb (3,655 lines)


Original Content Rating: 0.503

Averages

Posts per poster: 3.6

     median: 1 post
     mode:   1 post - 93 posters
     s:      7.4 posts
Posts per thread: 4.8
     median: 3.0 posts
     mode:   1 post - 31 threads
     s:      7.2 posts
Message size: 2960.6 bytes


     - header:     1153.7 bytes (18.0 lines)

     - body:       1592.6 bytes (45.7 lines)

     - original:   801.0 bytes (24.0 lines)

     - signature:  213.2 bytes (5.7 lines)

Top 10 Threads by Number of Posts

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

50 Oracle's Myth: keep tables and indexes in separate tablespaces 42 Outsourcing developer to India and China - As an Oracle developer

        I am miffed
    25 are hints still necessary in 9i?     22 How to create the seed database?     19 why does CBO not use available indices     18 Oracle 9i + Death of the DBA
    15 Oracle 9i New Features or Data Guard Course     14 system statistics
    13 Oracle 10G new features preview
    12 Frequency of log switches

These threads accounted for 36.2% of all articles.

Top 10 Threads by Volume

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

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

  152.8 ( 61.1/ 73.7/ 37.4)     50  Oracle's Myth: keep tables and
                                    indexes in separate tablespaces
  144.5 ( 52.1/ 91.4/ 46.9)     42  Outsourcing developer to India and
                                    China - As an Oracle developer I am
                                    miffed
   91.3 ( 22.1/ 68.8/ 35.0)     19  why does CBO not use available
                                    indices
   85.2 ( 28.5/ 46.4/ 14.0)     22  How to create the seed database?
   68.8 ( 29.9/ 38.4/ 19.1)     25  are hints still necessary in 9i?
   46.9 ( 18.8/ 24.1/ 15.2)     18  Oracle 9i + Death of the DBA
   44.5 ( 16.3/ 19.1/  8.0)     14  system statistics
   42.2 ( 10.2/ 31.2/ 15.8)      9  9i, pfiles and spfiles
   41.7 (  5.4/ 14.3/  2.6)      4  Outsourcing developer to India and
                                    China - As an Oracle developer I am
                                    miffed
   41.0 ( 10.3/ 30.1/ 14.3)     10  ORA-27101 hell!!!

These threads accounted for 41.3% of the total volume.

Top 10 Targets for Crossposts

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

       12  comp.databases.oracle.tools
       10  comp.databases.oracle.misc
        8  comp.databases.oracle
        7  microsoft.public.dotnet.framework.adonet
        1  comp.lang.java.programmer

Received on Sun Oct 12 2003 - 01:26:32 CDT

Statistics for comp.databases.oracle.server - WE 10/12/2003