Hello, today we want to share an error ORA-00600 that has arisen in a client that demonstrates how important it is to know the new functionalities of the application with …
Collect data and statistics from the current environment to compare before and after changes. Store this data for later use in new platform changes.
The behavior of the selected queries, showing their execution plans, times and other performance meters to be compared.
It allows to identify the queries with problems and to make the necessary adjustments that avoid degradations caused by the jumps of version or changes in the database.
With the information obtained after relaunching the queries, possible errors. Avoiding surprises in production passes.