ORACLE

  Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which …

  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 …

  The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error …

  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 …

  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-676d15f427193846599596/] 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 …