A company using Exadata sparse clones for database provisioning faced slow materialization times for sparse clones compared to full clones.
The issue was identified as a result of Oracle sequentially performing online database move operations, slowing down the process.
Monitoring the materialization process was possible through queries on GV$SESSION_LONGOPS.
The company optimized the process using Python scripts with cx_Oracle driver, enabling parallel task execution and reducing the materialization time to that of creating a full PDB clone.