Stored Outlines in RAC
Hi,
I have created a outline to add a Hint index to a query using Bind variables. I have 2- Node RAC wherein I shutdown second instance in the night. I see that when the instance starts up, that instance is not using the stored outline. I have used alter system command to enable the stored outlines. (as below)
Alter system set user_stored_outlines=TRUE;
I had to redo the creation of stored outline on the second instance, to enable the Hint index be used for the query.
What could be the reason for this. Why does the second instance use old execution plan, without the hint index. Where as the first Instance, uses the stored outline.
I have created a outline to add a Hint index to a query using Bind variables. I have 2- Node RAC wherein I shutdown second instance in the night. I see that when the instance starts up, that instance is not using the stored outline. I have used alter system command to enable the stored outlines. (as below)
Alter system set user_stored_outlines=TRUE;
I had to redo the creation of stored outline on the second instance, to enable the Hint index be used for the query.
What could be the reason for this. Why does the second instance use old execution plan, without the hint index. Where as the first Instance, uses the stored outline.
0