[Python] How to process 10 million records in Oracle DB using Python. (cx_Oracle / Pandas)

Discussão em 'Python' iniciado por Stack, Junho 9, 2025.

  1. Stack

    Stack Membro Participativo

    I tried cx_Oracle package , fetchall() , but this ended up consuming lot of RAM, Tried Pandas as well, but that also doesn't seem to be that efficient in case we have billions of records.

    My Use case - Fetch each row from oracle table to python , do some processing and load it to another table. PS - Expecting something like fetchmany() , tried this but not able to get it work.

    Continue reading...
    Stack, Junho 9, 2025
    #1

Compartilhe esta Página