How to Find Last Analyzed date on Tables, Partition, and Subpartition in Oracle

Find Last Analyzed date on Tables, Partitions, and Subpartitions in Oracle Here we are going to demonstrate how to find the last analyzed date on tables in Oracle. Some time…

Basic Linux Commands For Daily Usage

A Handy Guide for Basic Linux Commands Linux, an open-source Operating System is one of the most popular operating systems which takes inputs in the form of commands to direct…

Target Blackouts in OEM13c using EMCTL

Target Blackouts in OEM13c using EMCTL In the literal sense, A blackout is a temporary condition that affects your memory. It’s characterized by a sense of lost time. In terms of…

Step by Step manually creation of an Oracle 19c Database

Step by Step manually creation of an Oracle 19c Database on Linux 7 In the previous article, we have demonstrated Step by step silent installation of oracle 19c on Linux 7, …

The last 10 startup times of the database along with timezone in Oracle Sometimes we have to find when the database is started with which timezone especially when the database…

How to Find Sessions in RAC Oracle All in One

How to Find Sessions In RAC Oracle All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to…

Step by step silent installation of Oracle 19c on Linux 7

Step by step silent installation of Oracle 19c on Linux 7 As everyone is aware of the oracle database installation. oracle database installation can be done through 2 methods. Here…

Solution for Error ORA-29289 Directory Access Denied in Oracle

Error ORA-29289 Directory Access Denied in Oracle Sometimes application users have DIRECTORY details like name of DIRECTORY of a database but not having proper privileges (READ, WRITE) on DIRECTORY and…

How to find Privileges on Directory in Oracle

Find Privileges on Directory in Oracle Oracle has introduced the concept of DIRECTORY which is a type of object and introduced in Oracle version 8.0. DIRECTORY is a logical structure…

ADD-DROP Redo log files in Oracle Database

ADD-DROP Redo Log Files In Oracle Database In the real world, we may encounter scenarios where we need to or asked to increase/decrease the size of redo log files as…