ORACLE

  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. …

  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 …

  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. …

  The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …

  Result Cache is the memory space in the shared pool area within the Shared Global Area (SGA). In this memory area, the database query …

  We can also display the execution plan with sqlplus. For this we can use the explain plan tool with sqlplus. To use the Explain …

  When you try to get a backup with Expdp, if the process ends with error ORA-01426: numeric overflow, there are some alternative solutions. During …

  If we are trying to drop the redo log group created for a thread that is active and if the drop operation of redo …

We can query all the information about the cellnodes on Exadata from any database. It is possible to query information from v$cell_config. With this view, …

  Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use …