0 Comments

How to Check Retention Period of AWR Snapshot in Oracle 0 (0)

How to Check Retention Period of AWR Snapshot in Oracle AWR (Automatic Workload Repository) is a key to diagnose the performance of Oracle database, AWR collects various types of processes along with maintains statistics of database performance. Below is the SQL command to Check the Retention Period of AWR Snapshot in Oracle. We always encourage the technical […]

 41 total views

0 Comments

How to Find User’s Privileges in Oracle 0 (0)

How to Find User’s Privileges in Oracle In this article, we are going to find all forms of privileges of users in Oracle.  Commonly users have the below types of access in databases which are important to perform day-by-day activities according to their roles & responsibilities. System Privileges Role PrivilegesObject Privileges  Privileges are authentication to execute any activities in the database […]

 119 total views,  1 views today

0 Comments

How to Setup Passwordless SAMBA Share in Linux for Windows Server Access 0 (0)

Setup Passwordless SAMBA Share in Linux for Windows Server Access In this article, we will perform the required steps to setup Passwordless SAMBA Share on Linux Server. This can permit everyone on a windows machine to get entry to this without a set off for password. This form of requirement generally comes from the Window […]

 207 total views,  1 views today

0 Comments

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

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 due to performance issues, statistics locked on the table, disable statistics in the database, before/after manual analyze on tables or gather statistics, before/after migration, etc. […]

 147 total views

2 Comments

Basic Linux Commands For Daily Usage 4.5 (2)

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 a computer program to perform a specific task. To use this Operating System we need to get familiar with the commands to navigate between directories, […]

 499 total views,  3 views today

0 Comments

How to check the last 10 startup times of the database along with timezone 5 (1)

The last 10 startup times of the database along with timezone. Sometimes we have to find when the database is started with which timezone especially when the database is getting reboot unknowingly. The below query gives the output of the last 10 start times of the database along with the timezone, Click here for sample […]

 348 total views

0 Comments

How to Find Sessions in RAC Oracle All in One 5 (2)

To Find Sessions In RAC All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to monitor application connected sessions, etc. Here we are going to show various scenarios to find connected sessions in RAC databases. Here we have a two-node RAC to […]

 643 total views,  3 views today

0 Comments

Solution for Error ORA-29289 Directory Access Denied in Oracle 5 (1)

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 received error “ORA-29289″ directory access denied”. Thanks to one of my application users who did the same mistake yesterday and encourage to me elaborate here […]

 535 total views,  1 views today

0 Comments

How to find Privileges on Directory in Oracle 0 (0)

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 that presents a physical directory on the database server’s file system.DIRECTORY  can be used in DATAPUMP, PL/SQL block, UTL_FILE packages, etc In Oracle. Below is […]

 164 total views,  2 views today

4 Comments

ADD-DROP Redo log files in Oracle Database 5 (4)

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 log switches creating contentions at the database. For example, by increasing the redo log file size, the number of log switches can be decreased which […]

 725 total views,  5 views today