ORACLE

  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 …

  HI Guys, We were put in a Situation that we had to Create the New data files  for the tablespaces in the RECO diskgroup …

  If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …

  The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …