Search

Top 60 Oracle Blogs

Recent comments

Developer Live wrap up

The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across the USA, Europe and APAC timezones! I very much appreciate you giving up your time to attend the session.

Whilst we were doing some Q&A I tried to add as many useful links into the chat line as I could, to help people with onward learning on SQL performance and database performance in general. A few of you then asked if I could publish that chat as to not lose that information, so here it is below

From Me to Everyone:  04:06 PM
Hi everyone,

Its Connor here. Chris Saxon and I are monitoring the Q&A channel, so fire off your questions and we’ll answer them right here.  Anything we can’t answer, we’ll tackle at a later date.

Sessions are all recorded and will be made available in the next day or so.
Check back on
https://developer.oracle.com/developer-live/database for the recordings.

From Me to Everyone:  04:36 PM

If you want more details on PLSQL, I had a chat with Ace Director Patrick Barel about PLSQL, which you can check out here on my youtube channel https://www.youtube.com/watch?v=7xcQtxsM7DE
There are more videos on parsing and avoiding the pain of it at my YouTube channel https://www.youtube.com/c/ConnorMcDonaldOracle

If you want fun way of explaining array fetching to your development team, here’s a funny video on a real world example https://www.youtube.com/watch?v=-Mlxdn5osvs

If you want more info on some of these more sophisticated SQL statements, here’s a playlist on analytic SQL https://www.youtube.com/watch?v=0cjxYMxa1e4&list=PLJMaoEWvHwFIUwMrF4HLnRksF0H8DHGtt

See the full example of how smart the database optimizer is here https://www.youtube.com/watch?v=s1MDfejM0ys

How to use FORCE_MATCHING_SIGNATURE on V$SQL. Check out my blog post on this
https://connor-mcdonald.com/2016/05/30/sql-statements-using-literals/

cursor_sharing can also be used to improve DML (insert/update/delete) performance. Here’s an example https://connor-mcdonald.com/2019/05/17/hacking-together-faster-inserts/

More information on bind peeking  https://www.youtube.com/watch?v=MnISfllmK74 and some of the risks that were there in earlier versions problems with bind peeking https://www.youtube.com/watch?v=ynLF6S15J5M

And here is how adaptive cursor sharing improves things https://www.youtube.com/watch?v=m9sjq9TDuTw

If you DO find SQL complex, then here’s a great resource to get up to speed with database developement using SQL https://asktom.oracle.com/databases-for-developers.htm

Once again, thanks for attending, and if you the missed the session, here it is below