Linux & Oracle DBA Blog
You might need to get the sql_id of a Query in Oracle to troubleshoot some performance problem or just to check some stats.
This is the simplest way to do it.
Continue reading “How to Get the sql_id of a Query in Oracle”
To copy the password file from a primary database to a standby database it requires a few steps, especially if the password is located inside the ASM.
This article describes how to copy the password file for an Oracle RAC environment, but it can also be used for standalone databases.
Continue reading “Copy Password File From Primary ASM to Standby ASM on Oracle 19c”