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.

Friday, January 29, 2021

How to manually register missing logsequences on a standby database

›
I have previously documented how to identify gaps in your standby database's log sequence. See these posts: How to check if your phy...
Friday, January 15, 2021

What privileges are needed for flashback queries?

›
If the table is in your own schema, no extra privileges are needed. If the table is in a schema different from your own, you need object ...
Friday, January 8, 2021

How to disable a scheduler job in a another schema

›
Use the syntax connect system set serveroutput on EXECUTE DBMS_SCHEDULER.DISABLE(name=>'SCOTT.UPDATE_COMMISIONS'); You canno...

Comparison between default traditional auditing and default unified auditing

›
Applicable to Oracle Database versions 12.1 and onwards. By default, the databases are created with "Mixed-Mode" auditing enable...
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_...
‹
›
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.