Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 13 Jan 2003 01:30:58 GMT
Message-ID: <BA4756AA.59E5%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 06 Jan 2003 02:00:03 GMT and ending at 13 Jan 2003 00:45:27 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: 269
Articles: 756 (54 with cutlined signatures) Threads: 181
Volume generated: 2125.5 kb

headers: 827.3 kb (13,339 lines)
bodies: 1291.6 kb (37,086 lines)
original: 574.6 kb (18,141 lines)
signatures: 5.9 kb (182 lines)

Original Content Rating: 0.445

Averages

Posts per poster: 2.8

    median: 1 post
    mode: 1 post - 151 posters
    s: 5.4 posts
Posts per thread: 4.2

    median: 3 posts
    mode: 1 post - 45 threads
    s: 5.1 posts
Message size: 2879.0 bytes

header: 1120.5 bytes (17.6 lines)
body: 1749.5 bytes (49.1 lines)
original: 778.3 bytes (24.0 lines)
signature: 8.0 bytes (0.2 lines)

Top 10 Posters by Volume

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

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

 227.6 ( 75.4/152.1/ 23.5)     68  DA Morgan
  97.0 (  3.2/ 93.9/ 73.1)      3  Nagarajan
  68.0 ( 38.7/ 29.3/ 15.5)     25  Karsten Farrell
  60.7 (  2.1/ 58.7/  1.0)      2  dias
  59.4 ( 15.7/ 43.7/ 10.7)     15  Jim Kennedy
  54.5 ( 15.3/ 39.2/ 18.6)     13  Howard J. Rogers
  48.7 ( 11.1/ 35.6/ 16.8)      9  timx_at_spamto.devnul.com
  41.4 ( 14.5/ 26.9/ 17.5)     14  Jonathan Lewis
  39.7 ( 18.6/ 20.2/ 10.5)     19  Noons
  36.4 (  9.9/ 26.5/  6.2)      9  servant

These posters accounted for 34.5% of the total volume.

Top 10 Posters by OCR (minimum of five posts)

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

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

1.000  (  1.7 /  1.7)      5  srivenu
0.990  ( 11.8 / 11.9)     10  Norman Dunbar
0.821  (  3.5 /  4.3)      5  ~MINOLTA a303si~
0.747  (  4.2 /  5.7)      6  Niall Litchfield
0.715  (  9.9 / 13.9)     12  Dusan Bolek
0.681  (  4.6 /  6.7)      8  100.17706_at_germanynet.de
0.672  (  2.5 /  3.7)      8  Galen Boyer
0.663  (  5.1 /  7.7)      5  FC
0.649  ( 17.5 / 26.9)     14  Jonathan Lewis
0.591  (  5.1 /  8.6)      5  Sean M

Bottom 10 Posters by OCR (minimum of five posts)

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

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

0.381  (  7.4 / 19.5)     13  Richard Foote
0.335  (  2.6 /  7.8)      7  David Sharples
0.304  (  3.1 / 10.1)      7  johng_at_mm.nospam.com
0.289  (  1.8 /  6.1)      5  Pete Sharman
0.266  (  2.0 /  7.5)      6  Detlef Jockheck
0.246  ( 10.7 / 43.7)     15  Jim Kennedy
0.234  (  6.2 / 26.5)      9  servant
0.228  (  5.0 / 21.9)      9  Alex Filonov
0.190  (  1.7 /  8.9)      5  Peter van Rijn
0.154  ( 23.5 /152.1)     68  DA Morgan

35 posters (13%) had at least five posts.

Top 10 Threads by Number of Posts

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

   37 Comparison of Java, C# for development on Windows and future for them    29 9i streams vs triggers
   19 Oracle stored procedures vs Running from a flat .sql file    19 Locally Managed Tablespaces ... again!!!    18 Oracle and Java. Does Oracle know something some of us don't?    17 using rman
   15 What do these terms mean?
   13 Install Oracle817 on linux (suse72,redhat80)    12 Performance issue while loading large amount of data    12 dbms_jobs versus cron

These threads accounted for 25.3% of all articles.

Top 10 Threads by Volume

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

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

 157.8 (  5.2/152.5/ 74.1)      5  Help: large "cache buffers lru chain",
                                   large performace degradation
 123.6 ( 50.1/ 72.8/ 36.5)     37  Comparison of Java, C# for development on
                                   Windows and future for  them
 123.0 ( 30.8/ 92.1/ 17.5)     29  9i streams vs triggers
  73.2 ( 22.5/ 50.0/ 26.8)     18  Oracle and Java. Does Oracle know
                                   something some of us don't?
  66.8 ( 23.8/ 42.6/ 13.7)     19  Oracle stored procedures vs Running from
                                   a flat .sql file
  50.1 ( 21.3/ 28.7/ 16.9)     19  Locally Managed Tablespaces ... again!!!
  48.9 ( 19.5/ 29.3/ 14.4)     17  using rman
  41.2 (  7.6/ 33.5/ 23.9)      7  Temporary tablespace near 100% full, smon
                                   is not freeing up, Oracle 7.3.4.5  ---->
                                   URGENT
  38.3 ( 11.0/ 27.2/  5.9)     10  Intercepting Oracle traffic
  36.3 (  5.1/ 31.2/  5.2)      4  Why SAP is doing well when Oracle is not

These threads accounted for 35.7% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.809  (  2.3/   2.8)      5  Can i use command mode to install Oracle?
0.718  (  7.9/  10.9)     10  Unable to extend temp on non temp tablespace
0.714  ( 23.9/  33.5)      7  Temporary tablespace near 100% full, smon is
                              not freeing up, Oracle 7.3.4.5  ----> URGENT
0.696  (  4.9/   7.0)      5  Guidelines for using Oracle 9i Object
                              Relational Features
0.682  (  1.4/   2.1)      5  8i client for W2k
0.652  (  2.5/   3.9)      5  Why it doesn't start ?
0.649  (  3.4/   5.2)      7  autocommit ON but no commits visible in
                              v$sqlarea
0.632  (  4.4/   6.9)      7  archivelog or not
0.609  (  2.7/   4.4)      5  basic oracle questions.
0.607  (  2.1/   3.4)      5  Connecting to Oracle 8.0.4 Database using
                              8.1.7 client

Bottom 10 Threads by OCR (minimum of five posts)

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

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

0.325  (  1.7 /  5.3)      8  Accessing the Seed databse
0.322  ( 13.7 / 42.6)     19  Oracle stored procedures vs Running from a
                              flat .sql file
0.317  (  1.7 /  5.3)      6  Can't run external procedure
0.304  (  2.4 /  8.0)      5  ORA-01092
0.292  (  4.3 / 14.6)      9  How to do this as a singleton select?
0.272  (  1.7 /  6.1)      5  Question to oracle products newest version?
0.253  (  2.9 / 11.3)      8  Peferred Credentials on OEM
0.218  (  2.2 /  9.9)      7  CLUSTER TABLES
0.217  (  5.9 / 27.2)     10  Intercepting Oracle traffic
0.190  ( 17.5 / 92.1)     29  9i streams vs triggers

56 threads (30%) had at least five posts.

Top 10 Targets for Crossposts

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

      45  comp.lang.visual.basic
      42  comp.databases.oracle.misc
      41  microsoft.public.dotnet.languages.csharp
      41  comp.lang.java.programmer
      41  comp.lang.java.developer
      19  comp.databases.oracle.tools
       7  comp.databases.oracle
       6  comp.databases.oracle.marketplace
       5  comp.databases.olap
       5  microsoft.public.sqlserver.datawarehouse

Top 10 Crossposters

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

      24  kim bruning
      24  Chad Myers
      13  DA Morgan
      12  Ingo Pakleppa
      12  Mark Thornton
      12  Karsten Farrell
       8  A Bag Of Memes
       8  James
       8  Tim Ward
       8  Frans Bouma

Received on Sun Jan 12 2003 - 19:30:58 CST

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