A user receives the following error while executing a query:ORA-01555: snapshot too oldWhich two options can be the solutions to avoid such errors in future?
What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?
Which three pieces of information would you check to confirm that the statistics have been collected?