How to Resolve a Hung AWR Process in Oracle
If you encounter a hung AWR (Automatic Workload Repository) process in Oracle, you may need to identify and terminate the associated session. Here’s a…
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 is an SSH Key and How to Add One in Oracle
An SSH key is a pair of cryptographic keys used for secure communication between a client and a server over the SSH (Secure Shell)…
Generate AWR, ASH, ADDM Reports from SQL Prompt
In Oracle databases, performance reports like AWR (Automatic Workload Repository), AWRDD (AWR Daily), ASH (Active Session History), and ADDM (Automatic Database Diagnostic Monitor) are…
Understanding the Find Command
Learn how to efficiently search and manage files with the find command. This post covers essential examples for finding, deleting, and compressing files based…
Oracle RMAN: Scripts to Monitor Backup Progress
These SQL scripts help monitor and check various aspects of RMAN (Recovery Manager) backups in Oracle databases. Below is a summary of what each…
How to Fix ORA-39095: Dump File Space Has Been Exhausted
To fix the ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes error, you can follow these steps: 1. Use Dynamic…
How to Export & Import Statistics in Oracle Database
There are several reasons you might need to export Oracle object statistics. For instance, you may want to back up the current statistics before…
How to Check Hidden Parameters in Oracle
In Oracle databases, many parameters are designed to be hidden from users to ensure that they don’t accidentally modify critical settings. These hidden parameters…
Step-by-Step Guide to Creating and Executing a SQL Tuning Task
SQL tuning is crucial for optimizing query performance in Oracle databases. This step-by-step guide explains how to create and execute a SQL tuning task,…
Oracle Tablespace Quota Management Script
In Oracle databases, it’s important to manage user quotas on tablespaces effectively to prevent users from consuming excessive disk space. The following scripts provide…
Monitor Long Operations in Oracle
Use the following script (@longops.sql) to monitor long-running operations in Oracle: This script provides real-time details on session progress, elapsed time, and remaining time…
Understanding SQL>@?/rdbms/admin/sqltrpt.sql: A Detailed Guide
Oracle Database administrators often need tools for performance diagnostics and tuning. One such tool is the sqltrpt.sql script, located in the ?/rdbms/admin directory. This…