Re: Spotlight on Oracle
From: kyle Hailey <kylelf_at_gmail.com>
Date: Fri, 22 Mar 2013 12:30:10 -0700
Message-ID: <CADsdiQiTR9+_mqKbHpupof1dJYsM4vhBN2=0Q7a90qN67OuubA_at_mail.gmail.com>
I loved Spotlight when it came out in 13 years ago. That being said, it's methodology had remained the same where as the industry has changed. Oracle came out with Average Active Sessions in Enterprise Manager and that model has been adopted across the industry.
Date: Fri, 22 Mar 2013 12:30:10 -0700
Message-ID: <CADsdiQiTR9+_mqKbHpupof1dJYsM4vhBN2=0Q7a90qN67OuubA_at_mail.gmail.com>
I loved Spotlight when it came out in 13 years ago. That being said, it's methodology had remained the same where as the industry has changed. Oracle came out with Average Active Sessions in Enterprise Manager and that model has been adopted across the industry.
Lab128 is a better recommendation. Lab128 that is faster, lighter weight,
cheaper and uses the Average Active Session approach to performance
monitoring. Lab128 can use active session history from Oracle if you paid
for it or it can collect it without Oracle meaning it works on Standard
Edition as well as Enterprise.
See
http://dboptimizer.com/2013/02/17/lab-128-expert-dbas-secret-weapon/
Of course there is DB Optimizer which uses Average Active Sessions approach as Lab128 and DB Optimizer has Visual SQL Tuning (VST) based on the ideas of Dan Tow in his book "SQL Tuning"
- Kyle Hailey http://dboptimizer.com
On Fri, Mar 22, 2013 at 8:15 AM, Root <mufc01666_at_gmail.com> wrote:
> Spotlight on Oracle
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 22 2013 - 20:30:10 CET