Document Type | Technical Information
Category | Monitoring/Inspection
Applicable Product Versions | 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TMOTI025
Overview
The lsof command is used in Unix and Linux systems to check currently open files and the processes using them.
It is useful for DB monitoring and troubleshooting, and this document provides examples of lsof options.
Method
1. Check files opened by a specific process
- lsof -p <PID>
$ lsof -p 2181877 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME tbsvr 2181877 tibero cwd DIR 253,2 143 11382749 /home/tibero/yerin tbsvr 2181877 tibero rtd DIR 253,0 235 128 / tbsvr 2181877 tibero txt REG 253,2 685311160 12044659 /home/tibero/yerin/tibero7/bin/tbsvr tbsvr 2181877 tibero mem CHR 1,5 6 /dev/zero tbsvr 2181877 tibero DEL REG 0,1 5 /SYSV9ee33181 tbsvr 2181877 tibero mem REG 253,0 2539832 340 /usr/lib64/libc.so.6 tbsvr 2181877 tibero mem REG 253,2 5684136 809110656 /home/tibero/yerin/tibero7/lib/libspatial_c.so.0 tbsvr 2181877 tibero mem REG 253,2 54137416 807369279 /home/tibero/yerin/tibero7/lib/libspatial.so.0 tbsvr 2181877 tibero mem REG 253,2 1741408 807369278 /home/tibero/yerin/tibero7/lib/libgeos_c.so.1 tbsvr 2181877 tibero mem REG 253,2 25319064 809110657 /home/tibero/yerin/tibero7/lib/libgeos-3.7.3.so tbsvr 2181877 tibero mem REG 253,2 6494040 539102069 /home/tibero/yerin/tibero7/client/lib/libtbepl.so tbsvr 2181877 tibero mem REG 253,2 65536 270849864 /home/tibero/yerin/tibero7/instance/tibero/log/ilog/tibero-75.ilg tbsvr 2181877 tibero mem REG 253,2 65536 270849863 /home/tibero/yerin/tibero7/instance/tibero/log/ilog/tibero-74.ilg tbsvr 2181877 tibero mem REG 253,2 65536 270849862 /home/tibero/yerin/tibero7/instance/tibero/log/ilog/tibero-73.ilg ... tbsvr 2181877 tibero 83u REG 253,2 10485760 809110672 /home/tibero/yerin/tibero7/database/tibero/log003.log tbsvr 2181877 tibero 84u REG 253,2 3533146 539839297 /home/tibero/yerin/tibero7/instance/tibero/log/dlog/dbms.log tbsvr 2181877 tibero 85u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181877 tibero 86u REG 253,2 104857600 809110673 /home/tibero/yerin/tibero7/database/tibero/system001.dtf
2. Check processes using a specific file
- lsof /path/filename
$ lsof /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME tbsvr 2181865 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181867 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181868 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181868 tibero 42u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181869 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181869 tibero 41u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181870 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181871 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181872 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181873 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181874 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 34u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 37u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 39u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 42u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181875 tibero 43u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181876 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181876 tibero 26u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181876 tibero 40u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181876 tibero 50u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181877 tibero 4u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181877 tibero 65u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181877 tibero 68u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log tbsvr 2181877 tibero 85u REG 253,2 6654448 809110663 /home/tibero/yerin/tibero7/instance/tibero/log/slog/sys.log
3. Check processes opening a specific port
- lsof -i :[port number]
$ lsof -i :9292 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME tblistene 2181866 tibero 5u IPv4 2392346 0t0 TCP *:armtechdaemon (LISTEN)
4. Check ports in LISTEN state on TCP
- lsof -iTCP -sTCP:LISTEN
$ lsof -iTCP -sTCP:LISTEN COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME tblistene 36849 tibero 5u IPv4 61050 0t0 TCP *:8029 (LISTEN) tbsvr 36850 tibero 39u IPv4 61056 0t0 TCP *:8030 (LISTEN) tblistene 2181866 tibero 5u IPv4 2392346 0t0 TCP *:armtechdaemon (LISTEN) tbsvr 2181867 tibero 39u IPv4 2395271 0t0 TCP *:storview (LISTEN)
5. Check files opened by a specific user
- lsof -u [user name]
$ lsof -u tibero lsof 2184184 tibero txt REG 253,0 179256 203624732 /usr/bin/lsof lsof 2184184 tibero mem REG 253,0 223542144 67727891 /usr/lib/locale/locale-archive lsof 2184184 tibero mem REG 253,0 5436640 361 /usr/lib64/libcrypto.so.3.2.2 lsof 2184184 tibero mem REG 253,0 102552 57147 /usr/lib64/libz.so.1.2.11 lsof 2184184 tibero mem REG 253,0 70880 350 /usr/lib64/libresolv.so.2 lsof 2184184 tibero mem REG 253,0 23992 57471 /usr/lib64/libkeyutils.so.1.10 lsof 2184184 tibero mem REG 253,0 906400 518131 /usr/lib64/libkrb5.so.3.3 lsof 2184184 tibero mem REG 253,0 636840 57431 /usr/lib64/libpcre2-8.so.0.11.0 lsof 2184184 tibero mem REG 253,0 2539832 340 /usr/lib64/libc.so.6 lsof 2184184 tibero mem REG 253,0 66320 518133 /usr/lib64/libkrb5support.so.0.1 lsof 2184184 tibero mem REG 253,0 23872 57282 /usr/lib64/libcom_err.so.2.1 lsof 2184184 tibero mem REG 253,0 99120 518125 /usr/lib64/libk5crypto.so.3.1 lsof 2184184 tibero mem REG 253,0 358576 518121 /usr/lib64/libgssapi_krb5.so.2.2 lsof 2184184 tibero mem REG 253,0 196216 515815 /usr/lib64/libtirpc.so.3.0.0 lsof 2184184 tibero mem REG 253,0 175760 348438 /usr/lib64/libselinux.so.1 lsof 2184184 tibero mem REG 253,0 892528 335 /usr/lib64/ld-linux-x86-64.so.2 lsof 2184184 tibero 4r FIFO 0,13 0t0 2402491 pipe lsof 2184184 tibero 7w FIFO 0,13 0t0 2402492 pipe ...
6. Check processes using deleted files
- lsof | grep deleted
$ lsof | grep deleted tbsvr 36848 tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36848 tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tblistene 36849 tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tblistene 36849 tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36975 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36975 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36976 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36976 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36977 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36977 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36978 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36978 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36993 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36993 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36996 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36996 tbsvr tibero 1u CHR 136,0 0t0 3 /dev/pts/0 (deleted) tbsvr 36850 36998 tbsvr tibero 0u CHR 136,0 0t0 3 /dev/pts/0 (deleted) ...
7. Check files opened in a specific directory (including subdirectories)
- lsof +D /path/directory_name
$ lsof +D /home/tibero/yerin/tibero7/client/lib/ COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME tbsvr 2181865 tibero mem REG 253,2 6494040 539102069 /home/tibero/yerin/tibero7/client/lib/libtbepl.so tbsvr 2181865 tibero mem REG 253,2 1238872 539102064 /home/tibero/yerin/tibero7/client/lib/libtbextb.so tbsvr 2181865 tibero mem REG 253,2 102123912 539102076 /home/tibero/yerin/tibero7/client/lib/libtbclnt.so tbsvr 2181867 tibero mem REG 253,2 6494040 539102069 /home/tibero/yerin/tibero7/client/lib/libtbepl.so tbsvr 2181867 tibero mem REG 253,2 1238872 539102064 /home/tibero/yerin/tibero7/client/lib/libtbextb.so tbsvr 2181867 tibero mem REG 253,2 102123912 539102076 /home/tibero/yerin/tibero7/client/lib/libtbclnt.so tbsvr 2181868 tibero mem REG 253,2 6494040 539102069 /home/tibero/yerin/tibero7/client/lib/libtbepl.so tbsvr 2181868 tibero mem REG 253,2 1238872 539102064 /home/tibero/yerin/tibero7/client/lib/libtbextb.so tbsvr 2181868 tibero mem REG 253,2 102123912 539102076 /home/tibero/yerin/tibero7/client/lib/libtbclnt.so tbsvr 2181869 tibero mem REG 253,2 6494040 539102069 /home/tibero/yerin/tibero7/client/lib/libtbepl.so tbsvr 2181869 tibero mem REG 253,2 1238872 539102064 /home/tibero/yerin/tibero7/client/lib/libtbextb.so tbsvr 2181869 tibero mem REG 253,2 102123912 539102076 /home/tibero/yerin/tibero7/client/lib/libtbclnt.so ...
8. Check files opened by processes with a specific command name
- lsof -c [command name]
$ lsof -c lsof COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME lsof 2184219 tibero cwd DIR 253,2 143 11382749 /home/tibero/yerin lsof 2184219 tibero rtd DIR 253,0 235 128 / lsof 2184219 tibero txt REG 253,0 179256 203624732 /usr/bin/lsof lsof 2184219 tibero mem REG 253,0 223542144 67727891 /usr/lib/locale/locale-archive lsof 2184219 tibero mem REG 253,0 5436640 361 /usr/lib64/libcrypto.so.3.2.2 lsof 2184219 tibero mem REG 253,0 102552 57147 /usr/lib64/libz.so.1.2.11 lsof 2184219 tibero mem REG 253,0 70880 350 /usr/lib64/libresolv.so.2 lsof 2184219 tibero mem REG 253,0 23992 57471 /usr/lib64/libkeyutils.so.1.10 lsof 2184219 tibero mem REG 253,0 66320 518133 /usr/lib64/libkrb5support.so.0.1 lsof 2184219 tibero mem REG 253,0 99120 518125 /usr/lib64/libk5crypto.so.3.1 lsof 2184219 tibero mem REG 253,0 906400 518131 /usr/lib64/libkrb5.so.3.3 lsof 2184219 tibero mem REG 253,0 358576 518121 /usr/lib64/libgssapi_krb5.so.2.2 lsof 2184219 tibero mem REG 253,0 2539832 340 /usr/lib64/libc.so.6 lsof 2184219 tibero mem REG 253,0 23872 57282 /usr/lib64/libcom_err.so.2.1 lsof 2184219 tibero mem REG 253,0 636840 57431 /usr/lib64/libpcre2-8.so.0.11.0 lsof 2184219 tibero mem REG 253,0 196216 515815 /usr/lib64/libtirpc.so.3.0.0 lsof 2184219 tibero mem REG 253,0 175760 348438 /usr/lib64/libselinux.so.1 lsof 2184219 tibero mem REG 253,0 892528 335 /usr/lib64/ld-linux-x86-64.so.2 lsof 2184219 tibero 0u CHR 136,2 0t0 5 /dev/pts/2 lsof 2184219 tibero 1u CHR 136,2 0t0 5 /dev/pts/2 ...