Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 09 Mar 2003 20:58:15 GMT
Message-ID: <BA90EAE5.BFF5%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 02 Mar 2003 20:45:34 GMT and ending at 09 Mar 2003 20:29:21 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: 229
Articles: 930 (74 with cutlined signatures) Threads: 180

Volume generated: 2163.0 kb


    - headers:    1032.7 kb (16,459 lines)

    - bodies:     1121.6 kb (36,585 lines)

original: 541.2 kb (18,953 lines)
signatures: 7.8 kb (311 lines)

Original Content Rating: 0.483

Averages

Posts per poster: 4.1

    median: 2 posts
    mode: 1 post - 92 posters
    s: 8.4 posts
Posts per thread: 5.2

    median: 4.0 posts
    mode: 1 post - 34 threads
    s: 5.7 posts
Message size: 2381.6 bytes

header: 1137.1 bytes (17.7 lines)
body: 1235.0 bytes (39.3 lines)
original: 595.9 bytes (20.4 lines)
signature: 8.6 bytes (0.3 lines)

Top 10 Threads by Number of Posts

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

   35 Oracle vs. MS SQL Server
   27 Use of TEMP tablespace other than sorting    26 how synchronous is Oracle?
   23 performance problems after increasing redolog size    23 I would like to know how experts look at this problem    22 SQL Statement Shutdown
   19 Access to a Oracle DB over a Braoadband connection    19 9i install - 2000 Server
   15 startup nomount
   13 sysdba privileges and shutdown

These threads accounted for 23.9% of all articles.

Top 10 Threads by Volume

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

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

  84.4 ( 26.1/ 58.2/ 22.4)     22  SQL Statement Shutdown
  83.8 ( 32.9/ 50.8/ 24.5)     27  Use of TEMP tablespace other than sorting
  71.5 ( 39.0/ 32.4/ 12.2)     35  Oracle vs. MS SQL Server
  70.0 ( 26.6/ 43.3/ 17.4)     23  I would like to know how experts look at
                                   this problem
  69.6 ( 18.9/ 50.7/ 15.0)     15  startup nomount
  63.0 ( 27.4/ 35.6/ 24.4)     23  performance problems after increasing
                                   redolog size
  51.2 ( 29.1/ 21.9/ 10.4)     26  how synchronous is Oracle?
  43.3 ( 10.9/ 32.4/  6.4)     10  index on upper case
  38.3 ( 14.0/ 24.2/ 13.8)     13  30GB table: Hardware performance issue ?
  37.3 ( 15.2/ 22.1/  8.3)     13  cant connect to database after developer
                                   suite install

These threads accounted for 28.3% of the total volume.

Top 10 Targets for Crossposts

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

      32  comp.databases.oracle.misc
      26  comp.databases.oracle.tools
      10  comp.os.vms
       6  microsoft.public.win2000.advanced_server
       5  comp.databases
       5  comp.infosystems.www.databases
       4  comp.databases.oracle
       2  comp.unix.aix
       1  rec.autos.makers.ford.mustang
       1  comp.databases.ibm-db2

Received on Sun Mar 09 2003 - 14:58:15 CST

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