Troubleshooting Long Running Queries Oracle – 1

1.. SQL query to check active and inactive session in Databaseset linesize 200 pages 999column machine format a30column spid format a10column username format a30column program format a30column os_user format a20column LOGON_TIME format a20select b.inst_id,b.sid,b.serial#,a.spid, substr(b.machine,1,30) machine,to_char (b.logon_time, 'dd-mon-yyyy hh24:mi:ss') logon_time,substr(b.username,1,30) username,substr(b.osuser,1,20) os_user,substr(b.program,1,30) program,status,b.last_call_et AS last_call_et_secs,b.sql_idfrom gv$session b,gv$process awhere b.paddr = a.addrand a.inst_id = b.inst_idand type='USER'order …

Create Storage Account – Azure

An Azure storage account contains all types of Azure Storage data for e.g. objects blobs, files, queues, and tables where the storage account provides a unique namespace for your Azure Storage data which is accessible from anywhere in the world over HTTP or HTTPS and data in the storage account is durable and highly available, …

Resizing Disks storage for Virtual machines – Azure

1.. Login into Azure portal and verify attached disks size and storage type Note: - Storage type: - Premium SSD LRS Size (GiB): - 5 GB Also, login into Virtual Machine and verify the size of attached Disks Note: - Disks nvme0n2 is of 5 GB to the virtual machine - V1-Virtual-Machine 2.. Click on …

Creation of Virtual Machine and attach a DISKs – Azure

1.. Login to azure portal, click on Tab All services -> Virtual Machine Click on + Create -> Azure virtual machine 2..  Provide the required details for Virtual machine to be created V1-VirtualMachine Note: - Availability options Availability zones: - An Availability Zone is a physically separate zone or data center, within an Azure region. …

Create a virtual network with subnets using the portal and Custom template – Azure

1.. Navigate to All services -> provide details to create Virtual Network F1-Vnet 2.. Security – Leave as default 3.. IP address -> Provide the IP address detail 4.. Tags – Leave as default 5.. Review and Create 6.. Create additional subnets Navigate to created Virtual Network, below setting click on subnet. Note: - Before …

Resources Protection by Locking – Azure

In Azure, resources can be locked for e.g. Azure subscription, resource group, or resource to protect them from accidental deletions and modifications. The lock overrides any user permissions granted. There are two types of Locks called Delete and Read-only, similarly in the command line, these locks are called CanNotDelete and ReadOnly. CanNotDelete means authorized users …

Manage governance via Azure Policy Tagging – Azure

Azure Policy Azure Policy enforces organizational standards and to assess compliance at-scale. Through its compliance dashboard, it provides an aggregated view to evaluate the overall state of the environment, with the ability to drill down to the per-resource, per-policy granularity. It also helps to bring your resources to compliance through bulk remediation for existing resources …

Create custom Azure role and role assignment – Azure

1.. Login to azure portal, navigate to resource group - first-resource-group and click on the tab Access Control (IAM) 2.. Click on tab, + Add and Add custom role and provide name as required Note: - Custom role can be created either by cloning an existing role or create from scratch or using JSON 3.. …

Create User, Group and Azure RBAC and Role assignment – Azure

1.. Login to azure portal, search and click on Microsoft Entra ID 2.. Below Tab Manage - > click on Tab user and click on create Note: - In assignment: - Make up to 20 group or role assignments. You can only add a user to a maximum of 1 administrative unit. Once Basics information …

Create Management Group, Subscription, Resource Group and Resources – Azure

1..  Login to azure portal, click on Tab All Resources 2.. Click on Tab Management and governance and then search and click on Tab Management group. Now click on Tab create and give the name for management group. i.e. first-management-group 3.. Once Management group is created, click on the management group and click on the …