As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]
Monthly Archives: February 2018
High Water Mark USAGE
Before start this article we must know about “HWM” . After did lots of R&D i found the technical definition Explanation in Detail: (http://www.dba-oracle.com/t_high_water_mark.html) . The high water mark (HWM) for an Oracle table is a construct that shows the table at its greatest size. Just as a lake has a high-water mark after a draught, an Oracle […]
Sosreport on Oracle Linux
The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]
Grid Naming Service in Oracle RAC
When we use Oracle RAC, all clients must be able to reach the database. All public addresses, VIP addresses and SCAN addresses of Cluster must be resolved by the clients.And GNS[Grid Naming Service] helps us resolve this problem. GNS is linked to the domain name server (DNS) so that clients can resolve these dynamic addresses […]
Miscellaneous Oracle RAC wait events
Miscellaneous Oracle RAC wait events 1. gc remaster : resource remastering happens based on 2 situation : 1.When Instance leaves or joins cluster. 2.Dynamic remastering from a less busy instance to an instance where demand for that object is too high.This is also called resource affinity. 2. gc cr grant busy : The gc cr […]
Cloud Computing How do I Look
It’s been long I was thinking to write something about cloud computing, when people around me started talking about cloud computing. “Oh my God here is another buzzword in IT, let’s explore it” this was my first thought. For me it’s a new computing paradigm or IT infrastructure model. If you see the advancement in […]
Database Design – Hardware Requirements
Database Design is the most important part of the IT project. This is the second post regarding Database Design. Normally we just think about software and some basic terms of hardware while we think about the database. Now let’s have deep look at Hardware Requirements. This post explains the technical terms which must keep in mind […]
Rebootless node fencing in Oracle RAC
Oracle Grid Infrastructure 11.2.0.2 has many features including Cluster Node Membership, Cluster Resource Management, and Cluster Resources monitoring. One of the key areas where DBA need to have expert knowledge on how the cluster node membership works and how the cluster decides to take out node should there be a heartbeat network, voting disk or […]
TopicWise Interview Question on Oracle Database
Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]
Determine the process which is locking an Oracle account with incorrect password
As we know all that in the world of technology we have to fill ups user and password name multiple times . We must know what is actually happens while we enter incorrect password. First few lines give some basic idea about the Authentication. Authentication is a process in which the credentials provided are compared to those […]