Siebel Business Process & Functionality (MOSC)

MOSC Banner

How to reduce downtime for maintenance activities?

edited Aug 1, 2014 5:01AM in Siebel Business Process & Functionality (MOSC) 2 commentsAnswered

Hello,

Our Siebel environment is on 8.1.1.4 Call Center on DB2 UDB 9.7.

We are observing a lot of performance issues on the database due to high fragmentation on few tables (Service Requests and Activities). The total database size in more than 4 TB and major tables are more than 300 GB on size.

If we try to offline re-org the service request table, it takes more than 20 hours to complete which is too long of an outage for the business. Online re-org never completes and it also causes performance issues.

Can someone suggest any ideas on how can we reduce the downtime for maintenance activities like reorg on the database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

SBL Business Process Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center