Oracle Database Administrator

🔍 Purpose: To calculate the High Water Mark (HWM) in GB for each data file. The HWM is the highest block ever used by an object in the tablespace. 🧾 Query:                SELECT                        a.tablespace_name,                      a.file_name,                     ((b.maximum + c.blocks - 1) * d.db_block_size) / 1024 / 1024 / 1024 AS highwater_in_GB                FROM                     dba_data_files a,                    (SELECT file_id, MAX(block_id) AS maximum                    FROM dba_extents      GROUP...

This guide covers practical Kubernetes (K8s) administration tasks including managing namespaces , pods , deployments , PVCs , and PVs . Ideal for teams working with IFS Cloud deployments on Kubernetes . 📁 Namespace Management 🔥 Delete a Namespace                kubectl delete namespace hypdev --force 🧱 Pod Operations ❌ Delete or Recreate a Pod                kubectl delete pod <pod-name> --grace-period=0 --force -n <namespace> Example:                kubectl delete pod ifsapp-reporting-86b484b7cc-zws87 --grace-period=0 --force -n hypprd 🔍 Describe a Pod                kubectl describe pod <pod-name> -n <namespace> Examples:                kubectl describe pod ifsapp-proxy-xxxxxxxx-8k4ph -n hypprd          ...

In Oracle databases, proper management of data files is essential to ensure performance, availability, and scalability. This guide explains how to view , resize , and add data files using SQL*Plus, SQL Developer, TOAD, and command-line tools. 🔍 When to Resize Data Files? Resize a data file when available free space is less than 500MB . Use caution: only resize files that are not already at their maximum size (typically 32GB for most configurations). Always connect using a privileged user like SYS or SYSTEM . 🔧 Monitor via Alert Log You should always monitor changes in the alert log :           # Connect as Oracle OS user                su - oracle           # Monitor the alert log in real-time                tail -900f /u01/.../trace/alert_<SID>.log 📘 Using SQL*Plus or SQL Developer View Existing Data Files    ...