Originally posted by parijat67
okk. I would run statspack to gather the sql queries. What if I need to find out the expensive queries while running a particular application process and the statspack is not configured?

Suppose, I have run a process thru the application which does huge amount of calculations on huge set of tables and while the calculations are being done I want to check the queries according to the resources they are utilising. The purpose of this is to fine tune those expensive queries to speed up the process that I had run.

thanks

Paul
statspack is still the answer, not hard to set up and then you dont have to worry about querying the database for yourself

as sysdba

@?/rdbms/admin/spcreate.sql

done statspack installed