Tag: oracle

Miscellaneous

Using Oracle’s DBMS_PROFILER to tune PL/SQL

Performance is high on the list of IT requirements, especially with queries, functions and stored procedures. Queries have been easy to work with because the execution plan gives all of the details one could need to find trouble spots. When it’s PL/SQL, that’s been a more difficult apple to peel since extracting statements from a …

Miscellaneous

Challenges When Migrating from Oracle to PostgreSQL—and How to Overcome Them

David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on premises and in the cloud. In previous posts, we looked at the overall approach for a successful database migration and …

Miscellaneous

Going to Oracle MySQL Cloud via Enterprise Backup

First of all, if you want a guide on how to deploy MySQL in Oracle Cloud, then the best place to start is here. So, what are we going to do here? Create an Oracle Storage container to keep our backups safe. Run a MySQL Enterprise Backup from on-premise 5.7 MySQL (GPL or Enterprise) streaming …

Miscellaneous

Oracle’s Unified Auditing, Part II

Going back to Oracle’s UNIFIED AUDIT TRAIL some notes need be made as to which auditing actions are reported to regular users and which are reserved to privileged (SYSDBA) accounts. There are basically two types of policies that can be created: action policies and privilege policies. Action policies are triggered by actions executed by any …

Miscellaneous

Oracle’s UNDO Tablespace and Autoextend

The UNDO tablespace is one of the workhorses of an Oracle database (TEMP being the other) yet, unlike TEMP, UNDO requires a special tablespace configuration so that the UNDO mechanism operates properly. Conventional wisdom on configuring tablespaces in general has little or no place when it comes to the UNDO tablespace and following such guidelines …

Miscellaneous

Static Registration and the Oracle 12.2 Listener

In earlier versions of the Listener, Oracle has been more forgiving with static registrations; with 12.2 that seems to have changed as static registrations, if not configured completely, can cause the listener to dump a core file in the directory where the listener process was started. What can make this even more confusing is that …

Miscellaneous

MySQL 8.0 RESOURCE_GROUP Overview – Percona Database Performance Blog

  In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature. One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP. Short disclaimer: I want to point out that MySQL 8.0 is not GA yet, so it is possible for the …