search

awslabs / rds-support-tools

Amazon RDS Support Tools contains utilities, sql, scripts and views which are useful in a RDS environment
https://aws.amazon.com/rds/
Apache License 2.0
217 stars 229 forks source link

marozzin pull request #31

Closed marozzin closed 7 years ago

marozzin commented 7 years ago

Oracle

Review of Oracle patches installed on RDS Oracle instances equipped with 12c Oracle versions through the DBMS_QOPATCH.

These two SQL use the DBMS_QOPATCH to retrieve information regarding Oracle patch installed on RDS Oracle instances for 12c engine versions family.

As managed database standard methods available for 11g too still require OS access and are not available for RDS instances.

A KC article written by mmssl@ was proposed regarding the usage of DBMS_QOPATCH for RDS Oracle 12c in order to allow customers to review patches installed. When the article it will published these scripts should be linked as available in the GitHub repository.

Commits: oracle/diag/sql/oracle-12-patch-list-verbose.sql oracle/diag/sql/oracle-12-patch-list.sql oracle/oracle.README

MySQL

Commits: mysql/diag/sql/

mysql/diag/sql/blocking-sessions.sql

Blocking transactions

mysql/diag/sql/innodb-table-tablespace.sql

To be aware regarding which InnoDB tables are allocated in the system tablespace and which in per-file-tablespace.

mysql/diag/sql/kill-queries-builder.sql mysql/diag/sql/kill-sessions-builder.sql

Meta-queries to filter threads-id used to feed RDS Calls mysql.rds_kill(id) to kill sessions and mysql.rds_kill_query(id). Refer to: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.CommonDBATasks.html#Appendix.MySQL.CommonDBATasks.Kill

mysql/diag/sql/space-allocation.sql

Retrieve information about space used by MySQL structure for which data are available on RDS.

mysql/mysql.README