Oracle Enterprise Linux OEL 7.6 Installation

How to Set up Oracle Database Server on VMware Workstation using( OEL) Linux 7.6 OS Platform?     1.Download Vmware Workstation Pro 2.Download LINUX 7.6 iso files 3.install LINUX 7.6     1.Download and Install latest Vmware Workstation Pro on Windows 10 Machine.         LOCATION:     LINK:   https://www.vmware.com/in/products/workstation-pro/workstation-pro-evaluation.html     2.Download […]

Oracle Listener   The Databases/services needs to be registered with listener in order to establish connection.There are two types of registration Namely    1.Dynamic Registration  2.Static Registration   Dynamic registration : As the name suggests,dynamic means the Database/Service registration is done Automatic. As soon as the listener is started Automatically the dynamic registration happens which […]

SQL Tuning Advisor – Performance Tuning SQL Tuning Advisor How to run SQL Tuning Advisor Manually SQL Tuning Advisor is SQL diagnostic software in the Oracle Database Tuning Pack. SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing SQL statements. Use SQL Tuning Advisor to obtain recommendations for improving performance of […]

Oracle Explain Plan – Performance Tuning 1. Creating a Plan Table The first thing you will need to do is make sure you have a table called PLAN_TABLE available in your schema. The following script will create it for you if you don’t already have it: export ORACLE_SID=PrimeDG sqlplus / as sysdba @?/rdbms/admin/utlxplan.sql   2. […]

How To  Generate an ADDM Report? ADDM (Automatic Database Diagnostic Monitoring) Report: Automatic Database Diagnostic Monitoring Report analyzes the AWR data on a regular basis, to give you overview of the root cause of the problem which is affecting your database’s performance. It also provides suggestions or recommendations for rectifying any problem identified and lists […]

How to generate AWR report from Oracle Database?   AWR (Automatic Workload repository) Report: Automatic Workload Repository gathers, processes and maintains performance stats used for problem detection and self-tuning the databases. This collective information can be displayed as views and reports (HTML/text) to better show the current database performance status for further analysis.     […]

How to generate an ASH report from Oracle Database?   ASH reports give a quick glance of how the database has performed between two snapshots. It mainly highlights the following areas: Top User Events (frequent wait events) Details to the wait events Top Queries Top Sessions Top Blocking Sessions Top DB Objects Activity Over Time […]

How to duplicate 19c database on remote server Using RMAN’s Active Duplicate feature?   Task: Task is to clone a database called TESTDB to CLONEDB using RMAN’s Active Duplicate feature.   Source and Destination is as follows: Subject Source Destination IP Address: 192.168.0.197 192.168.0.198 Database Name: TESTDB CLONEDB Database Status OPEN Not Available yet Database […]

Oracle Database schema Refresh Activity ?   Solution: No. Description Command / Screenshot 1 Find the size of the schema . oraenv → BATCH46 sqlplus / as sysdba To find the size of the schema, execute the following:   COL OWNER FORMAT A15 SELECT owner, tablespace_name, round(Sum(bytes)/1024/1024,2) AS SIZE_in_MB FROM dba_segments WHERE owner like Upper(‘&User_Name’) […]

Oracle 19c Database Installation (on Oracle Linux 7.6) on VMware Workstation   Section-1   Download and unzip Oracle 19c Software Create a staging directory # Description Command / Details / Screenshots 1.1 let’s create a staging directory for all oracle software Login to server as oracle 1.2 Create a new staging directory What is the […]