Technical Blog

Starting with Oracle® 10g, you can partition tables online without any application downtime by using the DBMS_REDEFINITION package.

Use the following steps to change a non-partition table to a partition table by using DBMS_REDEFINITION. This example changes the non-partition table, TABLEA, to a range interval partition table.

Originally published by Tricore: March 15, 2017

In Part 1 of this two-part series, we introduced License Plate Numbers (LPNs) in the Oracle® Warehouse Management System (WMS). In this follow-up post we describe the various types of inventory transactions that you can perform with LPNs.

This post describes the Oracle® In-Memory Advisor (IMA), a feature of Database 12c, and describes its benefits. This feature is available in Oracle Database version 12.1.0.2 and later.

Originally published by Tricore: July 10, 2017

Apache™ Hadoop® is an open source, Java-based framework that’s designed to process huge amounts of data in a distributed computing environment. Doug Cutting and Mike Cafarella developed Hadoop, which was released in 2005.

Built on commodity hardware, Hadoop works on the basic assumption that hardware failures are common. The Hadoop framework addresses these failures.

In Part 1 of this two-part blog series, we’ll cover big data, the Hadoop ecosystem, and some key components of the Hadoop framework.

Originally published by Tricore: July 11, 2017

In Part 1 of this two-part series on Apache™ Hadoop®, we introduced the Hadoop ecosystem and the Hadoop framework. In Part 2, we cover more core components of the Hadoop framework, including those for querying, external integration, data exchange, coordination, and management. We also introduce a module that monitors Hadoop clusters.

Minimizing downtime and increasing the database availability are essential objectives that every business aspires to achieve. Database Adminstrators (DBAs) are always looking for new ways to provide a faster recovery solution in case of any data file or complete database corruption failure. Starting with version 10g, the Oracle® Recovery Manager (RMAN) offers a feature called Incremental Merge Backups (IMB), which provides a solution to minimize the recovery time, especially for very large databases (VLDB).

Originally published by Tricore: Dec 21, 2017

Row chaining is a bottleneck that causes disruption in database performance. We should avoid row chaining as much possible. In this blog, we’ll discuss row chaining, how to identify it, and how to remove or avoid it completely.

Originally published by Tricore: March 14, 2017

In this two-part series, we’ll discuss License Plate Numbers (LPN) in Oracle® Warehouse Management System (WMS), why and how to use them, as well as shortcut keys for Mobile Telnet, which is commonly known as PuTTy.

This blog describes the Oracle ® AD Online Patching (adop) utility phases, the patch process cycle steps, and some useful adop commands and tips.

Originally published by Tricore: Aug 14, 2017

This blog describes the following common issues and solutions for the Oracle ® AD Online Patching (adop) utility:

• Data dictionary corruption error
• adop prepare failure
• Forms object generation failure
• adop cutover hang-up
• Patch abort