Minimalistic Oracle

Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.

Wednesday, December 16, 2020

How to fix error SYS.DBMS_BACKUP_RESTORE version 18.11.00.00 in TARGET database is not current

›
Even if you're not using a recovery catalog, you may encounter this issue if you have recently patched your database. Simply by connec...
2 comments:
Friday, December 4, 2020

How to view the contens of a zip file without extracting it

›
Method 1: zip -sf myzipfile.zip Method 2: zipinfo myzipfile.zip

How to mark an existing SQL Plan baseline as fixed

›
Thanks a lot to Tim Hall for providing this simple example: SET SERVEROUTPUT ON DECLARE l_plans_altered PLS_INTEGER; BEGIN l_plans_...
Tuesday, November 10, 2020

Date formatting in PostgreSQL

›
select action_type, to_char(action_date,'DD Mon YYYY'), count(*) from actions group by action_type, action_type | to_char...
Thursday, November 5, 2020

How to change the control_files parameter used in the spfile

›
Mind your syntax when you are changing certain multi-value parameters directly in the spfile. Oracle will tell you that the syntax is accep...
Wednesday, October 21, 2020

How to transfer SQL Profiles from one database to another

›
Following up from part 1 on my post on How to transfer SQL Plan Baselines from one database to another , I will now show you the steps to ...

How to transfer SQL Plan baselines from one database to another

›
A customer called with a request to transfer a specific SQL plan from production to test. The query was found in the shared pool: SELECT T...
‹
›
Home
View web version

About Me

My photo
Name: Vegard Kåsa
My career as an Oracle DBA startet in 2001, when I acceptet a request to take on the responsibility as my current employer's DBA. From that point and onwards, managing Oracle databases has kept me busy and engaged. I enjoy my work, and particulary appreciate the constant learning and devlopment that comes with the job. From 2014, I am self-employed through my company Oric Consulting AS (Norway), and from 2024 Oric Consulting AB (Sweden) I currently live in Göteborg, Sweden, with my family.
View my complete profile
Powered by Blogger.