Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 01 Sep 2003 00:48:35 GMT
Message-ID: <DHw4b.320495$uu5.65962@sccrnsc04>

Following is a summary of articles spanning a 7 day period, beginning at 25 Aug 2003 02:48:37 GMT and ending at 01 Sep 2003 00:27:40 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: 198
Articles: 564 (79 with cutlined signatures) Threads: 144

Volume generated: 1273.5 kb


     - headers:    602.0 kb (9,950 lines)

     - bodies:     648.4 kb (21,049 lines)

     - original:   336.0 kb (11,694 lines)

     - signatures: 22.5 kb (790 lines)


Original Content Rating: 0.518

Averages

Posts per poster: 2.8

     median: 1.0 post
     mode:   1 post - 102 posters
     s:      5.1 posts
Posts per thread: 3.9
     median: 3.0 posts
     mode:   1 post - 38 threads
     s:      4.7 posts
Message size: 2312.2 bytes


     - header:     1093.0 bytes (17.6 lines)

     - body:       1177.3 bytes (37.3 lines)

     - original:   610.0 bytes (20.7 lines)

     - signature:  40.9 bytes (1.4 lines)

Top 10 Threads by Number of Posts

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

    32 Why so many Gay Oracle people?
    15 drop user hangs
    14 Info on Migrating Sybase to Oracle     14 Query for Top 10 Most "Expensive" Queries     13 Problem witch create database
    12 URGENT: Is there any way to change the INTERNAL password?     10 Temporary tables in memory
    10 Oracle Create User Problem

     9  how to efficiently delete records from large tables?
     9  performance tuning questions: replace IN (values) by JOIN

These threads accounted for 24.5% of all articles.

Top 10 Threads by Volume

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

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

   65.8 ( 16.9/ 47.7/ 31.8)     15  drop user hangs
   61.1 ( 34.1/ 26.3/ 12.4)     32  Why so many Gay Oracle people?
   50.5 (  7.8/ 42.6/ 15.0)      7  30454.1- Unix script that automates
                                    warm backup of all available
                                    tablespaces ??
   38.3 ( 10.6/ 27.7/ 15.8)      9  performance tuning questions: replace
                                    IN (values) by JOIN
   32.5 ( 15.5/ 13.4/  7.2)     14  Info on Migrating Sybase to Oracle
   28.5 ( 10.1/ 13.7/  6.8)     10  Temporary tables in memory
   27.0 ( 15.7/ 10.9/  6.5)     14  Query for Top 10 Most "Expensive"
                                    Queries
   26.9 ( 13.9/ 13.0/  4.1)     12  URGENT:  Is there any way to change
                                    the INTERNAL password?
   25.9 ( 14.0/ 11.8/  5.0)     13  Problem witch create database
   23.8 (  9.8/ 13.7/  5.5)      9  8.1.7 and 9.2 pl/sql handling

These threads accounted for 29.9% of the total volume.

Top 10 Targets for Crossposts

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

       14  comp.databases.oracle.misc
        8  microsoft.public.sqlserver.server
        8  comp.databases.object
        8  comp.databases
        4  comp.database.oracle
        2  comp.databases.oracle.tools
        1  comp.databases.oracle
        1  comp.databases.orace.misc

Received on Sun Aug 31 2003 - 19:48:35 CDT

Statistics for comp.databases.oracle.server - WE 08/31/2003