Originally posted by marist89
NOLOGGING is one of the most misunderstood topics in Oracle Database Administration. Even if you have NOLOGGING turned on, not all operations are NOLOG operations. See http://technet.oracle.com/docs/produ...dlins.htm#4418 for details.
Thanks for clearing the subject marist89. I will try Direct-Load Insert with Append hint. I also think that because I am inserting about 80000 rows in one shot / one transaction, it is taking this much time. I commit transaction after insert. Will it make any difference if I divide single 80000 rows insert transaction into 1000 rows (commit) per transaction?

Pl. advise.

Thanks,