1748243 Members
4048 Online
108760 Solutions
New Discussion юеВ

application tuning

 
dngaya
Advisor

application tuning

hi ,
I have a database oracle 8.1.7 installed of HP 11.0. I have a problem of response time on a request which takes too much time. I have just launched a tkprof of which here results in file attachment.
I do not know the tuning, is what somebody can do to me of the comments.
3 REPLIES 3
Yogeeraj_1
Honored Contributor

Re: application tuning

hi,

can you also post the execution plan?

set autotrace traceonly


regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
zhuchao
Advisor

Re: application tuning

To solve your problem , you must clearly state your table structure, your index, your data volume, your execution plan.

You maybe need to create proper index on ta1.some_column depend on the selectivity of the columns and the bind variable.
And consider have proper index on the joined columns.
www.happyit.net
Emilio Brusa
Frequent Advisor

Re: application tuning

HI
how many rows are there in the tables ?
if you dont use indexes. the query scan all table.

The Oracle Enterprise have some tools for tunning