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, July 27, 2023

How to list the contents of a folder in a tree-like fashion in Linux

›
Use the tree command: cd /sw/oracle/admin tree -L 2 . ├── cdb │   ├── adump │   ├── dpdump │   ├── log │   ├── pfile │   └── xdb_wallet ├...
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...
Monday, June 19, 2023

Using the autoupgrade tool to migrate a non-multitenant database to a PDB on the same host

›
The autoupgrade tool can convert a non-cdb database to a PDB running in a container database. If you need to switch to a multitenant archi...
Thursday, June 15, 2023

How to list the content of a folder and get total size summary of the parent folder at the end

›
To list the size of all folders and get a summery at the end, use the --max-depth=1 switch with the du command. In the listing below, I ...
Tuesday, June 6, 2023

How to use sqlcl with / as sysdba

›
Creds to the findings of Rodrigo Jorge : Make sure the environment variable LD_LIBRARY_PATH is set, and if so, includes $ORACLE_HOME/lib: ...
Wednesday, May 10, 2023

Can the recyclebin be turned off for a container database but remain on in a pluggable database?

›
Yes, the multitenant architecture allows this. SQL>select name, value , ISPDB_MODIFIABLE from V$parameter where name = 'recyclebin...
Monday, May 1, 2023

How to use RMAN DUPLICATE FROM ACTIVE DATABASE to clone an entire CDB and all PDBs to a remote host

›
In this post I will show how to clone an entire cdb with all PDBs using the DUPLICATE FROM ACTIVE DATABASE command, which has been around f...
‹
›
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.