Function calls in SQL – Black Box for the Optimizer?

Functions in SQL are a useful and popular feature that is often used. However, little attention is often paid to performance aspects. A function call or an expression in a WHERE condition is a challenge for the query optimizer that often leads to unsuitable execution plans and bad response times. For PL/SQL functions called from SQL, the situation is even more complex. If used incorrectly, they can lead to massive performance degradation. In this presentation, I will show different possibilities to support the optimizer in function calls to generate better execution plans. Furthermore, I will explain how PL/SQL functions can


With the renewed urgency we’ve seen building in the last few months around migrating ERP data to Cloud, this topic is understandably one that’s top of mind for many organisations. Unfortunately, a lot of Oracle EBS users are still in the dark about the impact this data migration may have on their reporting, access to current data, and ability to view their legacy data. Understanding these aspects prior to your migration can set your team up for success and ensure as little disruption to monthly reporting as possible. Join us for this educational Webinar investigating the top five questions you’ll

Trust, but verify approach to securing access to Oracle Database

Trust-but-verify is a key security control for many compliance regulations. In this session, you will learn how you can use Unified Auditing in Oracle Database to implement this approach in a smart and practical way while minimizing performance and storage impact on the database. Try hands-on configuring simple unified audit policies with LiveLabs workshop practice in this session. Join this session and become subject matter experts for implementing this key security control in your organizations.

CFP CLOSING – pgDay Austria

Vienna Vienna

Hold a talk in front of PostgreSQL open source enthusiasts! Apply here and submit a detailed proposal for your talk! Send an email with a short thematic description of the talk to Please also state whether you want to hold the talk in German or English (both languages increase the chance of participation)! You are also welcome to attach first slides / PDFs. TALK Each talk will last a maximum of 45 minutes and must include a topic relevant to PostgreSQL. PROPOSALS Proposals may be submitted until May 30, 2022. SPEAKER Speakers will be notified and announced by the


Duesseldorf Duesseldorf

Sichern Sie sich ihre Konferenztickets! Freuen sie sich auf viele spannende Vorträge zu den Themen Datenbank und Engineered Systems, unterhaltsame Community-Aktivitäten und inspirierende Workshops sowie jede Menge Austausch und Networking – endlich wieder vor Ort in Düsseldorf. Das Programm ist online.  


PGConf NYC will be held on September 22nd and 23rd in New York, NY at Convene. It will cover topics for PostgreSQL users, developers and contributors, as well as decision and policy makers. For more information about the conference, please see About. Please note that PGConf NYC is open to all audiences and ages. All talks are expected to be appropriate for a diverse group. Please see our Conference Policies and feel free to contact the Committee with any questions. The submission deadline for regular sessions is May 31st, 2022. The conference commitee will review proposals and notify selected speakers

Seminario híbrido: Mejora tus dashboards con data-storytelling.

Mucha gente trabaja, en su día a día, con herramientas de Business Intelligence. Pero construir un buen dashboard con un storytelling coherente no es sencillo: es necesario preguntarse quién va a utilizar ese dashboard, qué información se quiere obtener de él, qué tipo de gráfico es el más adecuado, qué nivel de detalle el usuario necesita realmente, etc. Un dashboard tiene que ser un elemento que elimine capas de confusión entre el usuario y su negocio, no que las añada. Por ejemplo, en muchas ocasiones, el usuario pide el máximo número de gráficos posibles, y es nuestro trabajo entender qué


Madrid Madrid

We invite you to take part in an event where innovation, knowledge and training come together to spearhead the transformation of society. SPOUG22 is the Annual Convention of SPOUG, the Association of Oracle Users in Spain. This year we want to continue on our unstoppable journey towards the goal we have set ourselves: to continue together towards progress and technological transformation thanks to Oracle’s solutions and products. We look forward to seeing you on 2 and 3 June in Alcalá de Henares, a beautiful town located 20 minutes from Madrid. This is one of the best months of the year


MGM Grand in Las Vegas, NV Las Vegas

Make plans to join us for BLUEPRINT 4D, taking place in Las Vegas and online June 6 – 9th, 2022. The hybrid event format is designed to provide an optimal experience for customer participation and engagement both in person and digitally for a truly global event. This global Oracle customer event keeps you in the loop and up to date on the latest technology insights and product advancements for JD Edwards, PeopleSoft, Oracle Cloud apps, Oracle Database & Technology and Oracle Commerce!


Automation and digital assistants are the latest strategies in IT helping organizations reach their business goals. Although these solutions are native features of cloud applications, devising a modernization strategy for EBS R12, whether on premise or in the cloud, can pose a challenge. This 60-minute session will be an open dialogue/Q&A with industry experts, as well as innovative customers on their automation, AI and chat strategies. Join this important conversation to learn which factors to consider when beginning your journey, best practices for development, how to devise your IT goals and roadmap, and the tools of the trade.

[Online] Cloud Adoption Framework – você está migrando para a nuvem corretamente?

Você sabe quais as melhores práticas a se adotar na nuvem, seja migrando seu ambiente ou criando uma nova aplicação? Da nomenclatura de recursos a aspectos como segurança, ferramentas e estratégias? Conheça neste evento ONLINE e GRATUITO do Azure na Prática (Live #46) o Cloud Adoption Framework, uma excelente resposta a essas questões! Palestrante: Diego Matos (Microsoft MVP)

National Webinar Series 2022 – Process Automation functionality within Oracle APEX by Ralf Mueller

The Australian Oracle User Group, AUSOUG, have a focus on bringing together our Oracle community and servicing their core technical, development and applications needs. A balanced program is aimed at all levels of skill and experience within a forum of User led independent knowledge sharing.   Process Automation functionality within Oracle APEX by Ralf Mueller With the release of Oracle APEX 22.1, a journey towards enabling Process Automation functionality within Oracle APEX has started. The new Approvals Component in Oracle APEX 22.1 offers basic Task Management and streamlines Approvals in APEX apps and Workflows under a new Unified Task List.

[Online]PostgreSQL, MySQL, Cosmos DB…: indo além do Azure SQL na nuvem!

O uso de bancos de dados na nuvem Microsoft vai muito além do Azure SQL... Temos também alternativas como PostgreSQL, MySQL, Managed Instances e mesmo soluções NoSQL multimodel como o Cosmos DB. Confira neste evento ONLINE e GRATUITO do Canal .NET dicas, truques e também tire suas dúvidas sobre diferentes opções voltadas à área de dados dentro do Microsoft Azure! Palestrantes já confirmados: Dirceu Resende - Microsoft MVP Renato Groffe - Microsoft MVP, MTAC Não deixem de acompanhar! Convidem amigas, amigos e colegas de trabalho!

ODTUG Kscope22 Preview


On Thursday the 9th of June, SMART4Solutions organises the ODTUG Kscope22 Preview. Oracle professionals and interested people can get a preview of some of the presentations from the big event. A great opportunity to meet up with your APEX colleagues and catch up. We will provide a warm welcome with a delicious dinner and drinks. A glimpse of a promising evening: •LIVE FEED: Keynote by Karen Canell, ODTUG Kscope22 Conference Chair & ODTUG Vice-President •SNEAK PREVIEW by all Dutch and some international speakers from the main event. •MEET & GREET: Catch up with your APEX and Oracle colleagues. •SPEAKERS: Kim Berg Hansen, Dimitri Gielis, Alex Nuijten,

Ascend 2022: Elevating Insights for the Oracle Community

Las Vegas Las Vegas, Nevada

Ascend is the Oracle user community event that unites functional users, IT professionals and expert resources for frank discussion and practical education to elevate insights and improve decision making, project planning and business operations. Make plans now reconnect with the Oracle community June 12-15, 2022 at the sleek and sophisticated ARIA Resort & Casino in Las Vegas. Ascend conference attendees engaged in Q&A Presented by the Oracle Applications & Technology Users Group (OATUG) and Oracle HCM Users Group (OHUG), Ascend will deliver: Actionable insights Time- and money-saving strategies Opportunities to connect with potential partners and others in our global user

USA Postgres Vision 2022

Own your data, own your future. What Postgres Vision is all about Postgres is changing how the world’s data is organized. Data and databases are strategic to business and most of the world’s workloads are just beginning to move to open source. Enterprises that learn how to fully leverage their data hold the future in their hands. Postgres Vision 2022 is built to empower leaders to own their data and future. This free, virtual event brings together the world’s leading Postgres experts, users, and community members. Presentations will explore real-world user stories and new technologies harnessing the power of Postgres.

OBUG AppsConnected22


We mogen weer…. nice to see you! Heb jij er ook zo naar uitgekeken? Elkaar weer zien, spreken, kennisdelen en netwerken onder het genot van een hapje en een drankje… Eindelijk! OBUG is verheugd om AppsConnected dit jaar weer live te mogen organiseren, we hebben beslag gelegd op de prachtige locatie Fort Voordorp. Deze locatie is zeer centraal gelegen, er is parkeergelegenheid en de drankjes, lunch en andere versnaperingen staan voor u klaar. En dat is natuurlijk niet alles: het gaat natuurlijk om de inhoud van het programma, dat voornamelijk wordt ingericht op gebruikers van E-Business Suite, PeopleSoft en Cloud.

OUG Ireland 2022

Ireland Dublin

UG Ireland is back for 2022. The Irish Oracle community will be returning to Dublin for two days of top-quality content, covering everything across the business and technical landscapes. This is your chance to contribute your knowledge to an invaluable collection of sessions.  

Creating a Million Virtual Threads Using Project Loom by A N M Bazlur Rahman

Project loom introduces virtual threads, lightweight threads that aim to dramatically reduce the effort of writing, maintaining, and monitoring high-throughput concurrent applications with the Java platform. We need threads to achieve high throughput. However, threads are not cheap and limited in number. To get around this problem, various alternatives such as a reactive programming style have emerged. These techniques bypass creating a lot of threads but debugging becomes more difficult. This makes developers grumpy. However, with virtual threads, we no longer have to look for alternatives, which would make developers happy again. This talk will explore what virtual threads are,