Step 1:
Login to OCI console and click top right on user, User Settings -> Tokens and keys
Upon creation, you have to copy the secret keys and store it somewhere as once you close it, it wont show again.
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.
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.
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.
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).
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.
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;
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.
✅ 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.