Oracle SQLT Tips
SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise - ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed.
Licensing (SQLT requires no license and is FREE)
Execution plans, execution statistics, data volume, etc. Those have to be taken for the same query(ies) from different env.
SQLT helps gathering these info.
Oracle Architect Associate Summary
MySQL Study 008 - user() and current_user() Tips
MySQL Study 007 - log_timestamps Tips
MySQL Study 006 - sysbench tool Tips
Linux find du Tips
find large file in linux filesystem.
find /mdata -type f -printf '%s %p\n'| sort -nr | head -10
du -a /mdata |sort -n -r |head -n 10
Linux extend filesystem Tips
How to extend filesystem in virtualbox Linux?
MySQL Study 004 - Query table without primary key Tips
MySQL Study 005 - Query unused Index Tips
MySQL Study 003 - PT Tool Install Tips
MasOS SSH UTF8 Error Tips
There is LC_CTYPE error while connect to VM via ssh.
YourMacBook-Pro ~ % ssh root@127.0.0.1 -p2223
root@127.0.0.1's password:
Last login: Wed Mar 2 11:00:35 2022 from gateway
-bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
[root@centos7 ~]#
Edit /etc/ssh/ssh_config and comment out SendEnv LANG LC_*.
YourMacBook-Pro:~ you$ sudo vi /etc/ssh/ssh_config
## SendEnv LANG LC_*
warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
Have a good work&life! 2022/03 via LinHong
MySQL Study 002 - ROWNUM Tips
There is NOT row_num function in MySQL.
How to achieve this function in MySQL?