Hello All,

Hope you all are safe and healthy.

We are working on a B2Bi migration project from On-prem to AWS. Below are the highlights -

1. We had Oracle Enterprise Edition for B2Bi 5.2.6.3 in on-prem
2.Now when we were planning for the AWS Infra cost, initially we went for Oracle EE but as client was looking for cost reduction as well, they suggested to go for Oracle Standard edition unless there is a big reason to go for Enterprise one.
3. We moved ahead with Oracle 12c R1 Standard edition for AWS infrastructure.

Now based on our prior exp, usually for any DB maintenance that are proposed per documentation, we have certain housekeeping that we are supposed to do like RUNSTATS daily, Reindex / Reorg once in a month or the interval can vary based on volume of data.

Coming to this point,we suddenly planned to do a Re-index online and found that it is erroring out stating feature not enbled error.

When checked, Oracle SE doesnt allow online index rebuild and have to go for Offline which means application has to be down. 

But the SLA requirement doesnt allow for application to be down even if it is planned outage to perform the same.

Can anyone of you suggest what are the other alternatives or tasks that can be performed to ensure no degradation of application performance as its too late in the game to go back to change Oracle SE to Oracle EE ?

Kindly let us know.

Regards,
Pranjit

------------------------------
Pranjit Biswas
------------------------------

#B2BIntegration
#SupplyChain

Hello Pranjit,

If you cannot use online indexing then run db_optimization tool once every couple of days during low volume time. You can find out more at below link.

https://www.ibm.com/support/knowledgecenter/SS3JSW_5.2.0/com.ibm.help.performance_mgmt.doc/SIPM_TS_DBmaintCk.html

-Dhiraj Patil

------------------------------
Dhiraj Patil
------------------------------

Original Message:
Sent: Tue May 05, 2020 05:35 AM
From: Pranjit Biswas
Subject: Is there any alternative to Re-index/Re-org of Sterling B2Bi tables ?

Hello All,

Hope you all are safe and healthy.

We are working on a B2Bi migration project from On-prem to AWS. Below are the highlights -

1. We had Oracle Enterprise Edition for B2Bi 5.2.6.3 in on-prem
2.Now when we were planning for the AWS Infra cost, initially we went for Oracle EE but as client was looking for cost reduction as well, they suggested to go for Oracle Standard edition unless there is a big reason to go for Enterprise one.
3. We moved ahead with Oracle 12c R1 Standard edition for AWS infrastructure.

Now based on our prior exp, usually for any DB maintenance that are proposed per documentation, we have certain housekeeping that we are supposed to do like RUNSTATS daily, Reindex / Reorg once in a month or the interval can vary based on volume of data.

Coming to this point,we suddenly planned to do a Re-index online and found that it is erroring out stating feature not enbled error.

When checked, Oracle SE doesnt allow online index rebuild and have to go for Offline which means application has to be down. 

But the SLA requirement doesnt allow for application to be down even if it is planned outage to perform the same.

Can anyone of you suggest what are the other alternatives or tasks that can be performed to ensure no degradation of application performance as its too late in the game to go back to change Oracle SE to Oracle EE ?

Kindly let us know.

Regards,
Pranjit

------------------------------
Pranjit Biswas
------------------------------

#SupplyChain
#B2BIntegration

Dhiraj-

Thanks for the response. But unfortnately that db optimzation script code is itself trying to run the rebuild with default option of online and it is failing hence stating feature not enabled.

Hence this solution even wont work as well.

Regards,
Pranjit

------------------------------
Pranjit Biswas
------------------------------

Original Message:
Sent: Wed May 06, 2020 09:03 AM
From: Dhiraj Patil
Subject: Is there any alternative to Re-index/Re-org of Sterling B2Bi tables ?

Hello Pranjit,

If you cannot use online indexing then run db_optimization tool once every couple of days during low volume time. You can find out more at below link.

https://www.ibm.com/support/knowledgecenter/SS3JSW_5.2.0/com.ibm.help.performance_mgmt.doc/SIPM_TS_DBmaintCk.html

-Dhiraj Patil

------------------------------
Dhiraj Patil

Original Message:
Sent: Tue May 05, 2020 05:35 AM
From: Pranjit Biswas
Subject: Is there any alternative to Re-index/Re-org of Sterling B2Bi tables ?

Hello All,

Hope you all are safe and healthy.

We are working on a B2Bi migration project from On-prem to AWS. Below are the highlights -

1. We had Oracle Enterprise Edition for B2Bi 5.2.6.3 in on-prem
2.Now when we were planning for the AWS Infra cost, initially we went for Oracle EE but as client was looking for cost reduction as well, they suggested to go for Oracle Standard edition unless there is a big reason to go for Enterprise one.
3. We moved ahead with Oracle 12c R1 Standard edition for AWS infrastructure.

Now based on our prior exp, usually for any DB maintenance that are proposed per documentation, we have certain housekeeping that we are supposed to do like RUNSTATS daily, Reindex / Reorg once in a month or the interval can vary based on volume of data.

Coming to this point,we suddenly planned to do a Re-index online and found that it is erroring out stating feature not enbled error.

When checked, Oracle SE doesnt allow online index rebuild and have to go for Offline which means application has to be down. 

But the SLA requirement doesnt allow for application to be down even if it is planned outage to perform the same.

Can anyone of you suggest what are the other alternatives or tasks that can be performed to ensure no degradation of application performance as its too late in the game to go back to change Oracle SE to Oracle EE ?

Kindly let us know.

Regards,
Pranjit

------------------------------
Pranjit Biswas
------------------------------

#B2BIntegration
#SupplyChain