I think this is a prime example of why the cloud won.
You don’t need wizards in your team anymore.
Something seems off in the instance? Just nuke it and spin up a new one. Let the system debugging for the Amazon folks.
You don’t need wizards in your team anymore.
Something seems off in the instance? Just nuke it and spin up a new one. Let the system debugging for the Amazon folks.
If you do look into the Oracle dba handbook, scheduled index rebuilds are somewhat recommended. We do it on weekends on our Oracle instances. Otherwise you will encounter severe performance degredation in tables where data is inserted and deleted at high throughput thus leading to fragmented indexes. And since Oracle 12g with ONLINE REBUILD this is no problem anymore even at peak hours.