topic Re: application tuning in Operating System - HP-UX

application tuning

dngaya — Wed, 24 Dec 2003 05:12:45 GMT

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.

Re: application tuning

Yogeeraj_1 — Wed, 24 Dec 2003 05:28:17 GMT

hi,

can you also post the execution plan?

set autotrace traceonly

regards
Yogeeraj

Re: application tuning

zhuchao — Fri, 26 Dec 2003 03:04:47 GMT

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.

Re: application tuning

Emilio Brusa — Fri, 26 Dec 2003 19:23:51 GMT

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