hi
you write query in order of largest,larger,large table fashion
and input parameter column may be indexed
tlw
hernawan wrote:
Hi all,
I have process in Oracle apps 11.5.8 which need
very lot CPUs and long time to complete.
for about 17,000 invoices it takes 28 hours !!
I have open
sarcasm
Wow, your buffer cache hit ratio for this query is better than
99.99%! With a BCHR like that, how could you possibly tune this
query to be better??
/sarcasm
Now, seriously, since I know nothing about your application or
environment, and you do not show execution plan, I can only
Hernawan,
Is this a custom or standard Concurrent request? If this is standard, there
may be a patch out for your module/level. If not, I would use a 10046 level
12 to look at the issue. As you can see from tkprof, you have a huge amount
of LIO... Is your init.ora parameters kosher as per Oracle
comments in line...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:04 AM
sarcasm
Wow, your buffer cache hit ratio for this query is better than
99.99%! With a BCHR like that, how could you possibly tune this