My listener.log file is growing and now it is very big; I have difficulties to open it. What can I do when the listener.log is growing? Indeed, if you delete the LISTENER.LOG, the file will be recreated only after stopping and starting the listener … I want to archive it without boucing the listener (online […]
Author: Vincent
RAC architecture concepts
Oracle Real Application clusters (RAC) allows multiple instances to access a single Oracle database. These instances often run on multiple nodes. The Component Diagram with explanation shows all the components that inter-relate to each other and together make up THE “Oracle RAC architecture“. RAC is the principal component for the Oracle Grid Architecture. It’s […]
View Oracle hidden parameters
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
Download Brave : Secure, Fast & Private Browser with Adblocker 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 Perhaps you were looking for stop/drop job in DBMS_SCHEDULER. How to kill a datapump job in DBA_DATAPUMP_JOBS? You […]