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 credentials. Nowadays, it is broadly used for securely accessing web…
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 Flashback features. This post delves into the UNDO management, exploring…
Local UNDO in Multitenancy
With the introduction of Oracle Database 12c, the multitenant architecture allows multiple pluggable databases (PDBs) to coexist within a single container database (CDB). In Oracle Database 19c, a significant enhancement…
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. Broadly speaking, it paves the way to the following Oracle…
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 the process of modifying the undo tablespace in Oracle 19c.…
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 appropriate actions to optimize space usage. It works by analyzing…
Squeezing More from Your Oracle Database: A Deep Dive into Table Compression
As databases grow in size, so does the need for effective strategies to handle this growth. This is where data compression, including table compression, comes into play. Data compression is…
Shrinking fragmented free space on Oracle tables
Oracle tables can become fragmented due to excessive Data Manipulation Language (DML) operations such as insert, update, and delete. When rows are inserted into a table, the High Water Mark…
Getting objects definition in PL/SQL.
SQL Developer is a powerful and user-friendly tool that greatly simplifies the work of database administrators. It provides a graphical interface for database management and development, making it easier to…
Writing to the alert log from PL/SQL with DBMS_SYSTEM.ksdwrt
Writing to the alert log from PL/SQL in Oracle Databases can be a convenient way to monitor significant events or errors that occur during database operations. For example, you could…