View All Hidden Parameters: View a Specific Parameter:
Last day, while trying to flashback a test database (12.2) to a restore point, I got the following errors: ERROR at line 1: ORA-38754: FLASHBACK…
The Error: Of course the problem might always be due to actual wrong password or the lack of password file. However, in some strange circumstances…
You would most probably get the ORA-1804 error when you try to set time zone on a session like: Or you may get the ORA-1804…
First, let’s create our own audit log table to track the info about the host and time of the attempt: Then create the trigger: Now,…
Starting with the Oracle Database version 12.2, during the materialized view refresh, the below temporary tables are being created: This mechanism is implemented to address…
Database post 12.2 upgrade issue due to Scheduler Autotask running duplicate jobs during maintenance windows and increased resource consumption is observed: According to MOS Doc…
The RMAN “DUPLICATE TARGET DATABASE TO <auxdbname> FROM ACTIVE DATABASE” command fails from time to time… The research revealed a strange buggy behavior explained in…
The RMAN log look like something: Look into the alert log and see if you can find something related with memory: If yes… To fix…
While trying to drop a materialized view, the session waits on the following query: This wait is due to usage tracking enabled for MVIEW operations…