Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 20 Apr 2003 23:38:23 GMT
Message-ID: <PbGoa.279131$OV.329283@rwcrnsc54>

Following is a summary of articles spanning a 7 day period, beginning at 14 Apr 2003 01:24:55 GMT and ending at 20 Apr 2003 22:31:44 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: 207
Articles: 584 (64 with cutlined signatures) Threads: 154

Volume generated: 1384.6 kb


     - headers:    648.6 kb (10,077 lines)

     - bodies:     730.3 kb (21,992 lines)

     - original:   396.2 kb (12,691 lines)

     - signatures: 5.1 kb (192 lines)


Original Content Rating: 0.543

Averages

Posts per poster: 2.8

     median: 2 posts
     mode:   1 post - 101 posters
     s:      4.2 posts
Posts per thread: 3.8
     median: 2.0 posts
     mode:   1 post - 44 threads
     s:      3.9 posts
Message size: 2427.8 bytes


     - header:     1137.3 bytes (17.3 lines)

     - body:       1280.6 bytes (37.7 lines)

     - original:   694.7 bytes (21.7 lines)

     - signature:  8.9 bytes (0.3 lines)

Top 10 Threads by Number of Posts

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

    26 Anyone recommend a good Unix Scripting book?     18 java stored procedures fast, but slow when called as SQL function     17 Heavens!
    16 Would you recommend having multiple instances on the same box?     14 Not meant to be flame bait, but...     13 How do you remove an Oracle service?     11 oraback.sh archive log issue
    11 describing instance
    10 Join Two Extremely Large Tables
    10 easiest way to backup&recover Oracle?

These threads accounted for 25.0% of all articles.

Top 10 Threads by Volume

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

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

   71.8 ( 27.5/ 42.8/ 28.0)     18  java stored procedures fast, but slow
                                    when called as SQL function
   66.8 ( 29.5/ 37.0/ 16.7)     26  Anyone recommend a good Unix
                                    Scripting book?
   49.0 ( 19.4/ 29.4/ 12.1)     17  Heavens!
   41.4 ( 15.9/ 25.0/ 16.8)     14  Not meant to be flame bait, but...
   37.6 ( 16.8/ 20.6/  6.6)     13  How do you remove an Oracle service?
   35.8 ( 17.4/ 18.1/  9.0)     16  Would you recommend having multiple
                                    instances on the same box?
   33.6 ( 13.3/ 20.1/ 11.3)     10  Granting table privileges
   32.6 ( 11.7/ 20.9/  9.8)     10  easiest way to backup&recover Oracle?
   30.9 ( 11.8/ 19.1/ 10.2)     10  Recommended hardware for 9i on Linux,
                                    at home
   28.7 ( 12.8/ 15.8/ 10.4)     10  What is the difference between oradim
                                    and startup?

These threads accounted for 30.9% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.983  (  5.0/   5.1)      5  OCI Internal error - Help!!!!!!!
0.774  (  8.1/  10.5)      7  An Oracle Auto Generated Id Issue
0.733  (  4.6/   6.3)      8  Maybe stupid question about exp/imp
0.711  (  0.9/   1.3)      5  Apologies
0.706  (  3.5/   4.9)      6  Can an IMPORT be stopped/interrupted?
0.694  (  0.5/   0.7)      5  Need a web based Oracle DBA tool
0.672  ( 16.8/  25.0)     14  Not meant to be flame bait, but...
0.655  ( 28.0/  42.8)     18  java stored procedures fast, but slow when
                               called as SQL function
0.655  ( 10.4/  15.8)     10  What is the difference between oradim and
                               startup?
0.644  (  7.9/  12.3)      6  What's the point of decreasing consistent
                               gets by using IOTs?

Top 10 Targets for Crossposts

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

       34  comp.databases.oracle.misc
       23  comp.databases.oracle.tools
        5  comp.databases.oracle
        4  comp.unix.solaris
        3  comp.databases.oracle.marketplace
        2  alt.solaris.x86
        2  comp.lang.javascript
        2  alt.comp.periphs.videocards.ati
        2  comp.sys.laptops
        1  alt.os.linux.redhat

Received on Sun Apr 20 2003 - 18:38:23 CDT

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