ORS Database Indexing Considerations for Offline and Online Updates
(Doc ID 1381140.1)
Last updated on SEPTEMBER 09, 2019
Applies to:Oracle Real-Time Scheduler - Version 10.4.9 and later
Information in this document applies to any platform.
1. When is a suitable time to apply the index changes to the ORS database so that they do not impact the ORS application/website?
2. What impact would be caused while the tables are locked?
3. What is the impact of modifying the following tables to allow live indexing?: stop_shift_archive, drop index shift_date, drop depot_stop_shift_archive, drop stop_job.
4. Will the product provide the ability to do live indexing in the future?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document