|
||||
|
When a query is issued against an Oracle Real Application Clusters (Oracle RAC) database with multiple nodes, the parallel processes may be spawned on different nodes. This approach is used to ensure that no one node becomes overloaded and that the processing power of all nodes is utilized as efficiently as possible. However, under certain […] Updated answers Hello All, My best wishes for Christmas and upcoming new year to you all! This year has been very promising to me via this blog which earned me a lot of good friends and fellow DBA’s, indeed I have a learnt a lot too via this channel. I recognized that the journey of this blog […] A note on tracing when you have dataguard environment, Use the following useful SQL SELECT group#, member FROM v$logfile WHERE type = ‘STANDBY’; SELECT group#, dbid, archived, status FROM v$standby_log; SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest; SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#; SELECT name, value, time_computed FROM v$dataguard_stats; SELECT […] Opatch: Enable/disable the one off oracle patch to all of the databases using opatch util Problem: ======== Consider this situation, 1) You have Shared Oracle Home 2) 2 Databases running 3) You need to apply a patch for one databases only Many of us know once we apply the patch to a home this […] Hello Updated 11g Rac questions and answers and enabled link at Interviewquestions page. Want to know new features in 12c, 18c, 19c, 20c ??? Follow this http://db.geeksinsight.com/category/12c-database/ http://db.geeksinsight.com/category/18c-database/ http://db.geeksinsight.com/category/19c-database/ http://db.geeksinsight.com/category/20c-database/ click here Oracle DBA Course Oracle 12c New Features Course Oracle 12c RAC Administration Training Oracle ASM Course Oracle Dataguard […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!