# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1707402539 -7200
# Node ID eb3795b7211718ab4caa3450c9c228a3f28f930e
# Parent  f344c5cd259a5f7cd9d5c249f93a0af42adc2187# Parent  63472ea9e73b1c54ba4eac9519a3e7e0c83a710e
merged

diff -r 63472ea9e73b -r eb3795b72117 Makefile
--- a/Makefile	Mon Dec 25 14:48:27 2023 +0200
+++ b/Makefile	Thu Feb 08 16:28:59 2024 +0200
@@ -66,7 +66,13 @@
 
 # For SEO reason I removed tips from SF.
 .PHONY: deploy
-deploy: deploy2defun-web deploy2defun-hg # deploy2sf-web deploy2sf-hg
+deploy: deploy2defun
+
+.PHONY: deploy2defun
+deploy2defun: deploy2defun-web deploy2defun-hg
+
+.PHONY: deploy2sf
+deploy2sf: deploy2sf-web deploy2sf-hg
 
 RSYNC_FLAGS := --delete -avP -e ssh --exclude "google*.html" --exclude "BingSiteAuth.xml"
 
diff -r 63472ea9e73b -r eb3795b72117 dnf.rst
--- a/dnf.rst	Mon Dec 25 14:48:27 2023 +0200
+++ b/dnf.rst	Thu Feb 08 16:28:59 2024 +0200
@@ -5,6 +5,26 @@
 .. contents::
    :local:
 
+List repositories
+=================
+
+List subscription repos::
+
+  sudo subscription-manager repos --list
+
+List enabled repositories::
+
+  sudo dnf repolist
+  sudo dnf repolist --enabled
+
+List disabled repositories::
+
+  sudo dnf repolist --disabled
+
+Activate repository::
+
+  sudo subscription-manager repos --enable $REPO
+
 List packages
 =============
 
@@ -17,6 +37,22 @@
   dnf repoquery --userinstalled
   dnf history userinstalled
 
+List packages in a repository::
+
+  dnf repository-packages $REPO list
+
+Search for a package::
+
+  dnf search nodejs
+
+List all package version::
+
+  dnf search --showduplicates nodejs
+
+List all package versions together with repos::
+
+  dnf list --showduplicates nodejs
+
 Check package details
 =====================
 
@@ -41,25 +77,33 @@
   dnf repoquery -l $PKG
   rpm -ql $PKG
 
-Find packages a file belong to
-==============================
+Find packages a file belongs to
+===============================
 
 Using remote metadata::
 
   dnf provides ifconfig
   dnf repoquery --file /usr/sbin/ifconfig
+  repoquery --whatprovides python3
+  repoquery --whatprovides libssl*.so.*
 
 Using installed package DB::
 
   rpm -qf /usr/bin/rpm
+  rpm -q --whatprovides /bin/bash
+
+Limit search to a specific repository::
+
+  dnf repoquery --disablerepo=* --enablerepo=$REPO -f $PATT
 
 List package dependencies
 =========================
 ::
 
+  dnf deplist $PKG
   repoquery --requires --resolve $PKG
 
-If you possess a actual RPM::
+If you possess an actual RPM (``-q`` or ``--query``, ``-R`` or ``–requires``)::
 
   rpm -qpR $RPM
 
@@ -71,6 +115,23 @@
   dnf repoquery --installed --whatrequires $PKG
   rpm -q --whatrequires $PKG
 
+Install package
+===============
+
+By package name::
+
+  dnf install $PKG
+
+By a package file::
+
+  rpm -i $PKG.rpm
+  rpm --install $PKG.rpm
+
+Update a package by a file (same as install but removes all earlier versions)::
+
+  rpm -U $PKG.rpm
+  rpm --upgrade $PKG.rpm
+
 Dealing with streams
 ====================
 
@@ -98,4 +159,32 @@
   sudo dnf module reset nodejs
   sudo dnf module install nodejs:16
 
+Extra Packages for Enterprise Linux
+===================================
 
+EPEL stands for Extra Packages for Enterprise Linux and you can enable them by installing a special
+package::
+
+  sudo dnf install epel-release
+  sudo dnf install epel-next-release
+
+https://docs.fedoraproject.org/en-US/epel/
+  Extra Packages for Enterprise Linux (EPEL).
+https://fedoraproject.org/wiki/EPEL/FAQ
+  EPEL FAQ.
+
+Subscription manager
+====================
+
+https://developers.redhat.com/articles/renew-your-red-hat-developer-program-subscription
+  To renew subscription just login to https://developers.redhat.com/ and wait 15 min.
+
+Cleanup actions from broken previous subscription::
+
+  sudo subscription-manager remove --all
+  sudo subscription-manager unregister
+  sudo subscription-manager clean
+  sudo subscription-manager register --username ...
+  sudo subscription-manager refresh
+  sudo subscription-manager attach --auto
+
diff -r 63472ea9e73b -r eb3795b72117 oracle.rst
--- a/oracle.rst	Mon Dec 25 14:48:27 2023 +0200
+++ b/oracle.rst	Thu Feb 08 16:28:59 2024 +0200
@@ -159,6 +159,20 @@
 
   select sum(BYTES) from USER_EXTENTS;
 
+List all tables::
+
+  select * from DBA_TABLES;
+
+List table sizes::
+
+  select from DBA_SEGMENTS;
+
+Schema sizes::
+
+  select OWNER, sum(BYTES)/1024/1024 as MiB
+  from DBA_SEGMENTS
+  group by OWNER;
+
 Get LOB stored size::
 
   select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;
diff -r 63472ea9e73b -r eb3795b72117 pacman.rst
--- a/pacman.rst	Mon Dec 25 14:48:27 2023 +0200
+++ b/pacman.rst	Thu Feb 08 16:28:59 2024 +0200
@@ -86,7 +86,7 @@
 
   pacman -Fx $NAME
 
-To update file name package database::
+To update the package database (including file paths for search)::
 
   pacman -Fy
 
@@ -106,3 +106,11 @@
 
   pacman -Fl $PKG
 
+Managing mirrors
+================
+
+Check files from the package ``pacman-mirrors``::
+
+  pacman -Fl pacman-mirrors
+  pacman -Qi pacman-mirrors
+
diff -r 63472ea9e73b -r eb3795b72117 windows.rst
--- a/windows.rst	Mon Dec 25 14:48:27 2023 +0200
+++ b/windows.rst	Thu Feb 08 16:28:59 2024 +0200
@@ -93,6 +93,12 @@
   dism /Online /Cleanup-image /Scanhealth
   dism /Online /Cleanup-Image /RestoreHealth
 
+Alternative cmdlet in PowerShell::
+
+  Repair-WindowsImage -Online -RestoreHealth
+  Repair-WindowsImage -Online -CheckHealth
+  Repair-WindowsImage -Online -ScanHealth
+
 If Windows Update is broken you can provide path::
 
   dism /Online /Cleanup-Image /RestoreHealth /Source:C:\RepairSource\Windows /LimitAccess