{"id":14472,"date":"2023-11-24T22:06:54","date_gmt":"2023-11-24T21:06:54","guid":{"rendered":"https:\/\/www.oradba.ch\/wordpress\/?p=14472"},"modified":"2023-11-24T22:06:54","modified_gmt":"2023-11-24T21:06:54","slug":"doag-2023-debrief-a-speakers-perspective","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/doag-2023-debrief-a-speakers-perspective\/","title":{"rendered":"DOAG 2023 Debrief: A Speaker&#8217;s Perspective"},"content":{"rendered":"\n<p>It\u2019s a wrap. The DOAG database conference has come to an end. As I sit on the train, I reflect on a week full of excitement and variety. In addition to the many fascinating technical presentations, I had the opportunity to catch up with old friends and colleagues. The conference started on Monday afternoon when the Oracle ACEs met for the ACE Adventure. We got to know a different side of the city on a guided tour of Nuremberg&#8217;s rock cellars. The day ended with a beer tasting and dinner together. In addition to the ACE dinner, the SOUG evening was certainly another highlight of the event. In addition to the various social events, there were also plenty of interesting and informative technical presentations at this conference.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">My Talks in a Nutshell<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Oracle Database Security 23c new Feature<\/h3>\n\n\n\n<p>In my first session, I presented Oracle&#8217;s new Database Security 23c features. It was a unique opportunity to present this in the large keynote room. One of the most important new features is undoubtedly the SQL Firewall. Oracle now offers a novel approach to protecting the database from unauthorized access, SQL injection and more. In addition, Oracle Database 23c also introduces smaller improvements such as new schema privileges, read-only accounts, immediate activation of audit policies as well as updates and adaptations to new security standards.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"469\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=625%2C469&#038;ssl=1\" alt=\"\" class=\"wp-image-14511\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?w=2048&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1024%2C768&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=768%2C576&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1536%2C1152&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=624%2C468&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?w=1250&amp;ssl=1 1250w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?w=1875&amp;ssl=1 1875w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><figcaption class=\"wp-element-caption\">Although not a keynote, it was an honor to present in the keynote room <\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Slides<\/strong>: <a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DOAG2023_Oehrli_SecNF_23c_v1_small.pdf\">Oracle Database Security 23c new Feature<\/a><\/li>\n\n\n\n<li><strong>DOAG<\/strong>: Agenda, Recording and more <a href=\"https:\/\/meine.doag.org\/events\/anwenderkonferenz\/2023\/agenda\/#eventDay.all#textSearch.Oehrli%20Security%2023c\">DOAG 2023 Programm<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Secure administration of Database users on a large scale<\/h3>\n\n\n\n<p>My second presentation, which I held together with Bettina Schaumer, Senior Principal Product Manager at Oracle, focused on Oracle Data Safe and Oracle Centrally Managed Users (CMU). Together we demonstrated how Data Safe can be used to analyze the current configuration of the database as well as the users, roles and permissions. We then presented a strategy for centrally managing users and roles with Oracle CMU and discussed its implementation.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Slides<\/strong>: <a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/2023-11-21-DOAG_v1.0_small.pdf\"><\/a>\u00a0<a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/2023-11-21-DOAG_v1.0_small.pdf\">Sichere Verwaltung von Datenbankbenutzern im gro\u00dfen Ma\u00dfstab<\/a><\/li>\n\n\n\n<li><strong>DOAG<\/strong>: Agenda, Recording and more at <a href=\"https:\/\/meine.doag.org\/events\/anwenderkonferenz\/2023\/agenda\/#eventDay.all#textSearch.Oehrli%20Schaeumer\">DOAG 2023 Programm<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Database security, but what about Performance 2.0?<\/h3>\n\n\n\n<p>The focus of my third presentation was &#8220;Database security and its impact on performance&#8221;. I covered various test results that included network access and the use of Transparent Data Encryption (TDE). A key aspect of my presentation was to demonstrate the considerations necessary to determine the direct impact of specific security measures on database performance. I conducted my tests in both on-premises and cloud environments. Swingbench was used for these tests, and I presented my custom scripting framework for automating Swingbench executions in various configurations. The complicated relationship between performance and database security is a challenge because every environment, application and database is different. However, this talk provides essential insights to kick-start your own investigations in this area.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Slides<\/strong>: <a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/2023-11-21-DOAG_v1.0_small.pdf\"><\/a>\u00a0<a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DOAG_SecBench_soe-1.pdf\">Database security, but what about Performance 2.0?<\/a><\/li>\n\n\n\n<li><strong>DOAG<\/strong>: Agenda, Recording and more at <a href=\"https:\/\/meine.doag.org\/events\/anwenderkonferenz\/2023\/agenda\/#eventDay.all#textSearch.Swingbench\">DOAG 2023 Programm<\/a><\/li>\n\n\n\n<li><strong>GitHub<\/strong>: <a href=\"https:\/\/github.com\/oehrlis\/secbench\">oehrlis\/secbench<\/a> scripts and notes on my semi-automated performance tests with Swingbench<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">DOAG Training Day: Oracle Backup &amp; Recovery Hands-On Lab<\/h3>\n\n\n\n<div class=\"wp-block-media-text is-stacked-on-mobile\" style=\"grid-template-columns:39% auto\"><figure class=\"wp-block-media-text__media\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"1008\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173.jpg?resize=625%2C1008&#038;ssl=1\" alt=\"\" class=\"wp-image-14508 size-full\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=635%2C1024&amp;ssl=1 635w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=186%2C300&amp;ssl=1 186w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=768%2C1239&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=952%2C1536&amp;ssl=1 952w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=1270%2C2048&amp;ssl=1 1270w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?resize=624%2C1006&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3173-scaled.jpg?w=1587&amp;ssl=1 1587w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Once again this year, I couldn&#8217;t let it go and concluded my DOAG conference with a training day. In this session, we focused on backup &amp; recovery strategies in companies. After an introduction to Oracle Backup &amp; Recovery and RMAN, the participants had the chance to test their knowledge in a cloud-based lab. They worked on various tasks, from simple backup and recovery scenarios to complex disaster recovery cases, both independently and in groups. The aim was to gain practical experience in database recovery. This training was an excellent opportunity for participants to develop practical skills and exchange ideas with others to learn new approaches.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>This year&#8217;s DOAG conference was a remarkable blend of technical enrichment, professional networking and social engagement. Beginning with the Training Day, which offered hands-on experience with Oracle technologies, the event was an in-depth exploration of the latest trends and practices in the Oracle ecosystem. Highlights included the ACE Adventure and the SOUG Evening, which not only showcased the historical charm of Nuremberg, but also provided ample opportunity to catch up with old friends and catch up with colleagues. The various sessions and discussions throughout the week emphasized the importance of innovation and efficient problem solving in the database field. This event was not only a learning experience, but also a chance to strengthen relationships within the Oracle community, and it left me invigorated and looking forward to future collaborations and gatherings.<\/p>\n\n\n\n<p><strong>Just one more thing:<\/strong> During the conference, I received a lot of positive feedback about the sketches and drawings I created using Excalidraw. For those interested, my library is available via <a href=\"https:\/\/libraries.excalidraw.com\/?theme=light&amp;sort=default#oehrlis-db-eng\">Excalidraw<\/a>, and many images can also be found in my GitHub repository <a href=\"https:\/\/github.com\/oehrlis\/sketches\">oehrlis\/sketches<\/a>. These resources reflect my commitment to enhancing our understanding and visualization of complex Oracle systems.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"469\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3169-rotated.jpg?resize=625%2C469&#038;ssl=1\" alt=\"\" class=\"wp-image-14509\" style=\"width:640px;height:auto\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3169-rotated.jpg?w=640&amp;ssl=1 640w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3169-rotated.jpg?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3169-rotated.jpg?resize=624%2C468&amp;ssl=1 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><figcaption class=\"wp-element-caption\">Tune Conference Badges: A Casual Session with Beers<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>It\u2019s a wrap. The DOAG database conference has come to an end. As I sit on the train, I reflect on a week full of excitement and variety. In addition to the many fascinating technical presentations, I had the opportunity to catch up with old friends and colleagues. The conference started on Monday afternoon when [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-14472","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-3Lq","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":16381,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/11\/its-a-wrap-doag-conference\/","url_meta":{"origin":14472,"position":0},"title":"It\u2019s a Wrap: DOAG Conference","author":"Stefan","date":"22. November 2024","format":false,"excerpt":"A Challenging Start with a Silver Lining The DOAG Conference 2024 began with an eventful journey for me, Dani Schnider, and Martin Berger. A major train disruption in Memmingen forced us to switch to a rental car, turning our trip into an unplanned road trip. Despite the hiccups, we made\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=700%2C400 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=1050%2C600 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Gcu218KXoAA59UJ.jpeg?resize=1400%2C800 4x"},"classes":[]},{"id":8966,"url":"https:\/\/www.oradba.ch\/wordpress\/2021\/11\/doag-oracle-database-vault\/","url_meta":{"origin":14472,"position":1},"title":"DOAG Oracle Database Vault","author":"Stefan","date":"17. November 2021","format":false,"excerpt":"This morning I had the opportunity to give a presentation on Oracle Database Vault at the DOAG conference. Abstract Oracle Database Vault has been on the market for a few years now. The product has been constantly improved over the years. But where is it worthwhile to use it? Which\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/classified_database_tde.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":13445,"url":"https:\/\/www.oradba.ch\/wordpress\/2023\/06\/aoug-user-conference-2023-recap-in-a-nutshell\/","url_meta":{"origin":14472,"position":2},"title":"AOUG User Conference 2023 Recap in a Nutshell","author":"Stefan","date":"14. June 2023","format":false,"excerpt":"Over the past two days, I had the opportunity to participate in the AOUG User Conference as a speaker and presenter. Like in previous years, the conference took place at the Austria Trend Hotel Savoyen. The theme for this year was \"Everything Cloud?\" The first day of the conference started\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_2325-1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_2325-1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_2325-1.png?resize=525%2C300 1.5x"},"classes":[]},{"id":1005,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/05\/doag-2013-datenbank\/","url_meta":{"origin":14472,"position":3},"title":"DOAG 2013 Datenbank","author":"Stefan","date":"10. May 2013","format":false,"excerpt":"As I announced a while ago in SOUG Special Interest Group Baden March 21st I'll speak again about some improvements in the latest generation of Oracle Database. The content of the presentation is a mixture of the presentations I've lectured at SOUG SIG Baden and DOAG SIG Security Munich. It\u2026","rel":"","context":"In &quot;Audit&quot;","block_context":{"text":"Audit","link":"https:\/\/www.oradba.ch\/wordpress\/category\/audit\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":779,"url":"https:\/\/www.oradba.ch\/wordpress\/2012\/04\/doag-soug-security-lounge-at-basel\/","url_meta":{"origin":14472,"position":4},"title":"DOAG \/ SOUG Security-Lounge at Basel","author":"Stefan","date":"22. April 2012","format":false,"excerpt":"The DOAG regional group is organizing together with SOUG a Security Lounge on the 24th of April. I'll attend this event with two short presentations on Database Security and Oracle Auditing.","rel":"","context":"In &quot;11gR2&quot;","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2306,"url":"https:\/\/www.oradba.ch\/wordpress\/2017\/06\/gdpr-and-database-security-speeches\/","url_meta":{"origin":14472,"position":5},"title":"GDPR and Database Security Speeches","author":"Stefan","date":"16. June 2017","format":false,"excerpt":"The new EU GDPR and Database Security in general keeps me busy. I've updated the list of speeches and events for the next couple of month. It's an interesting mix between GDPR, Oracle Database Security and MS SQL Server 2016 security. Depending on the feedback of the Call For Papers\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/14472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=14472"}],"version-history":[{"count":4,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/14472\/revisions"}],"predecessor-version":[{"id":14513,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/14472\/revisions\/14513"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=14472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=14472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=14472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}