Tuning - Migration to Oracle

[jsquizz]

We are currently using CMOD 9.5/DB2 11. Our new system we just stood up is CMOD 10.5/Oracle 19C.


1) We are curious about tuning the database, one of the key things we are looking for is SGA size for the database. Are there any other tuning considerations we need to take into account?

2) We are also looking for information regarding - db reorg/runstats. I believe currently we do all of this through arsdb/arsmaint commands. Is that supported with oracle? Is there a specific way to do it.

[Justin Derrick]

Presumably you made the move to Oracle because you have better internal support for it...  So...  the ultimate authority are the local DBAs.  :)

Otherwise, I don't think there's much that needs tuning outside making sure your database indexes are good.

-JD.