Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 20 Jan 2003 04:22:32 GMT
Message-ID: <BA50B987.5C6D%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 13 Jan 2003 04:20:22 GMT and ending at 20 Jan 2003 03:04:32 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: 266
Articles: 773 (51 with cutlined signatures) Threads: 197
Volume generated: 2022.5 kb

headers: 859.9 kb (13,558 lines)
bodies: 1157.6 kb (34,507 lines)
original: 629.1 kb (19,791 lines)
signatures: 4.2 kb (129 lines)

Original Content Rating: 0.543

Averages

Posts per poster: 2.9

    median: 1.0 post
    mode: 1 post - 151 posters
    s: 6.1 posts
Posts per thread: 3.9

    median: 3 posts
    mode: 1 post - 51 threads
    s: 4.4 posts
Message size: 2679.3 bytes

header: 1139.1 bytes (17.5 lines)
body: 1533.5 bytes (44.6 lines)
original: 833.4 bytes (25.6 lines)
signature: 5.6 bytes (0.2 lines)

Top 10 Posters by Volume

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

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

 274.9 ( 84.1/190.8/ 88.1)     66  Howard J. Rogers
 156.0 ( 64.1/ 91.9/ 18.3)     57  DA Morgan
  72.9 ( 36.8/ 36.1/ 23.3)     28  Niall Litchfield
  60.8 (  1.1/ 59.6/ 54.5)      1  Sergey Adamenko
  56.9 ( 19.5/ 37.5/ 28.6)     14  Richard Foote
  54.1 ( 33.0/ 21.0/  9.4)     22  Karsten Farrell
  45.0 ( 24.6/ 20.4/  8.4)     23  Paul Brewer
  42.1 ( 15.4/ 26.1/ 18.7)     14  Noons
  34.3 (  9.4/ 24.9/  9.6)      8  Joel Garry
  31.5 ( 11.2/ 20.3/  9.2)     11  Jan Gelbrich

These posters accounted for 41.0% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

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

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

0.948  (  9.1 /  9.6)     10  Norman Dunbar
0.774  ( 11.5 / 14.8)     12  Billy Verreynne
0.769  ( 13.7 / 17.9)      7  Jonathan Lewis
0.764  ( 28.6 / 37.5)     14  Richard Foote
0.746  (  2.7 /  3.7)      8  Galen Boyer
0.716  ( 18.7 / 26.1)     14  Noons
0.682  (  6.6 /  9.7)      8  Rauf Sarwar
0.644  ( 23.3 / 36.1)     28  Niall Litchfield
0.642  (  3.4 /  5.3)      5  kenneth
0.615  (  4.5 /  7.3)      5  Thomas Kyte

Bottom 10 Posters by OCR (minimum of five posts)

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

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

0.447  (  9.4 / 21.0)     22  Karsten Farrell
0.430  (  3.4 /  7.8)      8  Ryan Gaffuri
0.410  (  8.4 / 20.4)     23  Paul Brewer
0.395  (  4.0 / 10.0)      5  timx
0.385  (  9.6 / 24.9)      8  Joel Garry
0.342  (  4.4 / 13.0)     15  Peter van Rijn
0.319  (  6.4 / 20.0)     10  Jim Kennedy
0.303  (  2.8 /  9.2)      8  Frank
0.268  (  3.5 / 13.1)     10  JustAnotherDBA
0.199  ( 18.3 / 91.9)     57  DA Morgan

27 posters (10%) had at least five posts.

Top 10 Threads by Number of Posts

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

   26 Performance issue while loading large amount of data    24 What is the work attire of an Oracle DBA?    23 Locally Managed Tablespaces ... again!!!    20 Tech Comparison of Oracle versus MS Sqlserver 2000    16 Oracle 9.2 RAC on Red Hat AS 2.1 setup question    14 Benchmarks
   14 decreasing initial extent
   13 Sizing SHARED_POOL_SIZE
   12 Strange behavior with SQLPLUS (Oracle)    12 Data Dictionary: relative_fno question

These threads accounted for 22.5% of all articles.

Top 10 Threads by Volume

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

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

 158.0 ( 41.9/115.9/ 57.3)     26  Performance issue while loading large
                                   amount  of data
  94.6 ( 22.8/ 71.5/ 39.1)     20  Tech Comparison of Oracle versus MS
                                   Sqlserver 2000
  89.5 ( 28.1/ 60.7/ 24.6)     23  Locally Managed Tablespaces ... again!!!
  67.0 (  3.1/ 63.8/ 57.5)      3  Auditing
  43.3 ( 27.1/ 15.9/  8.9)     24  What is the work attire of an Oracle DBA?
  40.1 ( 13.3/ 26.8/ 17.3)     12  Data Dictionary: relative_fno question
  38.2 ( 18.5/ 19.6/  9.3)     16  Oracle 9.2 RAC on Red Hat AS 2.1 setup
                                   question
  35.7 ( 15.9/ 19.8/  9.9)     14  decreasing initial extent
  35.4 (  9.5/ 25.8/  8.3)      8  SELECT on table containing BLOB column
                                   raises error
  31.6 ( 14.6/ 17.0/  6.1)     13  Sizing SHARED_POOL_SIZE

These threads accounted for 31.3% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.818  (  7.2/   8.8)      5  ORA-12560 when testing connection in Net8
                               Assistant
0.730  (  3.0/   4.1)      5  "Oracle not available" and "Shared memory
                              realm does not exist".
0.721  (  1.5/   2.1)      6  binary_code
0.698  (  3.9/   5.6)      5  dbms_output in a PL/SQL  loop...
0.690  (  1.9/   2.7)      7  Oracle 8i + Xp
0.661  (  0.8/   1.2)      6  is there a newsgroup for oracle financials?
0.644  ( 17.3/  26.8)     12  Data Dictionary: relative_fno question
0.644  (  3.8/   5.9)      5  Oracle 8i Certified DBA Tests - Performance
                              Tuning
0.639  (  1.2/   1.9)      6  how to build an aggregating function
0.607  (  1.2/   1.9)      5  Oracle 8.0.5 DOWNLOAD

Bottom 10 Threads by OCR (minimum of five posts)

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

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

0.376  (  6.3 / 16.7)      8  recovering data
0.376  (  3.1 /  8.3)      8  Performance different between two users
0.361  (  3.4 /  9.3)      6  2nd Oracle Instance on Windows 2000
0.356  (  6.1 / 17.0)     13  Sizing SHARED_POOL_SIZE
0.333  (  2.2 /  6.6)      6  oracle equiv. of SQLServer DMO?
0.331  (  4.5 / 13.7)      9  Database won't mount, but no errors reported
                              ???
0.320  (  8.3 / 25.8)      8  SELECT on table containing BLOB column raises
                              error
0.316  (  1.4 /  4.5)      5  unable to install oracle 9.2.0.1 Java problem
                              on FreeBSD 4.7
0.288  (  3.2 / 11.1)      6  Setting for default column width?
0.193  (  2.8 / 14.4)      9  Statistics for comp.databases.oracle.server -
                              WE 12/1/2003

50 threads (25%) had at least five posts.

Top 10 Targets for Crossposts

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

      25  comp.databases.oracle.tools
      24  comp.databases.oracle.misc
       8  comp.databases.oracle.marketplace
       8  comp.databases.oracle
       6  comp.lang.java.programmer
       6  comp.security.ssh
       6  comp.terminals
       6  comp.protocols.kermit.misc
       5  comp.lang.visual.basic
       5  microsoft.public.dotnet.languages.csharp

Top 10 Crossposters

Groups Address
-------- -------

      15  Thomas G. Marshall
       9  Roger Redford
       4  GBR
       4  DA Morgan
       4  Sasa Golub
       4  Niall Litchfield
       4  Howard J. Rogers
       4  Grant Wagner
       3  Andreas Wessner
       3  Christopher.Jones

Received on Sun Jan 19 2003 - 22:22:32 CST

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