Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 26 Jan 2003 20:53:16 GMT
Message-ID: <BA598AB9.7A34%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 19 Jan 2003 21:31:23 GMT and ending at 26 Jan 2003 19:32:55 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: 265
Articles: 773 (61 with cutlined signatures) Threads: 183
Volume generated: 2128.5 kb

headers: 875.7 kb (13,629 lines)
bodies: 1244.1 kb (38,191 lines)
original: 581.3 kb (19,301 lines)
signatures: 7.9 kb (190 lines)

Original Content Rating: 0.467

Averages

Posts per poster: 2.9

    median: 1 post
    mode: 1 post - 140 posters
    s: 22.7 posts
Posts per thread: 4.2

    median: 3 posts
    mode: 1 post - 56 threads
    s: 5.7 posts
Message size: 2819.6 bytes

header: 1160.1 bytes (17.6 lines)
body: 1648.0 bytes (49.4 lines)
original: 770.1 bytes (25.0 lines)
signature: 10.5 bytes (0.2 lines)

Top 10 Threads by Number of Posts

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

   42 question about automatic undo management    33 Statistics for comp.databases.oracle.server - WE 19/1/2003    27 Locks rows
   21 Locally Managed Tablespaces ... again!!!    17 OT: Richard Foote
   17 Solution for 01555
   17 Multi-homed interface and Oracle listener    15 Oracle9i with IIS on Win2k
   13 JDBC / Oracle / MS SQL Server performance anomalies    12 Reverse engineering existing remote Oracle 9i DB?

These threads accounted for 27.7% of all articles.

Top 10 Threads by Volume

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

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

 158.7 ( 58.0/100.7/ 44.7)     42  question about automatic undo management
 119.8 ( 32.0/ 87.5/ 39.6)     21  Locally Managed Tablespaces ... again!!!
 112.6 (  7.5/105.1/ 25.9)      7  ORA-01578: Datablock corruption
  85.9 ( 43.2/ 42.6/ 20.9)     33  Statistics for
                                   comp.databases.oracle.server - WE
                                   19/1/2003
  64.6 ( 32.7/ 31.4/ 15.6)     27  Locks rows
  53.7 ( 17.9/ 35.7/ 14.7)     17  Solution for 01555
  48.1 ( 15.0/ 33.0/ 14.8)     13  JDBC / Oracle /  MS SQL Server
                                   performance anomalies
  46.4 ( 20.4/ 24.8/  9.7)     17  Multi-homed interface and Oracle listener
  38.8 ( 21.4/ 17.3/  8.8)     17  OT: Richard Foote
  38.6 (  6.7/ 31.9/ 11.9)      6  Table recovery using Standby Database and
                                   RMAN

These threads accounted for 36.0% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.788  (  2.9/   3.7)      7  Oracle 8.1.6 installation on SuSE 8.1
0.731  (  8.3/  11.3)     11  Export from 9i and import to 8i
0.694  (  4.2/   6.1)      5  Create a tablespace on file network
0.672  (  4.3/   6.4)      6  Resetting state of PL/SQL package
0.664  (  2.9/   4.3)      5  PL/Compiler
0.633  (  2.4/   3.9)      7  How to find history of shutdown/startup
0.623  (  4.5/   7.2)      6  DWH concept, what is better ?
0.601  ( 12.0/  19.9)     10  Oracle 9i, Where to start?????
0.582  (  3.0/   5.1)      6  Private synonyms - I'm seeing too much!!
0.578  (  6.7/  11.6)      6  Oracle Replication / Migration Question

Bottom 10 Threads by OCR (minimum of five posts)

<snip>

Top 10 Targets for Crossposts

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

      77  comp.databases.oracle.misc
      31  comp.databases.oracle.tools
      15  comp.sys.hp.hpux
      14  comp.lang.java.programmer
      13  comp.lang.java.databases
      11  comp.lang.visual.basic
      11  comp.lang.java.developer
      11  comp.databases.ms-sqlserver
      11  microsoft.public.dotnet.languages.csharp
      10  comp.databases.oracle.marketplace

Top 10 Crossposters

<snip>

Note that I've snipped the statistics that could be construed as negative. Received on Sun Jan 26 2003 - 14:53:16 CST

Statistics for comp.databases.oracle.server - WE 26/1/2003