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.

Showing posts with label pfile and spfile. Show all posts

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...

Thursday, June 12, 2014

How to set the db_file_name_convert and log_file_name_convert parameters

›

In this example, I want to redirect the files to a slightly different path during a clone from prod to test. In prod, files are to be foun...

Wednesday, November 27, 2013

How to compare the content of memory parameter and spfile parameters

›

### Compare static (pfile) and dynamic (spfile) parameter setting: set pages 100 set lines 400 col init_value format a36 col spfile_value f...

›

Home

View web version

About Me

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