SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement. Conceptually, a SQL profile is to a SQL statement what object-level statistics are to a table or index. SQL profiles are created when a DBA … Read more
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
MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including Linux, Windows, Mac & Solaris. MySQL supports the following backup types: Logical backup Logical backup outputs a database structure in a .sql file by generating the CREATE or INSERT statements. Later, this file can be … 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 !! 🙂
What is Apache Cassandra? ▪ NoSQL database ▪ Schema-free ▪ Very fast ‘write’ ▪ Cassandra is designed to handle big data workloads across multiple nodes with no single point of failure ▪ Cassandra addresses the problem of failures by employing a peer-to-peer distributed system across homogeneous nodes where data is distributed among all nodes in … Read more
Cassandra.csv file data: Create keyspace and create tables and then importing the data form local system to Cassandra: $./bin/nodetool status $./cqlsh 192.168.0.104 Below are copied csv data from local system: Now we will export data from Cassandra to local file system: