ORACLE

With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table …

Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …

What is Oratab Oracle creates a record for each Oracle RAC database in the oratab configuration file. The oratab file is created by the root.sh …

If there is a difference with the db_name parameter when opening the Oracle database, you receive an error as follows. “ORA-00205: error in identifying control …

ORA_ROWSCN returns the SCN information for the last modified date of the row for each row in a table. You can use this pseudo-column to …

Static Data Dictionary Views These are new static data dictionary views which are introduce in Oracle Database Release 19c. ALL_TRIGGERS_AE DBA_TRIGGERS_AE USER_TRIGGERS_AE DBA_AUTO_INDEX_CONFIG DBA_AUTO_STAT_EXECUTIONS DBA_PDB_SNAPSHOTFILE …

It is possible to convert SCN (system change number) to date and date to SCN in Oracle databases. This allows us to find out when …

In Oracle databases, over time, indexes are fragmented and cause serious performance issues. We should check the indexes regularly and rebuild them if necessary. Determine …

If the password file format in the 12c databases is same with the format in the 11g databases, you receive the error “ORA-28017: The password …

You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-67429c2392ce3599350705/] The reason for this error is that …