When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …
Read More »
When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …
Read More »During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …
Read More »Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 »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 »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 »