Excellent feeds geselecteerd door Ageos

The Oaktable

Column Groups

Here’s an odd little detail about the statistics of column groups. At first glance it’s counter-intuitive but it’s actually an “obvious” (once you’ve thought about it for a bit) consequence of the approximate_ndv() algorithm for gathering stats. I’ll present

Lees meer

21 Oct 2020, 10:48 am

VirtualBox 6.1.16 has been released. The downloads and changelog are in the usual places. I’ve done the installation on Windows 10, macOS and Oracle Linux 7 hosts with no drama. I’ll be running new Packer builds for the oraclebase/oracle-7 and oraclebase/oracle-8 vagrant boxes, so they Lees meer
In today’s video we’ll discuss how to build a 2-node RAC setup using Vagrant. This video is based on the OL8 19c RAC build, but it’s similar to that of the OL7 19c RAC build also. If you don’t have access to the patches from MOS, stick with the OL7 build, as it will work wit Lees meer
It’s not uncommon for different recommended practices to arise in technical sizing and optimization practices.  For many, it’s a compromise between most optimal data and ease of access vs. impact on production environments, which is no different from what we face when sizing Oracle Lees meer
Automattic — a leader in publishing and e-commerce software and the parent company behind the industry-leading brands WordPress.com, WooCommerce, WordPress VIP, Jetpack, Tumblr, and more — was awarded a coveted spot on the prestigious Forbes Cloud 100 list, the annual ranking of the worl Lees meer

Oracle-Base

Oracle REST Data Services (ORDS) : Database API - Data Pump

The Oracle REST Data Services (ORDS) database API allows us to create Data Pump export and import jobs via REST web service calls.

Lees meer

The DBMS_DATAPUMP package provides a PL/SQL API, allowing us to define Data Pump operations programmatically. This article provides a few examples to get you started. Lees meer
The Oracle REST Data Services (ORDS) database API allows us to perform some database administration via REST web service calls. This article covers the basic setup. Lees meer
The Oracle REST Data Services (ORDS) database API allows us to manage the lifecycle of PDBs via REST web service calls. Lees meer
Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling. Lees meer

Blogs Oracle.com

RAC SIG Webcast: Oracle Database 12c Release 2 Rapid Home Provisioning and Maintenance

Please join me and the RAC SIG on Wednesday May 17th at 9:00 am PT for a discussion of Rapid Home Provisioning and Maintenance with Oracle Database 12.2.  We'll cover the full feature set available with the 12.2 release and see how it can help you meet today's requirements for maintaining a lar

Lees meer

Companies have been using workflow and content management for many, many years. In IT we got used to the term Business Process Management (BPM) whenever we spoke of automated process execution. Not so strange since the term BPM was adopted by all the major software vendors and has received a Lees meer
Companies have been using workflow and content management for many, many years. In IT we got used to the term Business Process Management (BPM) whenever we spoke of automated process execution. Not so strange since the term BPM was adopted by all the major software vendors and has received a Lees meer
This is the first of a two-part blog series. It leverages the Oracle Cloud platform (in concert with some widely used open source technologies) to demonstrate message based, loosely coupled and asynchronous interaction between microservices with the help of a sample application (scroll do Lees meer
Performance is a critical aspect of mobile app development and the embedded platform web view is a significant contributing factor to the performance of any hybrid mobile app. Since late 2015, hybrid app developers targeting iOS have been able to include the Apache Cor Lees meer

Amis technology blog

OpenAPI Support in Oracle API Gateway

Today I read the announcement of OpenAPI (fka Swagger) support in API Gateway on OCI. I was wondering what that entailed and I decided to try it out. In short, this support means that an API definition can be uploaded to API Gateway, is validated for correctness and can be […] The post OpenAP

Lees meer

The OWASP Foundation plays an important role in helping to improve security of software worldwide. They have created a popular and well-known awareness document called the ‘OWASP Top 10‘. This document lists the following risk: using components with known vulnerabilities. Software n Lees meer
The Oracle Developer Cloud Service was probably the very first service on Oracle Cloud, as early as 2015 if I remember correctly. This service has been repositioned and relabeled as Visual Builder Studio. This service supports agile project management, source code control, artifact management, autom Lees meer
In this article I want to describe how I run a SonarQube instance (that I intend to use from my automated CI/CD pipeline) on OCI, using a simple VM and a simple Docker container image. The VM gets a public IP address and I need to SSH into it in […] The post Run SonarQube on OCI– 10 min Lees meer
Introduction In response to a demo I gave about deploying a docker container to the Azure platform, I received some questions about deploying a docker container to the AWS platform. I wrote a guide on how to deploy a docker container with Azure Pipelines here. In my opinion is Azure […] The p Lees meer

Tanel Poder

Hacking Session: 7 Levels of Hint Invalidity in Oracle SQL

As I promised in the end of the last hacking session (about Oracle SQL Monitoring, I will run another one on 2. June 2020. This one will be a deep dive into Oracle hint usage and various scenarios of hint (in)validity. I have too much material in my full-week Advanced Oracle SQL Tuning training, so

Lees meer

Update: I have uploaded the videos of this hacking session to YouTube. I will run another hacking session that has been in my mind for a while. It will be a pretty narrow deep-dive into one of the SQL Monitoring report’s columns that is not well explained: Oracle SQL Monitoring - Understanding Lees meer
Update: I have added an interview with Jonathan Lewis to YouTube too. We talk a bit about the last 10 years and Jonathan describes what he’ll be talking about in his virtual conference talk:  I will add a few more videos in the coming days. The conference interview playlist URL is here. Lees meer
When talking about Oracle background processes, there’s a term/qualifier “fatal” background process. This means that when one of these background processes crashes, then whoever detects the process disappearance (PMON or LGWR or CLMN possibly), will shut down the instance as it can Lees meer
The current state of affairs in the entire world have radically changed since last month when we announced the next Oracle SQL Optimization event in the virtual conference series. We’ve been keeping an eye on the trajectory of the developments and decided to make some changes too. So, here&rsq Lees meer

All things Oracle

Why choose Oracle?

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.… The post Why choose Oracle? appeared first on Simple Ta

Lees meer

Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.… The post What is Oracle ASM to Azure IaaS? appeared first on Simple Talk. Lees meer
Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and troubleshoot errors as a new developer.… The post Oracle for Absolute Beginners: Problem-Solving as a New Developer appeared first on Simple Talk. Lees meer
Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the security aspects of ERP systems and some of the techniques used to protect data.… The post Security Considerations for ERP Applications appeared first on Simple Talk. Lees meer
There is often more than one way to write a query that returns the same results, but some methods may perform better than others. In this article, Ben Brumm discusses ten best practice when writing SQL code for Oracle. … The post 10 Best Practices for Writing Oracle SQL appeared first on Simp Lees meer