Problem solve
Get help with specific problems with your technologies, process and projects.
Oracle DBA tools
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
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
Oracle XML capabilities in Oracle Database 11gR2, part 1
New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a ...Continue Reading
Steps for copying a database or schema
Follow these steps to copy an entire database or a schema using Oracle's export and import utilities.Continue Reading
Working with Oracle10g's new global temporary table features
This tip will help those planning to work with Oracle10g's new global temporary table features -- VARRAY and nested tables.Continue Reading
Oracle housekeeping scripts
Here are a few scripts for Oracle database "housekeeping".Continue Reading
Determine used and free space in a tablespace
Use this script to determine total size, used space, free space and percentage of used and free space in all tablespaces.Continue Reading
Tablespace monitor for autoextend
Tablespace monitor for autoextendContinue Reading
The most important reporting and query tools
Identify the user and session ID for a UNIX process
This quick process identifies the Oracle user and session ID of a UNIX process that is using up a large amount of CPU.Continue Reading