Oracle 10G tuning statements

pts.
Tags:
Oracle
SQL
Windows
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The first thing that you need to do is familiarize yourself with any of the new features that were made in 10g from a SQL perspective

What type of environment are we speaking about here? OLTP, Data Warehousing? Let me know, I will be able to provide better direction.

Thanks
Scott

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kpierno
    Here are some things to keep in mind when tuning on 10g. 1. 10g now uses a new cost based optimizer by default 2. tkprof and explain plan help a ton you may also want to check out ADDM with its sql tuning advisors. 3. Don't forget to run analyze command on your tables, if you do not have a good set of statistics the optimizer will often choose a bad path. 4. Take advantage of the AWR reports (similar to good old statspack) run a snapshot prior to and following your query for additional tuning information. 5. Be wary of any joins done on the v$ tables, the new cost optimizer does not always handle them well and you will need to add the use hints to get decent results. I have done an explain on some queries where I join two or three v$ tables and it results in a cartesian joins. Oracle has provided hints so these queries actually complete in a timely fashion, as opposed to the 45 minutes it was taking before. I hope this helps you with some things to think about. Keith
    0 pointsBadges:
    report
  • Techiecat
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-10g-tuning-statements/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following