Oracle Tidbits September 2019 #oratidbit #OOW19

Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in September 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

#OraTidbit Oracle Developer Studio includes a compiler suite, an analysis suite, and a graphical integrated development environment (IDE). They provide a development environment that is optimized for developing applications with the best performance on Oracle Sun hardware.
#OraTidbit Oracle Machine Learning provides a notebook-style application designed for advanced SQL users and provides interactive data analysis that lets you develop, document, share, and automate reports based on sophisticated analytics and data models.
#OraTidbit #OracleCloud Work Requests in Oracle Autonomous Database let you track the progress of database lifecycle management operations such as creating, terminating, backing up (manual), restoring, scaling, and cloning.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes automated index management tasks such as creating, rebuilding, and dropping indexes based on changes in the application workload.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes gathering real-time statistics automatically while a conventional DML workload is running. This helps the optimizer generate more optimal plans.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes gathering statistics automatically on a more frequent basis (default is 15 minutes). High-frequency automatic optimizer statistics collection complements the standard statistics collection job.
#OraTidbit You can use Oracle Enterprise Manager to discover and manage dedicated Autonomous Transaction Processing databases, provided you are using Enterprise Manager version 13.3 with EM DB Plugin Bundle Patch 13.3.2.0.190731 (or higher).
#OraTidbit gridSetup.sh can be used with the -dryRunForUpgrade option for dry run testing of Oracle Grid Infrastructure upgrade and enables you to verify whether the system is ready for an upgrade. This mode does not perform an actual upgrade.
#OraTidbit The LOG_FILE_NUM_<listener_name> and LOG_FILE_SIZE_<listener_name> parameters in the listener.ora specifies the number of log file segments and the size of each log file segment. If the log grows beyond the number of segments, then the older segments are deleted.
#OraTidbit Oracle Data Safe is a fully-integrated Cloud service focused on the security of your data. It provides a complete and integrated set of features for protecting sensitive and regulated data in Oracle Cloud databases.
#Oratidbit #AutonomousDB Oracle Autonomous Data Warehouse (#ADW) supports dedicated deployments now. Autonomous Transaction Processing (#ATP) dedicated were available since June 2019.

There were no #OraTidbit tweets/fb posts during the OOW week. Here are a few of my #OOW19 tweets.

#OOW19 #CodeOne Highlights from Oracle OpenWorld 2019 – Larry Ellison’s Key-Notes
https://t.co/Y1DiHth767
#OOW19 Review: Oracle Analytics Deep Dive
#OracleAnalytics
https://t.co/pVu4tEYJRC
#OOW19 #CodeOne All the OpenWorld 2019 downloads!
Why dig around for hours in the catalog? Here are all of the downloads registered in the OpenWorld catalog!
https://t.co/Lztn15OBSN
#OOW19 #Exadata #Gen2
Oracle Gen 2 Exadata Cloud at Customer
https://t.co/L0lRLQozbB
#OOW19 #Exadata #X8M
Oracle Unleashes World’s Fastest Database Machine
Exadata X8M, industry’s first database machine with integrated persistent memory and RoCE, delivers 2.5X performance increase and 10X lower latency
https://t.co/CH8PG2DehT
#OOW19 #DataCenter #OracleCloud
Oracle Cloud Puts Data Center Expansion Pedal to the Metal.
Between now and the end of next year, the company expects to launch one new region every 22 days on average.
https://t.co/quvY1wBSpG
#OOW19 #CloudSecurity
Oracle OpenWorld 2019 – Oracle beefs up cloud security, announces three new features to build on Autonomous Database success
https://t.co/h7xvHPPkI8
#OOW19 “One More Thing”
The Oracle Cloud Free Tier – The New “Always Free Service”s announced at OOW19
https://t.co/yzwOXBWsjn
#OOW19 #VMWare #HybridCloud
New Oracle Cloud VMware Solution will Enable Customers to Run VMware Workloads on Oracle Cloud. Oracle to Offer Technical Support for Oracle Products Running on VMware Virtualized Environments.
https://t.co/HMGcOECh0x
#OOW19 “One More Thing”
Best and Cheapest Oracle APEX hosting: Free Oracle Cloud
https://t.co/BGidXWI5pU
#CodeOne #unconference #Groundbreakers @groundbreakers https://t.co/KyOj40J0G1
#OOW19 #AutonomousLinux #Linux
In an Industry First, Oracle Brings Autonomous Operation to Linux
https://t.co/v7NlAhKfBp

Oracle Autonomous Database: A DBA Perspective

When more people started using Autonomous Database services, more Admin tools are made available as well. When ADW was introduced, all the DBA had for monitoring or diagnosis or utilization was only the Service Console. Here are some administrative enhancements in ATP/ADW we saw in the past 1+ year.

  • July 2018: SQL Developer 18.2.0 and later allows for setting up connections without the need for Keystore passwords.
  • September 2018: Autonomous Data Warehouse allows users to create partitioned tables, indexes, and materialized views. 
  • March 2019: Autonomous Database provides cloning where you can choose to clone either the full database or only the database metadata. 
  • April 2019: A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. 
  • May 2019: Oracle Management Cloud supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. 
  • May 2019: It is possible to create a database link from an ADW instance to any database that is accessible from an ADW/ATP including other ADW/ATP instances.
  • June 2019: You can select auto-scaling during provisioning or later using the Scale-Up/Down button on the Oracle Cloud Infrastructure console.
  • June 2019: Oracle Rest Data Services (ORDS) is included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. 
  • June 2019: Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. 
  • June 2019: Autonomous Database includes Oracle’s premiere low-code development platform: Application Express (APEX). 
  • July 2019: Customers can get a real-time and historical view of performance data directly on the OCI console using Performance Hub.
  • August 2019: Autonomous Database supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB.

Oracle Open World 2019 announced that there are two autonomous databases included in the Always Free tier! Great news!! Now, DBAs and developers have no reason not to get into Autonomous Database and start playing. Maybe you can develop an application using APEX and ATP for your favorite local charity 🙂

I will be comparing the traditional DBA activities against the activities you can do on ATP or ADW of Autonomous Database service in my talk “Autonomous Database: What’s the Admin’s Role?” on Sep 27th at the Arizona User Group meeting.

https://www.meetup.com/Arizona-Oracle-User-Group/events/264171869/