Monitoring Oracle Archive Logs: A Quick Guide As an Oracle DBA, keeping a close eye on your archived redo logs is crucial for maintaining database health and ensuring smooth recovery operations. Today, I’ll share a simple yet powerful script that helps you monitor your archive logs effectively. The Power of v$archived_log The v$archived_log view is…
Automating Oracle Invalid Object Recompilation: A Practical Script As Oracle DBAs, we frequently encounter situations where database objects become invalid after patches, upgrades, or schema changes. Manually recompiling these objects can be time-consuming, especially in large databases. Today I’ll share a practical script that automates the generation of recompilation commands for all invalid objects in…
Managing Oracle Database Wallets: A Quick Guide Oracle Database provides robust security features to protect sensitive data, and one of the key components in this security framework is the Oracle Wallet. The wallet is a secure container used to store encryption keys, credentials, and certificates, ensuring that sensitive information is protected from unauthorized access. In…
Understanding Oracle Multitenant: Querying PDB Status Across Instances As an Oracle DBA working with Container Databases (CDBs), one of the most common tasks is checking the status of your Pluggable Databases (PDBs). Today I’ll share a useful script that provides a comprehensive view of all PDBs across all instances in your Oracle RAC environment. The…
Creating a Container Database (CDB) in Oracle Database Cloud Service Using dbaascli As a database administrator working with Oracle Database Cloud Service (DBCS), you have powerful command-line tools at your disposal. One of these is dbaascli, which allows you to perform various database operations directly from the server. Today, I’ll walk you through creating a…
This script will be useful for tracking progress of GBS copied to Target system. Need to execute it on Target system.
This will provide prompt with session details.
This script, prepfiles.sh, is a powerful utility for Oracle Database Administrators designed to automate the generation of a comprehensive SQL toolkit for managing and testing database statistics. By reading a list of tables from mtx_tablelist.lst, the script creates a sequenced set of SQL files that handle the entire lifecycle of Pending Statistics. This allows DBAs to gather and validate new…
Read More “prepfiles.sh for step by step generating pending statistics files” »
This PL/SQL block identifies recently active SQL queries from a specific application server and provides details on their performance and execution plans. Here is a breakdown of what the script does:
