Discussion of the different types of Oracle data compression and the best usage of each typoe of compression.
While my Blogstypically cover the features associated with Advanced Compression, I thought itwould be useful to discuss In-Database Archiving, an Information...
While my Blogstypically cover the features associated with Advanced Compression, I thought itwould be useful to discuss In-Database Archiving, an Information LifecycleManagement (ILM) feature that is new in Oracle Database 12c and not well known. In-DatabaseArchiving allows users, and applications, to set the archive state for individualrows. Rows that have been marked as archived stay where they are, but are notvisible unless the session is enabled to see archived data. To...
While my Blogstypically cover the features associated with Advanced Compression, I thought itwould be useful to discuss In-Database Archiving, an Information LifecycleManagement (ILM) feature that...
Since this is a blog related to oracle database storage optimization this post is an attempt to explain what we mean by tiered storage. You would think that...
Since this is a blog related to oracle database storage optimization this post is an attempt to explain what we mean by tiered storage. You would think that everyone would have the same definition of tiered storage, but I've found that not to be the case. So, what is tiered storage and how does it relate to an Oracle database storage solution?Tiered storage is the idea of creating different classes of storage with different performance, capacity and price points. The data...
Since this is a blog related to oracle database storage optimization this post is an attempt to explain what we mean by tiered storage. You would think that everyone would have the same definition of...
This post is about Automatic Data Optimization (ADO) and how to tell if your policies are working. It's fairly easy to display ADO policies and even to see if...
This post is about Automatic Data Optimization (ADO) and how to tell if your policies are working. It's fairly easy to display ADO policies and even to see if they've run. It's not quite as straight forward though, to see if anything actually happened. Unfortunately there is no "log" of what events or actions actually occurred when the policy ran. There are a couple of events that can be set, but I've had only hit or miss success with them detailing what actually happened....
This post is about Automatic Data Optimization (ADO) and how to tell if your policies are working. It's fairly easy to display ADO policies and even to see if they've run. It's not quite as...
We get asked the following question about Automatic DataOptimization (ADO) storage tiering quite a bit. Can you tier back to theoriginal location if the data...
We get asked the following question about Automatic DataOptimization (ADO) storage tiering quite a bit. Can you tier back to theoriginal location if the data gets hot again? The answer is yes but not withstandard Automatic Data Optimization policies, at least not reliably. That'snot how ADO is meant to operate. ADO is meant to mirror a traditional view ofInformation Lifecycle Management (ILM) where data will be very volatile when firstcreated, will become less active or cool,...
We get asked the following question about Automatic DataOptimization (ADO) storage tiering quite a bit. Can you tier back to theoriginal location if the data gets hot again? The answer is yes but not...