Re: reduce wait times

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0402160740.c3b131e_at_posting.google.com...
> "gp" <gieppetto_at_tiscali.it> wrote in message
news:<c0qa95$32$1_at_fata.cs.interbusiness.it>...
> > my problem is that the 90% of i/o operations and query executions is
made
> > from an application external that i cannot modify, so i try to adjust
> > performance without modify sql statements.
>
> So you have no problem at all! Just sit in your office dring a tea
> and/or coffee and if someone will come to complain about performance
> just blame the vendor. Without access to code you can't tune anything.
> Well, they're some possibilities (maybe outlines, disk tunning, some
> memory allocation changes), but blaming on vendor is quite reasonable
> and much more efficient.

Actually then surely, since you can do nothing, you may as well drink beer. Of course shortly after this becomes common knowledge you will be fired, giving more time but less cash for beer.

gp

Dusan's comments and Paul's about stored outlines and optimizing memory use may well be relevant. Equally important may well be a discussion with your app vendor along the lines of

US: 'this process takes far too long with our data' THEM:'oh really on our test database this works fine' US:'sure, but do you have 85 million rows in the table?' THEM:'er no, we do have ten rows in the table' US:'well I suggest you reproduce on this copy of our data' (produce export file from behind back)
US:' because that will help explain why we won't be paying your bill for the moment'.
US:' oh btw if you changed the sql to .... or allowed me to hint the statements you might find the bill paid quite rapidly'. THEM:' er....Ok, btw do you listen to too much Pink Floyd?'.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

P.S. I missed out US:'Too much Pink Floyd, can such a state exist?'