ORACLE

  For ACFS-9459 errors when you work on ACFS drivers, you can apply the following solution if the version is ‘unknown’. Do not implement this solution in case of errors …

  The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error as follows. ORA-02021: DDL operations …

  It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following steps must be completed before …

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

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

  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. As a solution of this …

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

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

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

  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 shares. If you are trying …