Cybersecurity
DevOps Cloud
IT Operations Cloud
On Tuesday, November 12, as part of a company wide initiative to bring all corporate websites under the OpenText brand, the Community will be down briefly around 11am Eastern / 8am Pacific as we transition to a new domain name. The community will be offline while we make the change and when it comes back online it will be located at community.opentext.com and the old domain will redirect to this new location. Thank you for your patience as we make this important change.
UCMDB (Universal Configuration Management Database) 23.4
Oracle Database (specific to one step of the solution)
After the upgrade when trying to access the Universal Discovery section in the Local Client the application remains frozen for a lot of time before responds (10 minutes or more). Every click in the section to select a different job has the same behavior.
SQL query is slow due to Fragmentation, Outdated Statistics or Index Fragmentation.
Involve DBA to perform following operations:
1. Rebuild or reorganize indexes to remove index fragmentation.
2. Gather updated statistics using Oracle's DBMS_STATS package (if using Oracle) to ensure accurate optimizer decisions. Analyze table cmdb.CCM_DISCOVERY_STATS estimate statistics sample 10 percent;' in this case.
3. Consider performing a table reorganization or shrink operation to reclaim fragmented space. For example, using truncate table instead of delete to free up the space.