Hidden parameters in Oracle always start with an underscore. It is not possible for the DBA to see the hidden parameters with the SQL*Plus command « show parameter » or by querying v$parameter. Unless the hidden parameter is explicitly set in spfile/init.ora file. How Can I list all Hidden Parameters set in The database? As they are […]
Ultimate Database Health Check (DBMS_HM)
The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regular basis daily/monthly: – DB Structure Integrity Check – CF Block Integrity Check – Data Block Integrity Check – Redo Integrity Check – Transaction Integrity Check – Undo Segment Integrity […]
How to Kill a datapump job and cleanup orphaned jobs in Oracle
Take Control: True Private Internet Browsing with Brave Download the Brave Browser ⇒ A safer and faster alternative than Chrome. It’s also free and you support my website In this article you will learn how to: Kill a datapump job from dba_datapump_jobs using expdp or with an internal package Cleanup orphaned datapump jobs in Oracle […]
Lock, expire and delete Linux account
Sometimes the Oracle DBA has to I delete a Unix user account under Linux operating systems including the home directory. How do I expire, delete or remove a user’s access from my server? Deleting user account in Linux is an administrative task to remove user login credentials from system configuration files such as /etc/passwd, /etc/shadow […]
Unable to create audit trail file or Read-only file system
This morning, the Cloud Control and other applications are down. Hard for the customer :( but as an Oracle DBA I love problems in production so it’s a great day today! First, I tried to edit a file with vi but a swap error raised: « E297: Write error in swap file« Another read-only error with […]