Before we migrate from oracle to MariaDB DB we will do PoC and for the PoC we need to prepare some information:
1) How many Tables, Views, Procedures, Functions, Packages, Triggers, Sequences, synonyms are there need to migrate
2) how often items in 1) has been executed
3) do we need to modify SQL statements within the application?
For 1) and 2) any script helps to find out? the script should filter out the items NOT belongs to oracle system.
for 3) I have to check embedded SQL code within the application, right ?