ORACLE

  In order to change the size of the Redolog files, it is necessary to create redolog files of the desired size and drop the …

  If Redo Log Switch count is too much, you can increase the redo log sizes if you need. However, the larger the Redo Log, …

SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …

A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …

  In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-6742c415a0cfc456496224/] [crayon-6742c415a0d00226927582/] or [crayon-6742c415a0d02271059432/] or [crayon-6742c415a0d03452724437/] …

  In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-6742c415a1058911586891/] [crayon-6742c415a105c460365771/] [crayon-6742c415a105d667899132/] [crayon-6742c415a105f551509718/] …

  Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …

  If the connection breaks  and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …

  OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …

  Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …