Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 05 Jan 2003 22:56:47 GMT
Message-ID: <BA3DF80A.5348%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 29 Dec 2002 23:41:54 GMT and ending at 05 Jan 2003 21:56:50 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: 131
Articles: 370 (34 with cutlined signatures) Threads: 93
Volume generated: 1209.2 kb

headers: 418.3 kb (6,529 lines)
bodies: 784.4 kb (20,608 lines)
original: 374.3 kb (10,290 lines)
signatures: 6.2 kb (166 lines)

Original Content Rating: 0.477

Averages

Posts per poster: 2.8

    median: 1 post
    mode: 1 post - 72 posters
    s: 15.5 posts
Posts per thread: 4.0

    median: 2 posts
    mode: 1 post - 31 threads
    s: 7.7 posts
Message size: 3346.5 bytes

header: 1157.7 bytes (17.6 lines)
body: 2170.8 bytes (55.7 lines)
original: 1035.8 bytes (27.8 lines)
signature: 17.0 bytes (0.4 lines)

Top 10 Posters by Volume

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

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

 177.1 (  1.9/175.2/ 95.1)      2  "cml" <lafeverc_at_hotmail.com>
  65.1 ( 23.4/ 41.7/ 18.6)     18  "Howard J. Rogers"
                                   <howardjr2000_at_yahoo.com.au>
  56.9 ( 21.6/ 35.3/  7.1)     20  damorgan <damorgan_at_exesolutions.com>
  53.0 ( 18.8/ 34.1/ 13.9)     12  "Bert Bear" <bertbear_at_NOSPAMbertbear.net>
  52.9 ( 15.5/ 37.4/ 11.7)     13  Joel Garry <joel-garry_at_home.com>
  41.6 ( 19.7/ 21.0/ 13.4)     17  Noons <nsouto_at_optusnet.com.au.nospam>
  32.8 (  5.3/ 27.5/ 16.5)      5  "Stephan" <test_at_test.com>
  29.4 ( 13.7/ 15.7/  6.2)      9  Karsten Farrell <kfarrell_at_belgariad.com>
  27.4 ( 13.8/ 13.5/  9.7)     10  "Niall Litchfield"
                                    <niall.litchfield_at_dial.pipex.com>
  27.0 ( 10.5/ 16.5/  3.0)      9  "Paul Brewer" <paul_at_paul.brewers.org.uk>

These posters accounted for 46.6% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

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

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

0.718  (  9.7 / 13.5)     10  "Niall Litchfield"
                               <niall.litchfield_at_dial.pipex.com>
0.639  ( 13.4 / 21.0)     17  Noons <nsouto_at_optusnet.com.au.nospam>
0.602  ( 16.5 / 27.5)      5  "Stephan" <test_at_test.com>
0.489  (  6.9 / 14.0)     11  Rauf Sarwar <rs_arwar_at_hotmail.com>
0.479  (  1.7 /  3.5)      5  Ban Spam <ban-spam_at_operamail.com>
0.445  ( 18.6 / 41.7)     18  "Howard J. Rogers" <howardjr2000_at_yahoo.com.au>
0.414  (  4.1 /  9.8)      9  Beserko <beserkobob_at_yahoo.ca>
0.407  ( 13.9 / 34.1)     12  "Bert Bear" <bertbear_at_NOSPAMbertbear.net>
0.406  (  5.0 / 12.3)      7  "Richard Foote" <richard.foote_at_bigpond.com>
0.392  (  6.2 / 15.7)      9  Karsten Farrell <kfarrell_at_belgariad.com>

Bottom 10 Posters by OCR (minimum of five posts)

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

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

0.373  (  3.2 /  8.5)      7  fbortel_at_nescape.net
0.372  (  4.5 / 12.1)      6  Pete Sharman <peter.sharman_at_oracle.com>
0.341  (  2.8 /  8.3)      6  postbus_at_sybrandb.demon.nl
0.330  (  2.4 /  7.3)      6  Ryan Gaffuri <rgaffuri_at_cox.net>
0.314  ( 11.7 / 37.4)     13  Joel Garry <joel-garry_at_home.com>
0.254  (  2.6 / 10.4)      7  "Jim Kennedy"
                              <kennedy-down_with_spammers_at_attbi.com>
0.213  (  2.2 / 10.2)      6  Wade Noordink <noordw_at_hotmail.com>
0.203  (  7.1 / 35.3)     20  damorgan <damorgan_at_exesolutions.com>
0.179  (  3.0 / 16.5)      9  "Paul Brewer" <paul_at_paul.brewers.org.uk>
0.146  (  0.9 /  6.1)      5  "David Sharples"
                              <david.sharples3_at_ntlworld.com>

20 posters (15%) had at least five posts.

Top 10 Threads by Number of Posts

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

   65 Outrage that OCP exams are now unproctored - Comments?    25 locally managed tablespace & dictionary managed tablespace    23 Java to die in 2003
   16 One vs many databases
    9 Oracle and Java. Does Oracle know something some of us don't?     9 Insert & Update triggers fire together when a new record is created.     8 corrupt datafile
    8 Natural penis enlargement - jy0 dq618j wq h     7 Statistics for comp.databases.oracle.server     6 Cannot log into Oracle Management Server.

These threads accounted for 47.6% of all articles.

Top 10 Threads by Volume

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

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

 232.4 ( 92.5/138.8/ 64.7)     65  Outrage that OCP exams are now
                                   unproctored - Comments?
 184.8 (  4.9/179.9/ 98.3)      5  Database Design
  76.9 ( 27.9/ 48.9/ 20.0)     25  locally managed tablespace & dictionary
                                   managed tablespace
  65.2 ( 28.8/ 36.2/ 17.2)     23  Java to die in 2003
  54.2 ( 18.0/ 36.0/ 13.6)     16  One vs many databases
  35.4 (  3.8/ 31.6/ 17.1)      3  performance: new info
  35.2 (  9.6/ 22.2/  8.3)      9  Oracle and Java. Does Oracle know
                                   something some of us don't?
  32.5 ( 10.2/ 22.2/  6.4)      9  Insert & Update triggers fire together
                                   when a new record is created.
  24.2 (  6.7/ 17.5/  2.8)      6  Create 9.2.0 database manually
  22.1 (  9.1/ 13.0/  4.3)      8  corrupt datafile

These threads accounted for 63.1% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.883  ( 11.7/  13.2)      7  Statistics for comp.databases.oracle.server
0.722  (  3.2/   4.4)      6  ORA-00600 ... more exactly (from a newbee)
0.588  (  1.8/   3.1)      5  question about initial extent
0.546  ( 98.3/ 179.9)      5  Database Design
0.474  ( 17.2/  36.2)     23  Java to die in 2003
0.466  ( 64.7/ 138.8)     65  Outrage that OCP exams are now unproctored -
                              Comments?
0.456  (  3.8/   8.3)      8  Natural penis enlargement - jy0 dq618j wq h
0.447  (  2.3/   5.2)      5  How to create a dynamic cursor?
0.413  (  2.4/   5.8)      5  Oracle 8i + changing language
0.410  ( 20.0/  48.9)     25  locally managed tablespace & dictionary
                              managed tablespace

Bottom 10 Threads by OCR (minimum of five posts)

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

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

0.389  (  2.4 /  6.2)      5  pb starting Oracle 9i on Linux
0.386  (  4.0 / 10.3)      5  Oracle stored procedures vs Running from a
                              flat .sql file
0.377  ( 13.6 / 36.0)     16  One vs many databases
0.374  (  8.3 / 22.2)      9  Oracle and Java. Does Oracle know something
                              some of us don't?
0.365  (  1.6 /  4.4)      5  Plz help finding replication solution!
0.364  (  3.5 /  9.8)      6  performance
0.327  (  4.3 / 13.0)      8  corrupt datafile
0.322  (  2.6 /  8.1)      6  Cannot log into Oracle Management Server.
0.291  (  6.4 / 22.2)      9  Insert & Update triggers fire together when a
                              new record is created.
0.162  (  2.8 / 17.5)      6  Create 9.2.0 database manually

21 threads (22%) had at least five posts. Received on Sun Jan 05 2003 - 16:56:47 CST

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