Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 23 Jun 2003 00:42:54 GMT
Message-ID: <i2sJa.107489$YZ2.275561@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 16 Jun 2003 00:35:14 GMT and ending at 23 Jun 2003 00:11:04 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: 237
Articles: 903 (122 with cutlined signatures) Threads: 169
Volume generated: 2140.8 kb

headers: 1024.2 kb (15,993 lines)
bodies: 1060.8 kb (32,949 lines)
original: 502.1 kb (16,803 lines)
signatures: 54.9 kb (1,957 lines)

Original Content Rating: 0.473

Averages

Posts per poster: 3.8

     median: 2 posts
     mode:   1 post - 97 posters
     s:      6.5 posts
Posts per thread: 5.3
     median: 4 posts
     mode:   1 post - 40 threads
     s:      10.5 posts
Message size: 2427.7 bytes


     - header:     1161.4 bytes (17.7 lines)

     - body:       1203.0 bytes (36.5 lines)

     - original:   569.4 bytes (18.6 lines)

     - signature:  62.3 bytes (2.2 lines)

Top 10 Threads by Number of Posts

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

    43 Plagiarism
    31 Where can I get a complete list of all SQL Hints?     26 What's wrong with SQL Server?
    24 How to Forbid sqlplus connecting to ORACLE     21 About Oracle9iAS
    19 PL/SQL substr(instr oracle
    18 Does a commit cause a checkpoint?     18 LINUX Kernel Parameters
    17 count(*) vs. a cursor when determining the existing record on

primary key
17 Interesting info about Oracle

These threads accounted for 25.9% of all articles.

Top 10 Threads by Volume

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

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

  102.9 ( 41.8/ 60.9/ 36.5)     31  Where can I get a complete list of
                                    all SQL Hints?
  100.7 ( 27.5/ 72.1/  9.2)     21  About Oracle9iAS
   74.2 ( 46.0/ 26.4/ 15.5)     43  Plagiarism
   64.1 ( 21.7/ 42.1/ 13.1)     18  Does a commit cause a checkpoint?
   59.8 ( 17.7/ 41.8/ 25.2)     17  count(*) vs. a cursor when
                                    determining the existing record on
                                    primary key
   56.9 ( 15.1/ 41.8/ 11.6)     14  imp hangs then ora-3113 error
   54.9 ( 19.9/ 33.1/ 16.1)     17  Interesting info about Oracle
   54.9 ( 34.0/ 17.8/  9.9)     26  What's wrong with SQL Server?
   48.9 ( 26.9/ 21.5/  9.2)     24  How to Forbid sqlplus connecting to
                                    ORACLE
   46.8 ( 21.0/ 25.3/  9.5)     18  LINUX Kernel Parameters

These threads accounted for 31.0% of the total volume.

Top 10 Targets for Crossposts

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

       17  comp.databases.oracle.tools
       16  comp.databases.oracle.misc
       12  comp.databases.oracle
        9  microsoft.public.vb.database.ado
        7  microsoft.public.odbc.beta.oracle
        7  comp.databases.ms-sqlserver
        6  comp.lang.java.programmer
        6  comp.lang.java.help
        2  alt.os.linux.mandrake
        2  microsoft.public.cert.exam.mcse

Received on Sun Jun 22 2003 - 19:42:54 CDT

Statistics for comp.databases.oracle.server - WE 06/22/2003