Feed aggregator

Parallelism in IOT's

Tom Kyte - Wed, 2018-11-07 11:06
I am trying to join (outer join) a number of IOT's all with the same key in Parallel Mode; and am expecting the optimizer to use a Merge Join in order to avoid sorts (as the documentation clearly says it should); but it does not. - I'm tracing the pr...
Categories: DBA Blogs

history of session for particular sql id

Tom Kyte - Wed, 2018-11-07 11:06
I have a query which takes times to execute. When a user connects to the system and I monitor database I also get the SQL statement which takes times. but when user complete his task and after days he talks to me report takes too much time. I analyz...
Categories: DBA Blogs

How to determine the faster of two queries based on the explain plan

Tom Kyte - Wed, 2018-11-07 11:06
Hello I have two SQL scripts that are producing the exact same result (returning approx. 30000 rows) but the first one does it for 30min. and the second one for 2min. The slower query has (by my understatnding) the better explain plan (because it ...
Categories: DBA Blogs

Hierarchy Validation - Incoming hierarchy vs Expected hierarchy

Tom Kyte - Wed, 2018-11-07 11:06
Hi Experts, I have a requirement to validate the hierarchical structure of flat files which are loaded into the database against an expected structure that is known. I have created some sample data to demonstrate what I would like to do: <code>...
Categories: DBA Blogs

Flashback data archive for auditing

Tom Kyte - Wed, 2018-11-07 11:06
Hi Tom, Greetings !! we would like to leverage the 18c Flashback Data archive feature for auditing in our environment. Currently its trigger based with some business logic implemented in it and only 30% of tables being audited and capturing all...
Categories: DBA Blogs

Which is better to use Direct SQL or Bulk Collect

Tom Kyte - Wed, 2018-11-07 11:06
I have a source table of almost 20 million records. I have to load another table from source table after some checks and validation. What would be the better way to transfer, Insert through Direct SQL or Use Bulk Collect. what is difference between...
Categories: DBA Blogs

How to prevent some firewall from terminating SQL*Plus sessions with long-running statements?

Tom Kyte - Wed, 2018-11-07 11:06
Hi Tom, In know that I should talk to the firewall admins to get things fixed but this is - unfortunately - out of scope. So here we go: We have a database running on some Linux server and some client application running on some W2k16 server. T...
Categories: DBA Blogs

Who last updated an Oracle object

Tom Kyte - Wed, 2018-11-07 11:06
Hello, My goal is to produce a list of all objects (procedures, packages, functions, triggers, and tables) that have changed in the database since they were first created. I have a query that compares "created" and last_ddl_time" in the vi...
Categories: DBA Blogs

SQL server security pre-conference @SQL Pass Summit 2018 in Seattle

Yann Neuhaus - Wed, 2018-11-07 07:53

After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin…


This first day for me started with the pre-conference about SQL Server Security with Denny Cherry.
Many topics were discussed like:

  • Network Designs (such as public IP vs. Private IP)
  • Firewall configurations (such as Network Design between Public network, Internal network and DMZ)
  • Physical Security Options (such as Cloud security)
  • Data Encryption Options (such as Always Encrypted)
  • Password Protection Options (such as rules to set a sql login password)
  • Contained Databases (such as principle of contained Databases)
  • Always On Availability Groups Security (such as new roles and sysadmin role)
  • Internet-facing Applications (such as SQL CLR risks)
  • SQL injections (Ascii characters that aren’t actually ascii)
  • Backups (such as backups encryption using TDE or Backup encryption)
  • Antivirus (such as Best Practice for the Antivirus)
  • SAN Security Designs (such as disk encryption option)
  • SQL Server Auditing Options (such as setting up auditing)

It will be a tough to go through all these subjects and all are interesting…


I preferred focusing on the Antivirus topic and to give you a little update on that.
First, we know that Antivirus can cause issues (CPU, memory and IO) on SQL Server.
As I always tell my customers, it is better not to install an antivirus on a server with SQL Server.
Why? Performance can be impacted but also because it will corrupt your databases too.
In the case that you have an Antivirus installed on a SQL Server, Denny gave us a good way to verify if it will inject itself into SQL Server:

SELECT * FROM sys.dm_os_loaded_modules where company != 'Microsoft Corporation'

This is also a good way to verify for other providers too and see a security break!
Beside this, do not forget to exclude files, folders and SQL Server from the Antivirus.
The list of exclusions is on the TechNet website here

A point I really ignored was that SQL Server 2016 & after, include and enabled Windows Defender but you can have very poor performance if is not setup correctly…


As conclusion, I will just write that Antivirus is good but not for SQL Server! 8-)

Cet article SQL server security pre-conference @SQL Pass Summit 2018 in Seattle est apparu en premier sur Blog dbi services.

Oracle Named a Leader in CRM Suites Evaluation by Independent Research Firm

Oracle Press Releases - Wed, 2018-11-07 07:00
Press Release
Oracle Named a Leader in CRM Suites Evaluation by Independent Research Firm Oracle is top-ranked in current offering category, receiving the highest possible scores in the sales force automation (SFA), marketing automation and customer service criteria

Redwood Shores, Calif.—Nov 7, 2018

Oracle has been named a leader in CRM suites by Forrester Research. The Forrester Wave™: CRM Suites, Q4 2018 gave Oracle the highest score of any vendor in the current offering category and cites Oracle’s ability to unify front- and back-office functions, noting that “Oracle's far-reaching vision is to enable the connected digital enterprise by integrating data, intelligence, and experiences across B2B and B2C customer journeys that span the front and back office.”

According to Forrester, modern CRM strategies enable differentiated customer experiences “by leveraging vast amounts of interaction, behavioral and transaction data to enable contextual experiences that deliver value to the customer...” Forrester cites intelligence as a key differentiator, saying “Intelligence-driven engagement streamlines work and allows CRM users to focus on the tasks that matter most to business outcomes.” The report also notes that “the value of CRM has shifted toward helping organizations better support customers in their end-to-end engagement journeys to garner their satisfaction and long-term loyalty...”

“At Oracle we know there is no such thing as a static and predictable customer journey and that’s why we are focused on providing powerful and actionable insights in context, in motion and in real time across the entire customer experience,” said Stephen Fioretti, Vice President Product Management, Oracle Service Cloud. “We believe our position in the Forrester Wave for CRM Suites underscores our data-driven approach to helping organizations make every customer interaction matter.”

For the report, 11 vendors were evaluated across 33 criteria, which were grouped into three categories: current offering, strategy and market presence. Oracle received the highest score of any vendor in the current offering category, and received the highest score possible in the product strategy criterion. Oracle also received the highest possible scores in the  sales force automation (SFA), confi­gure price quote (CPQ), marketing automation, customer service, field service, customer journey support criteria, as well as the highest score of any vendor in the go-to-market approach criterion.

Oracle (Customer Experience) CX Cloud is an integrated set of applications which empower organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences, and outcomes, Oracle CX Cloud helps customers reduce IT complexity, deliver innovative customer experiences, and achieve predictable and tangible business results.

Download The Forrester Wave™: CRM Suites, Q4 2018 here.

Contact Info
Kim Guillon
Oracle PR
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Kim Guillon

  • 209-601-9152

Machine Learning - Getting Data Into Right Shape

Andrejus Baranovski - Wed, 2018-11-07 06:17
When you build machine learning model, first start with the data - make sure input data is prepared well and it represents true state of what you want machine learning model to learn. Data preparation task takes time, but don't hurry - quality data is a key for machine learning success. In this post I will go through essential steps required to bring data into right shape to feed it into machine learning algorithm.

Sample dataset and Python notebook for this post can be downloaded from my GitHub repo.

Each row from dataset represents invoice which was sent to customer. Original dataset extracted from ERP system comes with five columns:

customer - customer ID
invoice_date - date when invoice was created
payment_due_date - expected invoice payment date
payment_date - actual invoice payment date
grand_total - invoice total

invoice_risk_decision - 0/1 value column which describe current invoice risk. Goal of machine learning module will be to identify risk for future invoices, based on risk estimated for historical invoice data.

There are two types of features - categorical and continuous:

categorical - often text than number, something that represents distinct groups/types
continuous - numbers

Machine learning typically works with numbers. This means we need to transform all categorical features into continuous. For example, grand_total is continuous feature, but dates and customer ID are not.

Date can be converted to continuous feature by breaking it into multiple columns. Here is example of breaking invoice_date into multiple continuous features (year, quarter, month, week, day of year, day of month, day of week):

Using this approach all date columns can be transformed into continuous features. Customer ID column can be converted into matrix of 0/1. Each unique text value is moved into separate column and assigned with 1, all other column in that row are assigned with 0. This transformation can be done with Python library called Pandas, we will see it later.

You may or may not have decision values for your data, this depends how data was collected and what process was implemented in ERP app to collect this data. Decision column (invoice_risk_decision) value represents business rule we want to calculate with machine learning. See 0/1 assigned to this column:

Rule description:

0 - invoice was payed on time, payment_date less or equal payment_due_date
0 - invoice wasn't payed on time, but total is less than all invoices total average and payment delay is less or equal 10% for current customer average
1 - all other cases, indicates high invoice payment risk

I would recommend to save data in CSV format. Once data is prepared, we can load it in Python notebook:

I'm using Pandas library (imported through pd variable) to load data from file into data frame. Function head() prints first five rows from data frame (dataset size 5x24):

We can show number of rows with 0/1, this helps to understand how data set is constructed - we see that more than half rows represent invoices without payment risk:

Customer ID column is not a number, we need to convert it. Will be using Pandas get_dummies function for this task. It will turn every unique value into a column and place 0 or 1 depending on whether the row contains the value or not (this will increase dataset width):

Original customer column is gone, now we have multiple columns for each customer. If customer with ID = 4 is located it given row, 1 is set:

Finally we can check correlation between decision column - invoice_risk_decision and other columns from dataset. Correlation shows which columns will be used by machine learning algorithm to predict a value based on the values in other columns in the dataset. Here is correlation for our dataset (all columns with more than 10% correlation):

As you can see, all date columns have high correlation as well as grand_total. Our rule tells that invoice payment risk is low, if invoice amount is less than all total average - thats why correlation on grand_total value exist.

Customer with ID = 11 is the one with largest number of invoices, correlation for this customer is higher than for others, as expected.

Pass summit – dbi visit day 2

Yann Neuhaus - Tue, 2018-11-06 19:19
 IMG_1046 The Art and Science of Designing Smart Data story

This pre-conference session was moderated by Mico Yuk CEO and founder of BI Brainz

Mico drove us through the path of BI data visual storytelling and the importance it has to present the data in an attractive way.
She warned the session will not be technical at all, I was a bit disappointed about this point, but was curious how she will drive us there.

Starting, she made us aware of the impact on your brain of what you see , especially the color, the words.
In order to create a good storytelling, the first think is to raise the right questions, but avoid the pitfalls like asking
What do you want to see?
How do you want it to look?
What do you want to measure?

She drew a parallel with Hollywood and the film scenarios, being most of the time build on the same template.
Why can’t we do the same with data:
Part 1: goal
goals need to be defined clearly, They are the core of your data story and what is significant is that the goal is quantified
Part 2: Snapshot or KPI
KPI what are the figures that measure your goal
Part 3: Trends
Is the way the KPI behaves to support your goal
Part 4: Actions
There are 3 kinds of actions that can be considered to fix the issues
Reality – what we want to happen
Fallback – if reality does not work what else do you do
Wish list – what do you wish to fix the issue

To succeed in creating the different storyboard parts you have to raise the right questions:
For the goal part : What is your goal for this project? What does success look like?
For the KPI part: What KPI do you need see to hit your goal?
For the trends: If your KPI is not on target why?

A goal formulation must follow the WHW goal sample would be “Hit consumer sales target 1% by 2018″
What = hit
How much = 1% sales
When = 2018

Finally Mico showed how to display the information of the story on a dashboard following the visual storyboard tile with the following elements:
0 Goal/Kpi name
1 Where are you no
2 How di you get here
3 Where will you end up
4 what is the impact

The trick is always to prototype your storyboard outside a BI tool.

Along the day we also did some gym to relax and aware our brains


It was a hands-on session with practical exercises and we worked by group on a concrete use case to apply the storytelling methodology all along the day.


Again an interesting data analytic day…stay tuned..

Cet article Pass summit – dbi visit day 2 est apparu en premier sur Blog dbi services.

Counter to indicate rate changes

Tom Kyte - Tue, 2018-11-06 16:46
Hi Tom! Glad to have you back. Oracle: My challenge is as follows: The t_res table contains hotel room reservations that consist of a reservation id (res_id), date of stay (res_date), and a rate card (rate_id) which typically dic...
Categories: DBA Blogs

How to split big union all query

Tom Kyte - Tue, 2018-11-06 16:46
Hi Tom In my application uses SSRS tool and PLSQL .According the requirement I have category as a in parameter like 'AD','SA','SSV' and 'SOA' , so I have written single query with union all operator for all category. Now problem is my query has b...
Categories: DBA Blogs

Data pump import unable to import table that data pump export exported

Tom Kyte - Tue, 2018-11-06 16:46
I'm having trouble importing a table that export exported. The error I'm getting is "ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL", but according to the documentation "The partit...
Categories: DBA Blogs

New White Paper: Oracle EBS 12.2 with Database Advanced Row Compression

Steven Chan - Tue, 2018-11-06 16:09

Oracle Database 12c Advanced Compression provides features designed to compress structured data (Advanced Row Compression), unstructured data (Advanced LOB Deduplication and Compression), database backups (RMAN and Data Pump Compression), and network traffic (Data Guard Redo Log Transport and Advanced Network Compression). 

Our EBS architects have released a new whitepaper that focuses on Advanced Row Compression:

This whitepaper quantifies the storage benefits for Oracle E-Business Suite and documents its effect on performance. Advanced Row Compression can reduce your current storage requirements as well as defer the future purchase and integration of additional storage. It includes optimization for Flashback Data Archive (FDA) history tables, which reduces the storage requirements for using FDA to track changes to tables.

Importantly, Advanced Row Compression is completely transparent to Oracle E-Business Suite and can even be used with Transparent Data Encryption (TDE) tablespace encryption because compression is applied before the data blocks are encrypted. The compression ratio depends on the data being compressed and more specifically the cardinality of the data. Customers have reported a reduction in storage by a factor of 2x to 4x across a range of systems. This new white paper examines whether this is the case for Oracle E-Business Suite. 

Related Articles

Categories: APPS Blogs

To or To Not Specify Thread# When Creating SRL?

Michael Dinh - Tue, 2018-11-06 09:24

Just quick and dirty notes on some references.

Notice that the Thread # is 0 for the SRL’s. Resist the temptation to explicitly assign the SRL to a specific thread. If you are using Oracle RAC, a SRL with with Thread # of 0 can be used by any primary instance, any thread from the primary.

Warning: standby redo logs not configured for thread <n> on <db_unique_name> (Doc ID 1956103.1)
Bug 14674237 – VALIDATE DATABASE from BROKER incorrectly reports on standby redo log files (Doc ID 14674237.8)

Warning: standby redo logs not configured for thread 0 on DATABASE
When run “Validate Database” DGML command, get “Warning: standby redo logs not configured for thread 0 ” and “Insufficient SRLs” warnings on database with “Database Patch Set Update : (26609783)”.

Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE
Even on a single instance, use the thread number in your create Standby Redo Log statement.

Oracle Data Cloud Launches ‘Pre-Bid by Moat’ to Help Marketers Identify Brand Safe, Fraud Safe, and Viewable Ad Inventory

Oracle Press Releases - Tue, 2018-11-06 07:00
Press Release
Oracle Data Cloud Launches ‘Pre-Bid by Moat’ to Help Marketers Identify Brand Safe, Fraud Safe, and Viewable Ad Inventory Pre-Bid by Moat Will Be Integrated with Top DSPs Including Adobe Advertising Cloud, Amobee, Basis by Centro, dataxu, MediaMath, The Trade Desk, and VideoAmp

Redwood City, Calif.—Nov 6, 2018

Oracle Data Cloud today announced Pre-Bid by Moat, a placement solution for marketers to identify and utilize ad inventory that meets their high standards for third-party viewability and invalid traffic (IVT). These new capabilities will join existing brand safety segments available through Oracle Data Cloud to create a powerful suite of media spend protection offerings. To make implementation seamless and simple, Pre-Bid by Moat will be integrated with top DSPs, including Adobe Advertising Cloud, Amobee, Basis by Centro, dataxu, MediaMath, The Trade Desk, and VideoAmp.

“Savvy marketers recognize the tremendous financial and reputational risks from misplaced advertising,” said Eric Roza, senior vice president and general manager, Oracle Data Cloud. “Fraud and viewability issues can drain your ad spend and damage your results, while association with offensive or inappropriate content can result in lasting brand damage. Oracle’s Pre-Bid by Moat offers a unified solution to protect media spend for advertisers by bringing together powerful tools to set real-time requirements for viewability, invalid traffic, and brand safety.”

Pre-Bid by Moat helps advertisers to optimize their media buys with:

  • Granular Viewability Standards. Pre-Bid by Moat will allow marketers to set viewability rates for specific ad slots and sizes, offering unprecedented precision before placement.
  • Invalid Traffic Avoidance. Pre-Bid by Moat is powered by Moat’s leading IVT measurement technology. Moat’s IVT solutions also benefit from learnings from Oracle’s other anti-fraud acquisitions, including web security and managed DNS from Oracle Dyn, which helps identify abnormal traffic patterns on the web and detect and block malicious non-human traffic.
  • Contextual Brand Safety Analysis. Using the contextual intelligence platform from its Grapeshot acquisition, Oracle Data Cloud analyzes and interprets the actual content of each web page, not just its URL-level keywords.

“The growth of digital advertising over the past decade has been staggering. In order to sustain that growth in the years to come, marketers must trust the effectiveness of the media they purchase,” said Lewis Rothkopf, general manager of media and growth channels, MediaMath. “We’re excited to be one of the first to make Moat’s first-in-class ad measurement actionable for media buyers. We’re confident this collaboration will help advertisers reduce waste and protect consumer trust.”

“Some brand safety solutions ask websites and apps to grade their own homework through self-reported URL keywords describing the content on their sites,” said Patrick Jones, group vice president and general manager, partnerships, Oracle Data Cloud. “Our contextual intelligence platform reviews and classifies billions of pages and apps with language-based algorithms, so we can categorize the content of each page as safe and brand-appropriate. By integrating that brand safety with our leading IVT and viewability tools, Pre-Bid by Moat gives marketers confidence that their ads are reaching real people, viewable, and appearing in brand-safe environments.”

For more information about Oracle Data Cloud’s Pre-Bid by Moat, please contact the Oracle Data Hotline at https://www.oracle.com/cloud/data-hotline.html.

Contact Info
Simon Jones
Oracle PR
About Oracle Data Cloud

Oracle Data Cloud helps marketers use data to capture consumer attention and drive results. Used by 199 of the world's 200 largest advertisers, our Audience, Context and Measurement solutions extend across the top media platforms and a global footprint of more than 100 countries. We give marketers the data and tools needed for every stage of the marketing journey, from audience planning to pre-bid brand safety, contextual relevance, viewability confirmation, fraud protection, and ROI measurement. Oracle Data Cloud combines the leading technologies and talent from Oracle’s acquisitions of AddThis, BlueKai, Crosswise, Datalogix, Grapeshot, and Moat.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Simon Jones

  • +1-415-202-4574

Oracle Empowers Global Retailers to Streamline Omnichannel Complexity

Oracle Press Releases - Tue, 2018-11-06 07:00
Press Release
Oracle Empowers Global Retailers to Streamline Omnichannel Complexity Better Inventory Visibility and Integration Across Transactions Enables Retailers to Improve Customer Experiences and Loyalty

Redwood Shores, Calif.—Nov 6, 2018

Recent enhancements to Oracle Retail Order Management System Cloud Service provide retailers with real-time visibility into inventory and customer activity throughout the transaction lifecycle, helping brands navigate omnichannel fulfillment complexity. By integrating all aspects of the transaction lifecycle across all channels and points of service, retailers open a wealth of opportunities to increase revenue, enhance customer loyalty, streamline operations, reduce markdowns, and cut costs.

Oracle Retail Order Management System Cloud Service integrates with Oracle Retail Order Broker Cloud Service to manage not only order creation, tracking, and payment but also the steps of the fulfillment process. The Oracle Retail Order Management Cloud Service unifies order maintenance, customer notifications, contact center, and payment settlements, while Oracle Retail Order Broker Cloud Service handles enterprise inventory, the routing engine, drop shipments, and the store connection for the associates.

“Oracle's OMS utilizes its Intelligent Order Routing to allow routing engines to make decisions as to the most profitable location to fulfill an order from while satisfying customers' requirement and still satisfying margin/profitability calculations via Order Broker,” said Victoria Brown, Research Manager, Global Supply Chain Strategy & Execution, IDC. “Oracle's users have found the system to have a tremendous speed to ROI and appreciate the speed to go live from the ease of configuration on the cloud.”

“Oracle Retail is honored to serve as a strategic partner that helps a global community prepare for the next wave of omnichannel innovation,” said Jeff Warren, Vice President Solutions and Strategy, Oracle Retail. “By providing our customers with an enterprise view of inventory and order across our omnichannel suite of solutions, brands are able to create new business standards that enhance customer loyalty, streamline operations and maximize profitability.” 

Oracle Retail Delivers a Prescriptive Approach to Order Management
  • Open Integration: In addition to pre-integration between Order Management and solutions within the Oracle portfolio, including with POS, CRM and ecommerce offerings, which work cohesively and solve end-to-end supply chain needs, open integration allows other third-party systems to handle the necessary business flows.
  • User Experience: A modern contact center with a streamlined workflow allows a quick and easy way for customer service reps to leverage customer information more effectively throughout the transaction and as part of their marketing, merchandising, and customer service efforts.
  • Globalization: To support global retailers, the introduction of language translation and fiscal requirements enables users in new markets. With these enhancements, we can empower contact center agents in France, Spain, Italy, Switzerland, Austria and Germany.
  • Modern Payments: The addition of a payment extension layer eases the integration with providers. A secure integration with Oracle Retail Customer Engagement for our gift card integration allows retailers to take advantage of additional features that are offered.

“The modern user experience present in Oracle Retail Order Management System Cloud Service empowers contact center agents to provide more thoughtful service by serving up all relevant information in a single, highly useable panel,” said Chris Sarne, Senior Director, Oracle Retail. “Visibility into order tracking and inventory location for service associates is critical to encourage customer loyalty as the omnichannel environment for retailers becomes more complex.”

Contact Info
Matt Torres
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Matt Torres

  • 415-595-1584

Why Your Developer Story is Important

OTN TechBlog - Tue, 2018-11-06 02:45

Stories are a window into life. They can if they resonate provide insights into our own lives or the lives of others.They can help us transmit  knowledge, pass on traditions, solve present day problems or allow us to imagine alternate realities. Open Source software is an example of an alternate reality in software development, where proprietary has been replaced in large part with sharing code that is free and open. How is this relevant to not only developers but people who work in technology? It is human nature that we continue to want to grow, learn and share.


With this in mind, I started 60 Second Developer Stories and tried it out at various Oracle Code One events, at Developer Conferences and now at Oracle OpenWorld 2018/Code One. For the latter we had a Video Hangout in the Groundbreakers Hub at CodeOne where anyone with a story to share could do so. We livestream the story via Periscope/Twitter and record it and edit/post it later on YouTube.  In the Video Hangout, we use a green screen and through the miracles of technology Chroma key it in and put in a cool backdrop. Below are some photos of the Video Hangout as well as the ideas we give as suggestions.

Oracle 60 Second Developer Story 2IMG_3756.JPG

Oracle 60 Second Developer Story.jpg

60 Sec with Background.png

  •     Share what you learned on your first job
  •     Share a best coding practice.
  •     Explain how  a tool or technology works
  •     What have you learned recently about building an App?
  •     Share a work related accomplishment
  •     What's the best decision you ever made?
  •     What’s the worst mistake you made and the lesson learned?
  •     What is one thing you learned from a mentor or peer that has really helped you?
  •     Any story that you want to share and community can benefit from





Here are some FAQs about the 60 Second Developer Story


Q1. I am too shy, and as this is live what if I get it wrong?

A1. It is your story, there is no right or wrong. If you mess up, it’s not a problem we can do a retake.


Q2. There are so many stories, how do I pick one?

A2. Share something specific an event that has a beginning, middle an end. Ideally there was a challenge or obstacle and you overcame it. As long as it is meaningful to you it is worth sharing.


Q3. What if it’s not exactly 60 seconds, if it’s shorter or longer?

A3. 60 Seconds is a guideline. I will usually show you a cue-card to let you know when you have 30 secs. and 15 secs. left. A little bit over or under is not a big deal.


Q4. When can I see the results?

A4. Usually immediately. Whatever Periscope/Twitter handle we are sharing on, plus if you have a personal Twitter handle, we tweet that before you go live, so it will show up on your feed.


Q4. What if I am not a Developer?

A5. We use Developer in a broad sense. It doesn’t matter if you are a DBA or Analyst, or whatever. If you are involved with technology and have a story to share, we want to hear it.



Here is an example of a  a 60 Second Developer Story.

We hope to have the Video Hangout at future Oracle Code and other events and look forward for you to share your 60 Second story.


Subscribe to Oracle FAQ aggregator