Email Alerts
-
Giving your Oracle hardware performance a shot in the arm
The performance of your databases and applications- both customer-facing and internal- are essential to your business’s success. And in the quest to improve performance, sometimes trying to dissect and fix code and tune important queries can be time ... E-Handbook
-
The future of Dell Toad: Oracle DBAs can use BI, Exadata features
Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance. Feature
-
The state of Dell Toad: Oracle DBAs and how they can still benefit
Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen. Feature
-
Collaborate 2013 Oracle user groups show guide
Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish. Collaborate 2013
-
What's out there for Oracle third-party tools
Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier. Feature
-
Justify Oracle third-party tools with performance and cost benefits
Ignore Oracle third-party tools at your own risk and expense, according to contributor Frank Ohlhorst. Feature
-
Oracle database administrators assemble their 2013 Oracle wish list
Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013. Feature
-
How CTO Joel Gilbert built his own Exadata
Gilbert, CTO of workforce management software company Pipkins, said he built Exadata before Oracle did. Well, kind of. See how he did it. Feature
-
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
- See more Essential Knowledge on Oracle database performance problems and tuning
-
Quest Software, its Toad tool leaping over to Dell
Dell plans to acquire Quest Software, maker of the Oracle Database development tool Toad. End users said Dell could improve Toad and adapt it for larger tech trends like “big data.” News | 02 Jul 2012
-
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
- See more News on Oracle database performance problems and tuning
-
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. Tip
-
Configure Oracle fine-grained access control for network services
Most Oracle databases don't need access to the network. So creating Oracle fine-grained access control for network services will help security. Tip
-
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. Tip
-
How to tune Oracle instance recovery
Find out how to tune Oracle instance recovery in this tip from Matthew Morris, a renowned Oracle Database author. Oracle Database Tip
-
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 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
-
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
- See more Tips on Oracle database performance problems and tuning
-
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. Answer
-
Why won't TNS listener connect with Oracle Database 11g 32-bit?
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g. Answer
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer
-
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
-
Oracle Exadata and SGA caching
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata. 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
-
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
- See more Expert Advice on Oracle database performance problems and tuning
-
What Oracle Database queries to tune, and when to index
Popular Oracle author and consultant Richard Niemiec talks about what Oracle Database queries are the best to tune, when it’s smart to index, and the importance of Exadata. Video
-
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
-
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. Answer
-
The future of Dell Toad: Oracle DBAs can use BI, Exadata features
Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance. Feature
-
The state of Dell Toad: Oracle DBAs and how they can still benefit
Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen. Feature
-
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. Tip
-
Configure Oracle fine-grained access control for network services
Most Oracle databases don't need access to the network. So creating Oracle fine-grained access control for network services will help security. Tip
-
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. Tip
-
How to tune Oracle instance recovery
Find out how to tune Oracle instance recovery in this tip from Matthew Morris, a renowned Oracle Database author. Oracle Database Tip
-
Collaborate 2013 Oracle user groups show guide
Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish. Collaborate 2013
-
What's out there for Oracle third-party tools
Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier. Feature
-
Justify Oracle third-party tools with performance and cost benefits
Ignore Oracle third-party tools at your own risk and expense, according to contributor Frank Ohlhorst. Feature
- 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.