Skip navigation
1 2 Previous Next

DBA/DEV Community Corner

20 posts

Borys Neselovskyi, a middleware and infrastructure architect with Opitz Consulting, likes Oracle Exadata Express Cloud Service so much he devotes 2 minutes to explaining why in this 2-Minute Tech Tip produced by Bob Rhubart-Oracle.



Oracle Exadata Express Cloud Service

Oracle Cloud Community

Oracle Database as a Service Community

Get started with Oracle Database Cloud Service

Download:  Oracle Cloud Free Trial



Do you have a 2-minute Tech Tip? Contact Bob Rhubart-Oracle to submit yours today!


Ciao for Now,


There are many hot new features for developers in Oracle Database 12c R2, but have you heard about Data Type conversions? This cool feature is presented by Oracle Developer Advocate and SQL Enthusiast Chris Saxon in this 2-Minute Tech Tip produced by Bob Rhubart-Oracle.



12 Things Developers LOVE about Oracle Database 12c Release 2

Oracle Developer Blog

All things SQL Blog

SQL & PL/SQL community space

Oracle Application Express (APEX) community space


Do you have a 2-minute Tech Tip? Contact Bob Rhubart-Oracle to submit yours today!


Ciao for Now,


Many Database Developers use a lot of PL/SQL inside Oracle APEX. But there are a number of reasons to move that PL/SQL into the database and just call the PL/SQL package a procedure in APEX. Here are the top reasons to make that move, as presented by Oracle Ace Director Roel Hartman in this 2-Minute Tech Tip produced by Bob Rhubart-Oracle.



SQL & PL/SQL community space

Oracle Application Express (APEX) community space

Apex Playlist: Oracle Database Developer Channel / YOUTUBE


Do you have a 2-minute Tech Tip? Contact Bob Rhubart-Oracle to submit yours today!


Ciao for Now,




Are you a software developer looking for the best cloud database for application development?


Oracle Database Exadata Express Cloud Service is the ideal entry-level service for running Oracle Database in Oracle Cloud.

Here's why:

  • It delivers an affordable and fully managed Oracle Database 12c Release 2 experience, with enterprise options, running on Oracle Exadata.
  • It is a great fit for small and medium-sized production databases as well as development, testing and evaluation environments.
  • For developers, Exadata Express provides easy access to advanced development features of Oracle Database, enabling you to rapidly create modern data-driven applications.


Exadata Express in Oracle Cloud delivers an easy, affordable and feature-rich enterprise database experience. You do not need to worry about network or storage configuration, patching, upgrade or other DBA tasks. These activities are managed for you by Oracle, so no customer DBA is required. Exadata Express gives you the same compatible Oracle Database Enterprise Edition that runs on-premises and in other Oracle Database Cloud Services–provisioned for you within minutes. It uses one of Oracle’s most advanced configurations, combining shared Oracle Exadata engineered systems for highest performance and availability with Oracle Multitenant Pluggable Database (PDB) containerization technology for security isolation, resource management and lowest cost. With support for up to 50 GB of database storage, Exadata Express is an ideal entry-level service for small and medium sized data bases used in production, development, testing and evaluation environments.




ServiceSubscription PriceStorage MaximumData Transfer Maximum
X20$175 / month20 GB120 GB / month
X50$750 / month50 GB300 GB / month
X50IM*$950 / month50 GB300 GB / month

                                   *Provides up to 5 GB additional RAM for use with Oracle Database In-Memory Column Store



Oracle Database 12c Release 2 gives software developers get a unifying database that includes support for new data management and access models. Native support for  RESTful and a schema-less documents & collections interfaces in addition to supporting standard SQL. The database can natively store JSON, XML and relational data all in a single environment.

In addition, developers get client drivers for all their favorite application environments and programming languages including Java, .NET, Python, Node.js, PHP, C/C++, Ruby and more. Developers can take advantage of free integrated development environments from Oracle for creating and debugging their applications including SQL Developer, Data Modeler and JDeveloper.

With Oracle Database 12c Release 2, developers also get pre-configured Oracle Application Express 5 (APEX). This is a simple declarative environment for rapid development of data-driven web apps using only your web browser. No additional tools are required. APEX version 5 includes all new packaged controls, updated themes, a gallery of productivity applications, and other enhancements that make apps look beautiful across desktop and mobile browsers.




                    Apex 5 Application Builder in Exadata Express


But more than advanced features and native support for popular languages, Oracle has brought out several new PaaS offerings Just for Developers:

Oracle’s Application Container Cloud Service  includes support for PHP, along with Node.js and Java.

Applications composed from multiple PaaS services can be created, scaled and managed as a single unit with the new Oracle Cloud Stack Manager.

Java EE apps are migrated to the Cloud automatically using Oracle AppToCloud while adding capabilities like active standby and increasing cluster size as the application is moved to the Cloud.

Anyone can author complete applications from a browser without coding skills, using the Oracle Application Builder Cloud Service low-code development platform to extend services with pre-populated Oracle Software-as-a-Service APIs or custom services from a common REST API catalog.

Oracle Developer Cloud Service also makes collaboration between developers easier by integrating with popular collaboration tools like Slack, Hipchat, Hashicorp's Packer and Terraform and including agile management features for managing sprints, tasks and backlogs.

Oracle Mobile Cloud Service now provides actionable insights and engagement across multi-channels and micro locations to improve the customer experience. It also provides an intelligent and contextual Chatbots experience across multiple messaging channels like Facebook Messenger, Slack, Kik and others.

What's a Storm Trooper DBA? Someone who shoots left, right, above and below their target and doesn't seem to hit it.  Looks great on the big screen, but if you really want to hit your target when it comes to your Oracle Database 12c performance, you may get better results from taking this approach suggested by Oracle Ace Director Bjoern Rost.



Performance Tuning in Oracle Database 12c




Here's the "Schedule of Shenanigans" Brought to you by OTN in the Project O.W.L. area at RMOUG TD17:



Hang space--drop by to Sign up for the new Oracle Cloud Promotion--including $300 user credits.


1:15 -- Zero Data Loss Recovery Appliance: Demo and Hands-On Lab

Oracle Zero Data Loss Recovery Appliance , is a machine focused on ensuring recoverability , with built in validation and incremental forever capabilities. it provides peace of mind to the recovery focused DBA. The session will include an overview of the architecture. Rman Best Practices, Capabilities within Appliance. Attendees will bring their own laptops and work on the appliance to perform a backup restore the database as look at how zero data loss works within the appliance. We will be using Enterprise Manager to drive the complete process.


4:00 - 5:30 Monitoring your application in the Cloud – private, public and anything in between

Within minutes you can monitor and report how users and devices  interact with your application, what their performance is and how the application internals are performing regardless on where they servers are deployed. Rapidly discover problem areas, without having to rebuild your monitoring every time the application changes. Deploy a new version of the app and automatically learn the architecture, so you do not miss that database version 2.0 started calling. Have an app deployed across multiple clouds.. no problem! Want to see the AJAX calls, no problem! Run down a broken application server... no problem! All easily done, even if you do not want to make changes to your code! You can also monitor your deployment using complex synthetic transactions using sessions recorded with Selenium, a free browser automation tool.




9:30 am - 11:30 -- Data Virtualization HOL

Traditional means of copying databases to provide clones for DEV, TEST and REPORTING can be lengthy and painstaking. Why wait for days or weeks to get a copy of production? What? You can only copy only a small subset of your data due to storage restraints?

Data virtualization allows DBAs to do with data and databases, what VMware does for compute. Get up-to-date copies of your database ready to use for Development and Testing. And get it fast!


11:30 - 12:30 Zero Data Loss Recovery Appliance: Demo and Hands-On Lab

Oracle Zero Data Loss Recovery Appliance , is a machine focused on ensuring recoverability , with built in validation and incremental forever capabilities. it provides peace of mind to the recovery focused DBA. The session will include an overview of the architecture. Rman Best Practices, Capabilities within Appliance. Attendees will bring their own laptops and work on the appliance to perform a backup restore the database as look at how zero data loss works within the appliance. We will be using Enterprise Manager to drive the complete process.


LImited space for all the sure to drop by!


Ciao for Now!


Attend Oracle Code – an event for developers, by developers


Oracle is ramping up a global Developer roadshow in 2017...and the registration for the first two cities is now open: We'll be in San Francisco and New York in March.  We also have a Call for Papers for all other cities and online events as well.  Submit your proposal today!


Oracle Code 2017 is an event for developers, by developers. The agenda features tech experts discussing the latest insights, technology, and innovation; educational sessions for developing software in Java, Node.js, and other programming languages  – and a hub where you can interact and exchange ideas with your peers. Register today!

What is it? It's the new "Project Visual Code" - an application development platform that enables business users and developers to extend SaaS services and build new applications with little to no coding.


Customers will be able to utilize a library of responsive user interface components and complete applications – made available in the Oracle Cloud Marketplace—to add features that can be embedded directly into their own applications, environments or even existing Oracle Cloud applications. With minimal coding needed and intuitive visual design capabilities, business users and citizen developers can easily create the applications they need on their own, with little to no involvement from their IT department.

Built on a standards-based architecture, the new platform also enables customers and partners to create a rich ecosystem of modular user interface building blocks as well as complete applications. In addition, with its best-in-class mobile development features, the new platform enables the creation of on-device mobile applications that work even in disconnected mode.


Oracle Ace Director Debra Lilley explains more here:





Interview with Debra Lilley -

Press release -


Ciao for Now!


Oracle Database 12.2 is now available...and it's time to start your upgrade path for your on-premise installation...but wait. You may want to check it out as a Cloud implementation.




Larry Ellison's keynote was great fun last week at Oracle OpenWorld. But turn down the volume and look at what we've got: The Oracle Database Cloud Service is an affordable, enterprise-class "data management cloud" that includes Oracle Database 12.2 innovations like RAC, In-Memory, Multitenant, and Exadata. All the things you rely on in your enterprise data center.


You say: my data management implementation is extraordinary and complex. And it's working.


Really? First of all, I don't know any DBA who isn't always looking for a way to deliver greater performance and reliability. It's like you are so rarely satisfied. And Oracle knows this. Here's something else we know:


Your users are innovating fast and want to develop and deploy apps as quickly as possible. You can rely on basic system automation to help support this typical Dev/Ops challenge, or you can leverage the streamlined provisioning and automated administration offered by Oracle Database Cloud Service. It will permit your developers to spin up database schemas or full database instances for dev/test quickly and consistently. With the Oracle Database Cloud Service, you can deliver a high-performing database with integrated tools that enable developers to rapidly build and run Oracle Application Express and Java applications.


Oracle ACE Director Bjoern Rost, a senior consultant from Pythian, discusses this scenario and the value moving to the cloud delivers to the Enterprise DBA:



And Robert Greene, Director of Product Management for the Oracle Data Management Cloud  gives an overview of Oracle Database Cloud Services and how it delivers the DevOps capabilities you need:



Ready to play?


Additional Resources:


Ciao for Now!


During an interview with Beda Hammerschmidt at Oracle OpenWorld this week, I had a chance to get the details behind the JSON updates in Oracle 12.2.

We also talked about why Developers love JSON.


It was cool because Beda would start the sentence talking about developers in general, but usually around the 20th word the words "me, my, and I " would slip in.


That was when I knew no matter how cool the new JSON features in Oracle Database 12.2 are, (and they the clip below)  I had to ask the question...What's it like to be a developer at Oracle?  It's a fun interview for sure.


Click on the Picture Below to watch the interview on Youtube.


Ciao for Now!




FB Beda Thumbnail.jpg

Let's talk about Securing the Big Data Lifecycle. 


We all have seen demos or attended tutorials with extraordinary examples of integrating, analyzing and making business decisions based on Big Data. And I always wonder...who's data is that anyway? Consider the nature and character of Big Data for a moment. What we have here is ubiquitous and indiscriminate data collection from a wide range of devices. Add to that unexpected uses of collected data, especially without customer consent. And that could possibly lead to unintended data breach risks with larger consequences.


It will be a great challenge.

You need a plan.


MIT Technology Review published this whitepaper addressing these issues.


Give it a read to set your mind at ease about how to secure your data, no matter how big.


Ciao for Now!

Hey, Hey DBAs--Do you have a plan for implementing a Database Cloud?


Here's what you need to know:


DBaaS is a cloud model that enables users to request database environments by choosing from a pre-defined service catalog using a self-service provisioning framework.


The key benefits of these database clouds are agility and faster deployment of database services.


Organizations are looking at DBaaS because it can simplify IT infrastructures and automate provisioning processes. So it makes it possible to deliver database functionality to many users and multiple divisions from the same hardware and software infrastructure.  



What's the ideal Oracle DBaaS configuration?


Start with Oracle Database 12c. Its multitenant architecture option makes it possible to enable DBaaS as part of a comprehensive cloud strategy. It allows collections of pluggable databases to be easily managed as a single entity, which maximizes consolidation density and simplifies administration.


The next key element:  Oracle Enterprise Manager 12c. It's designed to manage the entire database cloud deployment lifecycle, from planning, testing and deployment to ongoing operations and performance monitoring.


Finally, the exceptional deployment platform for DBaaS:  Oracle Exadata.  A fully integrated and sophisticated engineered system from Oracle that supports multiple deployment models, multiple workloads and multiple service levels from one integrated, optimized platform.

So, start thinking about the Database Cloud, deploying DBaaS and the value it can bring to your environment.                 

Here are some expert resources to help you come up to speed.



Ciao for Now!

There's a lot to talk about when it comes to JSON support in Oracle Database 12c. A big part of that story is Oracle REST Data Services. But there's more to it. Oracle 12c has a key set of API's:  Simple Oracle Document Access (SODA).   And it's important.


Here's the deal:


Oracle Database supports storing, indexing and querying JSON documents in the database. But the picture is completed by document-centric API's for accessing JSON documents.




Introducing Simple Oracle Document Access (SODA)

SODA, the set of APIs specifically designed to support schemaless application development.                                             

There are 2 SODA implementations:


  1. SODA for Java-- a programmatic document-store interface for Java Developers that uses JDBC to communicate with the database. SODA for Java consists of a set of simple classes that represent a database, a document collection and a document. Methods on these classes provide all the functionality required to manage and query collections and work with JSON documents stored in an Oracle Database.

  3. SODA for REST-- a REST-based document store interface implemented as a Java servlet and delivered as part of Oracle REST Data Services (ORDS) 3.0. Applications based on SODA for REST use HTTP to communicate with the Java Servlet. The SODA for REST Servlet can also be run under the database's native HTTP Server. HTTP verbs such as PUT, POST, GET, and DELETE map to operations over JSON documents. Because SODA for REST can be invoked from any programming or scripting language that is capable of making HTTP calls, it can be used with all modern development environments and frameworks.


Want to see it in action?

Check out the oracle/json-in-db repository on Github. You'll find downloadable and installable demonstrations for the JSON capabilities of Oracle Database and later.                                           


And get more details about Oracle as a Document Store from OTN.


Join the ORDS discussion space on the OTN Community Platform here.




Ciao for Now!


Did you miss the recent Virtual Technology Summit? It's cool. It's all available On Demand at:


As the IT landscape shifts to the cloud, system performance and best practices for developing high-performance applications are more important than ever. So we gathered sessions for the Database track that provide a deep dive into application performance and development best practices that address key factors for Enterprise Big Data or Cloud Implementations. In-depth topics cover the newest tips and techniques for developing and deploying applications utilizing Oracle Database 12c Advanced features and capabilities. Get the latest performance and tuning tips, learn more about new generation application development with JSON, Node.JS and Oracle Database Cloud.
The VTS agenda also features sessions dedicated to the most recent capabilities of Oracle MySQL.


Session Topics include:

  • Oracle Database 12c SQL performance
  • Oracle Database Optimizer,
  • Oracle Database Cloud Services
  • Oracle JMS Sharded Queues
  • Schemaless App Development
  • JSON Support and node.js
  • MySQL Tuning
  • Oracle Enterprise Manager

To see the session list and abstracts, go to:   Database Track Agenda and Abstracts


If you would like to attend a live session, we have 1 more live sessions scheduled for the APAC region. Register now to watch and ask the experts the hard questions live!




To view VTS Sessions from past events, join the OTN Database VTS Replay Library Group


Plug Inbound!

Be sure to Follow the Oracle Database Community page to get the most recent news and articles posted across the Oracle Database product and technology spaces.

Click the "Follow" button at the top right of the page.

And here are the social channels:  Tell them LKR sent you!



Ciao for now,


Oracle Ace Associate Kiran Tailor kt1 submitted an article for OTN a few weeks ago and as I edited this article, I wondered, how in the world did he come up with this idea? Was he facing a situation in his data warehouse? Was he wondering if there was an easier way to accomplish this? So I asked him, and he said:


Well the story goes:


We received the exalytics box at our company and it sat in the box for approx. 3 months, we didn’t even open the box.  When we did open the box, I decided to investigate how the machine works and that is how I was introduced to Timesten.  Our warehouse was only 350gb and this machine has much more memory, so I thought let’s try it and the with the help of the development teams in San Francisco and the UK it worked.  I would say ‘ Thinking outside the box’ J


Yes, I would agree. Take a look at his featured article in the Oracle Database OTN DBDEV library here: Using Oracle TimesTen on Exalytics as an Operational Data Store


Ciao for Now!