Re: Statistics for comp.databases.oracle.server - WE 19/1/2003

Mark Townsend wrote:

> Following is a summary of articles spanning a 7 day period,
> beginning at 13 Jan 2003 04:20:22 GMT and ending at
> 20 Jan 2003 03:04:32 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: 266
> Articles: 773 (51 with cutlined signatures)
> Threads: 197
> Volume generated: 2022.5 kb
> - headers: 859.9 kb (13,558 lines)
> - bodies: 1157.6 kb (34,507 lines)
> - original: 629.1 kb (19,791 lines)
> - signatures: 4.2 kb (129 lines)
>
> Original Content Rating: 0.543
>
> Averages
> ========
>
> Posts per poster: 2.9
> median: 1.0 post
> mode: 1 post - 151 posters
> s: 6.1 posts
> Posts per thread: 3.9
> median: 3 posts
> mode: 1 post - 51 threads
> s: 4.4 posts
> Message size: 2679.3 bytes
> - header: 1139.1 bytes (17.5 lines)
> - body: 1533.5 bytes (44.6 lines)
> - original: 833.4 bytes (25.6 lines)
> - signature: 5.6 bytes (0.2 lines)
>
> Top 10 Posters by Number of Posts
> =================================
>
> (kb) (kb) (kb) (kb)
> Posts Volume ( hdr/ body/ orig) Address
> ----- -------------------------- -------
>
> 66 274.9 ( 84.1/190.8/ 88.1) Howard J. Rogers
> 57 156.0 ( 64.1/ 91.9/ 18.3) DA Morgan
> 28 72.9 ( 36.8/ 36.1/ 23.3) Niall Litchfield
> 23 45.0 ( 24.6/ 20.4/ 8.4) Paul Brewer
> 22 54.1 ( 33.0/ 21.0/ 9.4) Karsten Farrell
> 15 25.1 ( 15.5/ 9.6/ 5.0) Sybrand
> 15 27.8 ( 14.8/ 13.0/ 4.4) Peter van Rijn
> 14 42.1 ( 15.4/ 26.1/ 18.7) Noons
> 14 56.9 ( 19.5/ 37.5/ 28.6) Richard Foote
> 12 27.1 ( 12.2/ 14.8/ 11.5) Billy Verreynne
>
> These posters accounted for 34.4% of all articles.
>
> Top 10 Posters by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Address
> -------------------------- ----- -------
>
> 274.9 ( 84.1/190.8/ 88.1) 66 Howard J. Rogers
> 156.0 ( 64.1/ 91.9/ 18.3) 57 DA Morgan
> 72.9 ( 36.8/ 36.1/ 23.3) 28 Niall Litchfield
> 60.8 ( 1.1/ 59.6/ 54.5) 1 Sergey Adamenko
> 56.9 ( 19.5/ 37.5/ 28.6) 14 Richard Foote
> 54.1 ( 33.0/ 21.0/ 9.4) 22 Karsten Farrell
> 45.0 ( 24.6/ 20.4/ 8.4) 23 Paul Brewer
> 42.1 ( 15.4/ 26.1/ 18.7) 14 Noons
> 34.3 ( 9.4/ 24.9/ 9.6) 8 Joel Garry
> 31.5 ( 11.2/ 20.3/ 9.2) 11 Jan Gelbrich
>
> These posters accounted for 41.0% of the total volume.
>
> Top 10 Posters by OCR (minimum of five posts)
> ==============================================
>
> (kb) (kb)
> OCR orig / body Posts Address
> ----- -------------- ----- -------
>
> 0.948 ( 9.1 / 9.6) 10 Norman Dunbar
> 0.774 ( 11.5 / 14.8) 12 Billy Verreynne
> 0.769 ( 13.7 / 17.9) 7 Jonathan Lewis
> 0.764 ( 28.6 / 37.5) 14 Richard Foote
> 0.746 ( 2.7 / 3.7) 8 Galen Boyer
> 0.716 ( 18.7 / 26.1) 14 Noons
> 0.682 ( 6.6 / 9.7) 8 Rauf Sarwar
> 0.644 ( 23.3 / 36.1) 28 Niall Litchfield
> 0.642 ( 3.4 / 5.3) 5 kenneth
> 0.615 ( 4.5 / 7.3) 5 Thomas Kyte
>
> Bottom 10 Posters by OCR (minimum of five posts)
> =================================================
>
> (kb) (kb)
> OCR orig / body Posts Address
> ----- -------------- ----- -------
>
> 0.447 ( 9.4 / 21.0) 22 Karsten Farrell
> 0.430 ( 3.4 / 7.8) 8 Ryan Gaffuri
> 0.410 ( 8.4 / 20.4) 23 Paul Brewer
> 0.395 ( 4.0 / 10.0) 5 timx
> 0.385 ( 9.6 / 24.9) 8 Joel Garry
> 0.342 ( 4.4 / 13.0) 15 Peter van Rijn
> 0.319 ( 6.4 / 20.0) 10 Jim Kennedy
> 0.303 ( 2.8 / 9.2) 8 Frank
> 0.268 ( 3.5 / 13.1) 10 JustAnotherDBA
> 0.199 ( 18.3 / 91.9) 57 DA Morgan
>
> 27 posters (10%) had at least five posts.
>
> Top 10 Threads by Number of Posts
> =================================
>
> Posts Subject
> ----- -------
>
> 26 Performance issue while loading large amount of data
> 24 What is the work attire of an Oracle DBA?
> 23 Locally Managed Tablespaces ... again!!!
> 20 Tech Comparison of Oracle versus MS Sqlserver 2000
> 16 Oracle 9.2 RAC on Red Hat AS 2.1 setup question
> 14 Benchmarks
> 14 decreasing initial extent
> 13 Sizing SHARED_POOL_SIZE
> 12 Strange behavior with SQLPLUS (Oracle)
> 12 Data Dictionary: relative_fno question
>
> These threads accounted for 22.5% of all articles.
>
> Top 10 Threads by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Subject
> -------------------------- ----- -------
>
> 158.0 ( 41.9/115.9/ 57.3) 26 Performance issue while loading large
> amount of data
> 94.6 ( 22.8/ 71.5/ 39.1) 20 Tech Comparison of Oracle versus MS
> Sqlserver 2000
> 89.5 ( 28.1/ 60.7/ 24.6) 23 Locally Managed Tablespaces ... again!!!
> 67.0 ( 3.1/ 63.8/ 57.5) 3 Auditing
> 43.3 ( 27.1/ 15.9/ 8.9) 24 What is the work attire of an Oracle DBA?
> 40.1 ( 13.3/ 26.8/ 17.3) 12 Data Dictionary: relative_fno question
> 38.2 ( 18.5/ 19.6/ 9.3) 16 Oracle 9.2 RAC on Red Hat AS 2.1 setup
> question
> 35.7 ( 15.9/ 19.8/ 9.9) 14 decreasing initial extent
> 35.4 ( 9.5/ 25.8/ 8.3) 8 SELECT on table containing BLOB column
> raises error
> 31.6 ( 14.6/ 17.0/ 6.1) 13 Sizing SHARED_POOL_SIZE
>
> These threads accounted for 31.3% of the total volume.
>
> Top 10 Threads by OCR (minimum of five posts)
> ==============================================
>
> (kb) (kb)
> OCR orig / body Posts Subject
> ----- -------------- ----- -------
>
> 0.818 ( 7.2/ 8.8) 5 ORA-12560 when testing connection in Net8
> Assistant
> 0.730 ( 3.0/ 4.1) 5 "Oracle not available" and "Shared memory
> realm does not exist".
> 0.721 ( 1.5/ 2.1) 6 binary_code
> 0.698 ( 3.9/ 5.6) 5 dbms_output in a PL/SQL loop...
> 0.690 ( 1.9/ 2.7) 7 Oracle 8i + Xp
> 0.661 ( 0.8/ 1.2) 6 is there a newsgroup for oracle financials?
> 0.644 ( 17.3/ 26.8) 12 Data Dictionary: relative_fno question
> 0.644 ( 3.8/ 5.9) 5 Oracle 8i Certified DBA Tests - Performance
> Tuning
> 0.639 ( 1.2/ 1.9) 6 how to build an aggregating function
> 0.607 ( 1.2/ 1.9) 5 Oracle 8.0.5 DOWNLOAD
>
> Bottom 10 Threads by OCR (minimum of five posts)
> =================================================
>
> (kb) (kb)
> OCR orig / body Posts Subject
> ----- -------------- ----- -------
>
> 0.376 ( 6.3 / 16.7) 8 recovering data
> 0.376 ( 3.1 / 8.3) 8 Performance different between two users
> 0.361 ( 3.4 / 9.3) 6 2nd Oracle Instance on Windows 2000
> 0.356 ( 6.1 / 17.0) 13 Sizing SHARED_POOL_SIZE
> 0.333 ( 2.2 / 6.6) 6 oracle equiv. of SQLServer DMO?
> 0.331 ( 4.5 / 13.7) 9 Database won't mount, but no errors reported
> ???
> 0.320 ( 8.3 / 25.8) 8 SELECT on table containing BLOB column raises
> error
> 0.316 ( 1.4 / 4.5) 5 unable to install oracle 9.2.0.1 Java problem
> on FreeBSD 4.7
> 0.288 ( 3.2 / 11.1) 6 Setting for default column width?
> 0.193 ( 2.8 / 14.4) 9 Statistics for comp.databases.oracle.server -
> WE 12/1/2003
>
> 50 threads (25%) had at least five posts.
>
> Top 10 Targets for Crossposts
> =============================
>
> Articles Newsgroup
> -------- ---------
>
> 25 comp.databases.oracle.tools
> 24 comp.databases.oracle.misc
> 8 comp.databases.oracle.marketplace
> 8 comp.databases.oracle
> 6 comp.lang.java.programmer
> 6 comp.security.ssh
> 6 comp.terminals
> 6 comp.protocols.kermit.misc
> 5 comp.lang.visual.basic
> 5 microsoft.public.dotnet.languages.csharp
>
> Top 10 Crossposters
> ===================
>
> Groups Address
> -------- -------
>
> 15 Thomas G. Marshall
> 9 Roger Redford
> 4 GBR
> 4 DA Morgan
> 4 Sasa Golub
> 4 Niall Litchfield
> 4 Howard J. Rogers
> 4 Grant Wagner
> 3 Andreas Wessner
> 3 Christopher.Jones

I'd say thank you but then it might be viewed as gratuitously jump pumping up my count.

Daniel Morgan Received on Sat Jan 18 2003 - 14:15:55 CST