RE: alert log suppression
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] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 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.oracledba.co.uk http://www.oaktable.net 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 http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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 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
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
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
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
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
Title: Message Thanks for the info Igor. In addition to thisI 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
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
Title: Message
Richard,
I have here versions 8.1.5 and 9.2.
Both show allocation type "UNIFORM" for LMTs with uniform
extent size (exceptLM 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 thisI 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
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 thisI 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
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 (exceptLM 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 thisI 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).
