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 …

When the database is created or manually increased in size or when it grows with auto growth, it allocates a space over the disk. With …

  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 the database falls into the suspect mode, we can solve this problem by restoring only the corrupted pages instead of  restoring full backup. …

  Sometimes you may want CRS resources to run on other nodes in RAC databases. In this case, you must manually move the relevant resources …

  The fall of the database into the suspect mode is the fearful dream of every dba. It is necessary to take precautions with a …

  When a sequence is queried, the NEXTVAL value is generated from the seq$ table if it is not cached. If it is cacheed, it …

  In some cases, the SQL Server Error Log File grows very fast. And when the file grows too large, it becomes difficult to read. …

  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 …

  You can create jobs on SQL Server to do certain operations at certain intervals. For example, if you want to run a script every …