• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Optimization

 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are there any general suggestions how to optimize Oracle database?
I mean PL/SQL code and the server itself.
Could someone provide a link?

Thanks in advance.
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Or you can use Oracle10g's SQL advisor.

Nick
 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How good are in general the advisors?
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL Advisor in Oracle10g provides lots of information and varity for you to tune the SQL statements, and test the performance. It also provides a graphical interface for us to see the execution plans.

Nick
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Nicholas Cheung:
SQL Advisor in Oracle10g provides lots of information and varity for you to tune the SQL statements, and test the performance. It also provides a graphical interface for us to see the execution plans.

Nick


Is it possible to plug-in my own SQL advisors?
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Is it possible to plug-in my own SQL advisors?

What do you mean by *your own SQL advisor*?

What I mention is the advisor that comes with Oracle10g DB, which is NOT a pluin or add-on module.

Nick
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic