I had a customer who complains about performance issues on one of the oracle production database. Environment Oracle Database 12c R1 (18.104.22.168) on Linux with Oracle RAC (two nodes). To start with, I collected some AWR reports around the complain time, and I found the top wait events (most of the time) as follows: So, … Continue reading Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”
Oracle Database 22.214.171.124 Release Updates (RUs) and Release Update Revisions (RURs)
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 12cR2 (126.96.36.199) since Jul-2017 till today 20-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that: - Both RU & RUR are released quarterly (Jan, April , Jul & … Continue reading Oracle Database 188.8.131.52 Release Updates (RUs) and Release Update Revisions (RURs)
Oracle Database 12c: Performance Management – Question 20
Oracle Database 12c: Performance Management – Question 13
Oracle Database Security Assessment Sample Report
Highly Confidential Assessment Date & Time Date of Data CollectionDate of ReportReporter VersionSun Apr 25 2021 00:12:00Sun Apr 25 2021 00:22:012.2.1 (May 2020) - f3a1 Database Identity NameContainer (Type:ID)PlatformDatabase RoleLog ModeCreatedORCLCDBPDB1 (PDB:4)Linux x86 64-bitPRIMARYNOARCHIVELOGMon Jan 13 2020 20:12:00 Summary SectionPassEvaluateAdvisoryLowRiskMediumRiskHighRiskTotalFindingsBasic Information0000011User Accounts70222013Privileges and Roles156100022Authorization Control0020002Fine-Grained Access Control0050005Auditing08500013Encryption0110002Database Configuration92010113Network Configuration0110103Operating System2200105Total33201734279 Basic Information Database Version Oracle … Continue reading Oracle Database Security Assessment Sample Report
ORA-03113 when running a specific query
I got a question from one of my clients that he has a query that he used to run it successfully on Oracle Database 10g,but when he run the same query on Oracle Database 184.108.40.206, the query failed and the connection dropped with the following errors: He confirmed many times that the same query with … Continue reading ORA-03113 when running a specific query
When to use SET DBID in RMAN?
According to oracle documentation:Specify a database's database identifier (DBID) when restoring a control file or server parameter file. Restrictions and Usage Notes for the SET DBID Command You should only run the SET DBID command in the following specialized circumstances: You are not connected to a recovery catalog and want to restore the control file … Continue reading When to use SET DBID in RMAN?
Change “Value” Column Width for “show parameter” in sqlplus
If you tried to increase the width of the "VALUE" column, nothing changed: I found that the NAME & Value columns have special names (for type column , it is normal): column NAME_COL_PLUS_SHOW_PARAM format A20column VALUE_COL_PLUS_SHOW_PARAM format A80 Now, it is fine.
Schedule RMAN Backup Job in one minute
In this demo, I'm going to schedule a backup job to run daily at a specific time. The backup script provided in this video is for demo only, please don't use it in production without proper testing. https://www.youtube.com/watch?v=sNQXBiOpPUk RegardsAhmed
Oracle Fail Safe 4.2.1 Implementation Plan on Windows 2016 and Oracle 12cR2
Following is the high level plan of Fail Safe 4.2.1 implementation on Windows 2016 and Oracle Database 12cR2 (220.127.116.11). System Administrator Activities: Database Administrator Activities: ThanksAhmed