» Kent Hinckley

For more than 20 years, Kent has owned and operated a small consulting company specializing in Oracle-based systems. Over the years, He has worked on a variety of database applications for both small and large companies as a designer, developer, and DBA of small and large database systems.

During that same period of time, he has worked for Learning Tree International as a course author, technical editor, and instructor specializing in Oracle and SQL Server. He is an experienced user and trainer for Database Administration, SQL, PL/SQL, T-SQL and related language services. He carries both the Oracle Certified Professional (OCP) and the Learning Tree International certifications.

He has been on the Board of Directors or the conference committee for the Independent Oracle Users Group (IOUG) for 18 years. He has been a speaker at Oracle OpenWorld, IOUG Live, and Collaborate for most of those 18 years.

How to Implement Temporal Validity in an Oracle Database

Jul 5, 2017

Kent Hinckley

Overview of Temporal Validity Temporal Validity is also referred to as Valid Time Support. The objective is to allow tables to have one or more valid time dimensions. That is, the data is visible (“valid”) depending on its time-based validity. The valid time is determined by start and end dates or timestamps of a valid […]

Oracle

Data, Flashback Archive, ILM, Oracle, Session-level control, Table, Temporal Validity, Valid Time, Valid Time Support

How to Manage the Flashback Data Archive

Jun 15, 2017

Kent Hinckley

In this post, we will continue with the theme of Information Lifecycle Management (ILM). Through ILM, I will be discussing how to successfully manage the Flashback Data Archive. Maintaining the Flashback Data Archives To add space to an existing archive: ALTER FLASHBACK ARCHIVE two_year_archive ADD TABLESPACE archive_two QUOTA 2G; To change the retention time: ALTER FLASHBACK ARCHIVE two_year_archive […]

Oracle

DDL restrictions, flashback data archive, ILM, Oracle, temporal history

How to Use Temporal History in Oracle 12c to Track Changes Over the Lifetime of a Table

May 24, 2017

Kent Hinckley

In this posting, we are continuing with the theme of Information Lifecycle Management (ILM). As mentioned in an earlier posting, there usually comes a point during the lifecycle of the data when it is no longer being regularly accessed: May be obsolete and is eligible for purging Might be needed in the future but could […]

Oracle

ILM, Oracle, temporal history

How to Use In-Database Archiving

May 9, 2017

Kent Hinckley

In this posting, we are continuing with the theme of Information Lifecycle Management (ILM). Another option in Oracle 12c, is In-Database Archiving, also called Row Archival. Why In-Database Archiving The simple goal of in-database archiving is to assign values to the data based on business rules of whether the data is current or marked as […]

Oracle

in-database archiving, Oracle, Row Archival, Row Archiving

How to Manage Automatic Data Optimization (ADO)

Apr 11, 2017

Kent Hinckley

In this last posting on Automatic Data Optimization, we will look at issues related to monitoring and managing Automatic Data Optimization (ADO). Displaying Automatic Data Optimization (ADO) Policies Several dictionary views are available to verify configured policies. DBA_ILMPOLICIES provides the list of all policies and their respective ENABLED status:The DBA_ILMDATAMOVEMENTPOLICIES view contains information specific to data […]

Oracle

ADO, Automatic Data Optimization, Oracle

1 2 »