The OAuth database is external to the gateway. There's a plan to move from Oracle to Exadata. We want to list all policies that use the OAuth JDBC connection.
API Gateway 10.1
There are only a few assertions where you can specify a JDBC connection.
select name from policy where xml like '%L7p:ConnectionName%OAuth%' and name not like '%OTK%';
If no results come back, then you don't have any user-defined policies that reference an OAuth JDBC connection (outside of the actual OTK policies).