Rediscovering Our Top Viewed Blog Posts ??
Learn DBA : A Life Long Learning Experience
by
1w ago
Hello Readers, As we continue our journey of sharing insights and knowledge through our blog, I wanted to take a moment to highlight some of our most popular and highly viewed posts. It's always exciting to see which topics resonate the most with our audience and spark meaningful conversations. Here are the top posts that have garnered significant attention:   These posts have not only garnered high views but have also sparked engaging discussions among our readers on various forums. If you haven't had a chance to explore these topics yet, now is the perfect time to dive in and red ..read more
Visit website
Understanding RMAN-08137 Warning and log_archive_dest_state_2 Reset: Investigating an Unusual Scenario
Learn DBA : A Life Long Learning Experience
by
1w ago
     SCOPE The article covers possible solutions to resolve warnings that appear in RMAN backups due to incorrect database configurations. Continuing from my previous post on RMAN backup failure warnings, I am now addressing another situation. Initially, the error seems concerning; however, there are scenarios where it appears to be a minor incorrect configuration, even though Data-Guard is working fine. Following was the excerpt from logfile :  channel ch2: backup set complete, elapsed time: 00:00:07 Finished Control File and SPFILE Autobackup at May 09 2024 07:40:0 ..read more
Visit website
How to Respect Yourself 24 x 7 ?
Learn DBA : A Life Long Learning Experience
by
2w ago
1. Stop looking for those who are not looking for you.  2. Stop begging. 3. Stop saying more than necessary. 4. When people disrespect you, confront them immediately. 5. Don't eat others' food more than they eat yours. 6. Reduce your visits to certain people, especially if they don't reciprocate. 7. Invest in yourself. Make yourself happy. 8. Stop entertaining gossip about others. 9. Think before you speak. Eighty percent of how people value you is based on what comes out of your mouth. 10. Always look your best. Dress the way you want to be addressed. 11. Be an achiever. Get ..read more
Visit website
Debunking 10 Myths about Database Administrators! ?
Learn DBA : A Life Long Learning Experience
by
6M ago
Database administrators (DBAs) play a critical and often underappreciated role in the world of information technology.  We might say they are the "groovy guardians of data harmony" in the digital universe. Here are some whimsical thoughts and myths about DBAs  Myth #1: DBAs just manage databases. Reality: One common myth is that DBAs only manage databases. In reality, their role is much more diverse and involves tasks like performance tuning, capacity planning, data security, backup and recovery, and more. ? Myth #2: DBAs only need technical skills. Reality: While technical experti ..read more
Visit website
A Case Study: Oracle Database vs. PostgreSQL
Learn DBA : A Life Long Learning Experience
by
6M ago
 Considering the best database management system for your organization? Let's explore the key differences between Oracle Database and PostgreSQL, two powerful contenders in the database landscape.   Oracle Database   Developed by Oracle Corporation, Oracle Database is an enterprise-grade, high-performance relational database management system. It offers advanced security, high availability, and support for complex data types. However, licensing costs and hardware requirements can be substantial, making it more suitable for large enterprises.   PostgreSQL   ..read more
Visit website
Facts: Native vs pglogical Logical Replication in PostgreSQL
Learn DBA : A Life Long Learning Experience
by
8M ago
Here are some of the facts about Native vs pglogical Logical Replication in PostgreSQL  1. For Physical Replication (streaming WAL replication) pg_replication_slots.slot_type is 'physical' . For Logical Replication pg_replication_slots.slot_type is 'logical', but the pg_replication_slots.plugin will have different values based on the type of logical replication used. 2. pg_replication_slots.plugin is 'pgoutput' for the Native (Pub/Sub model available from v10+) Logical replication. It is 'pglogical_output' when using the pglogical extension. 3. Database Migration Services for various CSP ..read more
Visit website
Agile is NOT FAST….
Learn DBA : A Life Long Learning Experience
by
8M ago
Agile is a widely adopted and highly effective approach to software development and project management in the IT environment. It has gained popularity for several reasons, and its principles and practices have proven to be beneficial for many organizations.  Agile may not deliver the expected speed if several factors are hindering its effectiveness including:  1. Dysfunctional teams 2. Lack of structure 3. Unclear rules of engagement 4. High turnover in teams 5. Ongoing disagreements over the definition of agile 6. Absence of a clear system to track and monitor work 7. Inefficient ..read more
Visit website
Trace performance issues in PostgreSQL using the pg_stat_statements
Learn DBA : A Life Long Learning Experience
by
9M ago
 Trace performance issues in PostgreSQL using the pg_stat_statements ? The pg_stat_statements view is a PostgreSQL extension that provides information about the execution statistics of all SQL statements that have been executed by the PostgreSQL server. ? You can use the pg_stat_statements view to trace performance issues by identifying the queries that are taking a long time to execute and then analyzing the execution plan for those queries. Here are some of the different ways to use the pg_stat_statements view to trace performance issues: ? Identify the slow queries. You can use t ..read more
Visit website
 It appears that the logical space for databa...
Learn DBA : A Life Long Learning Experience
by
1y ago
 It appears that the logical space for database was oversized Based on details recorded in alert log, the FRA threshold was set to 1024G Whereas the physical size of disk itself was 800G This could be a reason where an alert was not generated.  Ideally when the alerting threshold for FRA is reached  to 70-80% we do get alerts.  Since the size was exceeded to diskspace, the process has allowed to allocated overall space and this has resulted in diskspace exhaustion.  As checked, there are no records of FRA reaching to 90 or 100℅ From other aspect, the archive gener ..read more
Visit website
Networking fundamentals
Learn DBA : A Life Long Learning Experience
by
1y ago
  A user manually configures a static IP address of 192.168.92.30 with a subnet mask 255.255.255.0 but is neither able to connect to the internet nor any other resources. The correct IP address of the default gateway is 192.168.90.10 and the Domain Name System (DNS) address is 192.168.91.20. What change will likely fix this issue? Change the client's subnet mask to 255.255.0.0. Which device will examine incoming and outgoing network traffic for potential network attacks and actively remove the packets from the stream when detected? Change the client's subnet mask to 255.255.0.0. Wh ..read more
Visit website

Follow Learn DBA : A Life Long Learning Experience on FeedSpot

Continue with Google
Continue with Apple
OR