Feed aggregator
Change partition column
Adding a column with a default value to a table
Incorrect time in Database
Data warehouse performance
Package compilation speed
Explaination on LRU, MRU and MFL,TFL
Get trace file from server to client
The old way to get a user dump trace file, for sql_trace (10046), Optimizer compilation trace (10053), lock trace (10704), Optimizer execution trace (10507),… is to go to the server trace directory. But if you don’t have access to the server (as in the ☁) the modern (12cR2) way is to select from V$DIAG_TRACE_FILE_CONTENTS. Before everybody is on 12.2 I’m sharing here a sqlplus script that I use for a long time to get the trace file to the client.
This is a script to run with sqlplus passing as a parameter the name of the trace file you want to write to (because the original name on the server is not very meaningful). I close all cursors to get all info such as STAT lines. I get the trace file name from v$diag_info. If a directory exists I use it. If not I create one, named UDUMP, which I’ll remove at the end. Then the file is read by utl_file and spooled on client though dbms_output. At the end, I remove the trace file from the server.
Here is the script – comments welcome.
set serveroutput on feedback off verify off termout off linesize 1024 trimspool on echo off
spool &1..trc
declare
fd utl_file.file_type;
line varchar2(1024);
l_tracename varchar2(512);
l_directory_path all_directories.directory_path%TYPE;
l_directory_name all_directories.directory_name%TYPE;
l_directory_created boolean;
procedure t (msg in varchar2) is begin dbms_output.put_line(msg); end;
begin
/* use old parameter _cached_open_cursors to close all open cursors */
for r in (select 1 from v$session_cursor_cache where count>0) loop
dbms_session.set_close_cached_open_cursors(true);
rollback;
commit;
dbms_session.set_close_cached_open_cursors(false);
end loop;
/* get trace directory and trace file name */
select value into l_directory_path from v$diag_info where name='Diag Trace';
select substr(replace(value,l_directory_path,''),2) into l_tracename from v$diag_info where name='Default Trace File';
/* get directory name for it, or try to create it */
l_directory_created:=false;
begin
select directory_name into l_directory_name from all_directories where directory_path = l_directory_path and rownum=1;
exception
when no_data_found then
begin
l_directory_name:='UDUMP';
execute immediate 'create directory '||l_directory_name||' as '''||l_directory_path||'''';
l_directory_created:=true;
exception when others then
raise_application_error(-20000,'You must CREATE DIRECTORY '||l_directory_name||' as ''' ||l_directory_path||'''; or be granted CREATE DIRECTORY.');
end;
end;
/* opens the trace file */
begin
fd:=utl_file.fopen(l_directory_name,l_tracename,'R');
exception when others then
raise_application_error(-20001,'Impossible to open file: '||l_tracename||' in '||l_directory_name||' ( '||l_directory_path||' )');
end;
/* read the trace file and prints it */
begin
loop
begin
utl_file.get_line(fd,line);
dbms_output.put_line(line);
exception
when no_data_found then exit;
when others then
dbms_output.put_line('!!! error while reading file '||l_tracename||' in '||l_directory_name||' ( '||l_directory_path||' )');
end;
end loop;
/* close and remove the file from the server */
utl_file.fclose(fd);
utl_file.fremove(l_directory_name,l_tracename);
exception
when others then
raise_application_error(-20002,'Impossible to remove: '||l_tracename||' in '||l_directory_name||' ( '||l_directory_path||' )');
end;
begin
/* drop directory if created */
if l_directory_created then execute immediate 'drop directory '||l_directory_name; end if;
exception
when others then
raise_application_error(-20002,'Impossible to remove directory: '||l_directory_name||' ( '||l_directory_path||' )'||sqlerrm);
end;
end;
/
spool off
Cet article Get trace file from server to client est apparu en premier sur Blog dbi services.
CoreOS: How to login via ssh (default password?!)
If you ask your preferred search engine, you will get many answers that there is not default password...
(Of course! The idea behind containers and container schedulers is, that everything works automatically and typing passwords does not fit in this mantra).
But no worries, only 4 steps are needed to get a login via ssh:
- on your laptop
- $ ssh-keygen
Generating public/private rsa key pair.
Enter file in which to save the key (/home/schroff/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/schroff/.ssh/id_rsa.
Your public key has been saved in /home/schroff/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:xxxxxxxxxxxxxxxxxxxxxxxxxxx schroff@zerberus
The key's randomart image is:
+---[RSA 2048]----+
xxxxxx
+----[SHA256]-----+ - cp ~/.ssh/id_rsa.pub ~/.ssh/authorized_keys
- inside the coreos vm
- scp schroff@:/.ssh/authorized_keys /home/core/.ssh
schroff@xxxxxxx's password:
authorized_keys 100% 398 0.4KB/s 00:00 - on your laptop
- ssh core@
(Although you have to clean up your known hosts file, because the machine starts up with a new ssh key.)
Postgres vs. Oracle access paths VIII – Index Scan and Filter
In the previous post we have seen a nice optimization to lower the consequences of bad correlation between the index and the table physical order: a bitmap, which may include false positives and then requires a ‘recheck’ of the condition, but with the goal to read each page only once. Now we are back to the well-clustered table where we have seen two possible access paths: IndexOnlyScan when all columns we need are in the index, and IndexScan when we select additional columns. Here is a case in the middle: the index does not have all the columns required by the select, but can eliminate all rows.
The table created is:
create table demo1 as select generate_series n , 1 a , lpad('x',1000,'x') x from generate_series(1,10000);
SELECT 10000
create unique index demo1_n on demo1(n);
CREATE INDEX
vacuum demo1;
VACUUM
I use only one column (N), which is indexed, in the SELECT clause and the WHERE clause. And this WHERE clause is silly: in addition to the n<=1000 I've used in previous post to focus on 10% of rows, I add a condition which is always false: mod(n,100)=1000
explain (analyze,verbose,costs,buffers) select n from demo1 where n<=1000 and mod(n,100)=1000 ;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Index Only Scan using demo1_n on public.demo1 (cost=0.29..38.78 rows=5 width=4) (actual time=0.276..0.276 rows=0 loops=1)
Output: n
Index Cond: (demo1.n <= 1000)
Filter: (mod(demo1.n, 100) = 1000)
Rows Removed by Filter: 1000
Heap Fetches: 0
Buffers: shared hit=5
Planning time: 0.454 ms
Execution time: 0.291 ms
Index Only Scan is used here because no other columns are used. The n<=1000 is the access condition (Index Cond.) doing a range scan on the index structure. The mod(n,100)=1000 is a filter predicate which is applied to the result of the index access (Filter) and we have additional information that the 1000 rows selected by the access predicate have been filtered out (Rows Removed by Filter). During the execution, 5 index buffers have been read for the range scan (branches + leaves). Because I vacuumed any changes, the visibility map knows that all rows can be displayed and there are no blocks to read from the table (Heap Fetches).
Now I’ll select another column in order to see an Index Scan. We have seen in the previous post that the huge cost of index access is the access to the table. Filtering most of the rows from the index entries is the most common recommendation to optimize a query. And my example here is running the extreme case: a predicate on the indexed column removes all rows.
Index Scan and FilterI’ve just changed the ‘select n’ to ‘select a':
explain (analyze,verbose,costs,buffers) select a from demo1 where n<=1000 and mod(n,100)=1000 ;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------
Index Scan using demo1_n on public.demo1 (cost=0.29..184.78 rows=5 width=4) (actual time=0.427..0.427 rows=0 loops=1)
Output: a
Index Cond: (demo1.n <= 1000)
Filter: (mod(demo1.n, 100) = 1000)
Rows Removed by Filter: 1000
Buffers: shared hit=147
Planning time: 0.434 ms
Execution time: 0.440 ms
I can understand that the cost is higher. The optimizer may not know that mod(n,100) will never be equal to 1000. Estimating 5 rows, as in the previous case, is ok for me. We see different Output (different SELECT clause) but same information about Index Cond, Filter, and Rows Removed (same WHERE clause). The estimation part looks good.
However, there’s something that I can’t understand. At execution, we know that all rows can be removed before going to the table. We go to the table to get the value from A but all rows were filtered out from the index. At least it was the case with the Index Only Scan, and we know that the filter condition has all values from the index.
However, 147 blocks were read here. We have seen that the index scan reads 5 index pages, and then we can guess that 142 table pages have been read, exactly 10% of the pages from my correlated table. It seems that all rows have been read from the table before being filtered out. The Index Scan being one operation, the filter occurs at the end only. This is only my guess and I hope to get comments about that.
OracleWith Oracle, the first query, selecting only indexed columns is an INDEX RANGE SCAN similar to the Postgres one.
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID fj36y2vph9u8f, child number 0
-------------------------------------
select /*+ */ n from demo1 where n<=1000 and mod(n,100)=1000
---------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | Cost (%CPU)| A-Rows | A-Time | Buffers |
---------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 4 (100)| 0 |00:00:00.01 | 3 |
|* 1 | INDEX RANGE SCAN| DEMO1_N | 1 | 10 | 4 (0)| 0 |00:00:00.01 | 3 |
---------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("N"<=1000)
filter(MOD("N",100)=1000)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "N"[NUMBER,22]
Oracle does not know either that the filter predicate mod(n,100)=1000 eliminates all rows and estimates this kind of predicate to 10% of rows (a generic value) after the access predicate returning 10% (this one is calculated from statistics). 3 blocks were read: index branch + leaves.
Reading an additional table from the column does not change this INDEX RANGE SCAN operation but just adds one step to go to the table:
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 1rpmvq3jj8hgq, child number 0
-------------------------------------
select /*+ */ a from demo1 where n<=1000 and mod(n,100)=1000
----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | Cost (%CPU)| A-Rows | A-Time | Buffers |
----------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 6 (100)| 0 |00:00:00.01 | 3 |
| 1 | TABLE ACCESS BY INDEX ROWID BATCHED| DEMO1 | 1 | 10 | 6 (0)| 0 |00:00:00.01 | 3 |
|* 2 | INDEX RANGE SCAN | DEMO1_N | 1 | 10 | 4 (0)| 0 |00:00:00.01 | 3 |
----------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("N"<=1000)
filter(MOD("N",100)=1000)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "A"[NUMBER,22]
2 - "DEMO1".ROWID[ROWID,10]
Having two operations, the filter removes the rows on the output of the index range scan on line 2 and then has to go to the table only for rows that remain. No additional buffer reads on this step 1 when there are no rows. With Oracle, we build indexes to optimize the access predicates and we add columns to optimize the filter predicate. We can go further by adding all projections and avoid completely the access to the table, but that is not always needed. If we can apply all where clause filters on the indexed columns, then the access to the table remains proportional to the result. And the end-user usually accept longer response time for long results. And index access response time is proportional to the result.
The decomposition in two operations is also convenient to see which columns projection is done for the index result or the table result. Here the only output of the index range scan at line 2 is the ROWID and the output from the table access at line 1 is the column we select. So, we have two operations here. We have seen that INDEX RANGE SCAN can run alone. And we will see in the next post that the TABLE ACCESS BY INDEX ROWID can also run alone.
So what?I hope that Postgres experts will comment about the need to read the table pages even when we can filter all rows from the index scan. We can do something similar by re-writing the query where we can see that the access to the table is never executed:
explain (analyze,verbose,costs,buffers) select a from demo1 where n in (select n from demo1 where n<=1000 and mod(n,100)=1000 ) ;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=0.57..76.35 rows=5 width=4) (actual time=0.285..0.285 rows=0 loops=1)
Output: demo1.a
Buffers: shared hit=5
-> Index Only Scan using demo1_n on public.demo1 demo1_1 (cost=0.29..34.78 rows=5 width=4) (actual time=0.284..0.284 rows=0 loops=1)
Output: demo1_1.n
Index Cond: (demo1_1.n <= 1000)
Filter: (mod(demo1_1.n, 100) = 1000)
Rows Removed by Filter: 1000
Heap Fetches: 0
Buffers: shared hit=5
-> Index Scan using demo1_n on public.demo1 (cost=0.29..8.30 rows=1 width=8) (never executed)
Output: demo1.n, demo1.a, demo1.x
Index Cond: (demo1.n = demo1_1.n)
But this involves a join, and join methods will deserve another series of blog posts. The next one on access paths will show the TABLE ACCESS BY INDEX ROWID equivalent, Tid Scan. Then I’ll have covered all access paths.
Cet article Postgres vs. Oracle access paths VIII – Index Scan and Filter est apparu en premier sur Blog dbi services.
performance impact of CLOB's in table
performance tuning
How to eliminate TABLE ACCESS FULL
Sql Plan Managment (SPM) 12c - Evolve Procedure stuck on some SQL's
Character conversion from one character set to another
Unsupported type PL/SQL datatype in dot net program
Fundamentals: Create Trigger and Create Sequence
Linux Containers - Container LInux: Core OS - a minimal linux? A quick overview: diskspace, mounts, commands, kernel, ...
- os virtualization like VMware, Virtualbox, etc.
- container virtualization like Docker, etc.
Everybody is familiar with the first category. Creation of virtual machines is well known and most of us have created already tens or hundreds of such machines. (and deleted and lost them after some weeks). One of the benefits is, that it is easy to run additional machines on our laptops / workstations.
The second category is rarely used on laptops / workstations. This is something for computer rooms or data centers only.
Both categories reduce the amount of hardware needed - but management of all theses virtual entities has still to be done.
But for some workloads solutions are proposed like Kubernetes or Apache Mesos. Never heard about? ;-)
Kubernetes orchestrates containers and Core OS is providing a minimal Container Linux operating system, which can be used by Kubernetes.
$ uname -a
Linux localhost 4.11.9-coreos #1 SMP ......Diskspace used is only 244 megabytes:
Filesystem Size Used Avail Use% Mounted on
devtmpfs 361M 0 361M 0% /dev
tmpfs 499M 0 499M 0% /dev/shm
tmpfs 499M 13M 486M 3% /run
tmpfs 499M 0 499M 0% /sys/fs/cgroup
tmpfs 499M 8.0M 491M 2% /
/dev/loop0 244M 244M 0 100% /usr
tmpfs 499M 0 499M 0% /media
tmpfs 499M 0 499M 0% /tmp
tmpfs 100M 0 100M 0% /run/user/500Filesystems:
...
tmpfs on / type tmpfs (rw,relatime,seclabel,mode=755)
/usr.squashfs (deleted) on /usr type squashfs (ro,relatime,seclabel)
selinuxfs on /sys/fs/selinux type selinuxfs (rw,relatime)
tmpfs on /media type tmpfs (rw,nosuid,nodev,noexec,relatime,seclabel)
tmpfs on /tmp type tmpfs (rw,nosuid,nodev,seclabel)
...
Available commands /bin (/bin is a softlink to /usr/bin):
core@localhost ~ $ ls /bin
'[' ip rview
actool ipcmk rvim
arch ipcrm scanelf
arping ipcs scanmacho
attr iptables-xml sclient
aulast isosize scmp_sys_resolver
aulastlog join scp
ausyscall journalctl script
autopoint jq scriptreplay
auvirt js-config sdiff
awk k5srvutil sechecker
base32 kadmin secon
base64 kbxutil sed
basename kdestroy sediff
bash kernel-install seinfo
bashbug keyctl semodule_deps
block-until-url kill semodule_expand
bootctl kinit semodule_link
bsdcat klist semodule_package
bsdcpio kmod semodule_unpackage
bsdiff kpasswd seq
bsdtar krb5-config sesearch
bspatch ksba-config setarch
bunzip2 ksu setfacl
busctl kswitch setfattr
bzcat ktutil setsid
bzcmp kvno setterm
bzdiff last sftp
bzegrep lastb sg
bzfgrep lastlog sh
bzgrep ldapadd sha1sum
bzip2 ldapcompare sha224sum
bzip2recover ldapdelete sha256sum
bzless ldapexop sha384sum
bzmore ldapmodify sha512sum
c_rehash ldapmodrdn shlibsign
cal ldappasswd shred
captest ldapsearch shuf
captoinfo ldapurl sim_client
cat ldapwhoami slabtop
catchsegv ldbadd sleep
cgpt ldbdel sntp
chacl ldbedit sort
chage ldbmodify sotruss
chattr ldbrename split
chcon ldbsearch sprof
chfn ldd sqlite3
chgrp lddtree ssh
chkcon less ssh-add
chmod lessecho ssh-agent
chown lesskey ssh-copy-id
chroot lesspipe ssh-keygen
chrt libassuan-config ssh-keyscan
chsh libgcrypt-config sss_ssh_authorizedkeys
cksum liblinear-predict sss_ssh_knownhostsproxy
clear liblinear-train stat
cmp link stdbuf
col linux32 strace
colcrt linux64 strace-log-merge
colrm ln stty
column locale su
comm localectl sudo
containerd localedef sudoedit
containerd-shim locksmithctl sudoreplay
coredumpctl logger sum
coreos-cloudinit login symcryptrun
coreos-install loginctl symtree
coreos-metadata logname sync
cp look systemctl
csplit ls systemd-analyze
ctr lsattr systemd-ask-password
curl lsblk systemd-cat
curl-config lscpu systemd-cgls
cut lsipc systemd-cgtop
date lslocks systemd-delta
dbus-binding-tool lslogins systemd-detect-virt
dbus-cleanup-sockets lsmod systemd-escape
dbus-daemon lsns systemd-firstboot
dbus-launch lsof systemd-hwdb
dbus-monitor lsscsi systemd-inhibit
dbus-run-session lsusb systemd-machine-id-setup
dbus-send lzcat systemd-mount
dbus-test-tool lzcmp systemd-notify
dbus-update-activation-environment lzdiff systemd-nspawn
dbus-uuidgen lzegrep systemd-path
dd lzfgrep systemd-resolve
delv lzgrep systemd-run
df lzless systemd-socket-activate
dgawk lzma systemd-stdio-bridge
diff lzmadec systemd-sysusers
diff3 lzmainfo systemd-tmpfiles
dig lzmore systemd-tty-ask-password-agent
dir machinectl systemd-umount
dircolors makedb tabs
dirmngr mayday tac
dirmngr-client mcookie tail
dirname md5sum tailf
dmesg mkdir tar
dnsdomainname mkfifo taskset
dnssec-dsfromkey mknod tdbbackup
dnssec-importkey mkpasswd tdbdump
dnssec-keyfromlabel mktemp tdbrestore
dnssec-keygen modinfo tdbtool
dnssec-revoke more tee
dnssec-settime mount test
dnssec-signzone mountpoint tic
dnssec-verify mpicalc tickadj
docker msgattrib timedatectl
docker-containerd msgcat timeout
docker-containerd-shim msgcmp tload
docker-proxy msgcomm toe
docker-runc msgconv toolbox
dockerd msgen top
domainname msgexec touch
du msgfilter tpmd
dumpelf msgfmt tpmown
dumpsexp msggrep tput
e2size msginit tr
echo msgmerge true
egrep msgunfmt truncate
eject msguniq tset
env mv tsort
envsubst namei tty
etcd2 ncat tzselect
etcdctl ncurses5-config udevadm
ex ncursesw5-config ul
expand net umount
expiry netcap uname
expr netstat uname26
factor networkctl uncompress
faillog newgidmap unexpand
fallocate newgrp uniq
false newrole unlink
fgrep newuidmap unlzma
filecap ngettext unshare
find nice unxz
findcon nisdomainname unzip
findmnt nl unzipsfx
fleet nohup update-ssh-keys
fleetctl nproc update_engine_client
fleetd npth-config uptime
flock nsenter usb-devices
fmt nslookup usbhid-dump
fold nspr-config users
free nss-config utmpdump
funzip nsupdate uuclient
gapplication ntp-keygen uuidgen
gawk ntpdc vdir
gdbus ntpq vi
gencat ntptime view
getconf numfmt vim
getent od vimdiff
getfacl oldfind vmstat
getfattr openssl w
getopt passwd watch
gettext paste watchgnupg
gettext.sh pathchk wc
gettextize pcap-config wdctl
gflags_completions.sh pcprofiledump wget
gio-querymodules pcre-config whereis
git pcregrep which
git-cvsserver pcretest who
git-receive-pack pg whoami
git-shell pgawk whois
git-upload-archive pgrep x86_64
git-upload-pack pidof x86_64-cros-linux-gnu-curl-config
glib-compile-resources pinentry x86_64-cros-linux-gnu-gpg-error-config
glib-compile-schemas pinentry-curses x86_64-cros-linux-gnu-krb5-config
glib-genmarshal pinentry-tty x86_64-cros-linux-gnu-libgcrypt-config
glib-gettextize ping x86_64-cros-linux-gnu-nspr-config
gmsgfmt ping6 x86_64-cros-linux-gnu-nss-config
gobject-query pinky x86_64-cros-linux-gnu-pcre-config
gpasswd pkaction x86_64-cros-linux-gnu-xml2-config
gpg pkcheck xargs
gpg-agent pkexec xenstore
gpg-connect-agent pkill xgettext
gpg-error pkttyagent xml2-config
gpg-error-config pldd xmlcatalog
gpg2 pmap xmllint
gpgconf pr xmlwf
gpgparsemail printenv xtrace
gpgscm printf xz
gpgsm prlimit xzcat
gpgtar protoc xzcmp
gpgv ps xzdec
gpgv2 pscap xzdiff
grep pspax xzegrep
gresource ptx xzfgrep
groups pwd xzgrep
gsettings pwdx xzless
gss-client quota xzmore
gtester quotasync yes
gunzip randstat ypdomainname
gzexe rbash zcat
gzip readlink zcmp
head realpath zdiff
hexdump recode-sr-latin zdump
hmac256 rename zegrep
host renice zfgrep
hostid replcon zforce
hostname reset zgrep
hostnamectl rev zic
i386 rkt zip
iconv rm zipcloak
id rmdir zipgrep
ifconfig rngtest zipinfo
igawk rootdev zipnote
indexcon route zipsplit
infocmp rpcgen zless
infotocap rsync zmore
install runc znew
ionice runcon
Available commands /sbin (/sbin is a softlink to /usr/sbin):
core@localhost ~ $ ls /sbin/
adcli getfilecon modinfo sm-notify
addgnupghome getpcaps modprobe ss
addpart getpidcon mount.nfs sserver
agetty getsebool mount.nfs4 sshd
applygnupgdefaults getseuser mpathpersist sss_cache
arp groupadd multipath sss_debuglevel
auditctl groupdel multipathd sss_groupadd
augenrules groupmems nameif sss_groupdel
autrace groupmod newusers sss_groupmod
avcstat grpck nfsidmap sss_groupshow
badblocks grpconv nfsstat sss_override
blkdeactivate grpunconv nologin sss_seed
blkdiscard gss-server nscd sss_useradd
blkid halt nstat sss_userdel
blockdev hwclock ntpd sss_usermod
brctl iconvconfig ntpdate sssd
bridge ifcfg nvme start-statd
btrfs ifstat open_init_pty sulogin
btrfs-convert init osd_login swaplabel
btrfs-debug-tree insmod pam_tally swapoff
btrfs-find-root ip6tables pam_tally2 swapon
btrfs-image ip6tables-apply pam_timestamp_check switch_root
btrfs-map-logical ip6tables-restore parted sysctl
btrfs-select-super ip6tables-save partprobe tc
btrfs-show-super ipmaddr partx tcsd
btrfs-zero-log ipset pdata_tools telinit
btrfsck iptables pivot_root testsaslauthd
btrfstune iptables-apply plipconfig thin_check
cache_check iptables-restore pluginviewer thin_dump
cache_dump iptables-save policyvers thin_metadata_size
cache_metadata_size iptunnel poweroff thin_repair
cache_repair iscsi-iname pvchange thin_restore
cache_restore iscsi_discovery pvck thin_rmap
capsh iscsiadm pvcreate togglesebool
cfdisk iscsid pvdisplay tpm_hostpolicy
cgdisk iscsistart pvmove traceroute6
chcpu kadmin.local pvremove tune2fs
checkarray kadmind pvresize umount.nfs
chgpasswd kdb5_util pvs umount.nfs4
chpasswd kdump pvscan unix_chkpwd
compute_av kexec pwcheck unix_update
compute_create key.dns_resolver pwck update-ca-certificates
compute_member kpartx pwconv update_engine
compute_relabel kprop pwunconv update_engine_stub
compute_user kpropd quot useradd
consoletype kproplog quotacheck userdel
convertquota krb5-send-pr quotaoff usermod
coreos-postinst krb5kdc quotaon uuidd
coreos-setgoodroot ldattach quotastats uuserver
coreos-tmpfiles ldconfig rarp veritysetup
cryptsetup lnstat raw vgcfgbackup
ctrlaltdel load_policy readprofile vgcfgrestore
ctstat logoutd realm vgchange
debugfs logrotate reboot vgck
delpart logsave repquota vgconvert
depmod losetup request-key vgcreate
dhcpcd lshw resize2fs vgdisplay
dmeventd lsmod resizepart vgexport
dmsetup lspci restorecon vgextend
dmstats lvchange rmmod vgimport
dumpe2fs lvconvert rngd vgimportclone
e2freefrag lvcreate routef vgmerge
e2fsck lvdisplay routel vgmknodes
e2image lvextend rpc.idmapd vgreduce
e2label lvm rpc.mountd vgremove
e2undo lvmchange rpc.nfsd vgrename
e4defrag lvmconf rpc.rquotad vgs
ebtables lvmconfig rpc.statd vgscan
ebtables-restore lvmdiskscan rpcbind vgsplit
edquota lvmdump rpcdebug vigr
era_check lvmetad rpcinfo vipw
era_dump lvmsadc rtacct visudo
era_invalidate lvmsar rtcwake vmcore-dmesg
era_restore lvreduce rtmon warnquota
ethtool lvremove rtpr wipefs
exportfs lvrename rtstat xfs_admin
fdisk lvresize run_init xfs_bmap
filefrag lvs runlevel xfs_copy
findfs lvscan runuser xfs_db
fixparts matchpathcon saslauthd xfs_estimate
fsadm mcstransd sefcontext_compile xfs_freeze
fsck mdadm selinux_check_securetty_context xfs_fsr
fsck.btrfs mdassemble selinuxexeccon xfs_growfs
fsck.cramfs mdmon semodule xfs_info
fsck.ext2 mii-tool sestatus xfs_io
fsck.ext3 mke2fs setcap xfs_logprint
fsck.ext4 mkfs setenforce xfs_mdrestore
fsck.ext4dev mkfs.bfs setfilecon xfs_metadump
fsck.minix mkfs.btrfs setfiles xfs_mkfile
fsck.xfs mkfs.cramfs setpci xfs_ncheck
fsfreeze mkfs.ext2 setquota xfs_quota
fstrim mkfs.ext3 setsebool xfs_repair
gdisk mkfs.ext4 sfdisk xfs_rtcp
genhomedircon mkfs.ext4dev sgdisk xqmstats
genl mkfs.minix showmount xtables-multi
getcap mkfs.xfs shutdown zramctl
getconlist mkhomedir_helper sim_server
getdefaultcon mklost+found slattach
getenforce mkswap sln
APEX Interactive Grids - what I've learned so far
Internal workings of APEX
Advantages of Exadata for a PL/SQL developer.
Pages
