Many database administrators are enslaved by their consoles, completely dependent on GUI-based database management tools not only for modifications but for all diagnostics. This session is about breaking away from that trap, getting into the Linux/UNIX shell, and finding out what is really going on within the operating system. It explores the basic architecture of…

This presentation is a case study that will demostrate that implementing Virtual Private Database and Database Data Vault allows data access restriction to sensitive data at table row level from all unauthorized privilged user, including SYS. Why still allowing SYS user to access and perform required database functions. Virtual Private Database (VPD) secures data from…

Oracle Audit Vault consolidates audit data from Oracle databases, operating systems and directories into a centralized secure repository.  Audit Vault has built in reports and configurable alerting to enhance security across a large environment. This session will cover the initial deployment of Audit Vault as an Administrator and the separation of duties to configure Audit…

Is your WebCenter Portal-based employee intranet, customer, or partner portal underperforming? Does the home page take too long to load, or does page-to-page navigation cause a severe lag in page assets being displayed? If your organization has deployed Oracle WebCenter Portal and you feel that it is underperforming, this is the session for you. Oracle…

Ever wonder why you can spin-up an Oracle Database environment from a public cloud provider in mere minutes yet it takes days to provision and configure one internally? Oracle database provisioning and management using DevOps style processes may seem like mixing oil & water but it doesn't have to be that way.  In fact it's…

This presentation illustrates the power of Oracle Enterprise Manager's High Availability (HA) and Disaster Recovery (DR) configuration. The Electric Reliability Council of Texas (ERCOT) successfully rebuilt its OEM Oracle Management Service (OMS) HA configuration to fit the current Oracle Best Practices which didn't exist when the application was converted to using WebLogic file system replicated domains…

Have you every wondered what it takes to BLOG about technology? This Quick Tip will cover how to start BLOGing, from what not to say, though the process of editing and publishing your BLOG using a few free tools.

A summary and illustration of set-based SQL syntax as well as manipulation and use of SQL collections.  Examples will build from correlations to mathematics set theory through the powermultiset operators.  Collections will be created using native sql functions as well as pl/sql table functions.  The presentation ends with illustrations of recursive queries to solve set…

Faced with limited budget or resources an Oracle Spatial and Graph developer or DBA may consider ETL one of their biggest pain points. Commercial Spatial ETL tools like Safe Software's FME, ESRI's ArcGIS, and Oracle's Data Integrator unfortunately aren't a real option for all Spatial shops. Shell, Python, and Batch scripts can often proliferate and become redundant if strict discipline is not applied.

If you are faced with imminent resource reductions, are struggling with manual processes and their documentation, or are just plain bored with repetitive ETL procedures, then automation via a flexible tool like Gradle should be seriously considered. Written in Groovy and developed initially as a modern replacement for the build tools Ant and Maven, Gradle is much more than a simple build tool. Its declarative domain specific language (DSL) can take advantage of all the object-oriented goodness of Groovy and Java, thus propelling its adopters into the new age of treating build and automation logic as first-class citizens in the development cycle. Another key value point in using a tool like Gradle is its polyglotism: it can interface with and call almost all existing operating systems and languages, thus maintaining and leveraging your investments in these previously disparate skills and knowledge.

In this presentation Mike Sanchez will focus on the open-source, cross-platform build tool called Gradle and how it can be used to automate and extend your existing manual processes without busting your budget, especially when used with other open-source libraries like GDAL, JTS, OGR, GeoTools, QGIS, GeoKettle, etc. Mike will also touch on reasons why automation may not be so easily embraced and offer alternative outlooks to help overcome fear-driven development (FDD).

Agile development methodology helps teams deliver better software faster. How can you simplify things for those adopting and practicing agile development in your organization? This session shows you how Oracle Developer Cloud Service simplifies the management and delivery of agile development practices. Learn about tools that will help you plan, track, manage, and automate your…