Database Administration

By Brian Fitzgerald

How wallet locality is determined

10 things you didn’t know about tablespace quotas

Create spfile in ASM

Custom terraform script in Azure Linux VM

Data Guard broker 19c configuration export

listener status UNKNOWN or BLOCKED

Data Guard broker 19c edit database set parameter feature is unstable

AutoUpgrade 12c->19c with Transient Logical Standby

move spfile to ASM in one step

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

Permanently deleting histograms

SQL*Net break/reset to client

Scripts for trace 10053

Scripts for trace 10046 and tkprof

Flashback database with deleted archive log, or no archive log.

reader-friendly ASH sql_exec_id

Does dbms_stats.gather_table_stats issue commit?

export/import data pump mixed case username

datapump undocumented command “desc”

ambiguous data pump command “s”. start/stop/status

nohup.bash wrapper with unique, timestamped log

psuvers.sql: get Oracle Database PSU version