aspose file tools*
The moose likes Oracle/OAS and the fly likes Optimization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Optimization" Watch "Optimization" New topic
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: 8919

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: 8919

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Optimization