Hey ! Gary !

It is a cool staff. I can contribute to that session by brief look
from DBA perspective talking about:
-- PL/SQL Performance dangerous bits from Development DBA live experience
-- Native compilation or how to do not use it :)
-- Possible troubleshooting methods (call stack etc)

It is a great hint about Connor McDonald. I met him last AUSOUG in
Melbourne. We will get in touch with him and if he is in the town by
any chance we will invite to speak at Meetup.

Yury Velikanov
Oracle [Apps] DBA

The Pythian Group (Sydney Office)
http://timeanddat...

From Sydney:
+61 (0)280147452 or +61 (0)280149235 x 277 - office
+61 (0)414252591 - cell

From US & Canada
+1 [masked]  x 277 - office

www.pythian.com
---------------------------------
IMs:
---------------------------------
Skype 	j.velikanovs 	
AIM 	pythianvelikanov 		
GTalk 	[address removed] 	
MSN 	[address removed] 	
Y! 	[address removed]
---------------------------------



On 3 February 2010 14:44, Gary Myers <[address removed]> wrote:
> I'm happy to put my hand up for discussing / presenting some PL/SQL stuff
> and/or performance from a developer's perspective.
> I've been chugging through Steven F.'s book and picked up some good stuff.
>
> Connor McDonald would be Australia's Mr PL/SQL (despite a website of
> www.oracledba.co.uk), but he's in Perth and there's a big gap between east
> and west coasts.
>
> I saw him present in Melbourne a few years back and it is....breath-taking.
> You can get his slides from last year's talk at Melbourne. All 700 of them,
> presented over a single morning. Click-click-click. Its a unique style, but
> works well.
>
> There's a lot of PL/SQL that is simply control structures (loops, if/then..
> etc) around SQL statements (possibly the more complicated stuff like
> multi-table inserts) or chopping around variables with functions that are
> pretty similar to SQL functions, mostly using SQL datatypes. Connor's book
> and Steven Feuerstein's both consider SQL as the foundation for PL/SQL.
>
> I'd guess the main complications particular to PL/SQL are
> 1. Exception handling and propagation
> 2. Record types and collections.
> 3. Dynamic SQL
> 4. Triggers (and why not to use them)
> 5. Built-in packages like DBMS_JOB, UTL_FILE, UTL_HTTP etc.
>
> What sort of problems does EBS throw up in PL/SQL ? Is it performance
> related, session-state, something else
> And do they wrap their PL/SQL ?
>
>   Gary
>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Gary Myers ([address removed]) from Sydney
> Oracle Meetup.
> To learn more about Gary Myers, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Inc. PO Box 4668 #37895 New York, New York 10163-4668 |
> [address removed]
--
Client of Pythian? On twitter? Let @paulvallee know and we'll add you
to @pythian/clients!