Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 24 Mar 2003 01:45:21 GMT
Message-ID: <BAA3A32D.DC34%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 17 Mar 2003 01:48:55 GMT and ending at 23 Mar 2003 21:05:08 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: 204
Articles: 639 (78 with cutlined signatures) Threads: 165
Volume generated: 1436.8 kb

headers: 707.6 kb (11,308 lines)
bodies: 721.9 kb (22,135 lines)
original: 377.1 kb (12,226 lines)
signatures: 6.7 kb (283 lines)

Original Content Rating: 0.522

Averages

Posts per poster: 3.1

    median: 1.0 post
    mode: 1 post - 104 posters
    s: 5.2 posts
Posts per thread: 3.9

    median: 3 posts
    mode: 1 post - 47 threads
    s: 5.3 posts
Message size: 2302.5 bytes

header: 1133.9 bytes (17.7 lines)
body: 1156.8 bytes (34.6 lines)
original: 604.3 bytes (19.1 lines)
signature: 10.8 bytes (0.4 lines)

Top 10 Threads by Number of Posts

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

   45 One to One Relationship
   23 Catpatch.sql Problem
   14 slow query - index usage question    13 URGENT: ORA-01554 upon startup
   13 Holdable cursors in Oracle?
   12 Oracle 9.2.0.1 Patch to 9.2.0.2
   10 How are joins performed when using a database link?    10 RAID 0+1 and recommended stripe size    10 MTS - Multi-threaded server
   10 a performance question

These threads accounted for 25.0% of all articles.

Top 10 Threads by Volume

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

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

 124.2 ( 56.0/ 67.2/ 31.4)     45  One to One Relationship
  81.5 ( 27.2/ 54.3/ 23.5)     23  Catpatch.sql Problem
  43.4 ( 17.7/ 25.8/ 11.8)     14  slow query - index usage question
  34.5 ( 14.7/ 19.8/  9.0)     13  Holdable cursors in Oracle?
  33.7 ( 16.2/ 17.5/  9.4)     13  URGENT: ORA-01554 upon startup
  33.2 ( 13.2/ 19.9/ 11.8)     12  Oracle 9.2.0.1 Patch to 9.2.0.2
  30.2 ( 10.0/ 20.1/  7.4)     10  a performance question
  26.5 (  5.7/ 20.7/ 10.0)      5  8.1.5 and ORA-00600 with [4193], [1544],
                                   [1778], [], []
  25.3 ( 12.0/ 13.2/  7.0)     10  How are joins performed when using a
                                   database link?
  22.6 (  8.8/ 13.7/  6.5)      7  ANNOUNCEMENT: ChangeGroup PL/SQL Server
                                   Pages (CGPSP) 2.0

These threads accounted for 31.7% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

         (kb)    (kb)
OCR      orig /  body  Posts  Subject

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

0.701  (  6.0/   8.6)     10  Oracle 9i R2 database (9.2.0.1) on a RedHat
                              box
0.675  (  1.6/   2.3)      6  How to read DBF Files?
0.668  (  6.9/  10.3)      6  DMT and LMT
0.666  (  5.1/   7.6)      6  exception: The Network Adapter could not
                              establish the connection
0.649  (  1.0/   1.5)      5  What IDE to use for PROC under Linux ?
0.608  (  5.0/   8.2)      5  tns error: 03505 - trying to get hsodbc to
                              work
0.603  (  2.9/   4.9)      6  RO tablespaces, LMT and drop table.
0.599  (  3.8/   6.3)     10  MTS - Multi-threaded server
0.596  ( 11.8/  19.9)     12  Oracle 9.2.0.1 Patch to 9.2.0.2
0.573  (  3.0/   5.2)      7  Hi-- Upgrading from SQL Server 6.5 to oracle

Top 10 Targets for Crossposts

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

      47  comp.databases.oracle.misc
      23  comp.databases.oracle.tools
      14  comp.databases.oracle
       8  comp.databases.oracle.marketplace
       4  comp.databases
       4  comp.infosystems.www.databases
       2  comp.database.oracle
       1  fr.rec.genealogie

Received on Sun Mar 23 2003 - 19:45:21 CST

Statistics for comp.databases.oracle.server - WE 3/23/2003