ORACLE

  The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-67d4ed983890d497882543/] 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 …

  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 …