What does the "INSERT /*+ APPEND */" instruction do in Oracle?

Question

What exactly does the following instruction do ?

```sql
INSERT /*+ APPEND */ INTO ventes (id, produit, montant)
SELECT id, produit, montant FROM ventes_temp;

Accepted Answer

Performs an `INSERT` in Direct Path mode, writing directly to disk

Answer

Inserts data in parallel across multiple sessions

Answer

Performs a standard `BULK INSERT` using the buffer cache

Answer

Faster insertion thanks to automatic Oracle optimization

Question from the Oracle Database test