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.

Monday, September 16, 2019

How to work around ORA-03206 when running the RCU (Repository Creation Utility) used by ODI

›
During installation you may encounter the error ORA-03206: maximum file size of (13107200) blocks in AUTOEXTEND clause is out of range I...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Thursday, August 22, 2019

How to change location for the redo log files in physical standby database

›
Short background: After a cold restore of the database files from standbyserver1 to standbyserver2, the redo logfiles where incorrectly re...
Wednesday, August 21, 2019

How to create a compressed index using advanced index compression

›
Applicable for Oracle 12.1 and onwards. Basic syntax: CREATE INDEX MYIDX1 ON MYTABLE(COL1, COL2) COMPRESS ADVANCED LOW; The above st...
Tuesday, August 20, 2019

How to add a semicolon (or any other character) at the end of a line using vi

›
Open your text file in vi, and type :%s/$/;/g this will add a semicolon at the end of each line in your file.
Friday, August 9, 2019

How to find the number of executions for a specific SQL ID during a day

›
This query will gather data from DBA_HIST_ACTIVE_SESS_HISTORY for a specific day, and count the number of executions within that day: sel...
Thursday, August 8, 2019

How to find audit information about SELECT statements

›
This article is based on setup in a database running classical auditing in version 18.6.0.0.0, but should be possible to use in older versi...
‹
›
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.