|
||||
|
Hello All, Thanks to Natik for visiting my blog and update about their website, indeed very informative & nice content on Oracle Goldengate, Oracle 12c Features and some more. Here is some background of this website:- Natik Ameen is one of the VitalSoftTech’s Oracle Internal Experts. He is an Oracle Production DBA, Certified RAC Expert […] Quick Question: Is it possible to have Standby Database on different platforms? i.e Windows (Primary) –> Linux (Standby) Answer: Yes, From 11gr2 onwards. You can have different Operating Systems on primary and standby. Note: From 10g onwards, Different endian support i.e Linux 64bit(Primary) –> Linux 32bit (Standby) is possible but not different platforms. How […] My friend has asked this question today as he got the same in one his interview… The common answer we give is from any base table as v$database (current_scn) is populated by any base table. However the base table is $KCCDI under column DICUR_SCN is current SCN. you can find this by querying the v$database […] How many you know this structure at first glance, I am sure the old DBA junkies will say what this called immediately, but for those who does not know this diagram is called Network OSI diagram for Oracle and layers between client and database servers and how oracle connects. Oracle uses different methods […] Really, about 460 slides on just upgrades, all information about upgrade matrix, upgrade paths, references etc etc. A must read for all. https://blogs.oracle.com/UPGRADE/entry/new_version_of_slide_deck?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+orana+(OraNA) I will also upload the same soon. -Geek DBAGeek DBA Configuring RACONENODE in RAC database. We all know that Oracle RAC is active/active configuration, but due to application compatibility (the design part like cache fusion incompatibilities etc) you will need to stick to active/passive configuration but you want High availability solution and you do not want to use any third party clustering like VCS, Answer […] Using psrset, we can assign specific cpu’s as a group and assign specific processes to that processor set. This is useful in RAC where there node evictions due to CPU scheduling delays or CPU bottlenecks are high, we can assign the critical process like cssd, crsd, ohasd etc, so that CPU is always available to […] The key difference Guaranteed restore point does not need explicitly flashback on, where in the normal restore point does Guaranteed restore point requires less I/O as compared to the normal restore point due to the fact that flashback log maintains only one copy of block image before it get modified. where in the normal […] Hello All, This post is off the topic from Oracle which I generally not do in my blog, But I have to do this as I met my childhood teacher and wondered he has done a great work by creating a website for Telugu and trying to website as a medium to get the popularity […] Hello, You might be wondering about no posts in my blog. But the fact is am busy learning BigData and praticising and preparing a tutorial content in my new subdomain blog. http://bigdata.db.geeksinsight.com So far three lessons have been posted on Bigdata Hadoop Fundamentals, if you have missed to see them here are they, Hadoop Overview […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!