【学习】
2022年阅读清单
-
Oracle 23c Beta Install Tips
Oracle 23c Beta Install Tips
-
Oracle SQLcl Tips
Oracle SQLcl Tips
Generating Table DDL in Oracle Database
Table DDL (and a lot of other DDL for that matter) can be generated using DBMS_METADATA. This package has been part of the Oracle database for a long time now and it is documented in the PL/SQL Packages and Types Guide.
DBMS_METADTA is very useful, but it requires a bit of code. And now SQLcl provides a shortcut to using the DBMS_METADATA invoking the PL/SQL API.
help show ddl ddl <schema>.<object_name> set ddl storage off set ddl emit_schema off set ddl segment_attributes off
-
Oracle SQLT Tips
Oracle SQLT Tips
What is SQLTXPLAIN (SQLT)?
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 1Z0-1072-21 Tips
Oracle Architect Associate Summary
-
MySQL Study 008 - user() and current_user() Tips
MySQL Study 008 - user() and current_user() Tips
- user()
- current_user
-
MySQL Study 007 - log_timestamps Tips
MySQL Study 007 - log_timestamps Tips
- Parameter : log_timestamps
-
MySQL Study 006 - sysbench tool Tips
MySQL Study 006 - sysbench tool Tips
- Install and test
- sysbench test mysql 8.0
-
Linux find du Tips
Linux find du Tips
find large file in linux filesystem.
- find
find /mdata -type f -printf '%s %p\n'| sort -nr | head -10 - du
du -a /mdata |sort -n -r |head -n 10
- find
-
Linux extend filesystem Tips
Linux extend filesystem Tips
How to extend filesystem in virtualbox Linux?
- /root filesystem free size is NOT enough.
-
MySQL Study 004 - Query table without primary key Tips
MySQL Study 004 - Query table without primary key Tips
- Query table without primary key
- The found non-primary key table splices out the SQL of the new primary key
-
MySQL Study 005 - Query unused Index Tips
MySQL Study 005 - Query unused Index Tips
- List unused indexes
-
MySQL Study 003 - PT Tool Install Tips
MySQL Study 003 - PT Tool Install Tips
- percona-toolkit Install
- yun / make install
- Oracle 23c Beta Install Tips
- Oracle SQLcl Tips
- Oracle SQLT Tips
- Oracle Architect Associate 1Z0-1072-21 Tips
- MySQL Study 008 - user() and current_user() Tips
- MySQL Study 007 - log_timestamps Tips
- MySQL Study 006 - sysbench tool Tips
- Linux find du Tips
- Linux extend filesystem Tips
- MySQL Study 004 - Query table without primary key Tips