Email Alerts
-
Query Tuning for Developer, Beginner DBAs
If you’re a DBA, improving query performance is probably on your mind. Read this excerpt from Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec for his take. Feature
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions. Feature
-
Oracle 10g tops list of Oracle database platforms
In a survey taken in 2010, Oracle professionals listed Oracle Database 10g as their primary database platform, despite 11g having been out since 2007. Slideshow
-
Oracle upgrades lead expected database changes this year
Oracle database upgrades will be big on Oracle professionals' list of things-to-do this year, according to a recent survey by SearchOracle.com. Slideshow
-
Oracle database and application budgets in the down economy
See how Oracle professionals are handling their Oracle database and application budgets in 2010 in the midst of a down economy. Slideshow
-
Comparing servers for Oracle database 11g upgrades
An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance. Guide
-
Oracle database performance tuning guide
Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common problem... Learning Guide
-
SQL Tuning with SQL Access Advisor
This excerpt, taken from "Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features" by Dr. Arun Kumar R, describes the process of using SQL Access Advisor for tuning SQL. Chapter Download
-
Oracle 10g datafile I/O statistics
The Oracle10g database significantly improves the I/O subsystem, but it is still important to constantly monitor the I/O workload on the database. This excerpt, taken from the book "Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts"... Chapter Download
- See More: Essential Knowledge on Oracle database performance problems and tuning
-
Book explores Oracle, MySQL query methods
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview. Q&A | 29 Nov 2011
-
Oracle application performance management like a detective novel
Determining the root cause of an Oracle application performance problem might take you far, far outside the inner sanctum of Oracle database and applications. News | 29 Nov 2011
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout. News | 03 Oct 2011
-
Exadata and Exalogic's effect on database performance
Oracle Database performance can get a boost from newer Exadata and Exalogic server appliances, but the database design must still be good. Feature | 15 Jun 2011
-
Oracle releases new database, says 11g upgrade will cut costs
Oracle released its new 11g R2 database today. But will users embark on an Oracle 11g upgrade? And why should they? Article | 01 Sep 2009
-
Oracle raises prices on database management packs
With little fanfare, Oracle earlier this month increased pricing on a handful of optional database management offerings. Article | 17 Jul 2009
-
Oracle New Year's resolutions, part 1: Advice for navigating 2009
Oracle analysts weigh in with advice for improving Oracle database security and upgrading to new Oracle applications in 2009. Article | 30 Dec 2008
-
Author Mike Ault sizes up the new Oracle Database 11g
Oracle book author Mike Ault talks about the upcoming Oracle Database 11g's new SQL replay and memory management capabilities. Article | 03 May 2007
-
Lessons Learned Quiz #1: Performance tuning
Now that the first Lessons Learned series is complete, try your hand at this short quiz on performance tuning. Article | 06 Apr 2007
-
Lessons Learned: Oracle performance tuning 101
Part of the SearchOracle.com Lessons Learned series, this week's lesson covers Oracle performance tuning basics. Article | 06 Apr 2007
- See More: News on Oracle database performance problems and tuning
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation. Tip
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management. Tip
-
Dealing with Oracle Database bottlenecks
Unclogging Oracle Database bottlenecks can range from simple SQL re-coding to examining CPU use and monitoring the network infrastructure. Tip
-
Oracle 11g data compression
Here is an overview of new 11g compression features, which make storage up to three times cheaper, solid-state flash drives far less expensive allowing Oracle shops to forever eliminate the high costs of platter-disk I/O and enjoy data access speeds ... Tip
-
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. Tip
-
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. Tip
-
Using the cost-based optimizer to improve Database 10g performance
An advantage of upgrading to Oracle 10g is that the cost-based optimizer (CBO) has been improved to choose the best execution plans based on statistics of the data. But one of the most common causes of performance issues in 10g databases is bad stati... Tip
-
How to read a STATSPACK report
Part of our "How do I do that in Oracle?" series, this tip explains in detail how to read and understand a STATSPACK report. Tip
-
DBA 102: Beyond the basics
Learn how to go beyond the basic roles of a DBA -- these hard and soft skills will help you prove your value to management and ensure your job security. Tip
-
Tuning the Oracle database with initialization parameters
This chapter excerpt contains tips designed to achieve the greatest performance gain in your Oracle database with the least effort by focusing on the initialization parameters that yield the biggest impact. Tip
- See More: Tips on Oracle database performance problems and tuning
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata. Answer
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large. Answer
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Answer
-
Oracle Exadata and SGA caching
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata. Answer
-
Cache Fusion for RAC on Exadata
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms. Answer
-
Varchar or number for better performance?
Which one is better for performance as a unique index, varchar or number? Ask the Expert
-
Do statistics on SYS-owned objects hurt performance in 10g?
You mentioned that in Oracle 9i statistics on SYS-owned objects can actually hurt the performance. Is it the same in 10g? Ask the Expert
-
Difference between driving table and driver table in Oracle
I need to know the difference between the driving table and driver table in Oracle. Ask the Expert
-
20GB data dictionary causing performance problems
We have 81 schemas in our development instance! While the schemas are usually relatively small data-wise, this arrangement makes for a SYSTEM tablespace approaching 20 GB. Ask the Expert
-
Online tablespace reorganization in Oracle 9i
What is the procedure to do online tablespace reorganization in Oracle 9i? Ask the Expert
- See More: Expert Advice on Oracle database performance problems and tuning
-
What managers should consider when starting a database scaling project
Learn about database scaling from Oracle consultant Don Burleson, who discusses the goals, costs and challenges of scaling an Oracle database in this podcast. Podcast
-
Query Tuning for Developer, Beginner DBAs
If you’re a DBA, improving query performance is probably on your mind. Read this excerpt from Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec for his take. Feature
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata. Answer
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation. Tip
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions. Feature
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management. Tip
-
Book explores Oracle, MySQL query methods
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview. Q&A
-
Oracle application performance management like a detective novel
Determining the root cause of an Oracle application performance problem might take you far, far outside the inner sanctum of Oracle database and applications. News
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout. News
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large. Answer
- See More: All on Oracle database performance problems and tuning
About Oracle database performance problems and tuning
Browse through our tips and advice on Oracle performance tuning to keep your databases, applications and SQL queries running quickly and efficiently.