8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Here

About Tim Hall and the Website

Tim Hall

DBA, Developer, Author, Trainer
Birmingham, UK

Tim Hall  

Quotes:

"The harder I work, the luckier I get."
Samuel Goldwyn

"If you trust in yourself and believe in your dreams and follow your star you'll still get beaten by people who spent their time working hard and learning things and weren't so lazy."
Miss Tick (The Wee Free Men, Terry Pratchett)

"There’s a billion places like home. But only one of 'em's where you live."
Granny Weatherwax (Witches Abroad, Terry Pratchett)

"If there's one thing I've learnt about experts, they're experts on f*ck all!"
Jake Green (Revolver, Guy Richie)

Tim Hall is an Oracle Certified Professional (OCP) DBA/Developer, Oracle ACE Director, Oracle Groundbreaker Ambassador, OakTable Network member and was chosen as Oracle ACE of the Year 2006 by Oracle Magazine Editors Choice Awards. He has been involved in DBA, design and development work with Oracle databases since 1995.

Although focusing on database administration and PL/SQL development, he has gained a wide knowledge of the Oracle software stack and has worked as a consultant for several multi-national companies on projects ranging from real-time control systems to OLTP web applications.

Since 2000 Tim has published over 1,000 articles on his website (oracle-base.com) covering a wide range of Oracle features.

In his spare time Tim enjoys watching movies, reading and takes part in a number of activities including Yoga and going to the gym.

Certifications and Awards

Oracle ACE Oracle Developer Champion Oracle Groundbreaker Ambassador Oak Table Network Symposium42
OCA OCP      
OCP DB 10g Admin OCP DB 11g Admin OCP DB 12c Admin    
OCA PL/SQL Development OCP Advanced PL/SQL Development OCE: Oracle SQL Expert    

Publications

Oracle Job Scheduling - Creating robust task management with dbms_job and Oracle 10g dbms_scheduler
Oracle Job Scheduling
(2005)

(read reviews)
Oracle PL/SQL Tuning - Expert Secrets for High Performance Programming
Oracle PL/SQL Tuning
(2006)

(read reviews)

Conferences and Teaching Dates

Date Location Organisation Description
October2023 Birmingham, UK BCU Birmingham City University MSc Student Talks
July 2023 Birmingham, UK BCU Birmingham City University MSc Student Talks
 
Nov 2022 Birmingham, UK BCU Birmingham City University MSc Student Talks
 
Nov 2020 USA, Online ECO East Coast Oracle Users Conference 2020
Oct 2020 Asia Pacific, Online APAC Oracle Groundbreakers Tour APAC Virtual Tour
Oct 2020 Spain, Online SPOUG SPOUG20 Conference
Oct 2020 Croatia, Online HrOUG Oracle Groundbreakers Tour EMEA Virtual Tour
Aug 2020 Latin America, Online LAOUC Oracle Groundbreakers Tour Latin America Virtual Tour
July 2020 India, Online AIOUG Oracle Groundbreakers Yatra 2020 Virtual Tour
Apr 2020 UK, Online UKOUG UKOUG Tech Summit
 
Sep 2019 San Francisco, USA Oracle OpenWorld and Code One Conference
Apr 2019 Dublin, Ireland OUGI Conference
Feb 2019 Antwerp, Belgium OBUG Belgian Tech Days 2019
 
Dec 2018 Liverpool, UK UKOUG Conference
Nov 2018 Birmingham, UK BCU Birmingham City University CS Student Talks
Nov 2018 Bulgaria BGOUG Conference
Oct 2018 San Francisco, USA Oracle OpenWorld and Code One Conference
Aug 2018 Mexico DF, Mexico ODC Latin America Tour (Northern Leg) Conference
Aug 2018 Panama, Panama ODC Latin America Tour (Northern Leg) Conference
Aug 2018 San Jose, Costa Rica ODC Latin America Tour (Northern Leg) Conference
Aug 2018 Barranquilla, Colombia ODC Latin America Tour (Northern Leg) Conference
Aug 2018 Quito, Ecuador ODC Latin America Tour (Northern Leg) Conference
July 2018 Paris, France Oracle Code Conference
Jun 2018 Amersfort, Netherlands nlOUG Conference
May 2018 Riga, Latvia Riga Dev Days Conference
Apr 2018 Warsaw, Poland Oracle Code Conference
Apr 2018 Bangalore, India Oracle Code Conference
Apr 2018 Hyderabad, India Oracle Code Conference
Mar 2018 Dublin, Ireland OUGI Conference
 
Dec 2017 Birmingham, UK UKOUG Conference
Nov 2017 Birmingham, UK BCU Birmingham City University CS Student Talks
Sep 2017 San Francisco, USA Oracle OpenWorld Conference
Jun 2017 Amersfort, Netherlands OGh Conference
May 2017 Pravets, Bulgaria BGOUG Conference
Apr 2017 Prague, Czech Republic Oracle Code Conference
Apr 2017 London, UK Oracle Code Conference
Mar 2017 Dublin, Ireland OUGI Conference
Jan 2017 Birmingham, UK UKOUG Special Interest Group (SIG)
 
Dec 2016 Birmingham, UK UKOUG Tech16 Conference
Nov 2016 Pravets, Bulgaria BGOUG Conference
Nov 2016 Gold Coast, Australia OTN APAC Tour Conference
Oct 2016 Sydney, Australia OTN APAC Tour Conference
Oct 2016 Auckland, New Zealand OTN APAC Tour Conference
Oct 2016 Wellington, New Zealand OTN APAC Tour Conference
Sept 2016 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Sep 2016 San Francisco, USA Oracle OpenWorld Conference
Sep 2016 Redwood Shores, USA Cloud User Experience (UX) Strategy Day Special Interest Group (SIG)
Aug 2016 Pereira, Colombia OTN Latin America Tour (Northern Leg) Conference
Aug 2016 Guatemala City, Guatemala OTN Latin America Tour (Northern Leg) Conference
Aug 2016 Mexico City, Mexico OTN Latin America Tour (Northern Leg) Conference
Aug 2016 San Jose, Costa Rica OTN Latin America Tour (Northern Leg) Conference
Aug 2016 Panama City, Panama OTN Latin America Tour (Northern Leg) Conference
July 2016 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Jun 2016 FIGI in Zeist, Netherlands OGH OGH SQL Celebration Day
Jun 2016 Valkenburg in Katwijk, Netherlands AMIS AMIS 25th Anniversary Conference
Jun 2016 Valkenburg in Katwijk, Netherlands OTN OTN Cloud Developer Challenge
May 2016 Paris, France Paris Province Oracle Meetup Local Meetup
May 2016 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Apr 2016 Birmingham, UK BCU Birmingham City University CS Student Talks
Mar 2016 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Mar 2016 Birmingham, UK UKOUG Special Interest Group (SIG)
Mar 2016 Dublin, Ireland OUGI Conference
 
Dec 2015 Birmingham, UK BCU Birmingham City University CS Student Talks
Dec 2015 Birmingham, UK UKOUG Tech 15 Conference
Nov 2015 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Nov 2015 Hyderabad, India SANGAM15 Conference
Nov 2015 San Francisco, USA Oracle OpenWorld Conference
Sep 2015 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Aug 2015 Lima, Peru OTN Latin America Tour (Southern Leg) Conference
Aug 2015 Santiago, Chile OTN Latin America Tour (Southern Leg) Conference
Aug 2015 Sao Paulo, Brazil OTN Latin America Tour (Southern Leg) Conference
Aug 2015 Buenos Aires, Argentina OTN Latin America Tour (Southern Leg) Conference
Aug 2015 Montevideo, Uruguay OTN Latin America Tour (Southern Leg) Conference
Jul 2015 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
May 2015 London UK UKOUG Operating Systems & Storage Event
May 2015 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
May 2015 Birmingham, UK BCU Birmingham City University Staff Talk
Mar 2015 Birmingham, UK BCU Birmingham City University CS Student Talks
Mar 2015 Dublin, Ireland OUGI Conference
Mar 2015 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Feb 2015 Birmingham, UK BCU Birmingham City University CS Student Talks
Jan 2015 Riga, Latvia LVOUG Conference - Riga Dev Day
 
Dec 2014 Liverpool, UK UKOUG Tech14 Conference
Nov 2014 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Nov 2014 Auckland, New Zealand OTN APAC Tour Conference
Nov 2014 Bangkok, Thailand OTN APAC Tour Conference
Nov 2014 Beijing, China OTN APAC Tour Conference
Nov 2014 Tokyo, Japan OTN APAC Tour Conference
Nov 2014 Shanghai, China OTN APAC Tour Conference
Nov 2014 Perth, Australia OTN APAC Tour Conference
Sep 2014 San Francisco, USA Oracle OpenWorld Conference
Sep 2014 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Jun 2014 Sandanski, Bulgaria BGOUG Conference
May 2014 Birmingham, UK UKOUG Operating Systems & Storage Event
May 2014 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
May 2014 Birmingham, UK UKOUG Next Gen Introducing students to Oracle and the community.
Apr 2014 Oslo, Norway OUGN Conference
Mar 2014 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
Mar 2014 Dublin, Ireland OUGI Conference
Mar 2014 Chennai, India OTNYathra : India OTN Tour Conference
Feb 2014 Bangalore, India OTNYathra : India OTN Tour Conference
Feb 2014 Hyderabad, India OTNYathra : India OTN Tour Conference
Feb 2014 Pune, India OTNYathra : India OTN Tour Conference
Feb 2014 Mumbai, India OTNYathra : India OTN Tour Conference
Feb 2014 Noida, India OTNYathra : India OTN Tour Conference
Feb 2014 Jalandhar, India OTNYathra : India OTN Tour Conference
Jan 2014 Birmingham, UK Oracle Midlands Special Interest Group (SIG)
 
Dec 2013 Manchester, UK UKOUG Tech13 Conference
Oct 2013 Oslo, Norway OTN Nordic Tour Conference
Oct 2013 Copenhagen, Denmark OTN Nordic Tour Conference
Oct 2013 Stockholm, Sweden OTN Nordic Tour Conference
Sep 2013 San Francisco, USA Oracle OpenWorld Conference
Aug 2013 Sao Paulo, Brazil OTN Latin America Tour (Southern Leg) Conference
Aug 2013 Buenos Aires, Argentina OTN Latin America Tour (Southern Leg) Conference
Aug 2013 Montevideo, Uruguay OTN Latin America Tour (Southern Leg) Conference
Aug 2013 Lima, Peru OTN Latin America Tour (Southern Leg) Conference
Aug 2013 Santiago, Chile OTN Latin America Tour (Southern Leg) Conference
May 2013 Hissarya, Bulgaria BGOUG Conference
 
Dec 2012 Birmingham, UK UKOUG Conference
Sep 2012 San Francisco, USA Oracle OpenWorld Conference
July 2012 San Jose, Costa Rica OTN Latin America Tour (Northern Leg) Conference
July 2012 Tegucigalpa, Honduras OTN Latin America Tour (Northern Leg) Conference
July 2012 Guatemala City, Guatemala OTN Latin America Tour (Northern Leg) Conference
July 2012 Port of Spain, Trinidad and Tobago OTN Latin America Tour (Northern Leg) Conference
July 2012 Quito, Ecuador OTN Latin America Tour (Northern Leg) Conference
July 2012 Cali, Colombia OTN Latin America Tour (Northern Leg) Conference
 
Dec 2011 Birmingham, UK UKOUG Conference
Nov 2011 Hissarya, Bulgaria BGOUG Conference
Nov 2011 Perth, Australia OTN APAC Tour, AUSOUG Conference
Oct 2011 Auckland, New Zealand OTN APAC Tour, NZOUG Conference
Oct 2011 Beijing, China OTN APAC Tour Conference
Oct 2011 San Francisco, USA Oracle OpenWorld Conference
Aug 2011 Canberra, Australia ACTOUG User Group - Special Interest Group
Aug 2011 Sydney, Australia Sydney Oracle Meetup User Group - Special Interest Group
Aug 2011 Sydney, Australia AUSOUG Conference
 
Nov 2010 Belgrade, Serbia Oracle University 2 Day PL/SQL Masterclass
Oct 2010 Hong Kong Oracle University 2 Day PL/SQL Masterclass
Oct 2010 Melbourne, Australia Oracle University 2 Day PL/SQL Masterclass
Oct 2010 Sydney, Australia Oracle University 2 Day PL/SQL Masterclass
Oct 2010 Singapore Oracle University 2 Day PL/SQL Masterclass
Sep 2010 San Francisco, USA Oracle OpenWorld Conference
Jun 2010 Washington D.C., USA ODTUG Kaleidoscope Conference
May 2010 Zagreb, Croatia Oracle University 2 Day PL/SQL Masterclass
Apr 2010 Plovdiv, Bulgaria BGOUG Conference
Mar 2010 Auckland, New Zealand NZOUG 2 Day PL/SQL Masterclass
Mar 2010 Rotorua, New Zealand NZOUG Conference
 
Dec 2009 Birmingham, UK UKOUG Conference
Nov 2009 Melbourne, Australia AUSOUG Conference
Nov 2009 Canberra, Australia ACTOUG User Group - Special Interest Group
Nov 2009 Perth, Australia AUSOUG Conference
Oct 2009 San Francisco, USA Oracle OpenWorld Conference
Sep 2009 Utrecht, Netherlands Miracle Benelux 2 Day PL/SQL Masterclass
June 2009 Monterey, USA ODTUG Conference
May 2009 Helsinki, Finland OUGF Conference
May 2009 Stockholm, Sweden ORCAN Conference
May 2009 Bratislava, Slovakia Oracle University 2 Day PL/SQL Masterclass
April 2009 Pomporova, Bulgaria BGOUG Conference
April 2009 Santiago, Chile CLOUG Conference
 
Dec 2008 Stockholm, Sweden ORCAN Conference
Oct 2008 Rotorua, New Zealand NZOUG Conference
Oct 2008 Gold Coast, Australia AUSOUG Conference
Oct 2008 Perth, Australia AUSOUG Conference
Sep 2008 San Francisco, USA Oracle OpenWorld Conference
Jul 2008 Birmingham, UK UKOUG DE SIG Conference
Jun 2008 Tallinn, Estonia Oracle University 2 Day PL/SQL Masterclass
Mar 2008 Copenhagen, Denmark Oracle University 2 Day PL/SQL Masterclass
Feb 2008 Vienna, Austria Oracle University 2 Day PL/SQL Masterclass
 
Nov 2007 San Francisco, USA Oracle OpenWorld Conference
Oct 2007 London, UK UKOUG DE SIG User Group - Special Interest Group
Jan 2007 Birmingham, UK UKOUG DE SIG User Group - Special Interest Group
 
Oct 2006 San Francisco, USA Oracle OpenWorld Conference


View Oracle-Related Travel in a larger map

My Sites and Profiles

Contact ORACLE-BASE.com

I'm one guy with a full time job, and I do this website in my spare time. As you can imagine, that doesn't leave much time to answer questions for people. I had to close the forum on this site because I spent so long answering questions I had no time to produce new content. Please keep this is mind when trying to contact me by email.

With all that in mind, my email address is "tim(@)oracle-base.com".

ORACLE-BASE History

ORACLE-BASE started life as a collection of SQL scripts that I used regularly in several companies. Rather than take them between jobs on disks, I put them on a website so I would always have access to them.

Later I started to write how-to documents for new Oracle features and revision notes I used to prepare for OCP exams. Over the years the site has grown in size and popularity...

I have a real job too. The website is not a business, just something I do for fun.

Copyright & Disclaimer

Copyright:

Copyright© 2000, 2024 ORACLE-BASE.com. All rights reserved.

Articles created prior to 2005-05-14, will have a created date of 2005-05-14, as this is when created and updated dates were first captured by the current CMS.

This site and all content provided on it belongs to ORACLE-BASE.com and is copyrighted by law. The content of this site should not be republished, or used for training AI models without explicit permission.

All material is the property of ORACLE-BASE.com unless otherwise stated.

Disclaimer:

All information is offered in good faith and in the hope that it may be of use, but is not guaranteed to be correct, up to date or suitable for any particular purpose.

ORACLE-BASE.com accepts no liability in respect of this information or its use.

ORACLE-BASE.com is a UK based website which is governed by UK law. By using this website you are agreeing to abide by UK law.

This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.

Product and company names mentioned in this website may be the trademarks of their respective owners.

Cookie Policy

This has been moved to Privacy Policy page.