| Author |
Optimization
|
David Ulicny
Ranch Hand
Joined: Aug 04, 2004
Posts: 724
|
|
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.
|
SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
|
 |
Pradeep bhatt
Ranch Hand
Joined: Feb 27, 2002
Posts: 8876
|
|
Here is the link
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/toc.htm
|
Groovy
|
|
Nicholas Cheung
Ranch Hand
Joined: Nov 07, 2003
Posts: 4982
|
|
Or you can use Oracle10g's SQL advisor.
Nick
|
SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)
|
|
David Ulicny
Ranch Hand
Joined: Aug 04, 2004
Posts: 724
|
|
|
How good are in general the advisors?
|
|
Nicholas Cheung
Ranch Hand
Joined: Nov 07, 2003
Posts: 4982
|
|
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
Joined: Feb 27, 2002
Posts: 8876
|
|
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
Joined: Nov 07, 2003
Posts: 4982
|
|
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
|
|
 |
|
|
subject: Optimization
|
|
|
0
