ORACLE

  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 …

  Note: These tips were based on upgrades from 11.2.0.4 to 12.1.0.2 (Linux and Solaris ONLY) OS user grid was the “owner” of the Grid …

You can query errors in Alert.log by sql query. You can use the following queries for this. The following query returns with 20 rows.   …