Debunking 10 Myths about Database Administrators! ?
Learn DBA : A Life Long Learning Experience
by
4M 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
5M 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
6M 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
6M 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
7M 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
Devsec ops
Learn DBA : A Life Long Learning Experience
by
1y ago
  1. Not everybody in your software development team knows what a linter is, or sees the advantage of using linters. How would you convince your team members in the fastest possible way what the advantages for the team are? Locally install a linter, run it against the current code base, and show the results to the team. 2. A financial organization has created a centralized security team that ensures security for all of the 30 applications by mandating security controls and checklists. They also rely heavily on automated security scans that are conducted periodically by this security team ..read more
Visit website
PostgreSQL VACUUM and MVCC
Learn DBA : A Life Long Learning Experience
by
2y ago
   PostgreSQL uses MVCC (multi-version concurrency control) to provide transactional semantics. In the simplest form, MVCC lets each transaction work on a different copy of a row in a table. What it means is whenever a row is updated, a new version of the row is created. The existing readers continue to see the old version of the row whereas new transactions see the new version. This is rather a very simplified presentation of MVCC. In the real world, there can be many versions of the row and a transaction can see one of those versions. The visibility depends on the transaction start ..read more
Visit website
Consistency check before performing RMAN resetlogs.
Learn DBA : A Life Long Learning Experience
by
2y ago
The article covers consistency check before performing OPEN RESETLOGS after restoring a database using backup  Performing the fuzziness check SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS' ;SQL> select fuzzy, status, error, checkpoint_change#, checkpoint_time, count(*) from v$datafile_header group by fuzzy, status, error, recover, checkpoint_change#, checkpoint_time ; FUZ STATUS ERROR CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*)--- ------- --------------- ------------------ -------------------- --------YES ONLINE ..read more
Visit website

Follow Learn DBA : A Life Long Learning Experience on FeedSpot

Continue with Google
Continue with Apple
OR