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 Background Processes. Show all posts
Showing posts with label Background Processes. Show all posts
Monday, June 26, 2023

How to show current utilization of sessions, processes and other important settings for a database

›
Example: set lines 300 col RESOURCE_NAME format a30 select RESOURCE_NAME,CURRENT_UTILIZATION,MAX_UTILIZATION,INITIAL_ALLOCATION,LIMIT_VAL...
Wednesday, June 11, 2014

How to deal with ORA-00020: maximum number of processes (%s) exceeded

›
I recently had a situation where access to the database was completely blocked because of the infamous error message ORA-00020: maximum nu...
5 comments:
Wednesday, May 28, 2014

How to recreate the control file and rename the database and the datafiles

›
To change a database name or file names, it can be practical to recreate the control file, and in some cases your only option. In this exa...
Tuesday, March 4, 2014

What is the CJQ0 background process?

›
When starting the Oracle database you may see something like the following in the alert log: Tue Mar 04 12:40:50 2014 CJQ0 started with p...
Sunday, October 20, 2013

How to disable flashback archiver process, introduced to support Oracle 11gR1 feature "Flashback Data Archive"

›
If you do not use the flashback data archive feature, and have no plans to do so, you might as well disable the process, even though it is d...
›
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.