Problem solve

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

• Where to look for Oracle DBA learning materials

  Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator.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

• RAD Studio 2010 supports Oracle databases, .NET environments

  The three versions of Embarcadero’s RAD Studio 2010 are designed for individual developers and teams of developers building client-server and RAD Web applications for native Windows and .NET.Continue Reading

• SearchOracle.com Lessons Learned Library

  SearchOracle.com has identified your FAQs and compiled applicable expert answers in an easy-to-follow format.Continue Reading

• Steps to use SQL Developer

  Please let me know how I can get my hostname, service name and the port number to be able to run SQL statements and do other things on Oracle SQL Developer.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

• Using Oracle flashback querying for DDL audit

  Oracle's new flashback querying is an immensely useful feature and can be used to audit the DDLs (data dictionary changes) issued on the entire database.Continue Reading

• Terminating 11i concurrent requests

  With this script, you can find the SID, serial number and server PID for a terminated concurrent request so that the process can be killed at the database and OS level.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

• Find out about TEMP/SORT area usage

  This script will give you an idea about the existing usage of the TEMP/SORT area.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

• Modeling tools that support DB2 and forward/reverse engineering

  Continue Reading

• Successful data mining requires work

  Data mining tools are becoming more popular and more widely used as users learn more about their benefits.Continue Reading

• The most important reporting and query tools

  Continue Reading

• 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