Do you want to commit after a certain period of time? Is it through just SQL*Plus or through a program or SQL*Load? You need to give more details otherwise the answer to your question is already given :-)