Problem solve

Problem solve

Get help with specific problems with your technologies, process and projects.

• 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

• 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

• 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

• Battle through the recurring Oracle TNS mistakes admins make

  TNS often poses problems for IT admins and can be difficult to navigate -- especially when it comes to an Oracle database. Here's how to avoid those common errors. Continue Reading

• DBAs must master the art of database recovery management

  Database administrators are usually concerned with backing up their databases. But they should spend more time focusing on database recovery as part of the backup process. Continue Reading

• How to create an Oracle database link

  From remote databases to database migrations, this tip shows you how to create an Oracle database link and avoid potential pitfalls.Continue Reading

• How to fight higher Oracle licensing costs in the AWS, Azure clouds

  Oracle essentially doubled cloud licensing requirements to run its software on AWS or Azure, but Oracle shops can fight back. Here's how to avoid a bigger Oracle licensing bill.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

• What's the biggest trap for users in an Oracle licensing agreement?

  The biggest Oracle licensing trap isn't in how you use the vendor's software, but in the license agreement itself and how easy Oracle makes it for customers to start out noncompliant.Continue Reading

• Don't rush into cloud databases without a well-grounded plan

  As more companies move to the cloud, it's important for DBAs to know both the good and the bad about managing Oracle cloud database systems before they take the plunge and migrate.Continue Reading

• 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

• Five SQL performance tuning tips: Using the right third-party tools

  With the right tools, an Oracle DBA was able to resolve a SQL performance tuning problem in minutes rather than days. Here is how he uses those tools.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

• 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