Hi , just want to know if there is any particular DBFS settings to increase the performance on external table loading currently I have just mounted it with directio just looking for any other ways to improve the reading from the flat file that sits on dbfs on exadata x-2 half rack
The My Oracle Support Community which covers all support related questions about EXADATA is available under: https://communities.oracle.com/portal/server.pt/community/exadata_general/360
Have you ever visited the Community to exchange, learn, share and get answers to your support related questions?
The answer to your query is available on the My Oracle Support Community for Exadata
If you have not used the My Oracle Support Communities before, please watch this brief (2 minute) video to help you quickly understand the benefits available to you.