When we have a performance problem in the database, the first thing we do is to list current queries using dmws. You can find …

  You can specify the date format that the corresponding session accepts with “SET DATEFORMAT”. You may need this command if you want to assign …

  Events that are automatically recorded when a problem occurs on the Exadata cell node must be cleared when the problem is corrected. The cleaning …

  Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server …

  The CAST and CONVERT functions are conversion functions. We use these functions to convert a data type to another data type. Of course, every …

  After installing Oracle clusterware, we often ask the following question. What is my Oracle Cluster Name? In RAC systems, we can query the cluster …

  You may need to uninstall a replication that you previously installed and drop the database. You may receive an error if you want to …

  The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …

  When a table containing a CLOB column is queried with a dblink from a remote database, it returns an error as ORA-22992. A table …

  If you want to delete the database, you will get this error if there is an open session on the database. First, set the …