Any tool to analyze SP Packeges??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Any tool to analyze SP Packeges??

  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Any tool to analyze SP Packeges??

    Hi - Is there any way we can analyze SP Packages in ORacle 9i???

    We have lots of Packeges and we want to analyze if Stored procedured build are optimized or not...

    is there any tool which is easy to use and can give me reports on how well written sp's are...

    Kavans.

  2. #2
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi
    DBMS_PROFILER in Oracle 8i is a good tool and should be in 9i as well which I am not sure of .
    There is a chapter on it in Expert one on One by Tom Kyte .

    Cheers
    Afshin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width