Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 16 Mar 2003 22:32:44 GMT
Message-ID: <BA9A3B89.CB56%markbtownsend@attbi.com>

Following is a summary of articles spanning a 7 day period, beginning at 09 Mar 2003 22:59:40 GMT and ending at 16 Mar 2003 22:17:42 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: 231
Articles: 772 (69 with cutlined signatures) Threads: 183
Volume generated: 1800.7 kb

headers: 847.6 kb (13,309 lines)
bodies: 946.4 kb (28,935 lines)
original: 520.7 kb (16,796 lines)
signatures: 5.9 kb (215 lines)

Original Content Rating: 0.550

Averages

Posts per poster: 3.3

    median: 2 posts
    mode: 1 post - 106 posters
    s: 6.2 posts
Posts per thread: 4.2

    median: 3 posts
    mode: 1 post - 49 threads
    s: 8.3 posts
Message size: 2388.4 bytes

header: 1124.2 bytes (17.2 lines)
body: 1255.4 bytes (37.5 lines)
original: 690.6 bytes (21.8 lines)
signature: 7.8 bytes (0.3 lines)

Top 10 Threads by Number of Posts

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

   30 How to start a Stored Procedure directly from Unix shell skript ?    25 Oracle2PostgreSQL Migration with PL/pgSQL    24 ORA-12560 on NT
   24 Archive Logs
   23 A proper FAQ - Wish fulfillment
   21 INITRANS and MAXTRANS are confusing me?    16 Take care, there a nasty out there    15 Oracle on a Dell/Linux platform - any opinions?    14 Best way to move data beween servers    14 Possible Oracle Bug, Oracle Claims No

These threads accounted for 26.7% of all articles.

Top 10 Threads by Volume

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

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

  76.4 ( 27.0/ 48.7/ 25.3)     23  A proper FAQ - Wish fulfillment
  68.6 ( 33.9/ 34.5/ 17.4)     30  How to start a Stored Procedure directly
                                   from Unix shell skript ?
  67.7 ( 24.5/ 42.9/ 20.5)     21  INITRANS and MAXTRANS are confusing me?
  61.7 ( 32.8/ 28.2/ 13.2)     25  Oracle2PostgreSQL Migration with PL/pgSQL
  60.7 ( 29.3/ 31.4/ 13.7)     24  ORA-12560 on NT
  44.6 ( 25.5/ 19.0/ 11.5)     24  Archive Logs
  42.5 (  7.0/ 35.5/ 30.2)      6  Oracle versus MS Sqlserver 2000:
                                   Technical Comparison of the Features in
                                   the two databases
  35.1 ( 18.0/ 17.0/  5.6)     15  Oracle on a Dell/Linux platform - any
                                   opinions?
  33.7 ( 17.8/ 15.9/  9.3)     14  Possible Oracle Bug, Oracle Claims No
  31.9 ( 11.1/ 20.8/ 12.9)     10  DBA requires basic SQL assistance please
                                   (LONG POST)

These threads accounted for 29.0% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.956  ( 10.5/  11.0)      5  They wanna know why it takes so long .....
0.866  (  2.5/   2.9)      7  What is The different between PL/SQL and
                              SQL*Plus?
0.852  ( 30.2/  35.5)      6  Oracle versus MS Sqlserver 2000: Technical
                              Comparison of the Features in the two
                              databases
0.730  (  4.3/   5.9)      5  Option NOLOGGING  for indexes
0.673  (  7.2/  10.7)      8  ORA-00933: SQL command not properly ended
0.658  (  5.2/   7.9)     10  Determine if 32-bit or 64-bit installed
0.656  (  2.2/   3.3)      6  move datefiles (almost) online
0.640  (  7.2/  11.2)     11  Fine-Grained Auditing OCP Question
0.629  (  3.8/   6.1)      6  Restriction on sqlplus access
0.618  ( 12.9/  20.8)     10  DBA requires basic SQL assistance please (LONG
                              POST)

Top 10 Targets for Crossposts

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

      39  comp.databases.oracle.misc
      35  comp.databases.oracle.tools
      21  comp.infosystems.www.databases
      20  comp.databases
       3  comp.databases.oracle.marketplace
       3  comp.os.vms
       1  comp.text.xml

Received on Sun Mar 16 2003 - 16:32:44 CST

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