Home
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software
Latest
Popular
Who's Online
We have 52 guests online

Oracle SQL tuning- Identifying bottlenecks Print E-mail
    To start with PL/SQL or SQL tuning the first step should be to identify the bottleneck in the whole code. Idetifying individual SQL queries that are giving problems is no difficult task.
But identifying some PL/SQL block can be a difficult job.


Oracle has a package called DBMS_PROFILER, with this package , we can profile a code and idntify certain bottlenecks in the PL/SQL code.

 With many Oracle clients such as PL/SQl developer,Toad etc there is an option of PL/SQL profiling.

There is good tutorail on how to use the package DBMS_PROFILER direclty.
These are some good links to follow for that

http://www.oracle-base.com/articles/9i/DBMS_PROFILER.php
http://www.dbasupport.com/oracle/ora8/dbms_profiler2.shtml
< Previous   Next >



Polls
Have you visited this site earlier?
  
gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org