ORACLE

SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression …

These are the tasks for which DBAs required in a database industry. Defining the database architecture Creating data models Integrating new data sources Tuning business …

Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade, and tune itself. It handles routine database maintenance tasks while the system …

It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with …

Undo tablespace is extremely used during peak times. There is a possibility that some operations may be interrupted if you go uncontrolled. You should regularly …

Why DBA should pass the Oracle Database 19c OCP exam? DBA should get ready for new features & they should test themselves through latest certification. …

Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …

Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …

Oracle attempts  to put a lock on the table with the foreign key if a change is made to the main table with the primary …

Enqueues are shared memory structures that serialize access to database resources.(locks) They can be associated with a session or transaction. HW (high water mark) is …