Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 13 Apr 2003 18:30:12 GMT
Message-ID: <BABEFAC2.102AF%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 06 Apr 2003 18:22:44 GMT and ending at 13 Apr 2003 18:02: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: 241
Articles: 791 (118 with cutlined signatures) Threads: 172
Volume generated: 1851.1 kb

headers: 883.9 kb (13,872 lines)
bodies: 957.3 kb (28,818 lines)
original: 527.8 kb (17,013 lines)
signatures: 9.2 kb (367 lines)

Original Content Rating: 0.551

Averages

Posts per poster: 3.3

    median: 2 posts
    mode: 1 post - 120 posters
    s: 5.2 posts
Posts per thread: 4.6

    median: 3.0 posts
    mode: 1 post - 52 threads
    s: 11.1 posts
Message size: 2396.4 bytes

header: 1144.2 bytes (17.5 lines)
body: 1239.3 bytes (36.4 lines)
original: 683.3 bytes (21.5 lines)
signature: 11.9 bytes (0.5 lines)

Top 10 Threads by Number of Posts

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

   48 [ANNOUNCE] Senora: a replacement for sqlplus    29 java stored procedures fast, but slow when called as SQL function    24 Convert code from SQL Server 2000 to SQL Plus for Oracle    23 And the correct answer is?
   21 Schema Placement for Purchased Apps    21 Reorganizing the DB.. the tricky way    20 CPU waiting for... what? (mistery)    18 Career move - Oracle from Sybase
   15 Finding full-table scans?
   14 Rollback Segments Question

These threads accounted for 29.5% of all articles.

Top 10 Threads by Volume

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

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

 109.8 ( 62.1/ 47.1/ 22.8)     48  [ANNOUNCE] Senora: a replacement for
                                   sqlplus
  74.5 ( 35.5/ 38.0/ 20.6)     29  java stored procedures fast, but slow
                                   when called as SQL function
  57.3 ( 24.3/ 32.3/ 16.7)     20  CPU waiting for... what? (mistery)
  56.0 ( 28.1/ 27.5/ 11.0)     24  Convert code from SQL Server 2000 to SQL
                                   Plus for Oracle
  55.7 ( 25.1/ 30.4/ 17.3)     21  Reorganizing the DB.. the tricky way
  52.4 ( 27.4/ 25.0/  8.0)     23  And the correct answer is?
  52.0 ( 26.5/ 25.5/ 15.1)     21  Schema Placement for Purchased Apps
  49.4 ( 14.9/ 33.5/ 12.6)     14  Rollback Segments Question
  46.9 ( 15.2/ 31.7/ 13.7)     14  Query tuning
  44.5 ( 18.6/ 25.8/ 14.9)     15  Finding full-table scans?

These threads accounted for 32.3% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.932  (  2.5/   2.6)      5  OS, file system  information in Oracle
0.895  (  4.2/   4.7)      7  shared pool size question
0.777  (  0.7/   0.8)      7  ORACLE RAC
0.719  (  2.8/   3.9)      5  TWO_TASK
0.716  ( 16.1/  22.4)     13  Export / Import from 8i to 9i and locally
                              managed tablespace
0.708  (  2.0/   2.8)      5  determine log space used before a switch ?
0.688  (  8.3/  12.0)     18  Career move - Oracle from Sybase
0.685  (  7.8/  11.4)      9  Multiple sessions bound to one background
                              process in dedicated server
0.668  (  1.7/   2.6)      5  PL/SQL Execute Immediate
0.615  (  4.2/   6.9)      5  Table and Field Name Capitalization

Top 10 Targets for Crossposts

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

      55  comp.databases.oracle.tools
      35  comp.databases.oracle.misc
      19  comp.arch.storage
      17  comp.unix.solaris
       7  comp.databases.theory
       3  comp.databases.oracle.marketplace
       3  de.alt.comp.sap-r3
       3  comp.databases.ms-sqlserver
       3  comp.database.oracle
       3  misc.jobs.resumes

Received on Sun Apr 13 2003 - 13:30:12 CDT

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