 |
|
|
| Oracle Database / Applications Topics: |
|
|
|
|
|
|
|
|
Oracle performance tuning
Phillip Bracken can answer your questions about Oracle database and SQL 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?
|
|
|
|
SEE ALSO - Topics Related to Oracle performance tuning:
Oracle PL/SQL,
Oracle database security,
Oracle licensing,
Oracle database design and architecture,
Data Warehousing, ETL, and business intelligence,
Oracle database internals,
SQL,
SOA and application integration,
Oracle applications and E-Business Suite,
Oracle RAC and database clustering,
Oracle database backup and recovery,
Oracle Application Server,
Managing an Oracle shop |
|
|
|
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
