Oracle Database Version 19c (12.2.0.3) released on date 13-Feb-2019, initially it was available for Oracle Exadata only but on date 25-Apr-2019 it has also made available for Linux/Windows servers. Oracle 19c includes…
Category: Oracle
Different ways to get Oracle Software Release Number/Version Number
Different ways to get Oracle Software Release Number/Version Number: SQL> SELECT version FROM V$INSTANCE; VERSION—————–12.2.0.1.0 SQL> select BANNER from v$version; SQL> set line 200 col version for a15 col PRODUCT for a50 col STATUS…
Oracle 12c R1 New Features For DBAs
Oracle 12c R1 New Features For DBAs : 1: Enterprise Manager and Other Tools Enterprise Manager (EM) Cloud Control home page Enterprise Manager Express home page versus Enterprise Manager Database Control SQL…
Generating Automatic Workload Repository Reports
Generating Automatic Workload Repository Reports: Oracle provide following scripts to produce Automatic workload repository reports . They are similar in format to the statspack reports and give the option of HTML or plain text formats. The…
Introduction of Automatic Workload Repository (AWR)
Automatic Workload Repository (AWR) in Oracle 11g : Oracle has provided many performance gathering and reporting tools time to time. Before oracle 8i UTLBSTAT / UTLESTAT scripts were used to monitor performance…
Automatic Workload Repository Views
Automatic Workload Repository Views : Historical data (snapshot) stored in AWR can be seen using the following views: Thank you for reading …..This is Airy…Enjoy 🙂
Deleting a Node from RAC
Click on Below given link to get the step by step process to Delete a Node from RAC. Deleting-A-Node-from-cluster-By-AIRYDBA Password for opening the document is : Airydba@159 Thank you for reading… This…
Adding 3rd Node in RAC using addnode.sh
Click on Below given link to get the step by step Adding 3rd Node in RAC using addnode.sh: AddNode-airydba Password for opening the document is : Airydba@159 Thank you for reading… This…
CONVERT NON ASM (File System) SINGLE INSTANCE DATABASE TO RAC DATABASE USING RCONFIG: Oracle 11g R2 RAC:
CONVERT NON ASM ( File System ) SINGLE INSTANCE DATABASE TO RAC DATABASE USING RCONFIG: Oracle 11g R2 RAC: For converting standalone to RAC database, both the environments should be running on…
Oracle Local Registry ( OLR ) in Oracle 11g R2/12c
Oracle Local Registry ( OLR ) in Oracle 11g R2/12c : With reference to my previous blog post of GPnP Profile , there are two new additional components have been introduced in…