https://dbwiki.co.uk/ 2026-04-18T23:32:36+00:00 https://dbwiki.co.uk/ https://dbwiki.co.uk/_media/wiki/dokuwiki.svg text/html 2026-01-22T13:26:03+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/?image=0%3Acybertec_migrator-enterprise-v3.20.3-amd64.tar.gz&ns=0&rev=1769088363&tab_details=history&media_do=diff&do=media <img src="https://dbwiki.co.uk/lib/images/fileicons/svg/gz.svg" alt="cybertec_migrator-enterprise-v3.20.3-amd64.tar.gz" loading="lazy" width="500" height="500" /> text/html 2025-08-07T09:11:21+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/usefulscripts?rev=1754557881&do=diff Scripts Tablespaces / Data Files / Blocks SET PAGESIZE 140 LINESIZE 200 COLUMN used_pct FORMAT A11 COLUMN size_mb FORMAT 9,999,999 COLUMN free_mb FORMAT 9,999,999 COLUMN max_size_mb FORMAT 9,999,999 COLUMN max_free_mb FORMAT 9,999,999 SELECT tablespace_name, size_mb, free_mb, max_size_mb, max_free_mb, TRUNC((max_free_mb/max_size_mb) * 100) AS free_pct FROM ( SELECT a.tablespace_name, b.size_mb, a.free_mb, … text/html 2025-06-03T08:11:58+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/instantclient?rev=1748938318&do=diff Oracle Instant Client Installation sudo apt install -y libaio1 mkdir oracle && cd "$_" wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sdk-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/… text/html 2025-04-17T10:16:53+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/postgresqlcommands?rev=1744885013&do=diff Installation Linux <https://www.postgresql.org/download/linux/debian/> <https://www.postgresql.org/download/linux/redhat/> Create Cluster The Debian or Ubuntu installation will create a default instance. Create new instances using the commands below ... # Debian / Ubuntu pg_createcluster -d /var/lib/postgresql/17/main 17 main # Redhat / Fedora # Default Data Directory: /var/lib/pgsql/17/data sudo /usr/pgsql-17/bin/postgresql-17-setup initdb /usr/pgsql-17/bin/initdb -D /var/lib/pgsql… text/html 2025-04-01T08:34:31+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/performancetuning?rev=1743496471&do=diff Performance Tuning Simple Explain Plan EXPLAIN PLAN FOR SELECT * FROM dba_users; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); Get Active Sessions SET LINES 2000 TRIMSPOOL ON PAGES 10000 COLUMN EVENT FORMAT A30 COLUMN secw FORMAT 99999 COLUMN username FORMAT A15 COLUMN sqlid_chno FORMAT A20 ACCEPT usr PROMPT 'Username (blank for all): ' SELECT sw.SID, s.username, sw.SEQ#, sw.EVENT, sw.WAIT_TIME, sw.SECONDS_IN_WAIT secw, SQL_ID||' '||SQL_CHILD_NUMBER sqlid_chno, sw.STATE,… text/html 2025-03-27T15:50:13+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/start?rev=1743090613&do=diff Database Wiki PostgreSQL Articles PostgreSQL Information PostgreSQL Replication PostgreSQL Partitioning PostgreSQL Barman PostgreSQL Upgrades PostgreSQL Extensions PostgreSQL Vacuum PostgreSQL pl/pgpsql PostgreSQL Flexible Server for Azure Python and PostgreSQL Terraform and PostgreSQL Grand National Sweepstake Code IMDB Database ---------- Oracle Database Articles Automatic Diagnostic Repository Character Sets Cloud Control 12c Database Auditing Data Guard Da… text/html 2025-03-27T15:49:42+00:00 z0hpvk (z0hpvk@undisclosed.example.com) https://dbwiki.co.uk/easyconnect?rev=1743090582&do=diff