The OLE DB destinations for non-SQL databases are pretty slow generally and isn't due to the returning of rowid. It's inserting and committing every row one by one which is *slow*.

If you use Enterprise Edition, you could try using the Attunity driver set for Oracle which is said to be much faster (and has a fast load option similar to a bulk insert I believe).

SSIS is optimised for pulling data out of external sources into SQL Server rather than the reverse, so it's never going to be as fast as a SQL Server/Flat File Destination.

Another option would be to output to a flat file, then call SQL*Loader to load the data from Oracle's end.