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.

Thursday, March 15, 2018

›
The error SP2-0552: Bind variable "B2" not declared. can arise when using incorrect declarations in your SQL scripts. For exa...

How to load a plan from the cursor cache into the SMB

›
set serveroutput on VARIABLE cnt NUMBER -- Specifying both the SQL ID and the plan hash value: EXECUTE :cnt := DBMS_SPM.LOAD_PLANS_FROM_C...
Wednesday, March 14, 2018

How to recursively zip a folder and its subfolders and add password protetion+encryption

›
Below I am compressing all files and subfolders in the folder /home/oracle/outputfiles: cd /home/oracle/outputfiles zip -r --encrypt myzi...
Tuesday, February 27, 2018

How to install APEX in an existing database

›
I have based my receipe on Tim Hall's instructions found at www.oracle-base.com , and I do not want to take credit for this. But the in...
1 comment:
Monday, February 26, 2018

How to set up End-to-End tracing

›
Based on Performing Application Tracing in Oracle Database 12.1 SQL Tuning Guide Add the following to your application code: ALTER SES...
Thursday, February 22, 2018

DST_UPGRADE_STATE set to DATAPUMP(1) when running preupgrade_fixups.sql

›
During the preparation for a 12.2 upgrade, I found that the preupgrade-tool reported about an incomplete DST upgrade, where DST_UPGRADE_STAT...
7 comments:

Roles necessary to administer and view the Unified Audit Trail

›
Oracle 12c provides two new roles for auditing purposes: AUDIT_ADMIN for audit configuration/administration AUDIT_VIEWER for viewing an...
‹
›
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.