Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBGNSNh25758 for ; Mon, 16 Dec 2002 17:28:23 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBGNSM325753 for ; Mon, 16 Dec 2002 17:28:22 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA62008; Mon, 16 Dec 2002 12:10:58 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0051A845; Mon, 16 Dec 2002 11:38:51 -0800 Message-ID: Date: Mon, 16 Dec 2002 11:38:51 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Igor Neyman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Igor Neyman" Subject: Re: alert log suppression Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C7_01C2A511.3235AA00" ------=_NextPart_000_00C7_01C2A511.3235AA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MessageRichard, I have here versions 8.1.5 and 9.2. Both show allocation type "UNIFORM" for LMTs with uniform extent size = (except LM SYSTEM and UNDO tablespaces in 9.2 , for which "SYSTEM" = allocation type is shown), and allocation type "USER" for dictionary = managed tablespaces. Igor Neyman, OCP DBA ineyman@perceptron.com =20 ----- Original Message -----=20 From: Markham, Richard=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, December 16, 2002 2:09 PM Subject: RE: alert log suppression Thanks for the info Igor. In addition to this I am curious of how to = determine that a given TS's extents are UNIFORM. dba_tablespaces shows = allocation_type of user for a known UNIFORM TS. TIA -----Original Message----- From: Igor Neyman [mailto:ineyman@perceptron.com]=20 Sent: Monday, December 16, 2002 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), = you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA ineyman@perceptron.com =20 ----- Original Message -----=20 From: Markham, Richard=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and=20 I believe that SMON requires PCTINCREASE > 0 to do routine=20 coalescing.........perhaps you have further to add to your post.=20 -----Original Message-----=20 From: Connor McDonald [mailto:hamcdc@yahoo.co.uk]=20 Sent: Monday, December 16, 2002 12:00 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Re: alert log suppression=20 The obvious question being why you are coalescing tablespaces....=20 --- "Markham, Richard" =20 wrote: > Is it possible to suppress successful DDL=20 within the=20 > alter log?=20 > For example, I have a cron job that coalesces 300+ tablespaces=20 > which creates a couple line entry for each. I would=20 > like to=20 > get feedback only if the DDL has actually failed.=20 >=20 > TIA=20 > =20 =3D=3D=3D=3D=3D=20 Connor McDonald=20 http://www.oracledba.co.uk=20 http://www.oaktable.net=20 "GIVE a man a fish and he will eat for a day. But TEACH him how to = fish, and...he will sit in a boat and drink beer all day" __________________________________________________=20 Do You Yahoo!?=20 Everything you'll ever need on one web page=20 from News and Sport to Email and Music Charts = http://uk.my.yahoo.com=20 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: =3D?iso-8859-1?q?Connor=3D20McDonald?=3D=20 INET: hamcdc@yahoo.co.uk=20 Fat City Network Services -- 858-538-5051 = http://www.fatcity.com=20 San Diego, California -- Mailing list and web hosting = services=20 = ---------------------------------------------------------------------=20 To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and = in the message BODY, include a line containing: UNSUB ORACLE-L (or the = name of mailing list you want to be removed from). You may also send = the HELP command for other information (like subscribing). ------=_NextPart_000_00C7_01C2A511.3235AA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
Richard,
 
I have here versions 8.1.5 and 9.2.
Both show allocation type "UNIFORM" for LMTs with = uniform=20 extent size (except LM SYSTEM and UNDO tablespaces in 9.2 , for = which=20 "SYSTEM" allocation type is shown), and allocation type "USER" for = dictionary=20 managed tablespaces.
 
Igor Neyman, OCP DBA
ineyman@perceptron.com
&nbs= p;
 
 
----- Original Message -----
From:=20 Markham, Richard =
Sent: Monday, December 16, 2002 = 2:09=20 PM
Subject: RE: alert log = suppression

Thanks for the info Igor.  In addition to this I am = curious=20 of how to determine that a given TS's extents are UNIFORM. =20 dba_tablespaces shows allocation_type of user for a known UNIFORM = TS. =20 TIA
-----Original Message-----
From: = Igor Neyman=20 [mailto:ineyman@perceptron.com]
Sent: Monday, December = 16, 2002=20 1:30 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Re: alert log = suppression

Richard,
 
If you are using UNIFORM extents (which is = usually the=20 best option), you don't need to do any coalescing on = LMTs.
 
Igor Neyman, OCP DBA
ineyman@perceptron.com
&nbs= p;=20
 
 
----- Original Message ----- =
From:=20 Markham, Richard =
Sent: Monday, December 16, = 2002 1:00=20 PM
Subject: RE: alert log=20 suppression

ok.  They are LMT's with PCTINCREASE = 0.  I'm=20 running 8.1.7.4 and
I believe that SMON = requires=20 PCTINCREASE > 0 to do routine
coalescing.........perhaps you have further to add to = your=20 post.


-----Original Message-----
From:=20 Connor McDonald [mailto:hamcdc@yahoo.co.uk]=20
Sent: Monday, December 16, 2002 12:00 = PM=20
To: Multiple recipients of list ORACLE-L =
Subject: Re: alert log suppression


The obvious question being why you are = coalescing=20 tablespaces....

 --- "Markham, Richard"=20 <RMarkham@hafeleamericas.com>
wrote: > Is=20 it possible to suppress successful DDL
within=20 the
> alter log?
>=20 For example, I have a cron job that coalesces 300+ = tablespaces=20
> which creates a couple line entry for = each.  I=20 would
> like to
>=20 get feedback only if the DDL has actually failed.
>
> TIA
> 

=3D=3D=3D=3D=3D
Connor = McDonald=20
http://www.oracledba.co.uk= =20
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. = But TEACH=20 him how to fish, and...he will sit in a boat and drink beer all=20 day"

__________________________________________________=20
Do You Yahoo!?
Everything you'll=20 ever need on one web page
from News and = Sport to=20 Email and Music Charts http://uk.my.yahoo.com =
--
Please see the official = ORACLE-L FAQ: http://www.orafaq.com =
--
Author:=20 =3D?iso-8859-1?q?Connor=3D20McDonald?=3D
  INET:=20 hamcdc@yahoo.co.uk

Fat City Network Services    --=20 858-538-5051 http://www.fatcity.com =
San Diego, = California        --=20 Mailing list and web hosting services
----------------------------------------------------------------= -----=20
To REMOVE yourself from this mailing list, send = an E-Mail=20 message
to: ListGuru@fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in the message BODY, include a line=20 containing: UNSUB ORACLE-L (or the name of mailing list you want = to be=20 removed from).  You may also send the HELP command for other=20 information (like=20 subscribing).

------=_NextPart_000_00C7_01C2A511.3235AA00-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: ineyman@perceptron.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).