Understanding V$SESSION_LONGOPS in Oracle Database

 In Oracle Database, V$SESSION_LONGOPS is a dynamic performance view available in every database release.

It provides visibility into the status of certain long-running operations—typically those that take more than 6 seconds to complete. Examples include:

  • Backup and recovery processes

  • Statistics gathering

  • SQL query executions

The set of operations tracked is determined entirely by Oracle—DBAs cannot influence which operations are monitored.

By querying V$SESSION_LONGOPS, you can get progress updates, elapsed time, and estimated completion time for operations Oracle chooses to track.

The following query displays operation details, progress percentage, and remaining time:

SELECT opname,

       username,

       sql_fulltext,

       TO_CHAR(start_time,'DD-MON-YYYY HH24:MI:SS') AS start_time,

       (sofar/totalwork)*100 AS "%_complete",

       time_remaining,

       s.con_id

FROM   v$session_longops s

       INNER JOIN v$sql sl USING (sql_id)

WHERE  time_remaining > 0;




Oracle Linux: Introduction to CPU Hotplug (Quick Summary)

CPU Hotplug in Oracle Linux allows you to dynamically enable or disable CPU cores in a running system—without requiring a reboot. This is especially useful in virtualized and cloud environments where workloads fluctuate.

🔍 Key Points:

  • Hotplug Support is included in the Unbreakable Enterprise Kernel (UEK) and enabled by default.

  • 🛠️ You can manage CPU state using simple sysfs commands:

    echo 0 > /sys/devices/system/cpu/cpuX/online  # offline
    echo 1 > /sys/devices/system/cpu/cpuX/online  # online
    
  • 🔒 Security-conscious systems can restrict CPU hotplug operations using procfs and system security modules like SELinux or AppArmor.

  • 💡 Useful for performance tuning, resource scaling, and testing failover behavior without downtime.


Bottom Line:
CPU Hotplug gives administrators more control and flexibility over CPU resource allocation—supporting smarter, dynamic infrastructure management in Oracle Linux.

👉 Full Blog Here


Running out of tablespace? Let automation handle it!


In mission-critical Oracle environments, tablespace full alerts can cause major disruptions if not addressed in time. Manually managing these situations isn’t scalable.

💡 This Oracle blog post walks through how to automatically respond to tablespace full alerts using Corrective Actions in Oracle Enterprise Manager.

🔧 Highlights:

  • Real-world use case: Handling tablespace full scenarios automatically

  • Setup guide for defining and enabling corrective actions

  • Custom script that auto-extends tablespaces

  • Helps avoid downtime and manual interventions

📊 Ideal for DBAs looking to operationalize resilience in Oracle environments.


Planning Your Oracle Certification Path for Race to Certification 2025?

Here’s a curated list of Oracle Cloud and Data certifications to help you complete Levels 1, 2, and 3 – and potentially earn up to 7 free exam attempts! 🎓🧠


Below certifications has 15 Free Attempts:


  • Oracle Cloud Infrastructure 2025 AI Foundations Associate (1Z0-1122-25)

  • Oracle Cloud Infrastructure 2025 Foundations Associate (1Z0-1085-25)

  • Oracle Data Platform 2025 Foundations Associate (1Z0-1195-25)

🟢 Each of the above has 15 free attempts—great way to build confidence and progress quickly!


💼 Intermediate to Advanced Certifications:

Certification Code
OCI Generative AI Professional 1Z0-1127-25
Oracle AI Vector Search Professional 1Z0-184-25
OCI Data Science Professional 1Z0-1110-25
OCI Architect Associate 1Z0-1072-25
OCI Migration Architect Professional 1Z0-1123-25
OCI Networking Professional 1Z0-1124-25
OCI Developer Professional 1Z0-1084-25
OCI DevOps Professional 1Z0-1109-25
OCI App Integration Professional 1Z0-1042-25
OCI Observability Professional 1Z0-1111-25
Oracle Redwood App Developer Associate 1Z0-1114-25
OCI Multicloud Architect Professional 1Z0-1151-25
Autonomous DB Cloud Professional 1Z0-931-25
Cloud DB Services Professional 1Z0-1093-25
APEX Cloud Developer Professional 1Z0-771
Oracle Analytics Cloud Professional 1Z0-1041-25
MySQL HeatWave Implementation Associate – Rel 1 1Z0-915-1


EBS 12.2.14: Key Enhancements by Product Family

 Financial Management

  • ECC: GL, AR, iReceivables, iReceipts, Assets, Cash Management, Lease Contracts, Leases & Finance

  • Equipment Leasing for IFRS 16/ASC 842/SFFAS 54

  • GL & AP Approval Flexibility & Automation

  • AR: New Cash Receipt Application Methods

  • Enhanced Credit Scoring & Collections

  • Lease & Finance: Increased Throughput Across Processes


Procurement

  • Modern Shopping Minimizing Non-Catalog Spend

  • ECC: Procurement, Project Procurement, CLM

  • Procurement & Contract Efficiencies

  • Supplier Portal: Advanced Configurability

  • Supplier Management & Assessments

  • Services Procurement: Invoicing & Complex Payments

  • Project Procurement

  • Sourcing Streamlined Flows

  • Proc/Proj: G-Invoicing for US Federal Program Agencies


Projects

  • ECC Projects

  • Labor Costing with Actual Costs

  • Budgetary Control for Labor & Non-Labor Transactions

  • Enhanced Cost Accounting Adjustment Options

  • Enhanced Billing including Federal Billing & Bill Groups

  • Enhanced Revenue Recognition for IFRS 15 / ASC 606

  • Scheduled % of Work Completed Based Structure

  • Enhanced Project Planning & Controls

  • Proc/Proj: G-Invoicing for US Federal Program Agencies


Applications Technology

  • ECC Dashboards

  • EBS on Oracle Cloud Infrastructure (OCI): EBS Cloud Manager

  • Enterprise Command Center Framework

  • Enhanced UX with OAF & WebADI

  • Enhanced Oracle APEX Integration for EBS Customizations

  • Oracle Guided Learning (OGL) Integration with EBS

  • Customer Driven Enhancements


Order Management

  • ECC: Order Management, Advanced Pricing, iStore, CHRM, OIC

  • New HTML UIs

  • Enhanced Subscription & Service Ordering

  • Advanced Scheduling, Milestone, Usage Based

  • Enhanced Returns (ISO) Processing

  • Improved Cancellations, Performance, & Archival

  • Enhanced Quoting Creation, Validation & Approval

  • Enhanced Flexible Volume Pricing, Enhanced Financial Control


Logistics

  • ECC: Inventory Mgmt, Landed Cost Mgmt

  • UX: New HTML UIs

  • ECC for Android and iOS enhancements

  • Material Flow Mapping & Physical Inventory

  • Enhanced Material Tracking

  • Bin Optimization, Backorders, & Inter-Org Transfer (IOT)

  • On Time In Full (OTIF)

  • ECC: Receiving Efficiencies, Pick by More Docs, Yard Mgmt

  • WMS/MSCA: Activity Tracking incl User-Defined Activities


Manufacturing

  • ECC: Discrete Mfg, Process Mfg, Project Mfg, Outsourced Mfg

  • ECC: Cost Mgt, OPM Analytics, Quality, BOM

  • Discrete Mfg: Rework Work Orders, Dual UOM for Mfg, MES, Internet of Things, E-Kanban, Serialization

  • Project Mfg: Procurement Availability Mgmt, Outsourced Mfg, MES, Item Genealogy

  • Process Mfg: Equipment Availability & Utilization, Asset Integration, Serialization, Batch Genealogy, Lab Mgmt

  • Quality: Enhanced Quality Collection & ECC Control


Asset Lifecycle Management

  • ECC: EAM, Asset Tracking

  • Mobile Maintenance App

  • EAM: Linear Asset Management

  • EAM Map Visualization for Assets & Work; Indoor Maps

  • EAM: Central Maintenance Technician Assignment

  • EAM: Functional Asset Hierarchy

  • EAM: Enhanced Work Task Functionality & Productivity

  • Installed Base & Asset Tracking Enhanced Flows


Service

  • ECC: Service Contracts, Service, Field Service, Depot

  • New HTML UIs

  • Service Contracts: Enhanced Usage Billing w/Group Plans

  • ECC: Improved MOAC & Inventory Org Security

  • Enhanced SR Definition: Multiple Products on 1 SR, more

  • Field Service Integration w/Projects; Enhanced DTL Integration

  • Depot: Warranty, Waste Mgt, Outsourced Repair, Prescriptive Recommendations


Human Capital Management

  • ECC: Human Resources, Payroll

  • Mobile Apps: SSHR, OTL

  • Time & Labor: Enhanced Entry & Processing

  • Payroll: Enhanced Administration & Processing

  • SSHR: Mass Update by Mgmt, Surrogate Approvers

  • HTML Dashboards for Payroll & SSHR Admin

  • Person Data Removal Tool (PDRT)


Connect OCI DB system using Console Connection

 


 

Step 1:

In your local machine, open terminal (Windows Powershell) and generate key pair

PS C:\Users\admin> ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (C:\Users\admin/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in C:\Users\admin/.ssh/id_rsa

Your public key has been saved in C:\Users\admin/.ssh/id_rsa.pub

The key fingerprint is:

SHA256:5Ioqw+KE2SJqgucRgjxXNhCpzZOBMgH4zSl/vYpD1Ec arunkumar k@doyenltp1980

The key's randomart image is:

+---[RSA 3072]----+

|=..oo            |

|+. o.   E        |

|.o+oo* ..        |

|o.o=B oo.        |

|oo.=.  oS        |

|.+o.o....        |

|B.o....  .       |

|X+.o..  .        |

|**o ....         |

+----[SHA256]-----+

PS C:\Users\admin>

 

Step 2:

Copy the contents of public key

PS C:\Users\admin> cat C:\Users\admin/.ssh/id_rsa.pub

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQDKYsAVXzjj1dmLevNjKdJkK7so6efkrlLq7Iy9jVOLcvsEOR4lFprAyXq+sQIl+xSzdlcEl7mFrbf+dzb2gzewWiGn6cj5zPRgQ6CVElhHizFFEfv9Nn2X4p3heeligRwnj4Alw80iqEaC3vf4a9b8npkQ05t0cRHJzX/Go/+NhLkwBA7XvfnrUY9iry05wLl1dzj+BseD3JuK/Zj8dx9mhCCurTh1bc72k1DMDSzlfpHifuFBLXylNPmEe/o3orHppakhbki7dYZTNuqS9jdXvZyWnA1oNYslCS773yULfFi82Dbdhpbp71B10jgKVt1t/AdoMLc7iT4UEDFUTcmIbNDp1raqtGb1LPgOl1G9WQhYzSLV3ciDtcMAYRTKmjljDkm/W9FMCZ2qZO3CCDkB4JchhLyhSzN51c+4a7nWG+xhXpI68wRJ5Q0xkpVmc84S6RUiybgLpyxblWgH5qAoHQm5OFiP89IqmcJt/U//VbavslvDlAzHUWM5tXhYb8E= username@desktop

PS C:\Users\admin>

Step 3:

 

Database service -> select the Database system -> consoleconnections-> click “Create console connection”

 

 

 

Step 4:

 

Add the public key you copied from step 2:

 

Step 5:

Once it is available after the below creating stage

 

A screenshot of a computer

AI-generated content may be incorrect.

Copy the ssh string and paste in notepad.

 

A screenshot of a computer

AI-generated content may be incorrect.

Step 6:

 

Switch to you local desktop and cd to .ssh directory.

A computer screen with white text

AI-generated content may be incorrect.

 

Step 7:

Paste the SSH string and press enter and you will see the prompt asking for login.

 

ssh -o "HostKeyAlgorithms=+ssh-rsa" -o "PubkeyAcceptedAlgorithms=+ssh-rsa" -o ProxyCommand='ssh -W %h:%p -p 443 ocid1.instanceconsoleconnection.oc1.phx.anyhqljtwdx4egacfcdgmnzwb4itm3i3utnvuuwopeczdoyu6akmxgqev7aa@instance-console.us-phoenix-1.oci.oraclecloud.com' ocid1.instance.oc1.phx.anyhqljtwdx4egacejrj33wgjwhpcmn3xzafpv2htje66pa3ngtu5niy2wiq

 

A black screen with white text

AI-generated content may be incorrect.

 

Step 8:

Go back to OCI console and reboot the node and come back to you local machine and press enter. You will see the below message. As soon as you see this message, press up or down key to pause the reboot.

A screenshot of a computer error

AI-generated content may be incorrect.

 

Step 9:

As soon as you see reboot message, press up or down key to pause the reboot. You will end up with below screen.

 

A screenshot of a computer

AI-generated content may be incorrect.

 

Step 10:

You may proceed with your troubleshooting.