# Oracle push down behavior and location of ARP configuration

**URL:** <https://community.dremio.com/t/oracle-push-down-behavior-and-location-of-arp-configuration/4547>\
**Category:** Uncategorized\
**Created:** [November 11, 2019, 5:35pm UTC](https://community.dremio.com/t/oracle-push-down-behavior-and-location-of-arp-configuration/4547 "2019-11-11T17:35:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpcarter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mpcarter/32/1233_2.png) [@mpcarter](https://community.dremio.com/u/mpcarter)\
**Post date:** [November 11, 2019, 5:35pm UTC](https://community.dremio.com/t/oracle-push-down-behavior-and-location-of-arp-configuration/4547/1 "2019-11-11T17:35:58Z")

</div>

I am trying to better understand the circumstances that permit Dremio to push down query to database (e.g. Oracle). I trying to create a VDS that invokes several of our larger Oracle tables joined together, and from the job profile it looks like Dremio is querying the tables separately and attempting to join in Dremio instead of in Oracle.

I was trying to locate the YAML file for the ARP implementation of Oracle connector, but cannot locate it within dremio-oss on github.

---

<div class="post-metadata">

**Author:** ![mpcarter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mpcarter/32/1233_2.png) [@mpcarter](https://community.dremio.com/u/mpcarter)\
**Post date:** [December 6, 2019, 5:23am UTC](https://community.dremio.com/t/oracle-push-down-behavior-and-location-of-arp-configuration/4547/2 "2019-12-06T05:23:16Z")

</div>

Let me rephrase. How can I optimize dremio for queries against Oracle?

I’m more than willing to study the code, but there is not an obvious place in your public github repo for Oracle connector. (Least not obvious to me)

---

<div class="post-metadata">

**Author:** ![patricker](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/patricker/32/1823_2.png) [@patricker](https://community.dremio.com/u/patricker)\
**Post date:** [December 6, 2019, 3:23pm UTC](https://community.dremio.com/t/oracle-push-down-behavior-and-location-of-arp-configuration/4547/3 "2019-12-06T15:23:30Z")

</div>

@mpcarter Correct. ARP JDBC falls under the, “free but not open source” section of Dremio CE. Dremio provides ARP adapters by default in the UI. If you build from source, there is specific profile you have to choose if you want to build with just the community edition/OSS code being in the final binary.

I’ve had this discussion a couple times on here in different forms about this.

- Direct response from Dremio developers about licensing: [Is Dremio CE fully Apache 2.0?](https://community.dremio.com/t/is-dremio-ce-fully-apache-2-0/3858/4)
- My request to make the JDBC ARP library open source: [Enhancement Request - ARP JDBC](https://community.dremio.com/t/enhancement-request-arp-jdbc/4449/3)