ORACLE

  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 …

  It is possible to export the data in tables in the database in csv format depending on a specific condition. We can use the …

  It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from …

  When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary …

  In Oracle databases running on Linux, you can access the relevant session information from each user processes. In most cases, it is necessary to …