How to Generate IOPS and I/O Performance Reports in Oracle 19c
This document explains how to generate IOPS and I/O throughput reports in Oracle Database 19c for both Single Instance and RAC databases. These reports…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
What’s New in Oracle AI Database 26ai? A Simple Guide
Oracle just launched Oracle AI Database 26ai in October 2025, and it’s a game-changer. Think of it as your database getting superpowers for the…
How to Create & Manage Oracle Bigfile Tablespaces
Bigfile tablespaces are commonly used in modern Oracle environments where large storage volumes, ASM, and Oracle Managed Files (OMF) are standard. They simplify tablespace…
How to Set Up Oracle Wallet for Passwordless Login (19c/21c)
Oracle Wallet allows secure storage of database login credentials and enables passwordless authentication for scripts, applications, and command-line tools. Instead of exposing clear-text passwords,…
How to Fix ORA-12560: TNS Protocol Adapter Error in Oracle
If you’ve just installed Oracle Database and tried connecting using SQL*Plus, you might have seen this frustrating error: Don’t worry — this is one…
ORA-00030: User Session ID Does Not Exist
The Oracle error ORA-00030: user session ID does not exist occurs when you try to perform an action on a session that no longer…
ORA-14451: Unsupported Feature with Temporary Table
The Oracle error ORA-14451: unsupported feature with temporary table occurs when you try to use an operation that is not supported on a temporary…
Should You Use “@” in Oracle Passwords? Risks, Errors & Fixes
When setting strong passwords in Oracle, it’s tempting to use special characters like @. But in Oracle’s world, @ isn’t just another symbol—it has…
Oracle Kill Session – ALTER SYSTEM KILL Session
Database administrators often face sessions that hang, lock resources, or consume unnecessary memory. Oracle provides multiple ways to terminate or disconnect sessions, depending on…
How to Fix ORA-19687: SPFILE Not Found in Backup Set
If you’re working with Oracle RMAN and trying to restore the SPFILE, running into the ORA-19687 error can be frustrating. This error message indicates…
How to Disable AutoTask in Oracle
Sometimes you may want to stop Oracle’s AutoTask jobs temporarily — for example, to troubleshoot performance issues or avoid conflicts with important batch jobs.…
How to Fix ORA-00054: Resource Busy and Acquire with NOWAIT Specified or Timeout Expired
While working with Oracle databases, you might encounter: If you’re wondering: This post will clarify these questions simply so you can handle this confidently…