ORACLE

  When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …

  In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …

  If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …

  In some cases, depending on the corruption of the binary files, strange behavior can be observed in the program. It’s possible to encounter strange …

  Indexes are usually not maintained in Oracle databases. But indexes need to be checked regularly. If an index is created and not checked, it …

  When a sequence is queried, the NEXTVAL value is generated from the seq$ table if it is not cached. If it is cacheed, it …

  Application developers may want to kill long-running queries. However, since application developers do not have ALTER SYSTEM privileges, they cannot execute the kill session …

If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …

  When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp …

  When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in …