1.Configuring Shared Global Area (SGA) in a Multitenant Database
David Kurtz shared, “I have been working on a PeopleSoft Financials application that we have converted from a stand-alone database to be the only pluggable database (PDB) in an Oracle 19c container database (CDB). We have been getting ORA-4031 (unable to allocate shared memory) errors in the PeopleSoft application.
It has taken a while to solve and test.”
2. The Future of Generative AI: What Enterprises Need to Know
Greg Pavlik asks:
- What enterprises really need from generative AI
- How are we delivering these capabilities?
3. Oracle Statistics Gathering Timeout
Neil Chandler writes, “Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort, and takes place automatically in scheduled windows, both overnight or at the weekend. These windows have a limited duration, and if there’s a lot of data to analyse to get the requisite metadata, it may run out of time.”
4. Data Compare in Toad for SQL Server
Ryan Crochet shares this video:
5. Will I lose my existing AUDIT settings in 23c?
Connor McDonald shares this:
This blog shares the problem ‘While running command in GGSCI, I received the following messages’ and the solution.
7. RMAN: Archivelogs, the UNTIL clause – expectations vs. reality
Marco Parchaly-Mischke apologises for the lengthy title!
Then goes onto say, “Yesterday I was implementing a disaster recovery solution. The solution consists of a database copy, a process that transfers archivelogs from the original database and a process that applies the archivelogs to the copy. Dataguard would do that much better, but the system is running on Standard Edition 2, so no Dataguard at all. The solution worked quite well until I wanted to introduce an apply delay yesterday. That would mean, I still ship archivelogs on a regular basis but apply them only until a specific point in time. Assuming all archivelogs are present at the DR site, that is quite easy using RMAN.”
8. Embedding Machine Learning Models in the Oracle Database: Create an ONNX model
This post starts with, “This post is the first of a three-part series where I’m going to show you how to use pre-configured machine learning models to embed vectors into the Oracle Database. Before I dive into how to load a pre-trained machine learning models with ONNX, it is helpful to know what is an ONNX file? And how do you create one to use with the Oracle Database.”
9. How to change admin password in Apex 23.2
This post goes through how to change the admin password in Apex 23.2
10. How To Add The Datafile To Tablespace
This blog discusses the question of how to add a data file to the tablespace in Oracle.