oracle - do you need COMMIT; after INSERT /*+ append */ -

i have commit after every insert statement.

i wondering if need commit; after insert /*+ append */ ...

a commit not required directly after insert /*+ append */ .... common convention because of issues caused direct-path writes. direct-path inserts write directly data files. locks segment other dml , prevents same session querying table or generate ora-12838: cannot read/modify object after modifying in parallel.

other restrictions, when commit depends largely on application's concept of transaction, brian driscoll pointed out.