The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …
Read More »
The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …
Read More »When you want to disable the diagsnap feature that introduced with Oracle 12c Grid Infrastructure, ologgerd causes an error like “LoggerD –> Error connecting with …
Read More »In opatch operations, if the corresponding home is not included in the ORACLE_HOME parameter, all opatch related commands cause 134 errors. To avoid this error, …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »Why DBA should pass the Oracle Database 19c OCP exam? DBA should get ready for new features & they should test themselves through latest certification. …
Read More »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. …
Read More »