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
Step by Step Database MySql 8 Installation using Binaries In the previous blog, we have performed MySql 8 installation using YUM Repository click here to read more. In this blog, we are going to perform step by step MySql 8 installation using binaries in OEL 7.9 (Oracle Linux Enterprise). Download MySql 8 tar binary using
How to Extend and Reduce LVM (Logical Volume Management) In the previous blog, we saw How to Configure LVM, click here to read more. In this blog we are going to demonstrate How to Extend and Reduce LVM with pvs command you can see here, we still have 20Gb free space in disk /dev/sdb1, We
How to Configure LVM (Logical Volume Management) in Oracle Enterprise Linux (OEL) In previous blog we have seen How to Install OEL 7.7 Click here to read more. And then Upgraded OEL 7.7 to 7.9 Click here to read more. In this blog post we will add new storage hard-disk in Linux Server to store
How to Upgrade OEL (Oracle Enterprise Linux) 7.7 to 7.9 In previous blog we have look into How to Install OEL 7.7 Click here to read more about it. In this blog post, we are going to perform how we can upgrade Oracle Enterprise Linux (OEL) 7.7 to 7.9. Please note here, we will be
Step by Step Install Oracle Enterprise Linux (OEL) 7.7 In this article, Here we are going to demonstrate step by step installation of Oracle Enterprise Linux (OEL) 7.7. For this demo, we will be using VMware Workstation 15. Click here to download OEL ISO Image. Setup your VM Machine as per your required configuration. Here
Step by Step Drop Database Manually in Oracle Sometimes we need to drop/delete the database, especially for the test and development databases. Usually, we drop test or development database once the application team’s testing completed and this database seems not to be in use. Key Points to remember before dropping the databases. =>
How to Mount Windows Share on Linux using CIFS In this article, we will perform steps on How we can mount the Windows Shared folder on Linux Server using CIFS rpm or use smbclient command to get (for download) or put (for upload) files between Windows and Linux Server. Please note we will be using
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
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
