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 …
Read More »ORACLE
Oracle Database 19c New Static Data Dictionary Views
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 …
Read More »How To Convert SCN to Date and Date to SCN in Oracle
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 …
Read More »When To Rebuild an Index in Oracle
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 …
Read More »ORA-28017: The password file is in the legacy format
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 …
Read More »“ORA-7452: resource plan ”” does not exist” occurred during upgrade from 11.2 to 12.2
You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-6628aeefab1b2269460178/] The reason for this error is that …
Read More »[INS-06006] Passwordless SSH connectivity not set up between the following node(s)
When running Database Configuration Assistant (dbca) on Exadata compute nodes, you will receive this error if all nodes cannot connect to each other without password …
Read More »How To Enable and Disable Unified Auditing Feature in Oracle
Enable Unified Auditing Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows. First, …
Read More »“gc buffer busy acquire” Wait Event in AUD$ insert operations
Because the segment space management of the tablespace of the AUD$ and FGA_LOG$ tables is not automatic, a “gc buffer busy acquire” wait event can …
Read More »How To Move AUD$ and FGA_LOG$ to a Different Tablespace
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 »