We have an Autonomous Database configured that is hosted wholly within OCI, so nothing running on our own local or virtual machines. Version 19c. I wanted to start with 23ai, but we're in Gov Cloud and that wasn't available when we stood this up.
We have a series of REST-enabled tables configured and we'd like to run some A/B performance testing on some of the calls. In one instance, we have an application using REST calls to perform CRUD operations for their users in our tables. We have a central USERS table and each app has its own set of app-specific tables.
In the search collection we built for them, we require a minimum 3-characters to search the tables. They're asking for 1-character searches and I'm concerned that it would negatively impact database performance. My co-worker believes he's got a fix for this, but I want to test it before enabling 1-character searches for this team.
All of the documentation I've found about this is built around locally hosted databases. I'm having trouble figuring out how to do something like EXPLAIN PLAN when I'm not sure where to find the config files. I'd bet that I don't actually have access to that.
Am I missing the documentation for our configuration, where everything is hosted within OCI?