Oracle database performance problems and tuning news, help and research


	Home > Oracle Topics > Oracle database administration (DBA) > Oracle database performance problems and tuning > Expert Technical Advice

Oracle Topics:

EMAIL THIS

TOPICS HOME

BROWSE ALL ORACLE TOPICS

ORACLE INFO CENTERS

RESOURCE CENTERS

RSS FEEDS


Oracle database performance problems and tuning



IN THIS TOPIC:	NEWS (20) , EXPERT TECHNICAL ADVICE (335) , REFERENCE & LEARNING (3) , WEBCASTS (3) , BEST WEB LINKS (10)

Display in sets of:


11 - 20 of 335 in Expert Technical Advice		<< Previous page 1 2 3 4 ... 32 33 34 Next >>



ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING EXPERTS



			Paul Baumgartel Senior Database Administrator and Consultant ASK A QUESTION


	How to read a STATSPACK report Submitted By: SearchOracle.com \| 12 Jul 2007 TIP - Part of our "How do I do that in Oracle?" series, this tip explains in detail how to read and understand a STATSPACK report.


	Index on table that is truncated/repopulated daily 11 Jul 2007 EXPERT ANSWER - Since I truncate and repopulate the data in my table every day, is the index of much use?


	Select on Oracle table takes hours 26 Jun 2007 EXPERT ANSWER - A user complains that every time he tries to access a table (select only), it takes more than two hours to get the results. There are no DML operations performed on the table.


	How to improve performance of column update 26 Jun 2007 EXPERT ANSWER - I have a table with 1.5 million records that needs to have a column updated based on a correlated subselect. This update is currently sitting at four hours and counting. What can I do to improve this performance?


	Can I use TKPROF in Oracle 10g? 26 Jun 2007 EXPERT ANSWER - I have always used TKPROF to do SQL tuning in previous versions of Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2?


	DBA 102: Beyond the basics Submitted By: SearchOracle.com \| 21 Jun 2007 TIP - 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.


	Tuning the Oracle database with initialization parameters Submitted By: SearchOracle.com \| 19 Jun 2007 TIP - Learn which initialization parameters provide the greatest performance gains when tuning the Oracle database.


	What is the difference between left outer join and (+) outer join? 15 Jun 2007 EXPERT ANSWER - What is the difference between left outer join and (+) outer join?


	Import of database dump takes 13 hours 11 Jun 2007 EXPERT ANSWER - I tried to import a database dump onto my Oracle server using the imp script. The import process currently takes 13 hours for a 3 GB dump file.


	Slow query performance for customer with large data volume 08 Jun 2007 EXPERT ANSWER - I have a critical performance issue due to the large volume of data for a specific customer. Whenever customer XYZ's data is being fetched the query takes about half an hour to execute, whereas it fetches the data in seconds ...


11 - 20 of 335 in Expert Technical Advice		<< Previous page 1 2 3 4 ... 32 33 34 Next >>

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy