The latest release of Oracle DB23ai (23.7) now includes the promised packages for DBMS_CLOUD.
I'm not talking about the ADB release, this is the general 23.7 DB release, and it even includes Select AI !!
You can find the documentation for how to install DBMS_CLOUD here. This is updated documentation that supersedes the MOS note 2748362.1 - How To Setup And Use DBMS_CLOUD Package.
What's Included in 23.7
The Following packages are included in 23.7
DBMS_CLOUD - The SQL to install this package has been included with the DB release since 19.9. More procedures have been added over time to provide more functionality with object storage.
DBMS_CLOUD_AI - This is the most interesting part of the release (at least to me). This package is used as the basis for Select AI.
DBMS_CLOUD_NOTIFICATION - This package allows you to send messages, or the output of a query to an e-mail or to Slack.
DBMS_CLOUD_PIPELINE - This package allows you to create a data pipeline for loading and exporting data in the cloud. This is mainly used to interact with data in object storage on a scheduled basis.
DBMS_CLOUD_REPO - This package allows you to interact with hosted code repositories from the oracle Database. Repositories like github and supported.
Where to start
The following are some great places to learn more about how to use the packages.
Videos:
Documentation:
Installing in your Database
I started by going through the install and prerequisites found here.
- Install the DBMS_CLOUD packages in a 23.7 CDB using the instructions in the 23.7 Documentation (20.2)
- Create the SSL wallet with certificates (20.3)
- Configure your environment with the new wallet (20.4).
NOTE: If you are using SEPS (ZDLRA uses SEPS), or other user authentication this is the same wallet that other authentication methods use).
4. Configure the ACL list to allow DB calls to the LLM that you are going to be using (20.5)
5. Verify the configuration for DBMS_CLOUD (20.6)
6. Configure users or roles to use DBMS_CLOUD. (20.7). In my case I granted the access to "SH".
7. Create the credential for the LLM you are using in your PDB
8. Create the Profile which identifies the tables that you want to use in your PDB
Example
I installed the Sample sales schema into my PDB (SH user) and followed the instructions in the documentation found here.
Below is the output of one of the queries that I ran using "Select AI" once I went through these steps to install it with the sample SH schema.
SQL> select ai tell me how many customers are in each country;
COUNTRY_NAME CUSTOMER_COUNT
---------------------------------------- --------------
Italy 7780
Singapore 597
Brazil 832
United Kingdom 7557
Australia 831
Japan 624
Canada 2010
Argentina 403
Poland 708
China 712
Germany 8173
United States of America 18520
France 3833
Spain 2039
New Zealand 244
Denmark 383
South Africa 88
Saudi Arabia 75
Turkey 91
I am just getting starting determining how to best use this feature, and this should be enough to get your started.
