Links e Referências

Deixe um comentário / Por /
 

DOCUMENTAÇÃO

 
 

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

Oracle Database Online Documentation 19c:





Data Guard per Pluggable Database – DG PDB:

MongoDB Documentation:

Amazon DynamoDB: a r(el)ational Glossary
https://blog.dbi-services.com/aws-dynamodb-a-relational-glossary/
Amazon DynamoDB Videos

PostGreSQL:

  
TAC - Transparent Application Continuity
 
 
 

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

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://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

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://academy.datastax.com/

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

Tarefas do Dia a Dia de um DBA SQL SERVER – Power Tuning:

 

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://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://www.oracle.com/a/ocom/docs/database/database-11g-managing-storage-wp-354099.pdf

https://www2.deloitte.com/content/dam/Deloitte/us/Documents/finance/us-advisory-information-lifecycle-management.pdf

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

https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/partition-availability.html?s=08#GUID-FA29787B-8700-49EA-B80D-54D667CF2752

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

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/

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

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://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/

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

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

https://franckpachot.medium.com/pitr-snapshot-an-easy-flashback-backtrack-for-application-releases-743485d82af5

https://dev.to/yugabyte/1-million-rows-insert-59c8

https://blog.yugabyte.com/achieving-fast-failovers-after-network-partitions-in-a-distributed-sql-database/

https://www.yugabyte.com/blog/how-does-the-raft-consensus-based-replication-protocol-work-in-yugabyte-db/

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:

https://www.amazon.science/publications/amazon-aurora-design-considerations-for-high-throughput-cloud-native-relational-databases

 

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-

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Rolar para cima