Excellent feeds geselecteerd door Ageos

The Oaktable

SELECT ANY DICTIONARY - What Privileges Does it Have - SELECT_CATALOG_ROLE

There has been a few blog posts over the years discussing what is the difference between SELECT ANY DICTIONARY and the SELECT_CATALOG_ROLE. Hemant posted in 2014 about the difference between SELECT ANY DICTIONARY and SELECT_CATALOG_ROLE . This post was a....[Read More] Posted by Pete On 11/10/19 At

Lees meer

11 Oct 2019, 1:29 pm

Here’s an odd, and unpleasant, detail about querying v$session in the “most obvious” way. (And if you were wondering what made me resurrect and complete a draft on “my session id” a couple of days ago, this posting is the reason). Specifically if you want to select some Lees meer
In first steps with with hashicorp vault and ansible I explained how to setup Hashicorp vault for use with Ansible. The authentication of the playbook with Hashicorp vault in the playbooks was done in two ways: – using a username and password in the playbook itself (which I discourage; then th Lees meer
The Oracle Groundbreakers program, and it’s previous incarnations going back to OTN and beyond, are all about me. Yes – Me! read more Lees meer
OGB Appreciation Day : “_query_on_physical” (again) Looks like we are on the #ThanksOGB day. One place where the Oracle Community is great is when it helps users with the technology, far from the commercial considerations. We all know that it can be very easy to use some features th Lees meer

Oracle-Base

AWX Installation on Oracle Linux 7 (OL7) Using the Docker-Compose Method

This article describes how to install AWX, the upstream project for Ansible Tower, on Oracle Linux 7 (OL7) using the Docker-Compose method.

Lees meer

The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs. Lees meer
This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit. Lees meer
This article describes the installation of Oracle Database 18c 64-bit on Oracle Linux 8 (OL8) 64-bit. Lees meer
This article provides a pictorial guide for performing a basic server installation of Oracle Linux 8 (OL8). 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

Introduction to Oracle Machine Learning – SQL Notebooks on top of Oracle Cloud Always Free Autonomous Data Warehouse

One of the relatively new features available with Oracle Autonomous Data Warehouse is Oracle Machine Learning Notebook. The description on Oracle’s tutorial site states: “An Oracle Machine Learning notebook is a web-based interface for data analysis, data discovery, and data visualizatio

Lees meer

It is such a small thing. That you can look for in the docs, no Stackoverflow and in many blog articles. After I have used groupby on a Data Frame, instead of getting a Series result, I would like to turn the result into a new Data Frame [to continue my manipulation, querying, visualization etc.]. [ Lees meer
The CBS (the Dutch Centraal Bureau Statistiek) keeps track of many thing in The Netherlands. And shares many of its data sets as open data, typically in the form of JSON, CSV or XML files. One of the data sets is publishes is the one on the number of births and deaths per day. I [...] The post Disse Lees meer
In a number of recent articles, I have described how to provision an instance of Oracle Data Warehouse Cloud in Oracle Cloud’s Always Free tier. I have also described how to connect both SQL Developer and Data Visualization Desktop to this ADW instance. In this article, we take this one step f Lees meer
Oracle Cloud now offers the Always Free Tier that comes with an always free Autonomous Data Warehouse (up to 20 GB data storage) as well as an free Autonomous Database for Transaction Processing. In an earlier article, I described how to provision your own Free Autonomous Data Warehouse in Oracle Cl 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