Links úteis para DBAs e DBREs
Tags: beginners, sql, dba, dbre
Published: 2022-02-06 23:22:01

Neste post vou colocar alguns links que uso como referência para estudos de alguns temas técnicos de banco de dados.

**

## Documentação (Concepts, admin guides, etc):
**

Oracle Database Online Documentation 11g Release 2 (11.2):

https://docs.oracle.com/cd/E11882_01/index.htm

Oracle Database Online Documentation 19c:

https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html

https://docs.oracle.com/en/database/oracle/oracle-database/19/books.html

https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/index.html

https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/index.html

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/index.html

Oracle Database Online Documentation 21c:

https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html

MongoDB Documentation:

https://docs.mongodb.com/manual/introduction/

Amazon DynamoDB: a r(el)ational Glossary

https://blog.dbi-services.com/aws-dynamodb-a-relational-glossary/



**

## Favoritos:
**

Analysis of a Couple AWR Reports - OTW2018:

https://www.youtube.com/watch?v=xSXQ3EwU8t0

Oracle Learning Library: Real World Performance Videos:

https://apexapps.oracle.com/pls/apex/f?p=44785:141:113846138080508::::P141_PAGE_ID,P141_SECTION_ID:119,870 ou http://www.oracle.com/goto/oll/rwp

Beginning Performance Tuning with Arup Nanda (In English):

https://www.youtube.com/watch?v=knPdTWil664

Oracle Live Labs:

https://apexapps.oracle.com/pls/apex/dbpm/r/livelabs/home

20 Essential Oracle SQL and PL/SQL Tuning Tips

https://www.youtube.com/watch?v=SxEQbz8tOwU

Reasons why SELECT * is bad for SQL performance:

https://tanelpoder.com/posts/reasons-why-select-star-is-bad-for-sql-performance/

Best Practices for Synchronous Redo Transport

https://www.oracle.com/technetwork/database/availability/sync-2437177.pdf

Best Practices for Asynchronous Redo Transport

https://www.oracle.com/technetwork/database/availability/async-2587521.pdf

Best Practices for Running Oracle Database on AWS

https://docs.aws.amazon.com/whitepapers/latest/oracle-database-aws-best-practices/oracle-database-aws-best-practices.html



**

## Cursos / Workshops / Webinares
**

Workshops gravados:

https://uolinc.sharepoint.com/:f:/r/sites/condado/Documentos%20Compartilhados/documentos%20Workshops%20Treinamentos%20e%20Afins/Videos%20-%20Webinar?csf=1&web=1&e=edDxYo

AWS Online Free Courses:

https://www.amazon.com/aws-courses/b?ie=UTF8&node=14297978011

https://explore.skillbuilder.aws/learn/course/external/view/elearning/9153/aws-certification-official-practice-question-sets-english

https://www.youtube.com/playlist?list=PLOF5f9_x-OYUaqJar6EKRAonJNSHDFZUm

Curso Free MongoDB:

https://university.mongodb.com/learning_paths/dba

https://jornadadodev.com.br/cursos/curso-de-mongodb

https://www.youtube.com/playlist?list=PL4Sl6eAbMK7RsS4Q8tSHTlOIaUmTG9eRS

Curso Free Cassandra/Datastax:

https://academy.datastax.com/

https://www.youtube.com/playlist?list=PLjHEb0NvFucip4VA3LGJiGTOJIXU97jRK

AWS solutions architect professional training for free:

https://www.youtube.com/playlist?list=PLeJgtCMvQjZd0kuK82-Et9IYcp6EiOeYa

Curso Git e Github:

https://www.promobit.com.br/oferta/curso-git-e-github-para-iniciantes-udemy-1018002/

https://www.youtube.com/playlist?list=PLHz_AreHm4dm7ZULPAmadvNhH6vk9oNZA

Curso API Rest:

https://www.youtube.com/playlist?list=PLf8x7B3nFTl17WeEVj405tHlstiq1kNBX

Microsoft Azure:

https://www.youtube.com/watch?v=q1bZOr0U8A8

Python:

https://www.youtube.com/playlist?list=PLvE-ZAFRgX8hnECDn1v9HNTI71veL3oW0

**

## MOS (DocId Favoritos):

**

Support for Oracle Database in Systems with IBM Guardium (Doc ID 2211837.1)

Installing Third Party Software On Exadata Components (Doc ID 1593827.1)

Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1)

Primary Note for Database Proactive Patch Program (Doc ID 888.1)

19c Database Self-Guided Upgrade with Best Practices (Doc ID 1919.2)

Assessing and Tuning Network Performance for Data Guard and RMAN (Doc ID 2064368.1)

Creating Archival Backups for Long Term Backup Retention on the Zero Data Loss Recovery Appliance (Doc ID 2107079.1)

Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1)

Implementing a Dual Backup Strategy with Backups to Tape and Recovery Appliance (Doc ID 2154471.1)

Exadata X9M/X8M (RoCE-based systems) Software Requirements and Recommendations (Doc ID 2724126.1)

Database 19 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2523220.1)

ZDLRA Install, Upgrade and Patching Troubleshooting Guide (Doc ID 2639262.1)

Security Hardening on Exadata (Doc ID 1396654.1)

Recommended Protected Database Patches for Zero Data Loss Recovery Appliance (Doc ID 1982542.1)

Is a Level=0 Database Backup Required after Enabling Change Tracking? (Doc ID 469692.1)

HOWTO: Install ksplice kernel updates for Exadata Database Nodes (Doc ID 2207063.1)

**

## YouTube Canais Oracle:
**

https://www.youtube.com/c/OraPub/videos

https://www.youtube.com/c/TanelPoder/videos

https://www.youtube.com/c/ConnorMcDonaldOracle/videos

https://www.youtube.com/c/OracleBasePage/videos

https://www.youtube.com/c/MariaColgan42/videos

https://www.youtube.com/user/OTNDatabasechannel/videos

https://www.youtube.com/user/OracleLearning

https://www.youtube.com/c/OracleMania/videos

https://www.youtube.com/user/AIOUG/videos

https://www.youtube.com/user/OracleMidlands/videos

https://www.youtube.com/c/UsenixOrg/videos

https://www.youtube.com/channel/UCJHCNVQfjshtJLGquL9QPig/videos

Outros Databases:

https://www.youtube.com/c/percona/videos

https://www.youtube.com/c/MongoDBofficial/videos

https://www.youtube.com/c/DataStaxDevs/videos

https://www.youtube.com/c/PlanetCassandra/videos

https://www.youtube.com/channel/UCk8VviAaxNZkakaL1hPykIg/videos

https://www.youtube.com/channel/UCqX_FVBw4RL-DMDwZ_H86gg/videos

ZDLRA:

http://www.fernandosimon.com/blog/

https://bryangrenn.blogspot.com/

https://sudhakarkotagiri.blogspot.com/

ILM:

http://ora-srv.wlv.ac.uk/oracle19c_doc/vldbg/ilm-strategy-heatmap-ado.html#GUID-1E510486-2ED8-467A-A5BA-045F4F3AC324

http://www.dhnomura.com/2017/12/ilm-information-lifecycle-management.html

https://oracle-base.com/articles/12c/heat-map-ilm-ado-12cr2

https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/heatmap-ado-em.html#GUID-42B9C5E1-768C-4EA1-AB9C-ADEA07B41721

https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/ilm-maual-system.html#GUID-E342DA80-8699-43FB-85FB-7A68A862280A

http://www.oracle.com/us/products/database/database-11g-managing-storage-wp-354099.pdf

https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/manage-data-db-ilm.html#GUID-AC2B567F-14EF-4E7A-9992-076A2A820305

SEQUENCES:

https://connor-mcdonald.com/2020/03/30/combinations-and-consequences/

https://connor-mcdonald.com/2018/01/24/identity-columns-in-12c-just-a-sequence/

https://connor-mcdonald.com/2016/05/27/let-me-start-with-sequences/

https://connor-mcdonald.com/2015/11/16/you-dont-need-that-sequence-number/

https://www.youtube.com/watch?v=itvobHdnCfA

https://www.youtube.com/watch?v=jOe-TDvmJdg

https://www.youtube.com/watch?v=m6iqOA2iEjw

https://www.youtube.com/watch?v=LdGtl09C6DM  ---> FASTER INSERTs

RWP*Load Simulator: a new way to measure your Oracle Database performance

https://blogs.oracle.com/database/rwploadsim-oracle-db-performance-simluator

PL/SQL & SQL Coding Guidelines

https://trivadis.github.io/plsql-and-sql-coding-guidelines/v4.0/9-appendix/PLSQL-and-SQL-Coding-Guidelines.pdf

Rolling Database Upgrade from 12.1.0.2 to 19.8 Using Transient Logical Standby

https://gglybin.wordpress.com/2020/12/03/rolling-database-upgrade-from-12-1-0-2-to-19-8-using-transient-logical-standby/

WSL2 Tips:

https://craigloewen-msft.github.io/WSLTipsAndTricks/

Oracle x VMWare:

https://blogs.vmware.com/apps/2017/08/rdm-oracle-rac-not-question.html

https://blogs.vmware.com/apps/2017/12/oracle-vsphere-storage-options.html

https://blogs.vmware.com/apps/2021/09/hot-remove-cpu-and-memory-for-oracle-production-workloads.html

https://blogs.vmware.com/apps/2020/08/to-numa-or-not-to-numa-oracle-workloads-and-numa.html

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/whitepaper/vmw-oracle-vsphere-performance.pdf

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/vmware-oracle-databases-on-vmware-best-practices-guide.pdf

Estatísticas:

https://blogs.oracle.com/optimizer/post/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-1

https://blogs.oracle.com/optimizer/post/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-2

https://blogs.oracle.com/optimizer/post/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-3

https://blogs.oracle.com/optimizer/post/locked-optimizer-statistics-a-useful-tool-in-your-toolbox

OEM:

Oracle Cloud Observability and Management Platform

https://www.youtube.com/c/OracleManagementCloud/videos

Oracle Enterprise Manager 13c - Database Tuning and Validation Workshop

https://videohub.oracle.com/media/Oracle+Enterprise+Manager+13c+-+Database+Tuning+and+Validation+Workshop/1_s0xm1g4t

Webinar: Building EM custom database monitoring dashboards for DevOps and other dedicated groups

https://www.youtube.com/watch?v=LVgM__p01DE

Webinar: Automate your database provisioning to increase efficiency and standardization

https://www.youtube.com/watch?v=nUMdekXyqr4

Webinar: Realtime Federation for Extreme Database Monitoring Across Entire IT Stack

https://www.youtube.com/watch?v=Z4DzMBH7PU4

Excel with Enterprise Manager: Get the Best Out of Your Exadata databases

https://www.youtube.com/watch?v=XtLDL0mg1y8

Webinar: RAT - Validate Database Performance Before Committing Updates, Upgrades, and Migrations

https://www.youtube.com/watch?v=8a6fSDSxCjM

Webinar: Secure Multitenant Databases and Hosts Using Automated Hardening and Security Frameworks

https://www.youtube.com/watch?v=QjdwUfBn6FI

Standardize and Automate Database Operations on Oracle Exadata

https://www.youtube.com/watch?v=Anu61HvrbM0

Webinar: Migrate Databases with minimal downtime using Migration Workbench

https://www.youtube.com/watch?v=XZ3k4SgXqR8

Connect Oracle Enterprise Manager 13 to Amazon’s Cloudwatch

https://www.jobacle.nl/?p=1624

Getting Oracle Enterprise Manager Cloud Control to talk to Amazon RDS Instances

http://oemcloud.blogspot.com/2013/07/getting-oracle-enterprise-manager-cloud.html

EXADATA:

Virtual Seminar 2- Part Series: Advanced Oracle Exadata Part 1

https://videohub.oracle.com/media/0_18ue44su?elqTrackId=dd57052180b744b1bc6f288db7a5c164&elqaid=91241&elqat=2&source=:se:lw:ie:pt:SEO400047213%2b:ow:lp:cpo::

Virtual Seminar 2- Part Series: Advanced Oracle Exadata Part 2

https://videohub.oracle.com/media/0_qgcntr0a?elqTrackId=a5838c87fccf466ba17b3e19414576be&elqaid=91241&elqat=2&source=:se:lw:ie:pt:SEO400047213%2b:ow:lp:cpo::

Ansible x DBA:

DevOps Series: Automate Oracle 19c RDBMS Installations with Ansible [GITHUB]

https://medium.com/oracledevs/devops-series-automate-oracle-19c-rdbms-installations-with-ansible-github-43cfdf344a4a

https://github.com/asiandevs/OracleDBAwithAnsible



ASCII Generator:

http://www.network-science.de/ascii/

PostgreSQL ASH Viewer (PASH Viewer)

https://github.com/dbacvetkov/PASH-Viewer