Tips

Tips

Oracle and SQL

• 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

• 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

• Oracle APEX application tools ease development of database apps

  Oracle Application Express lets users build web applications largely through wizards. Consultant Robert Sheldon explains the process for using the Oracle APEX toolbox.  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

• 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

• How to use Oracle SQL CUBE for cross-tabulation

  Using the SQL CUBE function in Oracle SQL at the right time can cut down on how much querying you'll need to do.  Continue Reading

• Oracle Database 11g SQL Tuning

  One of the main strengths of SQL is that you don't have to tell the database exactly how to obtain the data requested. You simply run a query specifying the information you want, and the database software figures out the best way to get it. ...  Continue Reading

• Inside the Oracle 11g SQL Performance Advisor, part 1

  This preview from the forthcoming book "Oracle 11g New Features" describes the goals of holistic SQL tuning and the steps to perform automated SQL tuning with Oracle 11g's new SQL Performance Advisor feature.  Continue Reading

• Inside the Oracle 11g SQL Performance Advisor, part 2

  Part 2 of this excerpt from "Oracle 11g New Features" explains how to create a SQL Tuning Set (STS) to be used as input for the SQL Performance Advisor, Oracle 11g's new automatic SQL tuning feature.  Continue Reading

• SQL analytics: A self-service model

  SQL analytics is one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. This article reviews a brief history at attempts to deliver ...  Continue Reading

• Mike Ault's Oracle "good practices": Oracle coding

  Mike Ault offers "good practices" for Oracle coding, including using array processing, placing code within stored procedures and using proper variable types for variable declaration.  Continue Reading

• Mike Ault's Oracle "good practices": Performance management and tuning

  Mike Ault offers "good practices" for Oracle performance management and tuning, including implementing proactive database monitoring, building in alert mechanisms and more.  Continue Reading

• Mike Ault's Oracle "good practices"

  In this six-part tip, Mike Ault offers Oracle "good practices" in categories including the Oracle environment; backup, failover and disaster recovery; system security; design; coding; and performance management and tuning.  Continue Reading

• Oracle 10g expert SQL tuning techniques

  This book excerpt focuses on real-world techniques for improving the speed of SQL queries with a focus on new Oracle 10g features. The topics include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution ...  Continue Reading

• SQL puzzles and answers: Finding equal sets

  A SQL puzzle in the December 1993 issue of Database Programming & Design magazine was to use a supplier and parts table to find pairs of suppliers who provide exactly the same parts. This is the same thing as finding two equal sets. How many ...  Continue Reading