Inadequate large extend size issue for LMT tablespace / segment space management are manual
From: Raja Subramaniyan <raja.s28_at_gmail.com>
Date: Fri, 15 Mar 2013 15:21:55 +0530
Message-ID: <CACxKW=Q_NwYBHECu0Myt1Q8hvV9SXKvwPdoptrNug9Qe5uajmQ_at_mail.gmail.com>
Hi,
We are migrating the Single Instance Database into RAC ( 10g to 11g ). Hence as a requirement, our database converted all the tablespaces from dictionary managed to locally managed tablespaces uing the dbms_space_admin. However the tablespace segment space management are still in manual. Hence, we are getting alerts for inadequate chunk of free space which is required.
Eventhougth when I extend the tablespace / adding the datafile, after some time, I am keep on getting inadequate chuck of freespace alerts. Some one give me idea for resolving such issues. Thanks in advance !
Date: Fri, 15 Mar 2013 15:21:55 +0530
Message-ID: <CACxKW=Q_NwYBHECu0Myt1Q8hvV9SXKvwPdoptrNug9Qe5uajmQ_at_mail.gmail.com>
Hi,
We are migrating the Single Instance Database into RAC ( 10g to 11g ). Hence as a requirement, our database converted all the tablespaces from dictionary managed to locally managed tablespaces uing the dbms_space_admin. However the tablespace segment space management are still in manual. Hence, we are getting alerts for inadequate chunk of free space which is required.
Eventhougth when I extend the tablespace / adding the datafile, after some time, I am keep on getting inadequate chuck of freespace alerts. Some one give me idea for resolving such issues. Thanks in advance !
Regards,
Raja
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 10:51:55 CET