Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another sessions wants to update the same data. This will block the second session until the first session has completed its work. Grant 777 permission to session_lock_asrblg1.sh script for its execution. Find Locked Table Find Lock … Read more
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It might give suggestion to create few indexes or accepting a SQL profile. As we all know running a slow query is a major performance issue in the database also has the biggest challenge for DBA to resolve … Read more
A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. To resolve this issue, we have to drop materialized view summary first:
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted the listener DIAG_ADR_ENABLE_LISTENER=OFF There are 3 parameters associated with ADR: DIAG_ADR_ENABLED DIAG_SIGHANDLER_ENABLED DIAG_DDE_ENABLED As long as you don’t set “DIAG_ADR_ENABLED = OFF” … ADR will still be enabled for the other services. THIS LOG.XML NEED … Read more
Check the datafile location along with name: Set standby file management parameter to manual before moving datafile: Stop the MRP : Move the datafile now : Bounce the DB to overcome this issue: Open the DB in read only: Start MRP: Now validate ,all datafiles are in same location:
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting error, we will defer it and enable it back, which will resolve the issue. Error is now resolved. Hope it worked !! 🙂
A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or short, distro) can bundle server software, system management tools, documentation and many desktop applications in a central secure software repository. A distro aims to provide a common look and feel, secure and easy software management … Read more
As a DBA, you are responsible for the performance of your Oracle database. Typically, performance problems result from unacceptable response time, which is the time to complete a specified workload, or throughput, which is the amount of work that can be completed in a specified time. Typical problems include: • CPU bottlenecks • Undersized memory … Read more
Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit is that changes are stored in memory which has a fast access time. GoldenGate: When processing a one-time activity : an initial load or a batch run, GoldenGate stages extracted changes in an extract file. During normal operation , GoldenGate … Read more
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data is encrypted, this data is transparently decrypted for authorized users or applications when they access this data. TDE helps protect data stored on media (also called data at rest) in the event that the storage … Read more