Untitled

A Static Pod is a pod that is directly managed by the kubelet (node agent) instead of the Kubernetes API server. It is managed locally by kubelet by creating YAML file directly on the Node by connecting node and create static pod with yaml file directly by using Kubectl apply command. 👉 Normal pods: Created using kubectl apply Managed by API server, scheduler, etc. 👉 Static pods: Created by…

AWR (Automatic Workload Repository) is one of the most important Oracle DBA tools for performance analysis. It captures database workload statistics and helps identify bottlenecks such as slow SQL, high CPU usage, I/O issues, waits, and memory problems. Types of AWR Reports 1. Single Instance AWR Report Used for standalone databases. @$ORACLE_HOME/rdbms/admin/awrrpt.sql 2. RAC AWR Report…

What is terminationGracePeriodSeconds in Kubernetes? In Kubernetes, terminationGracePeriodSeconds defines how much time (in seconds) a Pod gets to shut down gracefully before it is forcefully killed. When Kubernetes decides to stop a Pod (for example during scaling down, deployment update, or manual deletion), it does not immediately kill the container. Instead, it gives the application some…

What is Node Selector in Kubernetes? Kubernetes uses labels on nodes Pod uses nodeSelector to match those labels Pod will only run on nodes that match labels In Kubernetes, both nodes and pods use labels to control where workloads run. A node is first assigned a label such as disktype=ssd, which describes its characteristics. Then, when creating a pod, you specify a nodeSelector with the same…

For using the bash shell of POD kubectl exec -it <podname> -- /bin/bashExample kubectl exec -it POD1 -- /bin/bash -- In case of POD has multi container pod then we specify the container namekubectl exec -it <podname> --container <containername> -- /bin/bash example: kubectl exec -it POD1 --container CONTAINER1 -- /bin/bash Check Logs of POD kubectl logs <podname>Example: kubectl logs POD1 To…

Enhance SQL Queries Using Oracle Access Advisor SQL Access Advisor is a performance tuning tool provided by Oracle that analyzes your SQL workload and recommends structures such as: Indexes Materialized Views Materialized View Logs Partitions These recommendations help improve SQL performance and reduce query execution time. SQL Access Advisor helps Oracle DBAs identify missing indexes,…

ReplicaSet = Controller that keeps N Pods always running. We define the number of Pods running then kubenet keep this no of POD in running state. We set 3 POD to run then ReplicaSet ensures: ✅ Always 3 pods are running ✅ If 1 pod dies → creates new pod ✅ If extra pods exist → deletes extra Example of a manifest file: It defines 3 pods to run. If a pod dies or has issues, a new pod is created…

Kubernetes Labels Explained: Grouping and Managing Resources What are Labels in Kubernetes? 👉 Labels are key = value pairs attached to Kubernetes objects (Pods, Nodes, Deployments, etc.). Used for: Grouping resources Filtering objects Connecting services to pods Scheduling workloads Example: app=frontendenv=prodtier=backend Example (YAML with labels) apiVersion: v1kind: Podmetadata:…

Manage the Namespace in Kubernetes What is Namespace? In Kubernetes, namespaces help separate groups of resources within a single cluster. They function like virtual clusters, improving organization, resource management, and access control. Namespaces are especially beneficial in environments with many users from different teams or projects. Get a list of all namespaces in Cluster…

Create a manifest file with command for deployment in Kubernet To deploy an Nginx application in Kubernetes, create a manifest file using the command “kubectl create deployment ngnix –image=ngnix –dry-run=client -o yaml > deploymentngnix.yaml.” Deploy the pod with “kubectl apply -f deploymentngnix.yaml,” verify using “kubectl get pods,” and delete resources with “kubectl delete -f…

What is Dry Run? kubectl --dry-run lets you test a command without actually creating/updating resources. Types of Dry Run 1. Client Side (--dry-run=client) Use kubectl dry-run for client side validation of a manifest. Runs locally (no cluster call) Just checks syntax Does NOT validate with Kubernetes server kubectl create deployment my-app --image=nginx --dry-run=client -o yamlORKubectl…

Essentials of Managing Kubernetes Contexts Get information about our current cluster context. Ensure we are login to correct cluster. Note: * mark on cluster which we are on in output of the command kubectl config get-contexts Change our context if needed by specify name kubectl config use-context <name> Get information about the API server for our current context kubectl cluster-info Get…

To display all configured Docker network subnets: docker network inspect $(docker network ls -q) | grep Subnet You can also list available Docker networks: docker network ls Inspect a specific network: docker network inspect <network_name> Example: docker network inspect bridge Choosing a Free Subnet Each interconnect network must use a unique subnet. Example: docker network create \…

Find the all docker network details The following command displays network names along with their subnet information: docker network inspect $(docker network ls -q) \| grep -E &apos;"Subnet"|Name&apos; This is useful for quickly identifying available address ranges before creating new Oracle RAC networks. Example: ubuntu01@ubuntu01-VirtualBox:/opt/.secrets$ docker network inspect $(docker…

Overview While configuring EFS restore alerts via AWS Backup → EventBridge → SNS, you may face a situation where: ✅ Broad rules work (source: aws.backup)❌ Filtered rules do NOT trigger❌ No alert received for restore Even when configuration looks correct. Problem Scenario Working rule: Create this rule first as it activates on every event. This will assist in identifying whether the issue is…

1. What is STRING_SPLIT? STRING_SPLIT is a built-in function in SQL Server used to: 👉 Break a single string into multiple rows👉 Based on a separator (like ,, |, -, space, etc.) It returns a table of values (rows) where each part of the string becomes a row. Simple: STRING_SPLIT is a table-valued function that converts a delimited string into multiple rows based on a single-character…

Oracle memory architecture is one of the most important concepts for DBAs.Every SQL query, transaction, and user connection uses Oracle memory internally. Oracle memory architecture mainly consists of: SGA – System Global Area PGA – Program Global Area Background ProcessesReal-time Example:Think of Oracle Database like a large company office.- SGA = Shared office area used by all employees.-…