If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Edition highlights:<br /> Notes from OpenWorld<br /> from the UKOUG President<br /> Chatbots Come to Life<br /> with Oracle<br /> Plugging into Database<br /> Transportation<br /> Connecting to the Cloud<br /> OracleScene<br /> #OracleScene Winter 17 | Issue 66<br /> ORACLE<br /> OPTIMIZER<br /> <br /> <br /> <br /> <br /> Gathering Optimizer Statistics –<br /> What, Why and How?<br /> www.ukoug.org<br /> An independent publication not<br /> affiliated with Oracle Corporation<br /> <br /> Welcome to Oracle Scene<br /> Inside this issue<br /> Oracle Scene Editorial Team<br /> Editor: Martin Widlake<br /> Email: editor@ukoug.org<br /> Deputy Editor (Apps): Khalil Rehman<br /> Deputy Editor (Apps): Toby Price<br /> Deputy Editor (Tech): Alan McClean<br /> Deputy Editor (Tech): Nicholas Shearer<br /> UKOUG Contact: Deanna Bates<br /> Email: deanna.bates@ukoug.org<br /> Sales: Kerry Stuart<br<a title="Oracle Scene Issue 66 page 1" href="http://viewer.zmags.com/publication/07098028?page=1"> Edition highlights: Notes from OpenWorld from the</a> <a title="Oracle Scene Issue 66 page 2" href="http://viewer.zmags.com/publication/07098028?page=2"> </a> <a title="Oracle Scene Issue 66 page 3" href="http://viewer.zmags.com/publication/07098028?page=3"> Welcome to Oracle Scene Inside this issue Oracl</a> <a title="Oracle Scene Issue 66 page 4" href="http://viewer.zmags.com/publication/07098028?page=4"> OracleScene WINTER 17 First Word First word Wel</a> <a title="Oracle Scene Issue 66 page 5" href="http://viewer.zmags.com/publication/07098028?page=5"> UKOUG Our Missions & Values In the spring ed</a> <a title="Oracle Scene Issue 66 page 6" href="http://viewer.zmags.com/publication/07098028?page=6"> OracleScene WINTER 17 News & Reviews UKOUG L</a> <a title="Oracle Scene Issue 66 page 7" href="http://viewer.zmags.com/publication/07098028?page=7"> UKOUG Speaker Awards and what they’re doing well</a> <a title="Oracle Scene Issue 66 page 8" href="http://viewer.zmags.com/publication/07098028?page=8"> OracleScene WINTER 17 Technology From Tra</a> <a title="Oracle Scene Issue 66 page 9" href="http://viewer.zmags.com/publication/07098028?page=9"> In the log, you will see ‘PLUGTS’, which means ‘P</a> <a title="Oracle Scene Issue 66 page 10" href="http://viewer.zmags.com/publication/07098028?page=10"> WINTER 17 Technology: Franck Pachot OracleScene </a> <a title="Oracle Scene Issue 66 page 11" href="http://viewer.zmags.com/publication/07098028?page=11"> Technology: Franck Pachot If you wa</a> <a title="Oracle Scene Issue 66 page 12" href="http://viewer.zmags.com/publication/07098028?page=12"> WINTER 17 Technology: Franck Pachot OracleScene </a> <a title="Oracle Scene Issue 66 page 13" href="http://viewer.zmags.com/publication/07098028?page=13"> UKOUG: Partner of the Year 2017 partneroftheyear</a> <a title="Oracle Scene Issue 66 page 14" href="http://viewer.zmags.com/publication/07098028?page=14"> OracleScene WINTER 17 UKOUG: Partner of the Year</a> <a title="Oracle Scene Issue 66 page 15" href="http://viewer.zmags.com/publication/07098028?page=15"> UKOUG: Partner of the Year 2017 APPS17 Stand 6 K</a> <a title="Oracle Scene Issue 66 page 16" href="http://viewer.zmags.com/publication/07098028?page=16"> OracleScene WINTER 17 Technology Implement </a> <a title="Oracle Scene Issue 66 page 17" href="http://viewer.zmags.com/publication/07098028?page=17"> is ACCEPTED, which triggers encryption and checks</a> <a title="Oracle Scene Issue 66 page 18" href="http://viewer.zmags.com/publication/07098028?page=18"> WINTER 17 Technology: Jay Mehta Switch to REQU</a> <a title="Oracle Scene Issue 66 page 19" href="http://viewer.zmags.com/publication/07098028?page=19"> 9 REASONS WHY YOU SHOULD JOIN UKOUG With so many </a> <a title="Oracle Scene Issue 66 page 20" href="http://viewer.zmags.com/publication/07098028?page=20"> OracleScene WINTER 17 Technology </a> <a title="Oracle Scene Issue 66 page 21" href="http://viewer.zmags.com/publication/07098028?page=21"> WebLogic RESTful general concepts The WebLogic RE</a> <a title="Oracle Scene Issue 66 page 22" href="http://viewer.zmags.com/publication/07098028?page=22"> WINTER 17 Technology: Pascal Brand none&fields=</a> <a title="Oracle Scene Issue 66 page 23" href="http://viewer.zmags.com/publication/07098028?page=23"> Technology: Pascal Brand Each plugin is called</a> <a title="Oracle Scene Issue 66 page 24" href="http://viewer.zmags.com/publication/07098028?page=24"> OracleScene WINTER 17 Technology </a> <a title="Oracle Scene Issue 66 page 25" href="http://viewer.zmags.com/publication/07098028?page=25"> EXAMPLE 1: IP WHITELISTING connecting to the Or</a> <a title="Oracle Scene Issue 66 page 26" href="http://viewer.zmags.com/publication/07098028?page=26"> OracleScene WINTER 17 Technology: Philip Brown </a> <a title="Oracle Scene Issue 66 page 27" href="http://viewer.zmags.com/publication/07098028?page=27"> application which allows you to view both ends of</a> <a title="Oracle Scene Issue 66 page 28" href="http://viewer.zmags.com/publication/07098028?page=28"> OracleScene WINTER 17 Technology B</a> <a title="Oracle Scene Issue 66 page 29" href="http://viewer.zmags.com/publication/07098028?page=29"> Technology: Nigel Bayliss the statistics policy</a> <a title="Oracle Scene Issue 66 page 30" href="http://viewer.zmags.com/publication/07098028?page=30"> OracleScene WINTER 17 Technology: Nigel Bayliss </a> <a title="Oracle Scene Issue 66 page 31" href="http://viewer.zmags.com/publication/07098028?page=31"> Technology: Nigel Bayliss In such cases it is b</a> <a title="Oracle Scene Issue 66 page 32" href="http://viewer.zmags.com/publication/07098028?page=32"> OracleScene WINTER 17 Technology: Nigel Bayliss </a> <a title="Oracle Scene Issue 66 page 33" href="http://viewer.zmags.com/publication/07098028?page=33"> UK G Conferences Or UKO cle UG Confere</a> <a title="Oracle Scene Issue 66 page 34" href="http://viewer.zmags.com/publication/07098028?page=34"> e WINTER 17 Ora</a> <a title="Oracle Scene Issue 66 page 35" href="http://viewer.zmags.com/publication/07098028?page=35"> </a> <a title="Oracle Scene Issue 66 page 36" href="http://viewer.zmags.com/publication/07098028?page=36"> OracleScene WINTER 17 Oracle Looking into the Fu</a> <a title="Oracle Scene Issue 66 page 37" href="http://viewer.zmags.com/publication/07098028?page=37"> Oracle: Claire Swarthout It's easy to customise </a> <a title="Oracle Scene Issue 66 page 38" href="http://viewer.zmags.com/publication/07098028?page=38"> OracleScene WINTER 17 Technology Is it hAPI Time</a> <a title="Oracle Scene Issue 66 page 39" href="http://viewer.zmags.com/publication/07098028?page=39"> can be created dynamically. As a standard, HTTP h</a> <a title="Oracle Scene Issue 66 page 40" href="http://viewer.zmags.com/publication/07098028?page=40"> WINTER 17 Technology: Phil Wilkins </a> <a title="Oracle Scene Issue 66 page 41" href="http://viewer.zmags.com/publication/07098028?page=41"> Our solutions help you find innovative ways to im</a> <a title="Oracle Scene Issue 66 page 42" href="http://viewer.zmags.com/publication/07098028?page=42"> OracleScene WINTER 17 Technology Building Int</a> <a title="Oracle Scene Issue 66 page 43" href="http://viewer.zmags.com/publication/07098028?page=43"> access to an instance then you can sign up for on</a> <a title="Oracle Scene Issue 66 page 44" href="http://viewer.zmags.com/publication/07098028?page=44"> WINTER 17 Technology: Grant Ronald </a> <a title="Oracle Scene Issue 66 page 45" href="http://viewer.zmags.com/publication/07098028?page=45"> FIGURE 5: OVERVIEW OF A BOT CONVERSATION do you</a> <a title="Oracle Scene Issue 66 page 46" href="http://viewer.zmags.com/publication/07098028?page=46"> OracleScene WINTER 17 Technology: Grant Ronald </a> <a title="Oracle Scene Issue 66 page 47" href="http://viewer.zmags.com/publication/07098028?page=47"> Whether On-Premise or in the Cloud “Big Enough </a> <a title="Oracle Scene Issue 66 page 48" href="http://viewer.zmags.com/publication/07098028?page=48"> OracleScene WINTER 17 Applications Royal Mai</a> <a title="Oracle Scene Issue 66 page 49" href="http://viewer.zmags.com/publication/07098028?page=49"> Applications: Bob Heyes Captain’s log Royal Ma</a> <a title="Oracle Scene Issue 66 page 50" href="http://viewer.zmags.com/publication/07098028?page=50"> OracleScene WINTER 17 Applications </a> <a title="Oracle Scene Issue 66 page 51" href="http://viewer.zmags.com/publication/07098028?page=51"> Applications: Kapil K Somawaram This articl</a> <a title="Oracle Scene Issue 66 page 52" href="http://viewer.zmags.com/publication/07098028?page=52"> OracleScene WINTER 17 Applications: Kapil K Soma</a> <a title="Oracle Scene Issue 66 page 53" href="http://viewer.zmags.com/publication/07098028?page=53"> Applications: Kapil K Somawaram sourcing chann</a> <a title="Oracle Scene Issue 66 page 54" href="http://viewer.zmags.com/publication/07098028?page=54"> OracleScene WINTER 17 UKOUG: Speaker Awards 2017</a> <a title="Oracle Scene Issue 66 page 55" href="http://viewer.zmags.com/publication/07098028?page=55"> UKOUG: Speaker Awards 2017 APPLICATIONS APPLICAT</a> <a title="Oracle Scene Issue 66 page 56" href="http://viewer.zmags.com/publication/07098028?page=56"> OracleScene WINTER 17 Applications Getting the</a> <a title="Oracle Scene Issue 66 page 57" href="http://viewer.zmags.com/publication/07098028?page=57"> Applications: Andy Nellis Example roadmap for HCM</a> <a title="Oracle Scene Issue 66 page 58" href="http://viewer.zmags.com/publication/07098028?page=58"> WINTER 17 Applications: Andy Nellis So, how do</a> <a title="Oracle Scene Issue 66 page 59" href="http://viewer.zmags.com/publication/07098028?page=59"> Plan UKOUG 2018 events into your calendar Throug</a> <a title="Oracle Scene Issue 66 page 60" href="http://viewer.zmags.com/publication/07098028?page=60"> OracleScene WINTER 17 Applications Should I</a> <a title="Oracle Scene Issue 66 page 61" href="http://viewer.zmags.com/publication/07098028?page=61"> Applications: Debra Lilley want your systems to</a> <a title="Oracle Scene Issue 66 page 62" href="http://viewer.zmags.com/publication/07098028?page=62"> OracleScene WINTER 17 Ask Jonathan K JONATHAN AS</a> <a title="Oracle Scene Issue 66 page 63" href="http://viewer.zmags.com/publication/07098028?page=63"> Ask Jonathan AN ASK JONATHAN ASK JONATHAN ASK JON</a> <a title="Oracle Scene Issue 66 page 64" href="http://viewer.zmags.com/publication/07098028?page=64"> OracleScene WINTER 17 Ask Jonathan K JONATHAN AS</a> <a title="Oracle Scene Issue 66 page 65" href="http://viewer.zmags.com/publication/07098028?page=65"> UKOUG to all UKOUG Volunteers As we appro</a> <a title="Oracle Scene Issue 66 page 66" href="http://viewer.zmags.com/publication/07098028?page=66"> OracleScene WINTER 17 Oracle OpenWorld 2017 </a> <a title="Oracle Scene Issue 66 page 67" href="http://viewer.zmags.com/publication/07098028?page=67"> In Home Group, we’ve done a little testing with A</a> <a title="Oracle Scene Issue 66 page 68" href="http://viewer.zmags.com/publication/07098028?page=68"> WINTER 17 Oracle OpenWorld 2017: Paul Fitton </a> <a title="Oracle Scene Issue 66 page 69" href="http://viewer.zmags.com/publication/07098028?page=69"> Oracle OpenWorld 2017: Paul Fitton DAY 4 </a> <a title="Oracle Scene Issue 66 page 70" href="http://viewer.zmags.com/publication/07098028?page=70"> OracleScene WINTER 17 Oracle Bloodhound L</a> <a title="Oracle Scene Issue 66 page 71" href="http://viewer.zmags.com/publication/07098028?page=71"> Oracle: Cathy Toft </a> <a title="Oracle Scene Issue 66 page 72" href="http://viewer.zmags.com/publication/07098028?page=72"> REGISTRATION SPONSOR ORACLE GOLD PARTNER Provi</a>