RAG with Langchain and Oracle Database – Part II Providing memory to the agent.
Continuing from our previous post, we can see that the agent we defined is unable to remember our previous conversation,…
RAG with Langchain and Oracle Database
The recent arrival of Generative AI in the database world will revolutionize data interaction and utilization. These models can understand…
Backing Up Partitions Using RMAN
While RMAN (Recovery Manager) in Oracle Database does not support backing up individual partitions directly, you can effectively back up…
Understanding Partitioned Tables in Oracle Database
Partitioning tables is a powerful feature in Oracle Database that can significantly enhance performance and manageability for large datasets. By…
OAuth2.0 client authentication from PL/SQL
OAuth 2.0 is an open standard for authorization used for granting applications limited access to user resources without exposing their…
Understanding and Managing UNDO Segments in Oracle Database
In Oracle Database, the UNDO segment enables data consistency and supports various database operations, including transaction rollbacks, read consistency, and…
Local UNDO in Multitenancy
With the introduction of Oracle Database 12c, the multitenant architecture allows multiple pluggable databases (PDBs) to coexist within a single…
Managing Undo Data: Transactions and Undo Segments
Undo data plays a key role in maintaining data consistency, providing read consistency, rolling back transactions, and recovering the database.…
Resizing the Undo tablespace
As your database grows and evolves, its undo tablespace needs might change too. In this post, we’ll guide you through…
Mastering Oracle: A Practical Guide to the Segment Advisor
The Segment Advisor in Oracle 19c is a powerful feature designed to identify inefficient segments within your database and recommend…