ORACLE

  In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …

  I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …

  In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …

  Let’s assume that the sql_id of the query that we will improve is “bjyanqt9q718f”. First of all, we run the following procedure and create …

  If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be …

  With the flashback database feature, the hours-long restore-recover process can be completed in a few minutes. You can roll back and open your database …

  RMAN is a tool also recommended by Oracle for backup and recovery. There are many recovery scenarios. The main ones are: Recovering a database …

  There are several methods to delete the disk group from an ASM. It is possible to do this operation with “Enterprise Manager”, asmca and …

  The partition of the disk to be allocated to ASM should not start from the 0th cylinder. You must start at least from the …