During an SQL performance and tuning training session, in a middle of partitioning chapter, a student ask me: Wait a minute, how rows are stored when we have partitions… Read more »
Based on a simple test from Chris Antognini [code language=”sql”] Table CUSTOMERS Name Null Type ————— ——– ———— CUST_ID NOT NULL NUMBER PK CUST_FIRST_NAME NOT NULL VARCHAR2(20) CUST_LAST_NAME NOT NULL… Read more »
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 11.2.0.4 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.    Seguir a… Read more »
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 »
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 »