I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about Oracle Statspack. We are going to learn what is Oracle Statspack? how does it work, why do we need of Oracle Statspack? Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. […]
Monthly Archives: July 2017
Top 10 new Features of Oracle 12c Release 2
Hello Everyone, As I was going to Oracle through Oracle 12c release 2 documentation, I came across following important new features. This is not the complete list, there are many more new features came out with Oracle release 12c release 2. Multi-Instance Redo Apply : With Oracle 12c Release 2, you can apply redo logs to […]
Oracle RAC: Applying and Removing PSU in Database Home with Conflict Detection on Oracle 12c
In this article we will present how to apply and reverse a PSU applied to Database Home on a node with the conflict resolution method. To do this you need to have at least a 2-node RAC Database. If you want to patch on Grid Infrastructure Home in Oracle 12c then click here Our test environment: Grid […]
Oracle RAC – Applying and Removing PSUs in Grid Infrastructure Home with Conflict Detection (12.1.0.2.0)
In this article we will present how to apply and remove PSU in Grid Infrastructure Home on only one node using the conflict resolution method with roll forward method. To do this we need a RAC of at least 2 nodes. If you want to patch on Database Home in Oracle 12c then click here […]
Monitoring changes to Oracle tables
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The main purpose of this type of monitoring, in my opinion, is to know the most altered tables, the amount of changes in these tables since the last collection of statistics. Why since the last collection of statistics? Because every time a […]
Procedure for authorizing and disallowing users in Oracle Database Vault Realm
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have look at the document the procedure required to authorize a user as a participant in the Oracle Database Vault Realm and then disallow it. All this procedure is possible through Enterprise Manager, but as it is […]
Rebuilding / Moving MGMTDB on Grid Infrastructure 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically: [root@rac1 ~]# crsctl […]
Deleting diskgroup via asmcmd
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups: [oracle@london1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block […]
Difference between Oracle DBA and Oracle Apps DBA
Normally people start their journey from a software engineer in Information Technology. We all are aware of few fields of IT like testing engineer, data analyst, software engineer, web designer, coder etc. But in information-technology, we have an ocean of different kind of professions. In IT sectors administration plays an important role in business. without an administrator, IT projects can not […]
Introduction to Oracle AWR
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Today let’s talk a little about a fantastic feature we have in Oracle Database that helps us in performance analysis: the AWR. What is AWR? AWR stands for Automatic Workload Repository, ie it is a repository of information about the […]