Re: AWR interpretation
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 30 Oct 2013 14:51:21 -0500
Message-ID: <CAJvnOJY7-A=9tXKPy1EKomU8zvTyyO1YG0y5gzHPuxM3kMB9Ug_at_mail.gmail.com>
One other thing, if you have lob's in your data, you can pretty much kiss your performance goodby. I am sure someone here can identify why, I never really tried to track it down, but basically lob's take about 10 times longer to deal with than any other item. <snip
Date: Wed, 30 Oct 2013 14:51:21 -0500
Message-ID: <CAJvnOJY7-A=9tXKPy1EKomU8zvTyyO1YG0y5gzHPuxM3kMB9Ug_at_mail.gmail.com>
One other thing, if you have lob's in your data, you can pretty much kiss your performance goodby. I am sure someone here can identify why, I never really tried to track it down, but basically lob's take about 10 times longer to deal with than any other item. <snip
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 30 2013 - 20:51:21 CET