ODTUG Webinars June 2016

ODTUG Online Education Below is the list of upcoming webinars. If there is a topic you would like covered that is not on our current list, or if you would like to present a webinar, please email Melissa@odtug.com. Did you miss a webinar? Our Webinar File Library lists all of our webinars and can be filtered by subtopic (content track). As an ODTUG member, you can watch all of our past webinars at any time. Not a member? Join now for the low price of $99 per year! Our webinar calendar is constantly evolving! Check back frequently as more webinars will be added to the schedule. Thursday, June 9, 2016 12:00 PM - 1:00 PM EDT Taking Source Filters to the Next LevelFrancisco Amores Torres, Infratects   Some source systems such as Universal Data Adapter allow passing parameters to filter out data when importing it into FDMEE. These source filters are defined statically when creating data load rules, but sometimes we have requirements where filter values need to be dynamically passed to the data extract process. During this webinar, we will see how to take source filters to the next level to provide a flexible data extract process.   Wednesday, June 15, 2016 12:00 PM - 1:00 PM EDT The Right to Bear ARM: Lessons from the TrenchesErik West, EPM Intelligence Are you thinking about implementing ARM? Come learn about the uniqueness of this powerful tool that's changing the way companies are reconciling data. We'll walk through a case study of an FDMEE and ARM implementation and tackle important implementation considerations, integration challenges, and key lessons learned. If you're implementing ARM or thinking about it, this session will ensure a successful outcome for your project. Join us as we perform a deep dive into Oracle's Account Reconciliation Module. Thursday, June 16, 2016 12:00 PM - 1:00 PM EDT Translate APEX Project Aljaž Mali, Abakus Plus, and Przemysław Staniszewski, Pretius If your Oracle Application Express application uses a language that is not among the 10 languages into which APEX is translated, you must translate messages displayed by the APEX reporting engine. On November 30, 2015, Pretius (www.pretius.com) launched the translate-apex.com website. This project is the collection of free translations of APEX internal messages to help the APEX Community develop applications in something other than 10 default languages. The website allows you to browse translations (over 30 different languages available so far), download installation script for any APEX version starting from 3.0, and share your translation with others. All translations are available for free and have been created by the APEX Community. At the same time, Aljaz Mali of Abakus Plus was working on an application that helps you to centralize, consolidate, and simplify management of APEX text messages. This application was released during the APEX World conference as part of OraOpenSource project. During this presentation, we will discuss the APEX translation project and how it has connected over 30 APEX developers from all around the world. We will also show practical use of thewww.translate-apex.com website and how you can use the APEX translation application to simplify management of APEX text messages and the localization process. Monday, June 27, 2016 12:30 - 1:30 PM EDT 2016 CodeTalk Series: Finding All the Red M&Ms: A Story of Indexes and Full Table Scans Chris Saxon, Oracle Corporation   Join us live from Kscope16! “Why isn’t my query using an index?” is a common question people have when tuning SQL. This talk explores the factors that influence the optimizer’s decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms from their bags. It contrasts using an index range scan and a full table scan to do this. It introduces the concepts of blocks and the clustering factor. It discusses how these affect the optimizer's calculations. It goes on to demonstrate how these concepts work in practice using real SQL queries. This session is intended for developers and DBAs who want to learn the basics of how the optimizer chooses between an index range or full table scan.   Tuesday, July 19, 2016 12:00 PM - 1:00 PM EDT What Is the Oracle Red Stack?Sarah Zumbrum, Oracle Corporation You’ve heard the term “Oracle Red Stack,” and you may have seen the stack. But what is it? Why is it important in the “story” of Oracle? This webinar is geared toward introducing the Red Stack and what the different pieces, storage to applications, mean to Oracle as a whole.    Tuesday, July 26, 2016 12:00 PM - 1:00 PM EDT How to Do and Choose Your Best Performance Analysis Strategy Craig Shallahamer, OraPub The phone rings. It’s performance again, and users are not happy. What is your next move? What is your strategy to identify the issue, develop solutions, and communicate that to others? That’s what this webinar is all about. As Oracle DBAs, we have two fundamental performance analysis strategies: time-based and sample-based (ASH). Each strategy has strengths and weaknesses. Knowing these differences and how to exploit them gives you the edge in solving the puzzle. In this webinar, you’ll get a quick introduction of each strategy, highlighting how they work, their differences, and how to use them. This webinar will be 80% “how to” with live demonstrations (typing) and 20% pure knowledge (slides).   Register for Kscope16 today! How do I become a member of ODTUG? Click here for details! Submit Your Webinar Request

Oracle Hot Topics: Failed To Allocate New Temporary Tablespace to Local User In 12c Multitenant Architecture

Knowledge Articles

Knowledge Article	Product Area	Last Updated
ORA-02303 & ORA-00955 Errors on SYSTEM.LOGMNR$ Types During PSU Updates	Oracle Database - Enterprise Edition Oracle GoldenGate	Tue, 7 Jun 2016 06:03 GMT-06:00

Knowledge Article	Product Area	Last Updated
Failed To Allocate New Temporary Tablespace to Local User In 12c Multitenant Architecture	Oracle Database - Enterprise Edition	Sat, 4 Jun 2016 20:57 GMT-06:00

Alerts

Alert	Product Area	Last Updated
ALERT: Reinstating physical standby databases after a Data Guard Failover	Oracle Database - Enterprise Edition	Tue, 31 May 2016 06:13 GMT-06:00

Qué es más eficiente y que no? Respuesta pendiente de la charla del fin de semana. TECHNOCRUX

Buenas tardes a todos y todas

Me quedó pendiente exponer el siguiente caso en una de mis charlas del día sábado en el evento de TECHNOCRUX y les indique la que respuesta estaría el día de hoy en mi blog.

Nada más para que no crean que se me ha olvidado, aquí esta la respuesta.

Un simple bloque anónimo para trabajar la respuesta.

DECLARE
  starting_time  TIMESTAMP WITH TIME ZONE;
  ending_time    TIMESTAMP WITH TIME ZONE;
BEGIN
  -- Invokes SQRT for every row of empleados table:

  SELECT SYSTIMESTAMP INTO starting_time FROM DUAL;

  FOR item IN (
    SELECT DISTINCT(SQRT(department_id)) col_alias
    FROM empleados
    ORDER BY col_alias
  )
  LOOP
    DBMS_OUTPUT.PUT_LINE('Square root of dept. ID = ' || item.col_alias);
  END LOOP;

  SELECT SYSTIMESTAMP INTO ending_time FROM DUAL;

  DBMS_OUTPUT.PUT_LINE('Time = ' || TO_CHAR(ending_time - starting_time));

  -- Invokes SQRT for every distinct department_id of empleados table:

  SELECT SYSTIMESTAMP INTO starting_time FROM DUAL;

  FOR item IN (
    SELECT SQRT(department_id) col_alias
    FROM (SELECT DISTINCT department_id FROM empleados)
    ORDER BY col_alias
  )
  LOOP
    IF item.col_alias IS NOT NULL THEN
      DBMS_OUTPUT.PUT_LINE('Square root of dept. ID = ' || item.col_alias);
    END IF;
  END LOOP;

  SELECT SYSTIMESTAMP INTO ending_time FROM DUAL;

  DBMS_OUTPUT.PUT_LINE('Time = ' || TO_CHAR(ending_time - starting_time));
END;
/

SQL> set serveroutput on
SQL> @t2
Square root of dept. ID = 3.16227766016837933199889354443271853372
Square root of dept. ID = 4.47213595499957939281834733746255247088
Square root of dept. ID = 5.47722557505166113456969782800802133953
Square root of dept. ID = 6.32455532033675866399778708886543706744
Square root of dept. ID = 7.07106781186547524400844362104849039285
Square root of dept. ID = 7.74596669241483377035853079956479922167
Square root of dept. ID = 8.36660026534075547978172025785187489393
Square root of dept. ID = 8.94427190999915878563669467492510494176
Square root of dept. ID = 9.48683298050513799599668063329815560116
Square root of dept. ID = 10
Square root of dept. ID = 10.48808848170151546991453513679937598475
Square root of dept. ID =
Time = +000000000 00:00:06.176312000
Square root of dept. ID = 3.16227766016837933199889354443271853372
Square root of dept. ID = 4.47213595499957939281834733746255247088
Square root of dept. ID = 5.47722557505166113456969782800802133953
Square root of dept. ID = 6.32455532033675866399778708886543706744
Square root of dept. ID = 7.07106781186547524400844362104849039285
Square root of dept. ID = 7.74596669241483377035853079956479922167
Square root of dept. ID = 8.36660026534075547978172025785187489393
Square root of dept. ID = 8.94427190999915878563669467492510494176
Square root of dept. ID = 9.48683298050513799599668063329815560116
Square root of dept. ID = 10
Square root of dept. ID = 10.48808848170151546991453513679937598475
Time = +000000000 00:00:00.983346000

PL/SQL procedure successfully completed.


SQL>

Respuesta: Lo más eficiente es:

 FOR item IN (
    SELECT SQRT(department_id) col_alias
    FROM (SELECT DISTINCT department_id FROM empleados)
    ORDER BY col_alias
  )

Hay un artículo que estoy escribiendo para OTN, en donde voy a explicar más a fondo este tema.

ODTUG Kscope16 Chicago, Illinois June 26-30 2016

ODTUG Kscope16 Advance Registration ends June 9! Don’t delay; register today! Everybody knows Kscope16 is THE conference for learning, but did you know Kscope16 offers oodles of networking opportunities and other fun happenings? Check out the lineup below: Saturday, June 25, 2016 Community Service Day Sunday, June 26, 2016 Chi Gung Welcome Reception Werewolf Monday, June 27, 2016 Chi Gung Newcomers’ Breakfast Career Community and Leadership Breakfast Community Lunches Happy Hour Sponsored by Applied OLAP ODTUG Community Night Events Werewolf Tuesday, June 28, 2016 Chi Gung Lunch and Learn Sponsored by OTN Happy Hour Sponsored by Vertical Edge Werewolf Wednesday, June 29, 2016 Chi Gung International Breakfasts Women In Technology Roundtable Sponsored by EY Special Event Sponsored by interRel Consulting – The Roaring Twenties at the Museum of Science and Industry Thursday, June 30, 2016 Chi Gung Closing Session Have you heard about our Scavenger Hunt? It’s a great way to meet new people while taking part in a little healthy competition. Don’t miss out on all that Kscope16 has to offer; register today! TITANIUM SPONSOR PLATINUM SPONSORS HANDS-ON TRAINING SPONSOR

GOLD SPONSORS     SILVER SPONSORS

BRONZE SPONSORS

Comunicado de Prensa, Deborah Hellinger, Vice President

Press Release

Oracle Statement

Redwood Shores, Calif.—Jun 2, 2016

“We are confident that all our cloud accounting is proper and correct. This former employee worked at Oracle for less than a year and did not work in the accounting group. She was terminated for poor performance and we intend to sue her for malicious prosecution.”

—Deborah Hellinger, Vice President, Corporate Communications, Oracle

Contact Info

Deborah Hellinger
Oracle Corporate Communications
1.212.508.7935

Oracle Hot Topics: ALERT: Reinstating physical standby databases after a Data Guard Failover

Alerts

Alert	Product Area	Last Updated
ALERT: Reinstating physical standby databases after a Data Guard Failover	Oracle Database - Enterprise Edition	Tue, 31 May 2016 06:13 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
12c Unified Auditing used with Data Guard	Oracle Database - Enterprise Edition	Tue, 31 May 2016 05:11 GMT-06:00