Oracle Clusterware 12cR1 with Flex Cluster and GNS on Oracle Linux 6 (Virtual Box)

Introduction When I started this installation I configured DNS before, there are some interesting points that we have to have in mind because it could take some time to resolve them. I will focus on the Network Prerequisites (DNS and DHCP) if you configure both of these the next process’s going to be very easy … Continue reading Oracle Clusterware 12cR1 with Flex Cluster and GNS on Oracle Linux 6 (Virtual Box)

Configuring DNS and DHCP to use on Oracle Grid Naming Service

Configuring DNS and DHCP to use it on Oracle Grid Named Service This configuration will be on the same server Oracle Linux 6, I installed just to ensure that Oracle clusterware will be working fine with GNS option, so if there is any subjection about this configuration let me know. As of now it is … Continue reading Configuring DNS and DHCP to use on Oracle Grid Naming Service

How to find and execution plan and SQL ID for a SQL statement?

  This time I will show you how to get the explain plan and SQL_ID from a query statement. If we have the SQL statement we just need to run it and then execute the following query: select plan_table_output from table(dbms_xplan.display_cursor(null,null,'all')); The display_cursor function return the execution plan that is allocated on the SQL area. … Continue reading How to find and execution plan and SQL ID for a SQL statement?