Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 06 Apr 2003 22:51:14 GMT
Message-ID: <BAB5FD72.F769%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 30 Mar 2003 23:19:26 GMT and ending at 06 Apr 2003 22:25:36 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: 217
Articles: 614 (60 with cutlined signatures) Threads: 156
Volume generated: 1525.7 kb

headers: 668.6 kb (10,807 lines)
bodies: 850.6 kb (24,662 lines)
original: 478.4 kb (14,543 lines)
signatures: 5.9 kb (212 lines)

Original Content Rating: 0.562

Averages

Posts per poster: 2.8

    median: 1 post
    mode: 1 post - 129 posters
    s: 7.5 posts
Posts per thread: 3.9

    median: 2.0 posts
    mode: 1 post - 49 threads
    s: 7.4 posts
Message size: 2544.5 bytes

header: 1115.1 bytes (17.6 lines)
body: 1418.7 bytes (40.2 lines)
original: 797.8 bytes (23.7 lines)
signature: 9.8 bytes (0.3 lines)

Top 10 Threads by Number of Posts

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

   58 Oracle: Naked King in database land?    57 And the correct answer is?
   19 Finding full-table scans?
   17 Reorganizing the DB.. the tricky way    17 Oracle database status web page
   14 Gain OCP 9i Without attending trainging courses?    11 Question about sizing log files
   10 need advice for partitioning in 8.1.7.2    10 Mike Warren
   10 Locking Question (nowait, UPDATE etc)

These threads accounted for 36.3% of all articles.

Top 10 Threads by Volume

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

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

 161.5 ( 64.1/ 96.8/ 43.6)     58  Oracle: Naked King in database land?
 160.6 ( 63.9/ 96.4/ 37.2)     57  And the correct answer is?
  52.8 (  1.0/ 51.8/ 36.0)      1  ora-4031 and state objects?
  50.7 (  1.0/ 49.6/ 45.7)      1  Make $$$$$$ GUARANTEED - Postal
                                   Lottery.doc 3 6864 bytes (1/1)
  47.2 ( 19.7/ 27.5/ 17.1)     17  Reorganizing the DB.. the tricky way
  45.1 ( 22.8/ 22.2/ 11.5)     19  Finding full-table scans?
  39.9 ( 19.7/ 20.1/  9.5)     17  Oracle database status web page
  31.6 ( 11.6/ 19.6/  7.3)     10  Locking Question (nowait, UPDATE etc)
  30.6 ( 15.2/ 15.3/  7.3)     14  Gain OCP 9i Without attending trainging
                                   courses?
  26.3 ( 11.8/ 14.4/  6.3)     11  Question about sizing log files

These threads accounted for 42.4% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.983  (  9.6/   9.7)      5  error creating database from template (
                              NT/9.0.1 to linux/9.2.0.1.0)
0.882  (  1.8/   2.0)      7  Oracle 8.1.7 on RedHat 8.0 - DB creating
                              problem
0.875  (  7.7/   8.8)      6  Fad of the month Java data access question.
0.780  (  2.0/   2.6)      5  different verison oracle's in same box
0.753  (  2.6/   3.5)      6  How to trace the oracle optimizer...
0.695  (  4.1/   5.9)      6  Directory Service
0.623  (  7.8/  12.6)      6  Recommended hardware for 9i on Linux, at home
0.621  ( 17.1/  27.5)     17  Reorganizing the DB.. the tricky way
0.616  (  5.4/   8.7)      5  How to perform a simple full database backup
0.606  (  3.2/   5.4)      5  ~~ FunWithData.com ~~

Bottom 10 Threads by OCR (minimum of five posts)

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

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

0.440  (  6.3 / 14.4)     11  Question about sizing log files
0.440  (  3.7 /  8.3)     10  need advice for partitioning in 8.1.7.2
0.440  (  3.3 /  7.4)      8  cluster removal
0.433  (  3.2 /  7.4)      7  CBO when one table has no stats
0.386  ( 37.2 / 96.4)     57  And the correct answer is?
0.373  (  7.3 / 19.6)     10  Locking Question (nowait, UPDATE etc)
0.353  (  4.2 / 11.8)      6  local managed ts (indizes)
0.326  (  2.0 /  6.2)      5  Expanded Oracle DBA Site
0.288  (  4.4 / 15.1)     10  Cloning problem.... any ideas?
0.230  (  2.6 / 11.3)      6  Oracle Text, PDF files

34 threads (21%) had at least five posts.

Top 10 Targets for Crossposts

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

      31  comp.databases.oracle.misc
      18  comp.databases.oracle.marketplace
       8  comp.lang.java.databases
       8  comp.lang.java.programmer
       7  comp.databases.oracle.tools
       6  comp.database.oracle
       4  comp.databases.oracle
       3  comp.unix.solaris
       3  comp.sys.laptops
       3  comp.lang.javascript

Received on Sun Apr 06 2003 - 17:51:14 CDT

Statistics for comp.databases.oracle.server - WE 4/6/2003