Oracle Performance Tuning

EXPERT TECHNICAL ADVICE: 1 - 3 of 25

ORACLE PERFORMANCE TUNING EXPERTS
			Phillip Bracken Database Architect ASK A QUESTION

	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?

	VIEW ALL EXPERT TECHNICAL ADVICE ON ORACLE PERFORMANCE TUNING

SEE ALSO - Topics Related to Oracle Performance Tuning:  Data Warehousing, ETL, and business intelligence, (Archive) Database Performance Tuning, (Archive) Database Administration and Development, Oracle Internals, (Archive) Oracle Applications, Database Backup and Recovery, Oracle Application Server, PL/SQL, Managing an Oracle shop, RAC and Availability, Database Design and Architecture, (Archive) SQL and PL/SQL, (Archive) Database Installation and Upgrade, (Archive) Database Security, SQL, (Archive) Data Warehousing and Business Intelligence, (Archive) Database Design, (Archive) App Dev: PL/SQL and XML, (Archive) Database Installation/Upgrade/Patches, SOA and Integration, E-Business Suite