I can help with some of the issues you're facing.

Understanding Index-Organized Tables (IOTs) in Oracle: A Comprehensive Guide to Creating and Managing IOTs

Understanding Oracle's Aggregate Function Ordering Behavior: When Average Goes Wrong with Group By Clauses

Oracle 12c Duplicate Records Selection Using GROUP BY and HAVING

Understanding Full Table Scans with PL/SQL Tables: Mitigating Performance Bottlenecks in Oracle Databases.

Understanding Oracle BFILE Cache Directory: Best Practices and Common Issues