Excellent feeds geselecteerd door Ageos

The Oaktable

Interval Partition(s)

A quirky little feature of interval partitioning showed up on Twitter today – a parallel insert that would only use a single PX slave to do the inserting. With 1.1 billion rows and the option for running parallel 32 this made the loading process rather slower than it ought to have been. Fortun

Lees meer

A little over a week ago Enterprise Manager Cloud Control 13.4 was released. The following weekend I spent 3 days running builds constantly trying to get a clean install to work. Eventually I tweeted out in frustration and a friendly face at Oracle, who I’ve stalked on numerous occasions, put Lees meer

17 Feb 2020, 4:37 pm

It is possible to take subquery factoring (common table expressions / CTEs) too far. The most important purpose of factoring is to make a complex query easier to understand – especially if you can identify a messy piece of text that is used in more than one part of the query – but I have Lees meer
I have read on line about XS$NULL over the years and particularly the documentation that states that it has no privileges. The documentation states the following: An internal account that represents the absence of a user in a session. Because....[Read More] Posted by Pete On 17/02/20 At 01:09 PM Lees meer

17 Feb 2020, 10:35 am

And in other news about things I’ve missed recently… MobaXterm 20.0 was released a couple of days ago. It looks like they’ve switched across to the yearly naming like many other companies. Lees meer

Oracle-Base

Silent Upgrade of Oracle Enterprise Manager Cloud Control to 13c Release 4 (13.4)

This article describes a silent upgrade of Enterprise Manager Cloud Control to 13c Release 4 (13.4).

Lees meer

This article describes the silent installation of Oracle Enterprise Manager Cloud Control 13c Release 4 (13.4) on Oracle Linux 7. Lees meer
This article gives a quick overview of applying changes to the database using the Liquibase implementation in SQLcl. Lees meer
This article gives a quick overview of applying changes to the database using Liquibase. Lees meer
This article shows how to create a vault and key under Oracle Cloud Infrastructure (OCI). 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

Using PXE to deploy a DNS server

Last week, I published a blog about implementing a PXE server [1]. Today I’ll show how kickstart/anaconda files can be used to deploy a server. I will use the example of a DNS-server to explain what can be changed where in kickstart files and what you can do when the kickstart file isn’t

Lees meer

Oracle is not known for low prices or free products. However, when it comes to the Oracle Database there are some developments that might be of interest to you. Either when your organization has existing Oracle Database licenses – or when you do not. In short: three powerful and until recently Lees meer
In earlier articles, I have discussed features in Oracle Cloud Infrastructure for monitoring metrics published by virtually all OCI services. These metrics get published when functions are invoked, files are written, the API Gateway handles a request, events are published, a user is created and a ne Lees meer
Data is really important to any organization. Data tells us what the organization is doing, and where it is going. And how it can improve quality and efficiency of processes. Achieve better results. Data can be one of the key products an organization delivers to its customers. I am sure you have rea Lees meer

8 Feb 2020, 12:17 pm

What is PXE? PXE (Preboot eXecution Environment) is a method of deploying an operating system to a computer over the network. I think it’s great: you don’t need to burn CD’s or DVD’s anymore. The only thing you have to do is changing the boot order in the BIOS, and when the c Lees meer

Tanel Poder

My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced

I have uploaded my TPT-oracle scripts to GitHub and have formally open sourced them under Apache 2.0 license as well. This allows companies to embed this software in their toolsets and processes & distribute them without a worry from legal … Continue reading →Related PostsTroubleshoo

Lees meer

I have uploaded the the video of my Secret Hacking Session: Oracle X$TRACE, Wait Event Internals and Background Process Communication to my Oracle performance & troubleshooting Youtube channel. The slides are in Slideshare. Enjoy!   Lees meer
Update: I unexpectedly ended up falling ill and decided to reschedule this hacking session to January 24, 10am PST. No need to re-register if you already have done so. Sorry for the inconvenience. I will upload the video to Youtube … Continue reading →Related PostsOracle Session SnapperC Lees meer
A lot of people have asked me to do another run of my Advanced Oracle Troubleshooting training or at least get access to previous recordings – so I decided to geek out over the holiday period, update the material with … Continue reading →Related PostsAdvanced Oracle Troubleshooting Lees meer
If you happen to be in Bay Area on Thursday 9th November, then come check out the NoCOUG Fall Conference in California State University in downtown Oakland, CA. Gluent is delivering a Hadoop for Database Professionals class as a separate … Continue reading →Related PostsHadoop for Databa Lees meer

All things Oracle

Oracle for Absolute Beginners: Problem-Solving as a New Developer

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
This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular refrain from the EU in the ongoing Brexit negotiations. They also seem to be a bit intolerant of “cherry picking”. I’ve neve Lees meer
Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing unit tests to your database development, and suggests some lightweight ways to get started.… The post Strongholds of Confidence: Self-Testing Your Database ap Lees meer