Keep in mind that DIRECT=Y bypasses the buffer cache and the SQL processing layer. There are security and performance concerns when doing this. They are detailed in the following document:
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.