Learn DBA : A Life Long Learning Experience
696 FOLLOWERS
A place for Beginners and Experience to Learn Oracle DBA. A smarter way to learn Oracle DBA , with latest contents.
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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
Learn DBA : A Life Long Learning Experience
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