menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Databases

>

Optimize m...
source image

Dbi-Services

1w

read

274

img
dot

Optimize materialization of Exadata PDB sparse clones

  • 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.

Read Full Article

like

16 Likes

For uninterrupted reading, download the app