Optimizer Statistics in Oracle 19c
Posted inASM

Optimizer Statistics in Oracle 19c

Introduction Oracle optimizer cost model relies on statistics collected about the objects involved in a query. The query optimizer uses these statistics to choose the execution plan with the lowest cost, so up-to-date optimizer…
No Comments
Posted inKubernetes

Installation of Kubernetes -k3s

Master IP4=192.168.20.138 TOKEN="TOKEN" curl -sfL https://get.k3s.io | sh -s - server \ --node-ip="${IP4}" \ --node-name="k3s-master" \ --tls-san="${IP4}" \ --token="${TOKEN}" \ --cluster-cidr="10.44.0.0/16" \ --service-cidr="10.45.0.0/16" \ --embedded-registry \ --disable servicelb \ --disable…
No Comments
Posted inKubernetes

CNPG Disk Error

Fixing CNPG PostgreSQL CrashLoopBackOff: A Deep Dive into PVC Resize Failure & Disk Pressure on OpenEBS LVM LocalPV ┌─────────────────────────────────────────┐ │ CloudNativePG PostgreSQL Cluster │ │─────────────────────────────────────────│ │ customer-database-1 (Primary Pod) │…
No Comments
Posted inDataGuard Oracle RAC

Resizing redo logs and standby Redologs in Dataguard

IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby redo log size in Primary and standby :- Redo log…
No Comments