In Part I and Part II, we looked at how to index specific attributes within a JSON document store within an Oracle 12c database. But what if we’re not sure which specific attributes might benefit from an index or indeed, as JSON is by it’s nature a schema-less way to store data, what if we’re not entirely sure […]
I have been working with Oracle database performance for many years now, but for me it is time to make a change. Today I start with an exciting new and nimble company MemSQL.
MemSQL offers a new approach to real time analytics with lock-free data structures, in-memory row store, and column store. MemSQL can perform Real-Time analysis as well as pull data from traditional EDW or Hadoop.
In part 1 the basics were explained. In this part II other topics will be treated. This post will treat topics like virtualizing, engineered systems, SE2, Unlimited License Agreements, Cloud and other stuff. Whenever I can I will link to other posts. Comments or additions are welcome. The information in this […]
I recently posted a 4-part blog series that aims to inform readers that, in an All-Flash Array environment (e.g., XtremIO), database and systems administrators should consider opting for simplicity when configuring and managing Oracle Automatic Storage Management (ASM).
An invalid entry in the spfile may prevent the instance from starting up:
SQL> alter system set sga_target=500m scope=spfile;
SQL> shutdown immediate
ORACLE instance shut down.
ORA-00821: Specified value of sga_target 512M is too small, needs to be at least 1392M
The instance doesn’t come up! This is easy to fix without having to restore the spfile from backup:
My recent post about adding space to ASM disk groups by resizing them larger, as opposed to adding more disks, did not show a Real Application Clusters example. Readers’ comments suggested there is concern amongst DBAs that resizing disks (larger) in a RAC environment might somehow be more difficult than in non-RAC environments. This blog entry shows that, no, it is not more difficult. If anything is true it is that adding disks to ASM disk groups is, in fact, difficult and invasive and that resizing disks–whether clustered systems or not–is very simple.