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.
| 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, |
F:\WorkingKnowles\Oracle\Utility\12i\PT\PerformanceTuning_CheatSheet.md
| // ==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 { |
| 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 |
| <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> |
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.
| ----------------------------------------- | |
| -- 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:%> %n@%/%[%033[0m%]% # ' | |
| \set PAGER OFF |
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.
http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL