Re: Spotlight on Oracle
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: mufc01666@xxxxxxxxx
- Date: Fri, 22 Mar 2013 12:30:10 -0700
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@xxxxxxxxx> wrote:
> Spotlight on Oracle
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
