Real-Time SQL Monitoring in Oracle Database: Key Facts

Real-Time SQL Monitoring is a powerful feature that provides detailed insights into SQL execution, helping DBAs identify performance bottlenecks and optimize queries efficiently. But before using it, there are some important licensing considerations.

🔑 Licensing Requirements

• Requires the Oracle Tuning Pack.

• The Oracle Diagnostics Pack is a prerequisite for the Tuning Pack.

• Both packs must be licensed, and they are only available with the Enterprise Edition of the Oracle Database.

📊 When Does SQL Monitoring Trigger?

SQL statements are automatically monitored when:

• A single execution consumes more than 5 seconds of CPU or I/O time.

• The SQL uses parallel execution (DML, DDL, or queries).

---

✅ In short: Real-Time SQL Monitoring is an Enterprise Edition-only feature requiring additional licenses, and it kicks in automatically for resource-intensive or parallel SQL operations.

OCI File Storage with Lustre: High-Performance, Managed File System for AI

Oracle Cloud Infrastructure (OCI) offers File Storage with Lustre—a fully managed, high-performance file system tailored for demanding workloads such as AI, machine learning, and high-performance computing (HPC).

Key Highlights:

• Fully Managed Infrastructure
  OCI handles deployment, maintenance, scaling, and management of Lustre components—including metadata servers, management servers, and storage servers—letting you focus on your applications, not infrastructure. 

• Parallel and Distributed Architecture
  Designed for massive data volumes, this system delivers high aggregate throughput by distributing I/O workload across server components. 

• Performance Tiers for Flexibility
  Choose from different bandwidth configurations:

  • 125 MB/s per TiB (1 Gbps)

  • 250 MB/s per TiB (2 Gbps)

  • 500 MB/s per TiB (4 Gbps)

  • 1000 MB/s per TiB (8 Gbps)
    Administrators can also tweak performance using Lustre's lfs tools, including features like file striping and Progressive File Layout (PFL). 

• Client Compatibility
  OCI supports Lustre version 2.15.5. Compatible client environments include:

  • Ubuntu 22.04 (kernel 5.15.x)

  • Oracle Linux 8 (RHCK 4.18)

• Global Availability
  This service is available across multiple OCI regions (at the time of writing this blog) —such as Sydney, Frankfurt, São Paulo, Montréal, Tokyo, Amsterdam, and more—ensuring localized access and compliance. 

---

Bottom Line:

OCI File Storage with Lustre provides a scalable, high-throughput file system custom-built for data-intensive workloads. With its fully managed infrastructure and multiple performance configurations, it’s an ideal fit for running AI training jobs which needs high performance computing needs.

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)