Skip to content

Instantly share code, notes, and snippets.

@dincosman
dincosman / child_cursor_reasons.txt
Created October 29, 2023 11:37
Stew Ashton's child cursor reasons query
SQL> SELECT reason_not_shared, COUNT (*) cursors, COUNT (DISTINCT sql_id) sql_ids
FROM v$sql_shared_cursor
UNPIVOT (val
FOR reason_not_shared
IN (UNBOUND_CURSOR,
SQL_TYPE_MISMATCH,
OPTIMIZER_MISMATCH,
OUTLINE_MISMATCH,
STATS_ROW_MISMATCH,
LITERAL_MISMATCH,
@joelonsql
joelonsql / PostgreSQL-EXTENSIONs.md
Last active October 20, 2025 08:59
1000+ PostgreSQL EXTENSIONs

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

@kzhangkzhang
kzhangkzhang / PerformanceTuning_CheatSheet.md
Last active September 14, 2025 12:43
Oracle SQL Performance Tuning Cheatsheet
// ==UserScript==
// @name gheil Google Bookmarks fix
// @match https://www.google.com/bookmarks/*
// @grant none
// @require https://code.jquery.com/jquery-1.12.4.min.js
// @require https://code.jquery.com/ui/1.12.1/jquery-ui.js
// ==/UserScript==
// greg heil(cc-by-sa)18/07/09
var DONE = 0;
var MAX_SUGGESTIONS=108;
// ==UserScript==
// @name Google Bookmarks fix
// @match https://www.google.com/bookmarks/*
// @grant none
// @require https://code.jquery.com/jquery-1.12.4.min.js
// @require https://code.jquery.com/ui/1.12.1/jquery-ui.js
// ==/UserScript==
$(function() {
try {
@dotmaik1
dotmaik1 / reports: AWR-ADDM-ASH hourly script.sh
Created October 6, 2016 16:50
AWR-ADDM-ASH hourly script
05 8-17 * * 1-5 /dbms/oracle/local/AMCMPRN1/etc/Scripts/awrreport_html_hourly.ksh AMCMPRN1 > /tmp/AWR_report_AMCMPRN1.out 2>&1
08 8-17 * * 1-5 /dbms/oracle/local/AMCMPRN1/etc/Scripts/addmreport_hourly.ksh AMCMPRN1 > /tmp/addm_report_AMCMPRN1.out 2>&1
05 8-17 * * 1-5 /dbms/oracle/monitor/bin/ashreport_html_hourly.ksh -sAMCMPRN1 -t60 > /tmp/AWR_report_AMCMPRN1.out 2>&1
AWR:
oracle@mwamdb3p[DUMMY] /home/oracle => cat /dbms/oracle/local/AMCMPRN1/etc/Scripts/awrreport_html_hourly.ksh
@hvmonteiro
hvmonteiro / notepad_plus_log4j.xml
Created September 26, 2016 12:25
Notepad++ User Defined Language Syntax Highlight: Log4J
<NotepadPlus>
<UserLang name="Log4J" ext="log" udlVersion="2.1">
<Settings>
<Global caseIgnored="no" allowFoldOfComments="no" foldCompact="no" forcePureLC="0" decimalSeparator="2" />
<Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" />
</Settings>
<KeywordLists>
<Keywords name="Comments">00 01 02 03 04</Keywords>
<Keywords name="Numbers, prefix1"></Keywords>
<Keywords name="Numbers, prefix2"></Keywords>
@leonardofed
leonardofed / README.md
Last active October 23, 2025 11:18
A curated list of AWS resources to prepare for the AWS Certifications


A curated list of AWS resources to prepare for the AWS Certifications

A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.


@ekhabarov
ekhabarov / .psqrc.config
Created November 19, 2015 10:15
PSQL config
-----------------------------------------
-- psqlrc file to set psql preferences --
-- Author : Prashanth Goriparthi --
-----------------------------------------
-- source : https://opensourcedbms.com/dbms/psqlrc-psql-startup-file-for-postgres/
\set QUIET ON
\set PROMPT1 '%[%033[1;32;40m%]%M:%&gt; %n@%/%[%033[0m%]% # '
\set PAGER OFF
@apolloclark
apolloclark / postgres cheatsheet.md
Last active September 23, 2025 18:03
postgres cheatsheet

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL