Technical Blog

Technical and Product News and Insights from Rackspace

Oracle online table partitions using the DBMS_REDEFINITION package

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.

Read More

An overview of LPN and shortcuts to mobile Telnet: Part 2

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.

Read More

Oracle Database In-Memory Advisor

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 and later.

Read More

Hadoop ecosystem basics: Part 1

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.

Read More

Hadoop ecosystem basics: Part 2

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.

Read More

Bullet-speed recovery using incrementally updated images

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).

Read More

Avoid row chaining in a database

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.

Read More

An overview of LPN and shortcuts to mobile Telnet: Part 1

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.

Read More

AD Online Patching in Oracle applications

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

Read More

Oracle AD Online Patching errors and fixes

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
Read More