Problem solve

Oracle DBA tools

• 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

• 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

• 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

• 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

• Oracle has a new security tool for Database 12c, data redaction

  Oracle Database 12c adds a new security tool, data redaction. Here are step-by-step processes for using data redaction for data masking.Continue Reading

• Oracle 12c's heat map tool and data optimization can improve storage

  The heat map tool and Automatic Data Optimization features in Oracle 12c should help Oracle database shops improve data storage and compression.Continue Reading

• Using SQL Access Advisor to improve indexes and materialized views

  Adding indexes and materialized views should improve query performance, but it's not always the case. Learn how SQL Access Advisor can ensure it does.Continue Reading

• Encrypting data on Oracle SecureFiles

  Transparent Data Encryption is now enabled for Oracle SecureFiles. Read up on how to use it here.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

• Using Oracle Data Recovery Advisory for database backup and recovery

  Read this tip from DBA Matthew Morris on using Oracle Data Recovery Advisory to identify and fix data recovery failures.Continue Reading

• Managing Oracle connections from third-party apps

  Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.Continue Reading

• Improve database performance with Oracle segment space management

  Deleting database rows can create small data gaps that lead to slower table scans. Find out how to use Oracle segment space management to fix this.Continue Reading

• Use Oracle dynamic sampling to improve database optimizer performance

  To help an optimizer gather statistics more effectively, Oracle dynamic sampling comes to the rescue, according to database expert Matthew Morris.Continue Reading