Re: Inserting with billion of rows faster

From: Lok P <loknath.73_at_gmail.com>
Date: Tue, 30 Mar 2021 00:18:46 +0530
Message-ID: <CAKna9VZEzUKo4b2EwYKg3CR8yw_9yfNThvKyTVnbQh7ZvQkWUw_at_mail.gmail.com>

>
> Attached is the sql monitor plan for that sql when data volume was
> ~500million+ and this one also failed that time. I do see "load as select"
> and "index maintenance" in the sql path, so mostly its doing direct path
> load only but the UNDO generation perhaps because of Index maintenance
> only. Correct me if wrong.
>

--
http://www.freelists.org/webpage/oracle-l




text/plain attachment: Sample_dataload_path.txt

Received on Mon Mar 29 2021 - 20:48:46 CEST

This message: [ Message body ]
Next message: Pap: "Stats gather for big tables"
Previous message: Laurentiu Oprea: "Re: Inserting with billion of rows faster"
In reply to: Lothar Flatz: "Re: Inserting with billion of rows faster"
In reply to Lok P: "Re: Re: Column Length modification"
Next in thread: Lothar Flatz: "Re: Inserting with billion of rows faster"
Reply: Lothar Flatz: "Re: Inserting with billion of rows faster"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message