Re: Can someone please motivate to learn scripting and learn oracle internals ?

From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Tue, 30 Aug 2016 22:07:18 -0300
Message-ID: <CACH2ED+NY_pAER6-0p+bgNt480LbxSfd0zceQuwT1czfNMeDNA_at_mail.gmail.com>



thanks Tim!

I attended those seminars which were patterned after employees' courses if I remember correctly. What flabbergasted me was early on, Scott said "Ok, let's just do this." He described in detail, down to hexadecimal values, what happened when a user connected to Oracle using sqlplus to submit a query. He described the index blocks, the table block contents, everything. Then he used his diagram now and again to explain points later on during the seminar.

He also said things like "in 7.3 this is what happened, in 8.0 it started to change this way, but it was only in 9.2 that it finally settled to this and that's what you will see now if you look at the actual values."

I left that week telling myself "if I knew 1/10th of what that guy knows,..."

It was also obvious that he had contacts inside Oracle to answer just about any question. He spent his breaks answering questions from past students or from others, I imagined it was from other Oracle employees.

Oh he mentioned Krispy Kreme donuts... that was around the time they started becoming really popular I think.

Pat.

On Tue, Aug 30, 2016 at 2:22 PM, Tim Gorman <tim_at_evdbt.com> wrote:

> Some good history here...
>
> Those internals courses were originally written by Lex de Haan, and Scott
> Gossett was tagged specifically to deliver them. However, Scott was
> delayed from delivering those courses in 1998 and 1999, and classes had
> already been scheduled, so Oracle Education contracted me to deliver the
> first half-dozen seminars, including IOUG-Live 1999, as well as seminars in
> Caracas, Rio de Janiero, and Buenos Aires. I balked at delivering seminars
> in Medellin and Cali, because at that time it could be expensive and/or
> fatal to be both American and in Medellin or Cali.
>
> I had left Oracle Corporation a few months previous to become an
> independent consultant, and as part of my preparation, had requested one
> day on the internal Oracle network with the level of access that I had
> previously enjoyed as an employee, so that I could loot the internal
> support and development pages for explanatory information. It was not
> unlike one of those contests where someone wins a shopping spree for one
> hour where they can leave with anything they can carry in that time.
>
> Altogether, teaching those courses was both a terrifying and electrifying
> experience.
>
> Terrifying because this was one situation where the slidedecks contained
> *FAR* more information than I had ever imagined. Terrifying because most
> of the attendees were so scary smart, and had likely forgotten more than I
> ever knew.
>
> And the experience was electrifying for the same reasons.
>
> Thankfully, Scott came available and, as Pete indicated, is still crushing
> it at Oracle.
>
>
>
>
> On 8/30/16 10:48, Peter Sharman wrote:
>
> Nope, still works as a Consulting Technical Director in Oracle Consulting.
>
>
>
> Otherwise I agree. J
>
>
>
> Pete
>
>
> Pete Sharman
> Database Architect, DBaaS / DBLM
> Enterprise Manager Product Suite
> 33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
>
> Phone: +61262924095 | | Mobile: *+61414443449 <%2B61414443449>*
> Email: pete.sharman_at_oracle.com Twitter: _at_SharmanPete LinkedIn:
> au.linkedin.com/in/petesharman
> Website: petewhodidnottweet.com
> ------------------------------
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
>
>
> "Oh no, it's not, it's much harder than that!"
>
> Bruce Pihlamae, long term Oracle DBA
> ------------------------------
>
>
>
> *From:* Patrice sur GMail [mailto:patrice.boivin_at_gmail.com
> <patrice.boivin_at_gmail.com>]
> *Sent:* Tuesday, August 30, 2016 03:24 PM
> *To:* itakamran_at_azercell.com
> *Cc:* dbaorapps_at_gmail.com; ORACLE-L <oracle-l_at_freelists.org>
> <oracle-l_at_freelists.org>
> *Subject:* RE: Can someone please motivate to learn scripting and learn
> oracle internals ?
>
>
>
> Scott Gosset must have retired by now, he was awesome. He used to teach
> internals seminars.
>
>
>
> On Aug 30, 2016 02:13, "Kamran Agayev (TD/DBA)" <itakamran_at_azercell.com>
> wrote:
>
> Beside your own investigations, you might also check the following two
> books:
>
>
>
> Secrets of the Oracle Database (Expert's Voice in Oracle) 1st ed. Edition
>
> https://www.amazon.com/Secrets-Oracle-Database-Experts-Voice/dp/1430219521
>
>
>
> Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice
> in Databases) 1st ed. Edition
>
> https://www.amazon.com/Oracle-Core-Essential-Internals-
> Developers/dp/1430239549
>
>
>
>
>
> BR,
>
>
>
> Kamran Aghayev A.
>
> http://www.ocm11g.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Apps DBA
> *Sent:* Tuesday, August 30, 2016 6:47 AM
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* Can someone please motivate to learn scripting and learn
> oracle internals ?
>
>
>
>
> ------------------------------
>
> This e-mail and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any dissemination, forwarding, copying or use of any of the
> information is strictly prohibited and the e-mail should be deleted
> immediately.
>
> Bu e-mail və onunla göndərilən istənilən fayllar məxfidir və yalnız
> ünvanlandığı fərdin və ya müəssisənin istifadəsi üçün nəzərdə tutulmuşdur.
> Nəzərinizə çatdırırıq ki, əgər Siz nəzərdə tutulan qəbuledici deyilsinizsə,
> göndərilən məlumatın hər hansı şəkildə yayılması, yönləndirilməsi,
> kopyalanması və ya istifadəsi qəti qadağandır və həmin e-mail dərhal
> silinməlidir.
>
>
>

-- 


-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 31 2016 - 03:07:18 CEST

Original text of this message