ORACLE

  Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …

  We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …

  In busy databases you may encounter this wait event. The general reason is the low redo log I/O performance or the slow interconnect connection. …

  The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-6742bebc35d5d835743556/] If …

  Oracle ASM Cluster File System (ACFS) is used to create a cluster file system via ASM. The created file system will use the space …

  There are many tables and views in Oracle database that we can get information about with locked objects. You can access a lot of …

  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 …