RE: DBA Skill tree
From: David Kurtz <info_at_go-faster.co.uk>
Date: Mon, 6 Apr 2009 15:52:35 +0100
Message-ID: <805264AA6F6440FEADEEB458EF13AF87_at_GOFASTER4>
> I'm sick and tired of manually figuring out three-page-long Peoplesoft SQL
with umpteen levels of views on views
> and impenetrable execution plans. On a good day.
> That is precisely where an automatic tool like the tuning pack becomes
invaluable. It saves heaps of time.
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
Date: Mon, 6 Apr 2009 15:52:35 +0100
Message-ID: <805264AA6F6440FEADEEB458EF13AF87_at_GOFASTER4>
> I'm sick and tired of manually figuring out three-page-long Peoplesoft SQL
with umpteen levels of views on views
> and impenetrable execution plans. On a good day.
> That is precisely where an automatic tool like the tuning pack becomes
invaluable. It saves heaps of time.
While I sympathise with the rest of the sentiment, I have yet to agree with the suggestions of the tuning pack when applied to PeopleSoft nested views.
regards
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 06 2009 - 09:52:35 CDT