DOCUMENTAÇÃO |
|---|
Oracle Database Online Documentation 11g Release 2 (11.2):
Oracle Database Online Documentation 11g
Oracle Database Online Documentation 19c:
Oracle Database 19c - Get Started
Oracle Database 19c - Books
Database Concepts
Database Performance Tuning Guide
Database Reference
Data Guard per Pluggable Database – DG PDB:
21c, DG PDB - Fernando Simon
MongoDB Documentation:
Introduction to MongoDB
Amazon DynamoDB: a r(el)ational Glossary
https://blog.dbi-services.com/aws-dynamodb-a-relational-glossary/
Amazon DynamoDB Videos
Amazon DynamoDB Core Concept Videos
PostGreSQL:Debugging Postgres autovacuum problems: 13 tips
How to Avoid the 10 Deadly PostgreSQL Mistakes
TAC - Transparent Application ContinuityOracle Real Application Cluster (RAC) and Transparent Application Continuity (TAC) Overview & Demos
How to Configure Application Continuity, part 1 – What does the DBA need to do?
How to Configure Application Continuity, part 2 Master Class
TAF:
FAVORITOS |
|---|
Analysis of a Couple AWR Reports - OTW2018:
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
Best Practices for Running Oracle Database on AWS - Best Practices for Running Oracle Database on AWS
Tuning Cassandra (JVM):
https://docs.datastax.com/en/archived/cassandra/3.x/cassandra/operations/opsTuneJVM.html
Oracle Database performance tuning using oratop - tips and tricks
CURSOS / WORKSHOPS / WEBINARES |
|---|
AWS Online Free Courses:
https://www.amazon.com/aws-courses/b?ie=UTF8&node=14297978011
https://www.youtube.com/playlist?list=PLOF5f9_x-OYUaqJar6EKRAonJNSHDFZUm
AWS Training – PostGreSQL:
PostgreSQL Fundamentals: https://www.aws.training/Details/eLearning?id=32439
PostgreSQL Fundamentals: Architecture: https://www.aws.training/Details/eLearning?id=42102
PostgreSQL Fundamentals: SQL Command Line: https://www.aws.training/Details/eLearning?id=43293
PostgreSQL Fundamentals: Explain: https://www.aws.training/Details/eLearning?id=43291
Curso Free MongoDB:
https://university.mongodb.com/learning_paths/dba
MongoDB Basics: https://university.mongodb.com/courses/M001/about
MongoDB for SQL Pros: https://university.mongodb.com/courses/M100/about
MongoDB – Basic Cluster Administration: https://university.mongodb.com/courses/M103/about
MongoDB for Python Developers: https://university.mongodb.com/courses/M220P/about
https://jornadadodev.com.br/cursos/curso-de-mongodb
https://www.youtube.com/playlist?list=PL4Sl6eAbMK7RsS4Q8tSHTlOIaUmTG9eRS
Curso Free Cassandra/Datastax:
https://www.youtube.com/playlist?list=PLjHEb0NvFucip4VA3LGJiGTOJIXU97jRK
Cassandra World Party #1
https://www.youtube.com/watch?v=aK-H58ZXcuQ
Cassandra World Party #2
https://www.youtube.com/watch?v=P-aAeUH5drY
Cassandra World Party #3
https://www.youtube.com/watch?v=_kkx8f96j0M
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
Curso de Python moderno + Análise de dados
https://www.youtube.com/playlist?list=PLLWTDkRZXQa9YyC1LMbuDTz3XVC4E9ZQA
Curso SQL com python [Free]
Mydbops Webinar – “Linux Performance Monitoring Tools” Presented by Manosh Malai CTO – Mydbops
Mastering Linux Performance Monitoring Tools: Boost Your System’s Efficiency – Mydbops Webinar – 04
Tarefas do Dia a Dia de um DBA SQL SERVER – Power Tuning:
Tarefas do Dia a Dia de um DBA
YOUTUBE CANAIS |
|---|
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:
https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/manage-data-db-ilm.html
http://www.dhnomura.com/2017/12/ilm-information-lifecycle-management.html
https://oracle-base.com/articles/12c/heat-map-ilm-ado-12cr2
http://www.oracle.com/us/products/database/database-11g-managing-storage-wp-354099.pdf
https://www.oracle.com/a/ocom/docs/database/database-11g-managing-storage-wp-354099.pdf
https://www.informatik-aktuell.de/betrieb/datenbanken/partitionierung-aus-designsicht-eine-praktische-anleitung.html → Original em Alemão, precisa mudar para “Translate to English”
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
Rolling Database Upgrade from 12.1.0.2 to 19.8 Using Transient Logical Standby
WSL2 Tips:
https://craigloewen-msft.github.io/WSLTipsAndTricks/
https://stephenreescarter.net/how-to-shrink-a-wsl2-virtual-disk/
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
Estatísticas:
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
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
Virtual Seminar 2- Part Series: Advanced Oracle Exadata Part 2
Ansible x DBA:
DevOps Series: Automate Oracle 19c RDBMS Installations with Ansible [GITHUB]
GitHub – asiandevs/OracleDBAwithAnsible: Installing Oracle 19c RDBMS Software SI
https://oracle-base.com/articles/misc/articles-misc#ansible
MySQL:
https://learn.percona.com/ondemand-mysql-8-new-features
ASCII Generator:
http://www.network-science.de/ascii/
PostgreSQL ASH Viewer (PASH Viewer)
DISTRIBUTED DATABASES |
|---|
-
Oracle SHARDING:
Oracle database sharding overview
https://www.youtube.com/watch?v=yFRh2ebMbDA
Oracle database sharding – Geo-distributed sharded database overview and demo
https://www.youtube.com/watch?v=tFvMP59MaUo
Oracle database sharding demo
https://www.youtube.com/watch?v=Gi3VedNyqqw
-
YugaByteDB:
https://university.yugabyte.com/
https://www.yugabyte.com/yugabytedb-215/
https://www.yugabyte.com/blog/optimizing-yugabytedb-memory-tuning-for-ysql/
https://blog.yugabyte.com/three-nosql-challenges-solved-distributed-sql
YugabyteDB distributed SQL features
https://blog.yugabyte.com/stateful-applications-design-considerations-for-data-in-edge-environments
https://dev.to/franckpachot/default-tablet-splitting-in-yugabytedb-4lnf
https://dev.to/yugabyte/yugabytedb-cardinality-estimation-in-the-absence-of-analyze-statistics-1c1k
Read Committed and Pessimistic Locking in Distributed SQL Databases
https://dev.to/yugabyte/1-million-rows-insert-59c8
https://www.yugabyte.com/blog/distributed-sql-essentials-sharding-and-partitioning-in-yugabytedb/
https://www.yugabyte.com/blog/using-minio-for-yugabytedb-backup-and-restore/
https://blog.yugabyte.com/log-aggregation-yugabytedb-grafana-loki/
https://www.yugabyte.com/developers-hub
https://blog.yugabyte.com/distributed-sql-tips-and-tricks-july-2022
YugabyteDB Friday Tech Talks: Episode 24: Partitioning Tables in YugabyteDB
https://www.youtube.com/watch?v=WaCX9jlgj3g
YugabyteDB Friday Tech Talks: Episode 3: YugabyteDB Sharding Strategies
https://www.youtube.com/watch?v=3Jx6SH9iZ-s
YugabyteDB Friday Tech Talks: Episode 20: YCQL – Automatic Deletion of Data Using Time-To-Live (TTL)
https://www.youtube.com/watch?v=ubm2a7E0D44
-
CockroachDB:
https://www.cockroachlabs.com/blog/living-without-atomic-clocks/
https://www.cockroachlabs.com/blog/gs-response/
-
AlloyDB (Spanner):
https://cloud.google.com/blog/products/databases/introducing-alloydb-for-postgresql
-
AuroraDB:
MOS DOCids 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)
COMANDOS S.O. |
|---|
— move da tabela SW_TRANS com índices
SQL> alter table OWNER_ADM.SW_TRANS move online tablespace TSD_ENCRYPTED parallel 48 update indexes (OWNER_ADM.SWTRANSEXTINF_IDX02 tablespace TSI_ENCRYPTED, OWNER_ADM.SWTRANSEXTINF_IDX01 tablespace TSI_ENCRYPTED, OWNER_ADM.SWTRANSEXTINF_PK tablespace TSI_ENCRYPTED);
SQL> select ‘ALTER TABLE ‘||owner||’.’||table_name||’ MOVE LOB( ‘||column_name||’) STORE AS (TABLESPACE TSLOB02) parallel 48 online;’ from dba_lobs where tablespace_name=’TSLOB’;
SQL> select ‘ALTER TABLE ‘||table_owner||’.’||table_name||’ MOVE partition ‘||Partition_name||’ lob(‘||column_name||’)’||’ STORE AS (TABLESPACE TSLOB02) parallel 48 online;’ from dba_lob_partitions where TABLESPACE_NAME = ‘TSLOB’;
SQL> select ‘alter index ‘||index_owner||’.’||index_name||’ rebuild partition ‘||partition_name||’ tablespace TSLOB02 parallel 48;’ from dba_ind_partitions where tablespace_name=’TSLOB’;
–LoginGraceTime, timeout wait
# cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +”%Y%m%d_%H%M%S”` && sed -i ‘/#LoginGraceTime 2m/ s/#LoginGraceTime 2m/LoginGraceTime 0/’ /etc/ssh/sshd_config && grep LoginGraceTime /etc/ssh/sshd_config
–SSH DNS
# cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +”%Y%m%d_%H%M%S”` && sed -i ‘/#UseDNS yes/ s/#UseDNS yes/UseDNS no/’ /etc/ssh/sshd_config && grep UseDNS /etc/ssh/sshd_config
— Limpar traces mais antigos que 1 dia:
# find . -name ‘*.tr*’ -mtime +1 | xargs rm -rf
— Limpar cache de filesystems:
# sync; echo 3 > /proc/sys/vm/drop_caches
–DISPLAY TOP10 using SWAP em %:
# find /proc -maxdepth 2 -path “/proc/[0-9]*/status” -readable -exec awk -v FS=”:” -v TOTSWP=”$(cat /proc/meminfo | sed -n -e “s/^SwapTotal:[ ]*\([0-9]*\) kB/\1/p”)” ‘{process[$1]=$2;sub(/^[ \t]+/,””,process[$1]);} END {if(process[“VmSwap”] && process[“VmSwap”] != “0 kB”) {used_swap=process[“VmSwap”];sub(/[ a-zA-Z]+/,””,used_swap);percent=(used_swap/TOTSWP*100); printf “%10s %-30s %20s %6.2f%\n”,process[“Pid”],process[“Name”],process[“VmSwap”],percent} }’ ‘{}’ \; | awk ‘{print $(NF-2),$0}’ | sort -hr | head | cut -d ” ” -f2-