DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Any tool to analyze SP Packeges??

  1. 07-07-2003, 03:13 AM #1
    Kavans
    Kavans is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 07-08-2003, 07:28 PM #2
    afshin
    afshin is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width