oradrs

Oracle SQL Performance Tuning Cheatsheet

F:\WorkingKnowles\Oracle\Utility\12i\PT\PerformanceTuning_CheatSheet.md

Reference

• ** How To Fetch Multiple Oracle Execution Plans in One Nice Query
• Oracle Dev Gym class - Databases for Developers: Performance
• White Paper -Oracle 12c Optimizer Explain the Explain Plan
• Youtube - How to read an execute plan

oradrs

-----------------------------------------
-- psqlrc file to set psql preferences --
-- Author : Prashanth Goriparthi       --
-----------------------------------------

-- source : https://opensourcedbms.com/dbms/psqlrc-psql-startup-file-for-postgres/
-- in Linux - ~/.psqlrc
-- in Windows - %AppData%\postgresql\psqlrc.conf
	-- C:\Users\[Login id]\AppData\Roaming\postgresql\psqlrc.conf

oradrs

REM http://www.dbspecialists.com/files/scripts/compare_schemas.sql
REM
REM compare_schemas.sql
REM ===================
REM
REM This script is provided by Database Specialists, Inc. 
REM (http://www.dbspecialists.com) for individual use and not for sale. 
REM Database Specialists, Inc. does not warrant the script in any way 
REM and will not be responsible for any loss arising out of its use.
REM

oradrs

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)