Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Oracle Query Costing Tool

  • 18-10-2007 10:53am
    #1
    JohnnyBravo
    Closed Accounts Posts: 537 ✭✭✭


    Hi All

    I am looking for a freeware application that will tell me the cost of queries that are running against an oracle system
    Does anyone know of any

    Thanks


Comments

  • #2
    thewing
    Registered Users, Registered Users 2 Posts: 661 ✭✭✭thewing


    Why don't you just generate the explain plan for the statement you are running...


  • #3
    JohnnyBravo
    Closed Accounts Posts: 537 ✭✭✭JohnnyBravo


    We have a reporting application that sits on the database but it doesnt have an explain plan attached
    So i need a freeware app to just check that queries are actually being run against the database and their costing


  • #4
    thewing
    Registered Users, Registered Users 2 Posts: 661 ✭✭✭thewing


    Generate a session level trace, step through your app, use tkprof to format the trace, have a look.


  • #5
    DublinWriter
    Registered Users, Registered Users 2 Posts: 9,568 ✭✭✭DublinWriter


    JohnnyBravo wrote: »
    So i need a freeware app to just check that queries are actually being run against the database and their costing
    This is already built into Oracle - check out EXPLAIN PLAN.


Advertisement