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 online into a partitioned structure …

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 like gather stats of objects …

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 script during installation and is …

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 file, check alert log for …

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 determine last update date of …

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 DBA_RAT_CAPTURE_SCHEMA_INFO DBA_REGISTRY_BACKPORTS DBA_SQL_QUARANTINE   ALL_TRIGGERS_AE  …

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 a specific change in the …

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 an index needs to be …

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 file is in the legacy …

You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-600c07dea4d4b721497646/] The reason for this error is that the resource_manager_plan value was set …