Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Statistics for comp.databases.oracle.server - WE 11/22/2003

Re: Statistics for comp.databases.oracle.server - WE 11/22/2003

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 24 Nov 2003 09:37:12 -0000
Message-ID: <3fc1d148$0$13352$ed9e5944@reading.news.pipex.net>


I'm twice as sad as the rest of you....

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:3fc14975$0$13591$afc38c87_at_news.optusnet.com.au...

> Hi Mark:
>
> Any reason why Niall gets two separate entries?
>
> And whatever happened to top posts by original content??
>
> Regards
> HJR
>
>
>
> "Mark Townsend" <markbtownsend_at_attbi.com> wrote in message
> news:WFbwb.287193$Tr4.896223_at_attbi_s03...
> > Following is a summary of articles spanning a 7 day period,
> > beginning at 16 Nov 2003 23:58:22 GMT and ending at
> > 23 Nov 2003 23:31:22 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: 173
> > Articles: 524 (107 with cutlined signatures)
> > Threads: 113
> > Volume generated: 1287.3 kb
> > - headers: 573.3 kb (9,409 lines)
> > - bodies: 685.5 kb (21,754 lines)
> > - original: 310.4 kb (10,414 lines)
> > - signatures: 28.0 kb (910 lines)
> >
> > Original Content Rating: 0.453
> >
> > Averages
> > ========
> >
> > Posts per poster: 3.0
> > median: 1 post
> > mode: 1 post - 88 posters
> > s: 4.4 posts
> > Posts per thread: 4.6
> > median: 3 posts
> > mode: 1 post - 24 threads
> > s: 5.1 posts
> > Message size: 2515.6 bytes
> > - header: 1120.3 bytes (18.0 lines)
> > - body: 1339.6 bytes (41.5 lines)
> > - original: 606.6 bytes (19.9 lines)
> > - signature: 54.7 bytes (1.7 lines)
> >
> > Top 10 Posters by Number of Posts
> > =================================
> >
> > (kb) (kb) (kb) (kb)
> > Posts Volume ( hdr/ body/ orig) Address
> > ----- -------------------------- -------
> >
> > 40 97.0 ( 51.1/ 37.6/ 10.9) Daniel Morgan
> > 20 69.2 ( 24.4/ 44.8/ 25.4) Howard J. Rogers
> > 19 38.8 ( 19.5/ 19.3/ 7.9) Sybrand Bakker
> > 17 55.6 ( 22.7/ 32.5/ 3.3) fbortel
> > 15 40.6 ( 15.5/ 25.1/ 8.2) Joel Garry
> > 11 41.0 ( 15.9/ 25.0/ 24.8) mcstock
> > 11 28.9 ( 13.8/ 12.9/ 6.8) Niall Litchfield
> > 10 26.3 ( 9.7/ 16.6/ 5.7) Paul Drake
> > 10 31.1 ( 13.2/ 17.8/ 6.9) Niall Litchfield
> > 10 25.8 ( 12.2/ 13.6/ 7.8) Richard Foote
> >
> > These posters accounted for 31.1% of all articles.
> >
> > Top 10 Posters by Volume
> > ========================
> >
> > (kb) (kb) (kb) (kb)
> > Volume ( hdr/ body/ orig) Posts Address
> > -------------------------- ----- -------
> >
> > 97.0 ( 51.1/ 37.6/ 10.9) 40 Daniel Morgan
> > 69.2 ( 24.4/ 44.8/ 25.4) 20 Howard J. Rogers
> > 55.6 ( 22.7/ 32.5/ 3.3) 17 fbortel
> > 41.0 ( 15.9/ 25.0/ 24.8) 11 mcstock
> > 40.6 ( 15.5/ 25.1/ 8.2) 15 Joel Garry
> > 38.8 ( 19.5/ 19.3/ 7.9) 19 Sybrand Bakker
> > 31.1 ( 13.2/ 17.8/ 6.9) 10 Niall Litchfield
> > 28.9 ( 13.8/ 12.9/ 6.8) 11 Niall Litchfield
> > 26.9 ( 8.7/ 18.1/ 11.8) 8 Jonathan Lewis
> > 26.3 ( 9.7/ 16.6/ 5.7) 10 Paul Drake
> >
> > These posters accounted for 35.4% of the total volume.
> >
> > Top 10 Threads by Number of Posts
> > =================================
> >
> > Posts Subject
> > ----- -------
> >
> > 40 db cache size in oracle 9ir2
> > 21 Another Oracle "Myth"?
> > 20 Myth revisited ...
> > 17 DBMS_REPAIR, 8.1.7
> > 16 Patch Set for 8.1.7.4 failed to upgrade
> > 14 "Nologging"-option tablespace and tables
> > 14 Index not used therefore rebuild the thing ...
> > 12 -- insert instead of an update
> > 12 Synchronizing 2 tables in same database -how ?
> > 11 dbms_stats set_table_stats, set_index_stats and
set_columns_stats
> >
> > These threads accounted for 33.8% of all articles.
> >
> > Top 10 Threads by Volume
> > ========================
> >
> > (kb) (kb) (kb) (kb)
> > Volume ( hdr/ body/ orig) Posts Subject
> > -------------------------- ----- -------
> >
> > 105.0 ( 53.3/ 49.9/ 27.0) 40 db cache size in oracle 9ir2
> > 56.8 ( 17.2/ 39.3/ 5.7) 16 Patch Set for 8.1.7.4 failed to
> > upgrade
> > 53.3 ( 20.9/ 31.1/ 16.6) 20 Myth revisited ...
> > 50.3 ( 22.2/ 27.4/ 7.8) 17 DBMS_REPAIR, 8.1.7
> > 49.8 ( 22.9/ 25.5/ 14.9) 21 Another Oracle "Myth"?
> > 44.6 ( 17.4/ 26.7/ 8.7) 14 "Nologging"-option tablespace and
> > tables
> > 42.2 ( 12.0/ 29.0/ 16.3) 10 How to test to VARCHAR2's for
> > equality EFFICIENTLY ?
> > 39.6 ( 16.8/ 21.9/ 7.9) 14 Index not used therefore rebuild the
> > thing ...
> > 36.6 ( 12.8/ 23.7/ 7.9) 12 -- insert instead of an update
> > 28.9 ( 11.2/ 17.6/ 7.4) 11 dbms_stats set_table_stats,
> > set_index_stats and
set_columns_stats
> >
> > These threads accounted for 39.4% of the total volume.
> >
> > Top 10 Targets for Crossposts
> > =============================
> >
> > Articles Newsgroup
> > -------- ---------
> >
> > 7 comp.databases.oracle.misc
> > 6 alt.os.linux
> > 6 comp.os.linux.setup
> > 6 comp.os.linux.misc
> > 6 alt.os.linux.suse
> > 3 comp.unix.solaris
> > 2 comp.databases.oracle.marketplace
> >
>
>
Received on Mon Nov 24 2003 - 03:37:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US