Topics Archive

Top Stories

Feature 12 Oct 2022
Top 4 CRM systems comparison

What differentiates the 'big four' CRM providers? Explore the advantages and disadvantages of Salesforce, Oracle, Microsoft and SAP in this CRM comparison. Continue Reading
Answer 27 Jun 2022
DBMS keys: 8 types of keys defined

Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences among them. Continue Reading

News 05 Apr 2021

Supreme Court sides with Google in Oracle API copyright suit

The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a longstanding legal battle between Google and Oracle. Continue Reading
Feature 07 Nov 2019

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but migrating to the cloud has its share of issues. Continue Reading
News 18 Oct 2019

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the decision could go one of a few ways, analysts say. Continue Reading
Conference Coverage 01 Oct 2019

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle cloud, database and application users. Continue Reading
News 23 Sep 2019

Oracle applications development EVP on Fusion, SaaS and what's ahead

Steve Miranda discusses lessons learned from Oracle Fusion Applications, SaaS, best-of-breed apps vs. suites and Oracle's application acquisition strategy. Continue Reading
News 11 Sep 2019

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past 20 years helped lay the foundation. Continue Reading
Feature 10 Sep 2019

Oracle cloud ambitions follow decades of transition

The Oracle cloud strategy continues to evolve, with fresh emphasis placed on how its flagship database can help customers in the cloud. But the story truly begins decades ago. Continue Reading
News 04 Sep 2019

Oracle and Microsoft expand OCI, Azure cloud connections

The multi-cloud capabilities offered by Oracle and Microsoft are now available in the U.K. via a link between the Oracle Cloud Infrastructure and Azure platforms. Continue Reading
Tip 30 Aug 2019

Consolidating databases in Oracle systems: Methods and tips

A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading
Feature 28 Aug 2019

How to manage Oracle database upgrades and annual releases

Oracle consultants offer tips and advice on upgrading databases, including new considerations created by the annual release schedule that Oracle is now following. Continue Reading
Answer 31 Jul 2019

Oracle LEFT JOIN vs. LEFT OUTER JOIN: What's the difference?

Get an explanation of the different types of Oracle joins, including whether there's really a difference between the LEFT JOIN and LEFT OUTER JOIN syntax in PL/SQL. Continue Reading
Feature 19 Jul 2019

How Oracle RPA systems can automate business tasks for users

Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by augmenting workers with software robots. Continue Reading
News 25 Jun 2019

Oracle Analytics Cloud update unifies BI products, pricing

Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI update is also on the way for cloud holdouts. Continue Reading
Tutorial 19 Jun 2019

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading
Tip 23 May 2019

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. Continue Reading
Tip 26 Apr 2019

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. Continue Reading
Answer 05 Apr 2019

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Tip 29 Mar 2019

Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that Oracle users should be aware of. Continue Reading
Feature 25 Mar 2019

Oracle Digital Assistant unifies use of enterprise chatbots

With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to help increase worker productivity. Continue Reading
Feature 13 Mar 2019

Oracle 19c database software promises stability, compatibility

Oracle Database 19c offers automatic indexing and support for external data partitions but carries upgrade issues like apps certification and index creation agreement. Continue Reading
Feature 22 Feb 2019

First take on Oracle 19c: 6 useful enhancements for DBAs

Database administrator Brian Peasland lists some of the new and updated features coming in Oracle Database 19c that he thinks will be beneficial to Oracle users. Continue Reading
News 15 Feb 2019

Click-to-launch tools pull apps through Oracle Cloud Infrastructure marketplace

Oracle has made it easier for customers to choose and launch third-party software onto its cloud. Now, the question is whether more businesses will follow. Continue Reading
News 04 Feb 2019

Rewards program provider taps Oracle IaaS for app migration

Oracle struggles in IaaS against AWS and Azure, but one Oracle cloud customer said its move there is a success, albeit within an overall multi-cloud strategy. Continue Reading
Feature 30 Jan 2019

Future of Oracle centers on the cloud, AI and automation

Oracle deepened its embrace of cloud computing, AI software and IT automation tools in 2018. What can users expect from it in 2019? More of the same, most likely. Continue Reading
Feature 27 Dec 2018

Key new features coming in Oracle Database 19c

With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also offers DBAs a variety of added features. Continue Reading
Opinion 14 Dec 2018

The real Oracle cloud strategy that may work vs. AWS and Azure

Oracle's database software is at the heart of its efforts to move users to its cloud. And that strategy might work, despite Oracle's inauspicious standing in the cloud now. Continue Reading
Tip 12 Dec 2018

Why to give third-party Oracle database monitoring tools a try

Oracle DBAs can use features in Oracle Enterprise Manager under database licenses. But third-party tools may aid efforts to monitor and tune database performance. Continue Reading
Feature 13 Nov 2018

DataScience.com set to drive Oracle cloud analytics efforts

Oracle's cloud strategy includes machine learning jobs that differ from the usual SQL analytics. The company is turning to its DataScience.com purchase to fill the gap. Continue Reading
Podcast 05 Nov 2018

Oracle Cloud IaaS security gets superhero status from Ellison

TechTarget editors discuss security updates to Oracle Cloud Infrastructure and company leader Larry Ellison's vivid depiction of cloud-borne cyberthreats and bots to counter them. Continue Reading
Feature 01 Nov 2018

What the 3 versions of Oracle Cloud at Customer offer users

Oracle's Cloud at Customer service lets users run its cloud technologies in their data centers. Here's what users get in the different versions of the managed service. Continue Reading
Conference Coverage 30 Oct 2018

Oracle OpenWorld 2018 news, trends and analysis

At its OpenWorld 2018 conference, Oracle tried to position its cloud platform as well-suited for enterprise uses. This guide compiles coverage of key developments from the event. Continue Reading
News 25 Oct 2018

Users look to Oracle Autonomous Database to lighten IT load

Early users are kicking the tires of Autonomous Database, attracted by Oracle's pledge that the cloud technology will automate database administration chores. Continue Reading
News 23 Oct 2018

Updated Oracle Gen 2 Cloud aims to challenge cloud leaders

With enhancements to its Autonomous Database technology and cloud infrastructure security services, Oracle is trying to gain ground on Amazon and other cloud rivals. Continue Reading
Tip 17 Oct 2018

6 best practices on Oracle performance monitoring and tuning

Database administrators need to effectively manage Oracle Database performance to ensure an efficient processing workflow. Let this checklist be your guide. Continue Reading
Feature 17 Oct 2018

What Oracle performance tuning tools can and can't do for DBAs

Two Oracle experts discuss the tuning and monitoring capabilities of database performance management tools -- and the ongoing role that DBAs play in the process. Continue Reading
Feature 03 Oct 2018

Oracle Mobile Cloud helps place privacy engine on cloud

For Virtual Artifacts, the decision to go with Oracle's cloud was tipped by Oracle Mobile Cloud and a related bot platform -- and the self-driving Autonomous Database. Continue Reading
Feature 28 Sep 2018

Q&A: Oracle adaptive intelligence strategy pervades apps

From IT to HCM to sales, AI and machine learning capabilities have been added to a variety of Oracle's offerings through Oracle AI Apps. And the vendor says there's more to come. Continue Reading
Tip 17 Sep 2018

Breaking down AI-infused Oracle Autonomous Cloud services

Oracle offers a variety of AI-infused cloud services that it says will automate common administrative and operational tasks for users. Here's a look at what's available now. Continue Reading
News 09 Aug 2018

Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and management of Oracle databases. Continue Reading
Feature 16 Jul 2018

The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the technologies as part of its enterprise cloud strategy. Continue Reading
Tip 02 Jul 2018

How Oracle DBA responsibilities change with Autonomous Database

Oracle's Autonomous Database automates basic tasks of database administrators. That may put some DBA jobs at risk, but many will shift to higher-level duties. Continue Reading
News 03 May 2018

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to quickly find the source of IT problems. Continue Reading
Tip 30 Apr 2018

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but it does expand functionality in various areas. Continue Reading
News 26 Apr 2018

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying it's wise to be selective on what to move. Continue Reading
News 18 Apr 2018

Collaborate 18 to track progress of Oracle cloud database, apps

The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves can have on the careers of DBAs and other IT professionals. Continue Reading
News 30 Mar 2018

Oracle Autonomous Database debut heralds new cloud hopes

It wasn't the first in the cloud computing space, but Oracle is all in now. Key to the effort is a new Autonomous Database service, initially available for data warehousing uses. Continue Reading
Tip 15 Mar 2018

Seven to-do items for managing an Oracle cloud migration

Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place to help ease the transition and keep it on track. Continue Reading
Feature 28 Feb 2018

Oracle sees Autonomous Database changing DBA roles for the good

The job duties of database administrators will likely change in organizations that use Oracle Autonomous Database Cloud, but in ways that are beneficial, according to Oracle. Continue Reading
Tip 20 Feb 2018

How to use Oracle DBSAT to do a database security assessment

The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved in using DBSAT to collect data and create reports. Continue Reading
Tip 22 Jan 2018

Oracle Blockchain Cloud Service: What it is and what it does

Oracle's cloud-based blockchain service supports distributed transaction ledgers to boost data security and validation. Here's a look at the technology and its features. Continue Reading
Tip 15 Dec 2017

Using Oracle 12c Unified Auditing to set database audit policies

Oracle Database 12c's built-in Unified Auditing feature streamlines the database auditing process, including creation and implementation of audit policies. Here's how that works. Continue Reading
Tip 14 Jul 2017

Migrate an Oracle RAC database to new servers with zero downtime

Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and still stay up and running in an Oracle cluster. Continue Reading
Tip 14 Jun 2017

MySQL Community Server vs. Oracle MySQL databases

With various open source and commercial options available from Oracle, selecting a MySQL database can be confusing. Here's a comparison to help you decide which one makes sense for you. Continue Reading
Tip 23 Jan 2017

Ten reasons to do an Oracle database upgrade

For every excuse made not to upgrade an Oracle database, there are overriding reasons to do so. Here are the top reasons organizations should move up to Oracle Database 12c. Continue Reading
Tip 09 Jun 2015

Using Oracle ADDM reports to resolve SQL performance problems: Step-by step guide

Using Oracle ADDM is an effective way to resolve SQL performance problems, according to Brian Peasland. ADDM is his go-to tool for finding problem SQL statements. Continue Reading
News 03 Apr 2015

Oracle CEO Mark Hurd talks cloud HCM, Taleo integration

At Oracle HCM World, Oracle CEO Mark Hurd said human capital management software is key in the broader competition Oracle is waging for market share with companies such as SAP and Workday. Continue Reading
Feature 21 Nov 2014

How to use Patch Wizard to resolve Oracle EBS issues

Karen Brownfield shows the advantages of using Patch Wizard for Oracle EBS and how to use the Applied Patches, File History and Register Flagged Files components. Continue Reading
News 09 Jun 2014

Oracle to integrate Solaris with OpenDaylight SDN framework

This news roundup covers Oracle's plan to integrate the OpenDaylight software-defined networking framework with Solaris, plus its GreenBytes purchase. Continue Reading
News 05 Jun 2014

Oracle Enterprise Manager 12c R4 focuses on cloud, IT efficiency

Oracle announced Oracle Enterprise Manager 12c Release 4, an upgrade that offers new features for managing both enterprise stacks and private clouds. Continue Reading
Tip 28 May 2014

Design Hyperion for a natural class and a functional income statement

Juan Porter explains what you need in Hyperion or Essbase for calculating a natural class and a functional income statement. Continue Reading
Feature 27 May 2014

Oracle avoids usual lock-in strategy for its OpenStack development

Latest versions of Oracle Linux and VM will release with OpenStack integrated. OpenStack development is a chance for Oracle to support community. Continue Reading
Video 18 Apr 2014

Not much Exadata training necessary for experienced DBAs, says expert

A database consultant says using Exadata is relatively easy for IT shops already managing Oracle Database. But some new DBA skills may be required. Continue Reading
Feature 16 Apr 2014

Willis develops app to put a personal touch back in voluntary benefits

Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for voluntary benefits. Continue Reading
Feature 16 Apr 2014

Willis develops app for real-time voluntary benefit selection

Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary benefits. Continue Reading
Video 15 Apr 2014

Database 12c puts Oracle private cloud deployments more in reach

Pythian database consultant Marc Fielding explains how some of the new features in Oracle Database 12c can help enable private clouds. Continue Reading
Feature 11 Apr 2014

The case for commodity hardware vs. Oracle Exadata architecture

A former Oracle sales rep does a 180 by pushing his company not to buy an Exadata system, but to upgrade existing data center infrastructure instead. Continue Reading
Answer 10 Apr 2014

For Oracle disaster recovery, check your physical standby databases

Database expert Michael Abbey explains what's needed to ensure that your Oracle physical standby databases are vetted and work properly. Continue Reading
Answer 10 Apr 2014

How to escape the no-win Oracle SLA as a DBA

Escaping the no-win Oracle SLA as a DBA is all about tying technology to business, according to two Oracle Database experts. Continue Reading
Video 10 Apr 2014

Oracle data analytics tools target a spectrum of user needs

In an Oracle Collaborate session on Oracle data analytics, an expert outlined the range of tools available -- from canned reports to big data analysis. Continue Reading
Video 10 Apr 2014

Oracle RDBMS vs. NoSQL databases in the era of big data

While NoSQL databases are a lower-cost, scalable alternative to Oracle RDBMS, they pose risks of data loss, says an expert at Oracle Collaborate 2014. Continue Reading
Answer 09 Apr 2014

You don't need Oracle DB 12c Heat Map to prioritize, compress data

PayPal Database Engineer John Kanagaraj says an AWR workaround lets you prioritize and compress data in earlier ODB versions. Continue Reading
Answer 08 Apr 2014

Does Oracle database technology make sense for your company?

Two Oracle database experts explain why it's crucial for companies to make a specific business case for every technology feature they wish deploy. Continue Reading
Tip 04 Apr 2014

Collaborate 2014: Gaining greater value from software investments

In our Collaborate 2014 tweet jam, experts offer key insight into the software buying process -- and how to gain greater value from investments. Continue Reading
News 28 Mar 2014

Oracle JD Edwards EnterpriseOne 9.1, World upgrade challenges and tips

Quest President Patrick Kys talks about upgrading to Oracle JD Edwards EnterpriseOne 9.1 and World 9.3, and comments on application customizations. Continue Reading
Guide 28 Mar 2014

Collaborate 2014: News from the premier Oracle user groups conference

Access articles, interviews and videos that highlight the latest news from the Oracle user groups conference Collaborate14. Continue Reading
Podcast 20 Mar 2014

Handling database migrations, such as upgrading to Oracle 12c

IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live. Continue Reading
Feature 13 Mar 2014

OAUG Q&A: What's ahead for Oracle ERP systems and Fusion

Alyssa Johnson, president of OAUG, discusses the future of Oracle Fusion Applications and their coexistence with cloud in this Q&A session. Continue Reading
Feature 11 Mar 2014

Q&A with Alyssa Johnson: OAUG president talks Oracle Fusion Applications

Question and answer session with OAUG President Alyssa Johnson about the future of Oracle Fusion Applications and their coexistence with the cloud. Continue Reading
Opinion 13 Feb 2014

How can today's DBAs contribute to big data databases?

In the big data puzzle, data scientists and NoSQL are all the rage. Find out how traditional DBAs fit in, and what they have to do to stay there. Continue Reading
Answer 21 Nov 2013

Three tips for using Oracle insert syntax to insert multiple rows

If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members. Continue Reading
Feature 12 Nov 2013

Oracle pro takes the thoroughbred view with IT, EBS upgrade

CIO Wade Lewis has been in IT long enough to know that patience and planning are rewarded, particularly with an EBS upgrade. Continue Reading
Tip 16 Oct 2013

How to perform Oracle Flashback Transaction Queries

Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions. Continue Reading
Video 09 Oct 2013

WebLogic Application Server a big part of E-Business Suite 12.2

Oracle applications expert Floyd Teter talks about new features of E-Business Suite 12.2 and why WebLogic Application Server plays a big part. Continue Reading
Video 03 Oct 2013

State of Texas implements Oracle Database as a Service

The eGovernment director for the state of Texas, along with a business partner from Xerox, explain how they implemented Oracle Database as a Service. Continue Reading
Video 25 Sep 2013

Oracle and big data: Finding pearls in the sea of sand

In a video from OpenWorld 2013, see how one company uses Oracle and big data tools to analyze customer data and build brand loyalty for its clients. Continue Reading
Video 23 Sep 2013

Oracle in-memory database add-on makes debut

At OpenWorld 2013, Oracle CEO Larry Ellison announced an in-memory database add-on for the Oracle Database. Get the details in this video news report. Continue Reading
Opinion 14 Aug 2013

Evaluating the ROI of Oracle DB 12c Multitenant

Formerly called Pluggable Database, the Oracle 12c Multitenant feature is going to cost extra. Is it worth the money? Continue Reading
Video 08 Jul 2013

Oracle expounds on Primavera software roadmap

Tony Banks, product director for Oracle Primavera software, says the company can provide comprehensive project portfolio management. Continue Reading
News 01 Jul 2013

The Oracle-Salesforce deal, along with others, is good for end users

The witty jabs between Larry Ellison and Marc Benioff may be over, but overall the Oracle-Salesforce deal is probably good for users. Continue Reading
News 27 Jun 2013

Oracle news and trends RSS feed is moving!

As of July 1, the Oracle news and trends RSS feed will be moving off of the Pheedo platform. Instead, please bookmark the following URL to make sure you continue to receive our content: http://searchoracle.v7.techtarget.com/rss/Oracle-news-and-trends.xml Continue Reading
News 12 Jun 2013

Sales reps out of control on issue of software license compliance

A software vendor trolls a toll collection agency, and other ridiculous stories in the world of software license compliance. Continue Reading
Video 09 May 2013

John Webb: Why the new PeopleSoft applications are big news

Lena Weiner-Bishop catches up with Oracle's vice president of PeopleSoft strategy, who explains the excitement around new PeopleSoft applications. Continue Reading
Video 03 May 2013

Margaret Wright on E-Business Suite R12, Mark Hurd and more

OAUG president Margaret Wright gives us straight talk on getting users up to speed on E-Business Suite, her meeting with Oracle's Mark Hurd and more. Continue Reading
Video 02 May 2013

Rich Niemiec on Oracle database 12c, database security and Larry's law

We caught up with Rich Niemiec at Collaborate 13. Listen to his observations on such topics as Oracle database 12c and more. Continue Reading
Video 29 Apr 2013

Margaret Wright: OAUG will stay the course

We got a chance to catch up with OAUG's president, Margaret Wright, at Collaborate 13. Find out what she shared with us about OAUG's direction. Continue Reading
Tip 25 Apr 2013

The basics of Oracle database availability

Database expert Jeff McCormick introduces some basic Oracle database availability concepts such as uptime and mean time between failures. Continue Reading
News 08 Apr 2013

Collaborate 2013: Oracle user groups conference guide

Get all the news and features on Oracle databases, applications and hardware from Collaborate 2013, one of the biggest Oracle-related conferences of the year. Continue Reading
News 02 Apr 2013

Oracle Sun hardware is not for hobbyists, by a long shot

Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal. Continue Reading
News 20 Mar 2013

Spend smart on Oracle ERP implementations

Oracle ERP implementations usually take about a year-and-a-half, but a couple examples show that spending smart can shrink the timeline. Continue Reading
Feature 25 Feb 2013

Oracle Fusion Applications implementation: Slower than expected?

A Forrester report says Oracle Fusion Applications forces a tough choice for users and may be why adoption is slow. But not everyone agrees. Continue Reading