I have and application with oracle database. database have more than 800 tables. I want to find a way to get understand where each forms fields goes and store after submit in the database, witch store procedures ware called and the functions witch were called for each submit. now I need help if there is any software that I can connect it to the database in order to track the flow or any oracle query that can list me information about the queries and called stored procedures.

I have an Oracle database, I want to purge any data older than 365 days from all tables.