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, September 12, 2014

How to solve ORA-27125: unable to create shared memory segment on AIX

›
When starting an Oracle instance on a new AIX server, the following error may occur: ORA-27125: unable to create shared memory segment IBM...
Thursday, September 11, 2014

What constitute "default auditing" under traditional auditing?

›
From the Oracle Documentation : "When you use Database Configuration Assistant (DBCA) to create a new database, Oracle Database confi...
Tuesday, September 2, 2014

How to convert stored outlines to use SQL Plan Baselines

›
If you have been using stored outlines for plan stability in versions prior to Oracle 11g, you should migrate them to use SQL Plan Baseline...
Friday, August 29, 2014

Login storm against database caused exhausted library cache

›
One of our databases experienced massive contention in the shared pool, in form of wait events alerted as "library cache locks". ...
1 comment:
Thursday, August 28, 2014

How to use the case statement in a shell script, with case-insensitive input

›
Use the pipe (|) character for each possible case: echo "TABLESPACE REPORT FOR $ORACLE_SID" stty echo echo "All tablesp...
Tuesday, August 26, 2014

How to find the SID, serial# and their operating system process ID from the database

›
A simple statement to find the SID, serial# and their operating system process ID from the database: SET LINES 300 PAGES 300 SET TRIMSPOOL...

What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS?

›
When the value of DBA_USERS.PASSWORD_VERSIONS is shown as "10G 11G", it means that both old and new-style hash values are availabl...
‹
›
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.