Hi there, I got an interesting question during a SQL performance and tuning training session from one student. In this simple query select name from A union all select… Read more »
Here is an interesting tips in 220.127.116.11 and later (tested also in 12c), Simple example that shows Query rewrite using a materialized view. sqlplus scott/tiger SQL>create materialized view TEST_MV2 enable… Read more »
You can use the dbms_feature_usage_report.display_html procedure to display feature usage statistics. SQL>SELECT output FROM TABLE(dbms_feature_usage_report.display_html); Note: The feature usage statistics is updated during maintenance windows.
While evaluating the 12c beta3 I was not able to do the recover while testing “all pdb files lost”. Cannot close the pdb as the system datafile was missing… So… Read more »
Here is a full upgrade steps log from bundle 2.3 to 2.4 and at the end, the CPU reconfiguration from 12 to 2 per node. The patch number is: Patch… Read more »
Warning!: the following article will present Stretched cluster functionality using 2 VMWAre Esxi servers. This is NOT the Oracle supported configuration. Do NOT implement this solution for a productive environment…. Read more »
Purpose Maximum Availability Architecture is the concept of getting the absolute most of available resources to a service. We can distinguish two concepts that generally are in the loop:… Read more »
ASMLib is Simple to implement and makes disk management more easy, BUT, if you upgrade your system then you enter into troubles. The example will use iSCSI target to define… Read more »