Hi @saikat.chanda ,

The session may be locked even when it is idle, which means it is not currently executing any command but is still holding resources. This situation may arise due to various reasons, such as a network glitch or a user getting disconnected without committing or rolling back a transaction. The table EXCEL_PARAMETER_CACHE_TAB and its indexes could have been locked in a way that prevents DDL operations such as index validation.

The session may be active while executing the 'Validate Index' background job, check the active session that belongs to the table EXCEL_PARAMETER_CACHE_TAB. Terminate the active session if it is running for a long time and then try.

Note: Check the business impact of the query before terminating the session.

Possible ways to prevent this problem from occurring is to restart the database after the delivery installation activity.


I hope this will be helpful. Thank you.

Best Regards,
Dharmendra

Follow: linkedin.com/in/dharmendaribc

Thanks @Dharmendra , it solves the issue.