Re: how many LIOs is too many
From: Ram Raman <veeeraman_at_gmail.com>
Date: Sat, 25 Jan 2014 18:43:01 -0600
Message-ID: <CAHSa0M0mBmYA+SC3DVjOqh8bz640O5t+pm8WuGMGrMd6YaabBQ_at_mail.gmail.com>
List,
Date: Sat, 25 Jan 2014 18:43:01 -0600
Message-ID: <CAHSa0M0mBmYA+SC3DVjOqh8bz640O5t+pm8WuGMGrMd6YaabBQ_at_mail.gmail.com>
List,
Jonathan was spot on. As soon as I added an index on (maudrecno, memrecno) in the test database the time dropped from 4:14 to 3 seconds.
I have copied and pasted the outputs from the dev environment:
https://docs.google.com/file/d/0B9YC82qZ8_3eYlJGalRVQTM3cUU/edit
Thanks for all the people who helped.
Ram.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 26 2014 - 01:43:01 CET