Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 10 Feb 2003 00:08:02 GMT
Message-ID: <BA6C2D5E.A259%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 03 Feb 2003 02:05:33 GMT and ending at 09 Feb 2003 22:09:16 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: 209
Articles: 631 (63 with cutlined signatures) Threads: 160
Volume generated: 1531.0 kb

headers: 687.7 kb (10,796 lines)
bodies: 837.3 kb (26,494 lines)
original: 426.5 kb (14,328 lines)
signatures: 5.3 kb (189 lines)

Original Content Rating: 0.509

Averages

Posts per poster: 3.0

    median: 1 post
    mode: 1 post - 109 posters
    s: 5.2 posts
Posts per thread: 3.9

    median: 3.0 posts
    mode: 1 post - 43 threads
    s: 7.4 posts
Message size: 2484.5 bytes

header: 1116.0 bytes (17.1 lines)
body: 1358.8 bytes (42.0 lines)
original: 692.1 bytes (22.7 lines)
signature: 8.6 bytes (0.3 lines)

Top 10 Threads by Number of Posts

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

   31 LMT and DMT
   29 index rebuilding...
   14 database connectivity/tnsping problem    12 Bug or Misunderstanding ? Delete...Returning into does not work as

       expected
   12 PL/SQL Package Execution Privileges    12 PL/SQL problem
   11 Problem with granting object permissions to a role    11 Should I use an /*+ append */ hint here???    11 Oracle 8i Error Messages
   11 sqlldr

These threads accounted for 24.4% of all articles.

Top 10 Threads by Volume

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

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

 109.0 ( 46.6/ 61.7/ 26.6)     29  index rebuilding...
  88.4 ( 44.2/ 44.2/ 24.7)     31  LMT and DMT
  58.0 ( 15.6/ 42.4/ 10.9)     14  database connectivity/tnsping problem
  49.1 (  4.9/ 44.2/ 20.8)      5  "End of TNS Data Channel" with Oracle
                                    Text problem
  32.2 ( 11.1/ 21.1/  6.4)     10  Rename an Oracle 91 database
  31.5 ( 11.5/ 20.0/ 10.2)     11  Should I use an /*+ append */ hint
                                   here???
  30.4 (  9.9/ 20.5/ 11.4)     10  Oracle archive logging over a Windows NT
                                   share - does it work?
  29.0 ( 10.3/ 18.7/  9.6)      9  Total oracle newbie
  28.3 ( 10.7/ 17.4/  9.8)     10  Looking for Statspack documentation
  26.6 ( 12.3/ 14.2/  8.3)     12  PL/SQL Package Execution Privileges

These threads accounted for 31.5% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.697  (  2.5/   3.6)      5  Looking for Security book
0.609  (  1.9/   3.1)      5  Privileges
0.602  (  2.0/   3.3)      6  Move Table to another tablespace?
0.600  (  5.6/   9.3)      9  A bit of Linux advice yet again??
0.585  (  3.1/   5.3)      8  Backup question
0.583  (  8.3/  14.2)     12  PL/SQL Package Execution Privileges
0.564  (  9.8/  17.4)     10  Looking for Statspack documentation
0.560  ( 24.7/  44.2)     31  LMT and DMT
0.555  ( 11.4/  20.5)     10  Oracle archive logging over a Windows NT share
                              - does it work?
0.535  (  2.7/   5.0)      5  French characters

Top 10 Targets for Crossposts

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

      30  comp.databases.oracle.misc
      13  comp.databases.oracle
       5  comp.databases.oracle.tools
       4  comp.lang.java.databases
       4  comp.unix.solaris
       2  forums.software.oracle
       2  comp.databases.ms-sqlserver
       2  comp.lang.java.corba
       2  comp.database.oracle
       2  comp.lang.java.beans

Last one for a few weeks - I'm off on vacation :-) Received on Sun Feb 09 2003 - 18:08:02 CST

Statistics for comp.databases.oracle.server - WE 2/9/2003