Features

Features

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Database Performance Analyzer pumps up Bodybuilding.com's performance

  Sean Scott, DBA for Bodybuilding.com, wanted a performance tool that ran like it was designed by a DBA. He chose SolarWinds DPA to handle performance and Cyber Monday peak loads.  Continue Reading

• Mobile app keeps Merit Service Solutions from getting snowed under

  Merit Service Solutions' unusual business model called for an unusual mobile application. It developed a custom app, running on a back-end Oracle database, to manage its snow removal and landscaping contractors.  Continue Reading

• Unusual business model requires customized JD Edwards software

  Merit Service Solutions implemented JD Edwards to get a more scalable platform for a growing business, but its unusual business model meant it was in for a lot of customization.  Continue Reading

• OAUG head Dues talks tech plans, Oracle cloud applications

  OAUG president Patricia Dues talks about the technology that has the Oracle user group's attention and why it's important to learn about the cloud even if you aren't planning to use it.  Continue Reading

• Turn database administrator skills into leadership skills

  In a session at Collaborate 16, database architect Ziaul Mannan will reveal the ways DBAs are being overlooked as potential executives and how to prove internally that DBA skills translate well to IT leadership roles.  Continue Reading

• Big Data Discovery may put Oracle back in BI Magic Quadrant

  Oracle didn't make it onto Gartner's 2016 BI Magic Quadrant, but analyst Josh Parenteau says new products like Big Data Discovery and Visual Analyzer show modernization for next year.  Continue Reading

• Oracle cloud customers link vendor support, cloud adoption

  Rebecca Wettemann, vice president of Nucleus Research, answers questions on cloud adoption, third-party support and how that support promotes adoption for Oracle cloud customers.  Continue Reading

• The link between third-party vendor support and the cloud

  In this question and answer session, Nucleus Research Vice President Rebecca Wettemann explains the current trends in third-party vendor support, cloud adoption and how they relate.  Continue Reading

• OAUG president targets Oracle customer support, young members

  The new OAUG president had a good first experience with Oracle support. But there's always room for improvement, and she has since worked to take Oracle support from phone to online.  Continue Reading

• School district rethinks EBS after Oracle extended support ends

  A Colorado school district moved some business applications from Oracle EBS to Workday, then switched to Rimini Street's EBS support services after Oracle wouldn't lower its support costs.  Continue Reading

• Database Performance Analyzer 10 aims to reduce wait times

  SolarWinds Database Performance Analyzer tracks and analyzes wait time in database server processes in an effort to find the cause of performance problems. Version 10 adds MySQL compatibility.  Continue Reading

• As new systems launch, let's look at the SPARC M7 processor

  Oracle has begun to roll out products based on the SPARC M7 chip. Will they live up to the company's hype? Expert Robert Sheldon offers an overview of the processor.  Continue Reading

• Looking back on 2015: The year of Oracle cloud services

  In 2015, we saw the release of Oracle cloud services and a complete cloud platform, an increase in Oracle confidence in the cloud market and a new take on user experience.  Continue Reading

• Oracle's cloud analytics platform comprises several tools

  Oracle Analytics Cloud rounds up a number of the company's business intelligence and big data cloud services. Expert Robert Sheldon takes a look at the cloud analytics platform.  Continue Reading

• IOUG president champions resilience in the IT profession

  Maria Anderson, IOUG president, believes that resilience is crucial to thriving in the IT profession. IT professionals also need to expand their roles into business, she says.  Continue Reading

• Aptec names use cases for Oracle Identity Management patch

  Aaron Perry, president of Aptec, presents use cases for Oracle Identity Management 11gR2 PS3 drawn from his client's experiences with the new patch.  Continue Reading

• Mast Mobile device manager thrives with Oracle billing software

  Mast Mobile device manager needed billing and rating features for its, and chose Oracle's Billing and Revenue Management to get there.  Continue Reading

• Oracle's cloud services push brings users options, issues

  In a Q&A;, OAUG president Melissa English discusses how Oracle's increasing focus on cloud computing services affects users and what Oracle and the OAUG are doing to answer questions.  Continue Reading

• OAUG president: Collaborate 2015 confab peaked with networking

  In a Q&A;, OAUG president Melissa English discusses her passion for mingling with attendees at the 2015 Collaborate conference and how Oracle users old and new can learn from each other.  Continue Reading

• IOUG president dissects Oracle conferences at Collaborate 2015 event

  IOUG President John Matelski answers questions about Oracle users attending the big conferences, like Collaborate 15, and the process of integrating users from Oracle's new acquisitions.  Continue Reading

• Matelski mentors techies to help lead Oracle user group IOUG

  John Matelski, an IT executive and current president of the Independent Oracle Users Group, makes bringing out the leadership skills of DBAs and other technical staffers who are IOUG members a priority.  Continue Reading

• IOUG president on Oracle cloud services strategy, big data usage

  In a Q&A;, John Matelski, president of the IOUG, answers questions about Oracle's cloud strategy and his own organization's business intelligence and big data analytics initiatives.  Continue Reading

• Analytics drives Las Vegas at the Collaborate conference

  Las Vegas is an analytics-driven city. With the rarity of cities collecting data like Las Vegas does, Oracle has an interest in Raghav Venkat's data.  Continue Reading

• Collaborate conference needs to go back to square one, says presenter

  Michael Brown thinks that the Collaborate conference has gotten away from its roots in education. At Collaborate 15, he is presenting sessions for new users and experienced ones.  Continue Reading

• At the Collaborate conference, optimize BI with Oracle 12c

  At the Collaborate 15 conference, Kai Yu wants to share his experience working in BI and as a DBA and how to use Oracle Database 12c to improve BI.  Continue Reading

• Oracle’s session border controler powers Next Generation 911

  Morgan County, Ohio, is the first in its area to upgrade to Next Generation 911 for emergency calls. Oracle's session border controller is key to its success.  Continue Reading

• New orchestrator helps communication service providers

  The new Oracle Communication Network Service Orchestration solution is designed to guide communications service providers onto NFV.  Continue Reading

• New president brings global change management skills to OAUG

  The 2015 OAUG president, Melissa English, found a love of education in teaching her peers. Now she brings global change management skills to the OAUG.  Continue Reading

• The seven deadly sins that lead to an Oracle audit

  Oracle is notorious for its confusing licensing policy. Robert Sheldon presents seven behaviors that can lead to an Oracle audit and costly audit fees.  Continue Reading

• Off to see the Oracle patching wizard

  Karen Brownfield provides instructions for Oracle patching. The Patch Wizard recommends the patches you need for Oracle EBS.  Continue Reading

• 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

• Oracle cloud strategy is to coexist with on-premises

  Oracle updates its on-premises applications while it is investing in cloud services. Despite market concern, Oracle says coexistence is its strategy.  Continue Reading

• Converting historical data for an Oracle EPM redesign

  Hoa Pham explains the last step in an Oracle EPM Hyperion consolidation redesign: converting the historical data. Go through the process step by step and learn about loading and reloading, and setting data value.  Continue Reading

• Making and controlling change in your HFM application

  Hoa Pham explains the importance of extracting metadata from HFM into Excel and how to track the changes as you redesign your HFM consolidation. Your existing metadata can be a big advantage.  Continue Reading

• How to start redesigning your Hyperion consolidation

  As the business world changes, your Hyperion consolidation may need to change. Hoa Pham shows how to separate wants and needs and how to use multidimensional reporting to redesign your Hyperion consolidation.  Continue Reading

• What changes with Ellison no longer CEO of Oracle?

  Larry Ellison stepped down as Oracle CEO for a position as CTO and executive chairman. His vision remains integral to Oracle's development; only time can tell whether that will push Oracle ahead or hold it back.  Continue Reading

• The MicroStrategy best practices for Oracle In-Memory

  Jochen Demuth of MicroStrategy shares three best practices for the Oracle In-Memory Database. The MicroStrategy best practices come from Demuth's experience as a beta tester working closely with Oracle on the In-Memory Database.  Continue Reading

• The evolution of Oracle Fusion Cloud Services

  Robert Sheldon explains the history of Oracle Fusion Applications and the important choice between software-as-a-service and on-premises deployment.  Continue Reading

• Oracle gets away from relational DB with NoSQL database architecture

  Robert Sheldon traces the roots of NoSQL, shows the important features of the Oracle NoSQL Database architecture, and describes its implementation.  Continue Reading

• Oracle implementation at Celcom brings IT, business together

  Malaysia's largest cellular provider made a comeback due partly to the rapid deployment of an Oracle-based customer experience management system.  Continue Reading

• 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

• Successful ERP system integration relies on the right ERP philosophy

  Better integration is a main reason for ERP installations. But that doesn't mean the problems will miraculously end at go-live.  Continue Reading

• The Oracle big data strategy: Weighing appliance vs. commodity

  The Oracle big data strategy is about you buying a large, expensive server appliance and installing your big data platform on top. Good idea?  Continue Reading

• 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

• OpenWorld attendees learn best practices for upgrading Oracle Solaris

  Get expert tips and advice for making sure the switch to Oracle Solaris 11 goes as smoothly as possible, compiled from a session at OpenWorld 2013.  Continue Reading

• Online patching a game-changer in Oracle E-Business Suite 12.2

  Companies often take down their entire ERP system for software patching. That changes with Oracle E-Business Suite 12.2.  Continue Reading

• Database server virtualization wars: VMs vs. Oracle RAC

  Database server virtualization is always tough. Should you put multiple VMs on one machine or spread your database instances across several servers?  Continue Reading

• Installing Oracle Fusion Applications an integration challenge

  Find out how one user solved the problem that arises when installing Oracle Fusion applications and trying to integrate them with non-Fusion apps.  Continue Reading

• How Papa John's implemented career succession planning with PeopleSoft

  Papa John's may be better known for their pizza than their new career succession planning implementation, but maybe that should change. Find out why.  Continue Reading

• Doing an Oracle patch update the right way is no easy task

  Knowing which Oracle patch update is the right one, and how often to apply them, is key to keeping IT and end users happy.  Continue Reading

• What's out there for Oracle third-party tools

  Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.  Continue Reading

• Justify Oracle third-party tools with performance and cost benefits

  Ignore Oracle third-party tools at your own risk and expense, according to contributor Frank Ohlhorst.  Continue Reading

• Weigh the benefits of Oracle on mainframe vs. x86

  Until recently, big databases always meant using big iron. But as software and hardware evolves, Oracle on mainframe is becoming less common.  Continue Reading

• 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

• JD Edwards EnterpriseOne One View Reporting can save money

  An Infosys consultant argues that JD Edwards EnterpriseOne One View Reporting can save big bucks over customized reporting.  Continue Reading

• Pluggable Database virtualizes Oracle Database 12c

  Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.  Continue Reading

• PayPal completes a 60-day migration to Oracle Exadata

  Online payment processor PayPal knows what it takes to migrate to a new data management platform in a hurry.  Continue Reading

• Book excerpt: Oracle Exalogic Elastic Cloud Handbook

  Brush up on your understanding of Exalogic with this handbook excerpt, which differentiates between Oracle's Exalogic Elastic Cloud and Exadata Machine.  Continue Reading

• Excerpt: The key concepts of Oracle WebLogic server

  The Oracle Weblogic server is great, but it's important to understand a few key concepts. Read this excerpt from Oracle WebLogic Server 11g Handbook by Sam R. Alapati to learn why.  Continue Reading

• Query Tuning for Developer, Beginner DBAs

  If you’re a DBA, improving query performance is probably on your mind. Read this excerpt from Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec for his take.  Continue Reading

• BPM basics: The what, why and how

  Business process management (BPM) is designed to help an organization do its job better. Read this excerpt from the Oracle Business Process Management Suite 11g Handbook to learn the basics of BPM and its benefits.  Continue Reading

• Virtualization's impact on Oracle licensing and support

  Oracle's virtualization-related licensing and support policies can get confusing, but there are some tricks you can learn to simplify the process.  Continue Reading

• Oracle Exalogic: Is Oracle's cloud-in-a-box really cloud computing?

  Oracle’s new Exalogic Elastic Cloud is the company’s announced foray into cloud computing. But does Oracle Exalogicfit the traditional model of cloud computing, and does that matter?  Continue Reading

• Understanding the Oracle user provisioning process

  This chapter describes the various sophistication levels of the user provisioning process, including discretionary account provisioning, self-service provisioning, workflow-based provisioning and more.  Continue Reading

• Using Oracle Identity Manager (OIM) connectors and integration

  Learn how to use the Oracle Identity Manager (OIM) integration platform, including the OIM connectors such as prebuilt connectors and generic technology connectors , and provisioning and reconciliation integrations.  Continue Reading

• How to use Oracle Identity Manager for user provisioning

  Read about how Oracle Identity Manager is used for the user provisioning process, including enabling simpler administration, reduced risk and easier integration.  Continue Reading

• SELECT statement syntax and examples

  In this chapter, learn how to use the SELECT statement with SELECT statement examples, including the basics of the SELECT statement syntax.  Continue Reading

• Oracle E-Business Suite manufacturing and supply chain management

  Find out what the Oracle E-Business software suite can do for manufacturing supply chain management (SCM). Learn supply chain planning and forecasting strategies for Oracle SCM software.  Continue Reading

• How to use the Oracle Database SQL Reference Manual

  In this chapter, learn how to use the Oracle Database SQL Reference Manual, a collection of technical information on the SQL statements that work with the Oracle Database.  Continue Reading

• How to use SQL Developer to run SQL statements

  In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.  Continue Reading

• How to use SQL*Plus in Oracle

  In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed.  Continue Reading

• How to work with the Oracle database home page

  In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer.  Continue Reading

• How to view and edit table column definitions

  In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so.  Continue Reading

• How to use SQL Developer to work with an Oracle database

  In this chapter, learn how to use Oracle SQL Developer to review or modify your database design, navigate database objects and create, export and import database connections.  Continue Reading

• Writing single-row and multiple-row subqueries

  This chapter excerpt explains how to use and write single-row and multiple-row subqueries in SQL, with sample code and exercises.  Continue Reading

• List the types of SQL subqueries

  In this chapter, learn about the three broad divisions of a subquery in SQL: Single-row, multiple-row and correlated subqueries.  Continue Reading

• Using subqueries in SQL

  In this chapter, read examples and sample code for the types of problems that SQL subqueries can solve, including star transformation, generating a table from which to SELECT, generating rows to be passed to a DML statement and more.  Continue Reading

• Define SQL subqueries

  This chapter of "OCA Oracle Database 11g: SQL Fundamentals I Exam Guide" explains how a subquery, a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement or inside another subquery, is defined and used in SQL.  Continue Reading