ORACLE

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-6a83eee8c8881805998564/] [crayon-6a83eee8c8888166204694/] or [crayon-6a83eee8c888a242894368/] or [crayon-6a83eee8c888b564788967/] …

  In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-6a83eee8c8bec483735718/] [crayon-6a83eee8c8bf2839068459/] [crayon-6a83eee8c8bf4335273072/] [crayon-6a83eee8c8bf6545306152/] …

  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 …

  In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …

  I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …