Application developers sometimes receive a deadlock error and cannot see which queries are deadlocked. That’s why they demand this information from you. We can capture …

  We can see the locks on Library cache objects in V$ACCESS (GV$ACCESS on RAC systems). The dependency on objects is managed by library locks. …

  You may receive this error when you want to import data from a file such as Excel to the sql server. You must install …

  We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details …

We use the WITH ROLLUP and WITH CUBE operators with the GROUP BY statement. So before you read this article, I suggest you read the …

  Creates a checksum value of a data set. You can use it to check if data in a column is being modified. accepts int …

  In RAC databases, serious cluster wait events are seen, usually due to the low speed of interconnect interfaces. Therefore, after the installation, faster hardware interfaces …

  You moved the database to another instance and created a new login for this database instead of moving the login from the old instance …

  This function returns an estimated number of non-null unique values in a data set. It came with SQL Server 2019. Let’s create a table …

  ORA-00313 error can be received depending on any problem in redo log files in standby database. The possible error message will be as follows. …