Skip navigation

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.

 

Resources:

12 Things Developers LOVE about Oracle Database 12c Release 2

Developer.oracle.com

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,

LKR

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.

 

Resources:

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,

LKR

 

 

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.

 

OVERVIEW OF EXADATA EXPRESS

 

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.

 

 

database-exadata-express-ds-3224599.jpg

                    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.

 

Resources: 

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:

 

Wednesday:

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.

 

 

Thursday:

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 sessions...be sure to drop by!

 

Ciao for Now!

LKR