Basic tests with true cache on oracle database 26 ai
In this article, I’ll continue with some basic tests following my previous post orale-true-cache-installation-on-database-26ai
Thanks to Ulrike Schwinn
To complete the demo, we need to go through the following steps:
Step 1. we need to download the following packages:
db-sample-schemas-23.3.zip
sqldeveloper-24.3.1-347.1826.noarch.rpm
jdk-17.0.17_linux-x64_bin.rpm
- Download jdk-17.0.17_linux-x64_bin.rpm
Step 2. install jdk-17.0.17_linux-x64_bin.rpm & qldeveloper-24.3.1-347.1826.noarch.rpm
install jdk-17.0.17_linux-x64_bin.rpm
Step 3. add /opt/sqldeveloper to the PATH variable
export PATH=/home/oracle/.local/bin:/home/oracle/bin:/usr/share/Modules/bin:
/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/oracle/product/26ai/dbhomeFree/bin:
/opt/sqldeveloper
Step 4. Run the demo schema scripts
After launching the sh_install.sql, only the tables for which the data is not in csv format are populated.
As we can see, all the data provided in csv format, sales.csv, promotions.csv, customers.csv and costs.csv is not loaded
Step5. Load the data using sqldeveloper
Step 6. Let’s proceed with the tests:
Oracle True Cache installation on database 26ai Oracle SQL Firewall in Oracle database 26 ai
About Me
Senior oracle DBA/Developer | 9X OCI Certified | OCP | OCE Sql Certified Expert
