Originally published by Tricore: May 5, 2017
This blog covers some basic concepts of Edition Based Redefinition (EBR) and how to use it to support an applications upgrade, which can reduce downtime.
Originally published by Tricore: May 17, 2017
Oracle® Business Intelligence Discoverer is a toolset for ad hoc querying, reporting, data analysis, and web publishing for the Oracle database environment.
How do you read execution plans? From right to left, left to right, or by checking out costs? Or what about objects like index scans, table scans, and lookups? This blog discusses how to read a Microsoft® SQL Server execution plan.
This blog covers the process for converting a version 11i database to an Oracle® Applications Tablespace Model (OATM) by using an OATM migration utility that has 12 locally managed tablespaces for all products.
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.
This blog identifies the deprecated Microsoft® SQL Server® Database Engine features that are available in SQL Server 2016 and that will be removed in future releases of SQL Server.
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 blog post shows you how to generate an Array Diagnostic Utility (ADU) report on an Hewlett Packard Enterprise (HPE) server that is running VMware® ESXi™ version 5.x or 6.x. The information in this blog helps you to determine whether the ADU is installed. If it is not installed, you can use the steps provided in this blog to install it.
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 184.108.40.206 and later.
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.