• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

How do you use tune PL/SQL? 1,2,3 - explain plan, etc?

Hi,
I've been using PL/SQL for 10years in my work but never really learned the 1,2,3 ways of tuning PL/SQL or learning what is more effecient code over other code... (ex: BULK COLLECT verses regular cursor)
What is the best, quickest way to start getting the needed knowledge in these areas?
Maybe an awesome PL/SQL tutorial?
Link to How to use an Explain Plan?

Any help would be appreciated,
Bill
0
BILL Carlisle
Asked:
BILL Carlisle
  • 3
  • 2
1 Solution
 
sdstuberCommented:
tuning is huge topic...

but here are some good places to start

great authors, books and web articles
Steven Feurstein - pl/sql is his thing,  google pl/sql obsession
Tom Kyte - asktom.oracle.com

learn to use dbms_profiler for pl/sql tuning.

0
 
greyhumanCommented:
hi,
Its good that you have an urge to improve.
Tuning is not a small topic and also there are no Hard and Fast rules for it.
I will suggest start with code improvements.
Learn about explain plans- table analyse , dbms_profiler  etc.
Books are always helpfull - but more practice is needed.
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Thanks Sean,
I watched a bunch of Steven Feurstein's videos and this week end will look at his tutorials.

Thanks greyhuman,
I was looking for Expert suggestions of books and tutorials for "explain plans- table analyse, dbms_profiler" as Sean suggested:
Steven Feurstein - pl/sql is his thing,  google pl/sql obsession
Tom Kyte - asktom.oracle.com
thank you for your response.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
sdstuberCommented:
if you found my suggestions helpful, wouldn't a split have been in order?
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Actually Sean, I just realized by looking back at this that somehow I have selected the wrong one.

How do I change it?

Sorry greyhuman, But I know that I need to "Learn about explain plans- table analyse , dbms_profiler  etc." and I know that "Books are always helpfull - but more practice is needed."

Sean's post gave me a way I got into "Steven Feurstein's pl/sql obsession" with many videos, trainings and examples.
I thought I was awarding the whole amount to Sean.. I'd like to correct that because I have been going through the tutorials ever since and learned about Encapsulating DML to take advantage of SGA memory access verses going to the database each time if your SQL is a bit different.

Please correct the posting of points if possible.


0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Thank you Sean!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now