RE: alert log suppression

2002-12-17 Thread Connor McDonald 
The EXTENT_MANAGEMENT column tells you if they are
locally managed or not.  If they are local, then the
ALLOCATION_TYPE will be either UNIFORM, SYSTEM or
USER.  The latter means it was originally a dictionary
managed tspace that has been converted to lmt.

But in any event, the coalesce is just extra work for
no gain

hth
connor

 --- "Markham, Richard" <[EMAIL PROTECTED]>
wrote: > 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-
> Sent: Monday, December 16, 2002 1:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
> [EMAIL PROTECTED]
>  
>   
>  
>  
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L
>   
> Sent: Monday, December 16, 2002 1:00 PM
> 
> 
> ok.  They are LMT's with PCTINCREASE 0.  I'm running
> 8.1.7.4 and 
> I believe that SMON requires PCTINCREASE > 0 to do
> routine 
> coalescing.perhaps you have further to add
> to your post. 
> 
> 
> -Original Message- 
> ] 
> Sent: Monday, December 16, 2002 12:00 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> The obvious question being why you are coalescing
> tablespaces 
> 
>  --- "Markham, Richard"
> <[EMAIL PROTECTED]> 
> wrote: > Is it possible to suppress successful DDL 
> within the 
> > alter log? 
> > For example, I have a cron job that coalesces 300+
> tablespaces 
> > which creates a couple line entry for each.  I
> would 
> > like to 
> > get feedback only if the DDL has actually failed. 
> > 
> > TIA 
> >  
> 
> = 
> Connor McDonald 
> http://www.oracledba.co.uk
>   
> http://www.oaktable.net   
> 
> "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"
> 
> __ 
> Do You Yahoo!? 
> Everything you'll ever need on one web page 
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
>   
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>   
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?= 
>   INET: [EMAIL PROTECTED] 
> 
> 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: [EMAIL PROTECTED] (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).
> 
>  

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

"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"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: alert log suppression

2002-12-16 Thread Markham, Richard 
Title: Message



ok 
good thats what I had expected, I found that the particular TS was created 
differently in another instance.  Thanks for your time.

  
  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 
  2:39 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: alert log suppression
  Richard,
   
  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[EMAIL PROTECTED]  
  
   
   
  
- Original Message - 
From: 
Markham, Richard 
To: Multiple recipients of list ORACLE-L 

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:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 
  1:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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[EMAIL PROTECTED]  
  
   
   
  
- Original Message - 
From: 
Markham, Richard 
To: Multiple recipients of list 
ORACLE-L 
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 I believe that SMON requires 
PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your 
post. 
-Original Message- From: 
Connor McDonald [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 12:00 PM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: alert log suppression 
The obvious question being why you are coalescing 
tablespaces 
 --- "Markham, Richard" 
<[EMAIL PROTECTED]> wrote: > 
Is it possible to suppress successful DDL within 
the > alter log? > 
For example, I have a cron job that coalesces 300+ tablespaces 
> which creates a couple line entry for each.  
I would > like to > get feedback only if the DDL has actually failed. 
> > TIA >  
= Connor McDonald 
http://www.oracledba.co.uk http://www.oaktable.net 
"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"
__ 
Do You Yahoo!? Everything 
you'll ever need on one web page from News and 
Sport to Email and Music Charts http://uk.my.yahoo.com -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
Author: 
=?iso-8859-1?q?Connor=20McDonald?=   INET: 
[EMAIL PROTECTED] 
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: [EMAIL PROTECTED] (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).

Re: alert log suppression

2002-12-16 Thread Arup Nanda 
Title: Message



Rich,
 
You just gave the answer yourself, allocation_type 
in dba_tablespaces should show UNIFORM for uniform extent allocation. For 
non-uniform allocation, it will show SYSTEM in that field. If you want to know 
what is the size of the uniform extent, look for INITIAL_EXTENT and NEXT_EXTENT; 
they should be same.
 
HTH.
 
Arup

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list ORACLE-L 
  
  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:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 
1:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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[EMAIL PROTECTED]  

 
 

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list 
  ORACLE-L 
  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 I believe that SMON requires 
  PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your 
  post. 
  -Original Message- From: 
  Connor McDonald [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, December 16, 2002 12:00 PM 
  To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
  The obvious question being why you are coalescing 
  tablespaces 
   --- "Markham, Richard" 
  <[EMAIL PROTECTED]> wrote: > Is 
  it possible to suppress successful DDL within 
  the > alter log? > 
  For example, I have a cron job that coalesces 300+ tablespaces 
  > which creates a couple line entry for each.  I 
  would > like to > 
  get feedback only if the DDL has actually failed. > > TIA >  
  = Connor McDonald 
  http://www.oracledba.co.uk http://www.oaktable.net 
  "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"
  __ 
  Do You Yahoo!? Everything you'll 
  ever need on one web page from News and Sport to 
  Email and Music Charts http://uk.my.yahoo.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
  Author: =?iso-8859-1?q?Connor=20McDonald?= 
    INET: [EMAIL PROTECTED] 
  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: [EMAIL PROTECTED] (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).

Re: alert log suppression

2002-12-16 Thread Igor Neyman 
Title: Message



Richard,
 
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[EMAIL PROTECTED]  
 
 

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list ORACLE-L 
  
  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:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 
1:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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[EMAIL PROTECTED]  

 
 

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list 
  ORACLE-L 
  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 I believe that SMON requires 
  PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your 
  post. 
  -Original Message- From: 
  Connor McDonald [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, December 16, 2002 12:00 PM 
      To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
  The obvious question being why you are coalescing 
  tablespaces 
   --- "Markham, Richard" 
  <[EMAIL PROTECTED]> wrote: > Is 
  it possible to suppress successful DDL within 
  the > alter log? > 
  For example, I have a cron job that coalesces 300+ tablespaces 
  > which creates a couple line entry for each.  I 
  would > like to > 
  get feedback only if the DDL has actually failed. > > TIA >  
  = Connor McDonald 
  http://www.oracledba.co.uk 
  http://www.oaktable.net 
  "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"
  __ 
  Do You Yahoo!? Everything you'll 
  ever need on one web page from News and Sport to 
  Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  =?iso-8859-1?q?Connor=20McDonald?=   INET: 
  [EMAIL PROTECTED] 
  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: [EMAIL PROTECTED] (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).

RE: alert log suppression

2002-12-16 Thread Wong, Bing 
Title: RE: alert log suppression



If it 
is LMT, coalescing is ignored.

  -Original Message-From: Deshpande, Kirti 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 
  10:34 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: alert log suppression
  Coalescing LMTs is unnecessary ! 
   
  - 
  Kirti 
   
  -Original Message-From: Markham, Richard 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 
  12:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: alert log suppression
  ok.  They are LMT's with PCTINCREASE 0.  I'm running 
  8.1.7.4 and I believe that SMON requires PCTINCREASE 
  > 0 to do routine coalescing.perhaps you 
  have further to add to your post. 
  -Original Message- From: 
  Connor McDonald [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, December 16, 2002 12:00 PM 
  To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
  The obvious question being why you are coalescing 
  tablespaces 
   --- "Markham, Richard" 
  <[EMAIL PROTECTED]> wrote: > Is it 
  possible to suppress successful DDL within the 
  > alter log? > For example, I 
  have a cron job that coalesces 300+ tablespaces > 
  which creates a couple line entry for each.  I would > like to > get feedback only if the DDL 
  has actually failed. > > 
  TIA >  
  = Connor McDonald http://www.oracledba.co.uk 
  http://www.oaktable.net 
  "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"
  __ 
  Do You Yahoo!? Everything you'll ever 
  need on one web page from News and Sport to Email and 
  Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: 
  =?iso-8859-1?q?Connor=20McDonald?=   INET: 
  [EMAIL PROTECTED] 
  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: [EMAIL PROTECTED] (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).

RE: alert log suppression

2002-12-16 Thread Markham, Richard 
Title: Message



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:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 
  1:30 PMTo: Multiple recipients of list ORACLE-LSubject: 
  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[EMAIL PROTECTED]  
  
   
   
  
- Original Message - 
From: 
Markham, Richard 
To: Multiple recipients of list ORACLE-L 

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 I believe that SMON requires 
PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your 
post. 
-Original Message- From: 
Connor McDonald [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 12:00 PM 
To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
The obvious question being why you are coalescing 
tablespaces 
 --- "Markham, Richard" 
<[EMAIL PROTECTED]> wrote: > Is 
it possible to suppress successful DDL within 
the > alter log? > For 
example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each.  I would 
> like to > get feedback only 
if the DDL has actually failed. > 
> TIA >  

= Connor McDonald 
http://www.oracledba.co.uk http://www.oaktable.net 
"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"
__ 
Do You Yahoo!? Everything you'll 
ever need on one web page from News and Sport to 
Email and Music Charts http://uk.my.yahoo.com -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- Author: 
=?iso-8859-1?q?Connor=20McDonald?=   INET: 
[EMAIL PROTECTED] 
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: [EMAIL PROTECTED] (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).

RE: alert log suppression

2002-12-16 Thread Deshpande, Kirti 
Title: RE: alert log suppression



Coalescing LMTs is unnecessary ! 
 
- 
Kirti 
 
-Original Message-From: Markham, Richard 
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 
12:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: alert log suppression
ok.  They are LMT's with PCTINCREASE 0.  I'm running 
8.1.7.4 and I believe that SMON requires PCTINCREASE 
> 0 to do routine coalescing.perhaps you have 
further to add to your post. 
-Original Message- From: Connor 
McDonald [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 12:00 PM 
To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
The obvious question being why you are coalescing 
tablespaces 
 --- "Markham, Richard" 
<[EMAIL PROTECTED]> wrote: > Is it 
possible to suppress successful DDL within the 
> alter log? > For example, I 
have a cron job that coalesces 300+ tablespaces > 
which creates a couple line entry for each.  I would > like to > get feedback only if the DDL 
has actually failed. > > 
TIA >  
= Connor McDonald http://www.oracledba.co.uk 
http://www.oaktable.net 
"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"
__ 
Do You Yahoo!? Everything you'll ever 
need on one web page from News and Sport to Email and 
Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- Author: 
=?iso-8859-1?q?Connor=20McDonald?=   INET: 
[EMAIL PROTECTED] 
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: [EMAIL PROTECTED] (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).

Re: alert log suppression

2002-12-16 Thread Igor Neyman 
Title: 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[EMAIL PROTECTED]  
 
 

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list ORACLE-L 
  
  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 I believe that SMON requires PCTINCREASE 
  > 0 to do routine coalescing.perhaps you 
  have further to add to your post. 
  -Original Message- From: 
  Connor McDonald [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, December 16, 2002 12:00 PM 
  To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 
  The obvious question being why you are coalescing 
  tablespaces 
   --- "Markham, Richard" 
  <[EMAIL PROTECTED]> wrote: > Is it 
  possible to suppress successful DDL within the 
  > alter log? > For example, I 
  have a cron job that coalesces 300+ tablespaces > 
  which creates a couple line entry for each.  I would > like to > get feedback only if the DDL 
  has actually failed. > > 
  TIA >  
  = Connor McDonald http://www.oracledba.co.uk 
  http://www.oaktable.net 
  "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"
  __ 
  Do You Yahoo!? Everything you'll ever 
  need on one web page from News and Sport to Email and 
  Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: 
  =?iso-8859-1?q?Connor=20McDonald?=   INET: 
  [EMAIL PROTECTED] 
  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: [EMAIL PROTECTED] (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).

RE: alert log suppression

2002-12-16 Thread Markham, Richard 
Title: RE: alert log suppression





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



-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: alert log suppression



The obvious question being why you are coalescing tablespaces


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


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


"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"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).

Re: alert log suppression

2002-12-16 Thread Connor McDonald 
The obvious question being why you are coalescing
tablespaces

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

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

"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"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).