Lin Hong's TECH Blog!
刀不磨要生锈,人不学习要落后 - Thinking ahead
Home
Archives
Categories
Tags
About
Archives
2024
2024-08-30 Fri.
Oracle 23ai scripts Tips
Oracle
Oracle
Tips
2024-08-30 Fri.
Oracle 19c Linux 8 Install Tips
Oracle
Oracle
Tips
2024-07-31 Wed.
Oracle 23ai Linux 9 Install Tips
Oracle
Oracle
Tips
2024-06-10 Mon.
Oracle 23c Shrink Bigfile tablespace Tips
Oracle
Oracle
Tips
2024-06-10 Mon.
Oracle 23c ock-free reservation Tips
Oracle
Oracle
Tips
2023
2023-10-10 Tue.
Oracle 23c SSB setting Tips
Oracle
Oracle
Tips
2023-10-10 Tue.
Oracle 23c SQL Diagnostic Report Tips
Oracle
Oracle
Tips
2023-10-10 Tue.
Oracle 23c set user password limit Tips
Oracle
Oracle
Tips
2023-10-10 Tue.
Oracle 23c dbcs basic Tips
Oracle
Oracle
Tips
2023-10-10 Tue.
Oracle 23c create acfs in dbcs Tips
Oracle
Oracle
Tips
2023-08-07 Mon.
Oracle CONTROL_FILE_RECORD_KEEP_TIME Tips
Oracle
Oracle
Tips
2023-06-11 Sun.
Oracle NLS_DATE_FORMAT Tips
Oracle
Oracle
Tips
2023-04-11 Tue.
Oracle 23c Free rpm install Tips
Oracle
Oracle
23c
Tips
2023-03-16 Thu.
MySQL 8.0 Study 015 Tips
MySQL
MySQL
Tips
2023-03-03 Fri.
MySQL 8.0 Study 014 Tips
MySQL
MySQL
Tips
2023-03-01 Wed.
Oracle drop user trace Tips
Oracle
Oracle
Tips
2023-03-01 Wed.
MySQL 8.0 Study 000 Tips
MySQL
MySQL
scripts
Tips
2023-02-24 Fri.
Oracle kill sql lock Tips
Oracle
Oracle
Tips
2023-02-21 Tue.
MySQL 8.0 Study 013 Tips
MySQL
MySQL
Tips
2023-02-21 Tue.
MySQL 8.0 Study 012 Tips
MySQL
MySQL
Tips
2023-02-20 Mon.
Oracle Migration Methods Advisor Tips
Oracle
Oracle
Tips
2023-02-20 Mon.
Oracle Linux Kernel Tips
Oracle
Oracle
Tips
2023-02-20 Mon.
MySQL 8.0 Study 011 Tips
MySQL
MySQL
Tips
2023-02-15 Wed.
Oracle UNDO tablespace size Tips
Oracle
Oracle
scripts
Tips
2023-02-12 Sun.
MySQL 8.0 Study 010 Tips
MySQL
MySQL
Tips
2023-02-12 Sun.
MySQL 8.0 Study 009 Tips
MySQL
MySQL
Tips
2023-02-03 Fri.
MySQL 8.0 Study 008 Tips
MySQL
MySQL
Tips
2023-02-01 Wed.
MySQL 8.0 Study 007 Tips
MySQL
MySQL
Tips
2023-01-30 Mon.
MySQL 8.0 Study 006 Tips
MySQL
MySQL
Tips
2023-01-28 Sat.
Exadata CoD Tips
Exadata
Exadata
Tips
2023-01-28 Sat.
MySQL 8.0 Study 005 Tips
MySQL
MySQL
Tips
2023-01-27 Fri.
OCI SSH Key Tips
OCI
OCI
Tips
2023-01-27 Fri.
MySQL 8.0 Study 004 Tips
MySQL
MySQL
Tips
2023-01-27 Fri.
MySQL 8.0 Study 003 Tips
MySQL
MySQL
Tips
2023-01-21 Sat.
MySQL 8.0 Tpcc-mysql Test Tips
MySQL
MySQL
Tips
2023-01-21 Sat.
MySQL 8.0 Study 002 Tips
MySQL
MySQL
Tips
2023-01-21 Sat.
MySQL 8.0 Study 001 Tips
MySQL
MySQL
Tips
2023-01-19 Thu.
Oracle 23c awr_cdb_wr_control Tips
Oracle
Oracle
23c
Tips
2023-01-13 Fri.
MySQL dbdeployer tool Tips
MySQL
MySQL
Tips
2023-01-13 Fri.
MySQL Linux Slow Io Simulate Tips
MySQL
MySQL
Tips
2023-01-13 Fri.
MySQL Functional Index Tips
MySQL
MySQL
Tips
2023-01-03 Tue.
Oracle OCI Resize root volume Tips
Oracle
Oracle
OCI
Tips
2022
2022-12-21 Wed.
Oracle OCW2022 RWP Performance Up Tips
Oracle
Oracle
Performance
Tips
2022-12-21 Wed.
Oracle 23c New features - SQL_HISTORY_ENABLED Tips
Oracle
Oracle
23c
Features
Tips
2022-12-21 Wed.
Oracle 23c New features - smco process Tips
Oracle
Oracle
23c
Features
Tips
2022-12-21 Wed.
Oracle 23c New features - MAX_COLUMNS Tips
Oracle
Oracle
23c
Features
Tips
2022-12-21 Wed.
Oracle 23c New features - Data Quality Operators in Oracle Database Tips
Oracle
Oracle
23c
Features
Tips
2022-12-20 Tue.
Oracle ADB export data to Other Database Tips
Oracle
Oracle
23c
Tips
2022-12-20 Tue.
Oracle 23c export table data to csv via sql Tips
Oracle
Oracle
23c
Tips
2022-12-20 Tue.
Oracle 23c New features - Real-Time SQL Monitoring Enhancements Tips
Oracle
Oracle
23c
Features
Tips
2022-12-20 Tue.
Oracle 23c New features - Automatic Parallel Direct Path Load Using SQL*Loader Tips
Oracle
Oracle
23c
Features
Tips
2022-12-20 Tue.
Oracle 23c New features - Evolution of Oracle Homes Tips
Oracle
Oracle
23c
Features
Tips
2022-12-20 Tue.
Oracle 23c New features - Control PDB Open Order Enhancements Tips
Oracle
Oracle
23c
Features
Tips
2022-12-20 Tue.
Oracle 23c create user values Tips
Oracle
Oracle
23c
Tips
2022-12-19 Mon.
Oracle 23c New features - Encryption of Tablespaces in an Oracle Data Guard Tips
Oracle
Oracle
23c
Features
Tips
2022-12-19 Mon.
Oracle 23c New features - DBCA Support for Standard Edition High Availability Tips
Oracle
Oracle
23c
Features
Tips
2022-12-19 Mon.
MacOS restart ssh Tips
Linux
Linux
ssh
Tips
2022-12-16 Fri.
Oracle 23c Store AWR Snapshots In User Defined Tablespace Tips
Oracle
Oracle
23c
awr
Tips
2022-12-15 Thu.
Oracle 23c New features - sql_transpiler Tips
Oracle
Oracle
23c
Features
Tips
2022-12-15 Thu.
Oracle 23c New features - Parallel DML Tips
Oracle
Oracle
23c
Features
Tips
2022-12-14 Wed.
Oracle 23c New features - Update Using Direct Join Tips
Oracle
Oracle
23c
Features
Tips
2022-12-14 Wed.
Oracle 23c New features - IF EXISTS Tips
Oracle
Oracle
23c
Features
Tips
2022-12-14 Wed.
Oracle 23c New features - Develop role Tips
Oracle
Oracle
23c
Features
Tips
2022-12-13 Tue.
Oracle Developer Tools for VS Code (SQL and PLSQL) Tips
Oracle
Oracle
Developer
Tips
2022-12-13 Tue.
Oracle 23c recover table from rman Tips
Oracle
Oracle
23c
Tips
2022-11-28 Mon.
Oracle 23c PDB parameters Tips
Oracle
Oracle
23c
Tips
2022-10-28 Fri.
Oracle 23c Beta Install Tips
Oracle
Oracle
23c
Tips
2022-06-10 Fri.
Oracle SQLcl Tips
Oracle
Oracle
SQLcl
Tips
2022-04-27 Wed.
Oracle SQLT Tips
Oracle
Oracle
SQLT
Tips
2022-03-30 Wed.
Oracle Architect Associate 1Z0-1072-21 Tips
OCI
OCI
Tips
2022-03-13 Sun.
MySQL Study 008 - user() and current_user() Tips
MySQL
MySQL
Tips
2022-03-08 Tue.
MySQL Study 007 - log_timestamps Tips
MySQL
MySQL
Tips
2022-03-03 Thu.
MySQL Study 006 - sysbench tool Tips
MySQL
MySQL
sysbench
tpcc
Tips
2022-03-03 Thu.
Linux find du Tips
Linux
Linux
find
du
Tips
2022-03-03 Thu.
Linux extend filesystem Tips
Linux
Linux
Tips
2022-03-02 Wed.
MySQL Study 004 - Query table without primary key Tips
MySQL
MySQL
Tips
2022-03-02 Wed.
MySQL Study 005 - Query unused Index Tips
MySQL
MySQL
Tips
2022-03-01 Tue.
MySQL Study 003 - PT Tool Install Tips
MySQL
MySQL
Tips
2022-03-01 Tue.
MasOS SSH UTF8 Error Tips
OS
OS
Tips
2022-02-28 Mon.
MySQL Study 002 - ROWNUM Tips
MySQL
MySQL
Tips
SQL
2022-02-22 Tue.
MySQL Study 001 - Install Tips
MySQL
MySQL
Tips
2022-02-22 Tue.
Linux perl error in bash Tips
Linux
Linux
Tips
2022-02-20 Sun.
Oracle Basic SQL 014 Tips
Oracle
Oracle
SQL
Tips
2022-02-20 Sun.
Oracle Basic SQL 013 Tips
Oracle
Oracle
SQL
Tips
2022-02-20 Sun.
Oracle Basic SQL 012 Tips
Oracle
Oracle
SQL
Tips
2022-02-20 Sun.
Oracle Basic SQL 011 Tips
Oracle
Oracle
SQL
Tips
2022-02-19 Sat.
Oracle Basic SQL 010 Tips
Oracle
Oracle
SQL
Tips
2022-02-19 Sat.
Oracle Basic SQL 009 Tips
Oracle
Oracle
SQL
Tips
2022-02-19 Sat.
Oracle Basic SQL 008 Tips
Oracle
Oracle
SQL
Tips
2022-02-18 Fri.
Oracle Basic SQL 007 Tips
Oracle
Oracle
SQL
Tips
2022-02-18 Fri.
Oracle Basic SQL 006 Tips
Oracle
Oracle
SQL
Tips
2022-02-18 Fri.
Oracle Basic SQL 005 Tips
Oracle
Oracle
SQL
Tips
2022-02-18 Fri.
Oracle Basic SQL 004 Tips
Oracle
Oracle
SQL
Tips
2022-02-17 Thu.
Oracle Basic SQL 003 Tips
Oracle
Oracle
SQL
Tips
2022-02-17 Thu.
Oracle Basic SQL 002 Tips
Oracle
Oracle
SQL
Tips
2022-02-16 Wed.
Oracle Basic SQL 001 Tips
Oracle
Oracle
SQL
Tips
2022-02-06 Sun.
Oracle Different Code PDB Tips
Oracle
Oracle
Tips
2022-01-20 Thu.
Oracle dbca ORA-04062 Tips
Oracle
Oracle
Tips
2022-01-20 Thu.
Oracle awrinfo sql Tips
Oracle
Oracle
Tips
2022-01-19 Wed.
Oracle SYSAUX huge space Tips
Oracle
Oracle
Tips
2022-01-05 Wed.
Oracle rman catalog Tips
Oracle
Oracle
Tips
2021
2021-12-06 Mon.
Oracle sqlcl Tips
Oracle
Oracle
Tips
2021-11-19 Fri.
Oracle 19c index stats[ORA-20005] Tips
Oracle
Oracle
Tips
2021-10-20 Wed.
Oracle session reset parameter Tips
Oracle
Oracle
Tips
2021-10-08 Fri.
Oracle Sample Schema Tips
Oracle
Oracle
Tips
2021-10-08 Fri.
Oracle Calibrate IO Test Tips
Oracle
Oracle
Tips
2021-10-08 Fri.
Oracle ORA-01552 Tips
Oracle
Oracle
Tips
2021-09-24 Fri.
Oracle Monitor wrong password user Tips
Oracle
Oracle
Tips
2021-09-23 Thu.
Oracle Reset Linux 8 Root password Tips
Oracle
Oracle
linux
Tips
2021-08-30 Mon.
Oracle 21c RAC Linux 8 Install Tips
Oracle
Oracle
21c
RAC
Tips
2021-08-27 Fri.
Oracle nslookup Linux 8 Install Tips
Oracle
Oracle
linux
Tips
2021-08-18 Wed.
Oracle 19c mac os Client install Tips
Oracle
Oracle
19c
Tips
2021-08-18 Wed.
Oracle 19c TDE Tips
Oracle
Oracle
19c
TDE
Tips
2021-08-17 Tue.
Oracle 19c ORA-65179 Tips
Oracle
Oracle
19c
Tips
2021-08-14 Sat.
Oracle 21c Linux 8 Install Tips
Oracle
Oracle
21c
Tips
2021-08-14 Sat.
Oracle 19c 21c parameter different Tips
Oracle
Oracle
21c
Tips
2021-08-12 Thu.
Oracle 19c scheduler task Tips
Oracle
Oracle
19c
Tips
2021-08-01 Sun.
Oracle crsctl commands Tips
Oracle
Oracle
Tips
2021-07-28 Wed.
Oracle 19c Hint list Tips
Oracle
Oracle
hint
Tips
2021-07-23 Fri.
Oracle 19c Exadata Statistic Tips
Oracle
Oracle
hint
Tips
2021-07-22 Thu.
Oracle 19c use_concat Hint Tips
Oracle
Oracle
hint
Tips
2021-07-22 Thu.
Oracle 19c extract CAST Tips
Oracle
Oracle
Tips
2021-07-22 Thu.
Oracle 19c estimate index size Tips
Oracle
Oracle
Tips
2021-07-22 Thu.
Oracle 19c SQL Tuning Advisor Tips
Oracle
Oracle
Tips
2021-07-20 Tue.
Oracle 19c OPT_PARAM Hint Tips
Oracle
Oracle
sqldeveloper
Tips
2021-07-19 Mon.
Oracle MacOS SqlDevelper Tips
Oracle
Oracle
sqldeveloper
Tips
2021-07-19 Mon.
Oracle 19c Features in SQLDeveloper Tips
Oracle
Oracle
sqldeveloper
Tips
2021-07-19 Mon.
Oracle 19c OPatch 19.10 Tips
Oracle
Oracle
OPatch
Tips
2021-07-14 Wed.
Oracle get explain plan Tips
Oracle
Oracle
explain
Tips
2021-07-13 Tue.
Oracle Dataguard GAP Recovery Tips
Oracle
Oracle
Dataguard
Tips
2021-07-09 Fri.
Oracle HR emp and dept test Tips
Oracle
Oracle
Tips
2021-07-08 Thu.
Oracle 19c on Linux 8 Installation Tips
Oracle
Oracle
Virtualbox
Tips
2021-07-07 Wed.
Virtualbox Upgrade error Tips
Oracle
Oracle
Virtualbox
Tips
2021-07-06 Tue.
Oracle Index - Statics Tips
Oracle
Oracle
Index
Tips
2021-07-06 Tue.
Oracle Index - invisible Tips
Oracle
Oracle
Index
Tips
2021-07-06 Tue.
Oracle sqlplus plugin rlwrap install Tips
Oracle
Oracle
sqlplus
Tips
2020
2020-10-25 Sun.
Windows 10 Enable Hyper-V Tips
HyperV
Windows
HyperV
Tips
2020-09-13 Sun.
Oracle Create PDB Tips
Oracle
Oracle
PDB
Tips
2020-09-05 Sat.
Oracle Exadata Startup Shutdown Tips
Oracle
Oracle
Exadata
Tips
2020-09-05 Sat.
Oracle AWR Exadata Alert Tips
Oracle
Oracle
Exadata
Tips
2020-09-04 Fri.
Linux network issue Tips
Oracle
Linux
Network
Tips
2020-09-03 Thu.
Oracle Datapump lob table Tips
Oracle
Oracle
Datapump
Tips
2020-09-03 Thu.
Oracle Disable and Enable Constraint Tips
Oracle
Oracle
Datapump
Tips
2020-09-01 Tue.
Postgresql Primary Key CONSTRAINT Study 010 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql CONSTRAINT Study 009 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql CHECK Study 008 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql Temporary Table Study 007 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql pgbench Study 006 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql 12 Database Study 005 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql 12 Tablespace Study 004 Tips
Oracle
Postgres
Study
Tips
2020-09-01 Tue.
Postgresql 12 Connect Study 003 Tips
Oracle
Postgresql
Study
Tips
2020-09-01 Tue.
Postgresql 12 启动停止 Study 002 Tips
Oracle
Postgresql
Study
Tips
2020-09-01 Tue.
Postgresql 12 体系结构 Study 001 Tips
Oracle
Postgresql
Study
Tips
2020-08-18 Tue.
Oracle Exawatcher Tips
Oracle
Oracle
Exadata
Tips
2020-08-17 Mon.
Oracle Restore Tips
Oracle
Oracle
Restore
Tips
2020-05-14 Thu.
Oracle Parallel Tips
Oracle
Oracle
Parallel
Tips
2020-05-14 Thu.
Oracle 10046 event Tips
Oracle
Oracle
Tips
2020-04-14 Tue.
Oracle Hugepage Tips
Oracle
Oracle
Hugepage
Tips
2020-04-07 Tue.
Oracle AWR delete Tips
Oracle
Oracle
AWR
Tips
2020-04-04 Sat.
Github SpeedUp Tips
Git
Git
Tips
2020-04-01 Wed.
Markdown Tips
Markdown
Markdown
Tips
2020-03-31 Tue.
Oracle Flash Cache Hit Tips
Oracle
Oracle
Flash
Tips
2020-03-30 Mon.
Oracle Import Error Hit Tips
Oracle
Oracle
Import
Tips
2020-03-24 Tue.
Oracle 19c Poor Performance With DataPump Export
Oracle
Oracle
DataPump
Tips
2020-03-24 Tue.
Oracle Exadata Smart Flash Cache Tips
Oracle
Oracle
Exadata
Flash
Tips
2020-03-18 Wed.
Oracle 19c Wait event 'enq: KO - fast object checkpoint'
Oracle
Oracle
Event
Tips
2020-03-17 Tue.
Oracle 19c load awr report
Oracle
Oracle
awr
Tips
2020-03-17 Tue.
Oracle Recover Tips
Oracle
Oracle
Recover
Tips
2020-02-12 Wed.
Oracle 19c Analysis SQL in AWR report Tips
Oracle
Oracle
SQLloader
Tips
2020-02-11 Tue.
Oracle 19c online statistics gathering Tips
Oracle
Oracle
SQLloader
Tips
2020-02-10 Mon.
Oracle SQL loader Tips
Oracle
Oracle
SQLloader
Tips
scripts
2020-02-09 Sun.
Unix SSH Timeout Tips
Unix
Unix
SSH
Tips
2020-02-03 Mon.
Centos 7.6 + Postgresql 10 Install Tips
Postgresql
Centos
Postgres
Postgresql
Tips
2019
2019-12-01 Sun.
Ubuntu Change default editor Tips
Unix
Unix
Tips
2019-10-16 Wed.
Oracle Linux pstack Tips
Oracle
Oracle
Tips
12c
pstack
trace
2019-10-16 Wed.
Oracle Linux yum/wget proxy Tips
Oracle
Oracle
Linux
Tips
2019-09-04 Wed.
Oracle 12c PDB LOCKDOWN Profiles Tips
Oracle
Oracle
Tips
12c
2019-08-23 Fri.
Oracle 19c Query the patch Tips
Oracle
Oracle
Scripts
SQL
19c
2019-08-22 Thu.
Oracle 19c Import with disable_archive_logging Tips
Oracle
Oracle
Import
disable_archive_logging
Tips
2019-08-20 Tue.
Linux 7 enable Autostarting of Oracle Database 19c Tips
Linux
Oracle
autostart
Tips
2019-08-05 Mon.
Linux Visual-dstat Tips
Linux
Linux
dstat
Tips
2019-07-31 Wed.
The PLUSTRACE ROLE Tips
Oracle
Oracle
Autotrace
Tips
2019-07-18 Thu.
Unix Shell Tips
Oracle
Unix
Shell
Tips
2019-07-17 Wed.
Oracle Tools Tips
Oracle
Oracle
Tools
Tips
2019-07-15 Mon.
Oracle 12c MAX_IDLE_TIME Tips
Oracle
Oracle
MAX_IDLE_TIME
Tips
2019-07-15 Mon.
Oracle Drop User Tips
Oracle
Oracle
Tips
2019-07-15 Mon.
Oracle ATP Swingbench Tips
Oracle
Oracle
Tips
2019-07-13 Sat.
Oracle 19c Dataguard Standby DB Features Tips
Oracle
Oracle
19c
Dataguard
Tips
2019-07-04 Thu.
Oracle Top CPU Sql Tips
Oracle
Oracle
scripts
Tips
2019-07-01 Mon.
Oracle 1Z0-931 Tips
Oracle
Oracle
1Z0-931
Tips
2019-06-18 Tue.
Oracle 19c AutoIndex Tips
Oracle
Oracle
19c
AutoIndex
Tips
2019-06-07 Fri.
Oracle ADW Restrictions Tips
Oracle
Oracle
ADW
Tips
2019-06-03 Mon.
Linux Python3 Install Tips
Python
Unix
Python
Tips
2019-05-07 Tue.
Oracle Parameter Optimizer Tips
Oracle
Oracle
optimizer
Tips
2019-05-07 Tue.
Oracle_adw_swingbench_tips
2019-05-07 Tue.
Oracle ADW database_properties Tips
Oracle
Oracle
ADW
Tips
2019-05-07 Tue.
Oracle ADW Backup Tips
Oracle
Oracle
ADW
Tips
2019-05-04 Sat.
Linux/Unix list large file Tips
Unix
Unix
Tips
2019-04-18 Thu.
Oracle ADW Memory Tips
Oracle
Oracle
ADW
Tips
2019-03-26 Tue.
Oracle OCI CLI Setup Tips
Oracle
Oracle
ADW
Tips
2019-03-20 Wed.
Oracle ADW User Tips
Oracle
Oracle
ADW
Tips
2019-03-20 Wed.
Oracle ADW Storage Tips
Oracle
Oracle
ADW
Tips
2019-03-18 Mon.
Oracle ADW Statistics Tips
Oracle
Oracle
ADW
Tips
2019-03-18 Mon.
Oracle ADW Connect Tips
Oracle
Oracle
ADW
Tips
2019-03-13 Wed.
Oracle 19c SQL - Real-time SQL Monitoring for Developers Tips
Oracle
Oracle
19c
Tips
2019-03-13 Wed.
Oracle 19c SQL - COMPARE_PLANS Tips
Oracle
Oracle
19c
Tips
2019-03-13 Wed.
Oracle 19c SQL - HINT_REPORT Tips
Oracle
Oracle
19c
Tips
2019-03-12 Tue.
Oracle 19c Schema User Tips
Oracle
Oracle
Tips
2019-03-12 Tue.
Oracle 12c enable Flashback Database Tips
Oracle
Oracle
Tips
2019-02-21 Thu.
Oracle 18c XE windows Tips
Oracle
Oracle
Tips
2019-02-20 Wed.
Oracle 18c get SQLID Tips
Oracle
Oracle
Tips
2019-02-19 Tue.
Oracle 19c Automatic Indexing
Oracle
Tips
19c
2019-02-14 Thu.
Oracle 缩短备份恢复时间 Tips
Oracle
Tips
2019-02-14 Thu.
Oracle 19c
Oracle
Tips
2019-01-07 Mon.
Firefox Plugin Tips
Oracle
Tips
2019-01-06 Sun.
Oracle dbfs共享文件系统 Tips
Oracle
Oracle
Tips
2019-01-04 Fri.
Oracle Rman backup sctips Tips
Oracle
Tips
2019-01-03 Thu.
Oracle 18c enable dbhome readonly Tips
Oracle
Oracle
Tips
2018
2018-11-22 Thu.
Oracle 18c Private Temporary Table Tips
Oracle
Oracle
Tips
2018-11-02 Fri.
Oracle 12c Dataguard Error RMAN-05609 Tips
Oracle
Oracle
Tips
2018-10-22 Mon.
Oracle 18c RPM install Tips
Oracle
Oracle
Tips
2018-09-30 Sun.
Oracle dbca create database in DB18c Tips
Oracle
Oracle
Tips
2018-09-30 Sun.
Oracle Setting up the Star Schema Benchmark (SSB) with Import Tips
Oracle
Oracle
Tips
2018-09-29 Sat.
Oracle EM13c 02 - EMCC Install Tips
Oracle
Oracle
EMCC
Tips
2018-09-29 Sat.
Oracle EM13c 01 - dbca DB18c Tips
Oracle
Oracle
Tips
2018-09-28 Fri.
Oracle Setting up the Star Schema Benchmark (SSB) Tips
Oracle
Oracle
Tips
2018-09-25 Tue.
Oracle Get explain Tips
Oracle
Oracle
explain
Tips
2018-09-25 Tue.
Oracle ADWC Users Tips
ADWC
Oracle
ADWC
Tips
2018-09-24 Mon.
Linux SSH Tips
Unix
SSH
Tips
2018-09-12 Wed.
Oracle Setting max_string_size in RAC Tips
Oracle
Oracle
ADWC
2018-09-02 Sun.
Oracle Flush cache Tips
Oracle
Oracle
ADWC
2018-08-05 Sun.
Oracle Setting the NLS_LANG Environment Tips
Oracle
Oracle
ADWC
2018-08-05 Sun.
Oracle ADWC Restrictions Tips
Oracle
Oracle
ADWC
2018-08-05 Sun.
Oracle 18c check cdb/pdb Tips
Oracle
Oracle
18c
2018-07-29 Sun.
Oracle 18c EM Express Tips
Oracle
Oracle
12c
2018-07-26 Thu.
Oracle 12c pdbseed Tips
Oracle
Oracle
12c
2018-07-26 Thu.
Oracle 12c 新特性 validate_convertion Tips
Oracle
Oracle
12c
2018-07-26 Thu.
Oracle 12c 新特性 SQL row limited Tips
Oracle
Oracle
12c
2018-07-26 Thu.
Oracle 12c 新特性 max_string_size Tips
Oracle
Oracle
12c
2018-07-26 Thu.
Oracle 12c 新特性 invisible column Tips
Oracle
Oracle
12c
2018-07-25 Wed.
Oracle SQLcl Tips
Oracle
Oracle
Tools
2018-07-24 Tue.
Oracle Linux 18c GA DBCA create database
Oracle
Oracle
Linux
2018-07-24 Tue.
Oracle Linux 18c GA Installation
Oracle
Oracle
Linux
2018-07-15 Sun.
Oracle Session Tips
Oracle
Oracle
SQL
2018-07-15 Sun.
Oracle 修改sys密码和登录 tips
Oracle
Oracle
sqlplus
2018-07-15 Sun.
Oracle 迁移 Exadata 11g数据库到单实例
Oracle
Oracle
2018-07-15 Sun.
Tar命令常用选项
Unix
Unix
tar
2018-07-14 Sat.
Oracle rlwrap tips
Oracle
Oracle
Linux
2018-07-10 Tue.
Oracle Backup commands Tips
Oracle
Oracle
Backup
commands
2018-07-08 Sun.
Oracle Linux 7 Reset root password
Oracle
Oracle
Linux
Password
2018-06-20 Wed.
Oracle Some Tips for Expdp/Impdp
Oracle
Oracle
expdp
Tips
2018-06-18 Mon.
Oracle Recovery 05 - How to use BBED to recovery miss-archivelog file?
Oracle
Oracle
dump
controlfile
2018-06-15 Fri.
Oracle Data Skew Basic knowledge
Oracle
Oracle
DataSkew
2018-06-10 Sun.
Oracle Query 基础知识
Oracle
Oracle
select
2018-06-02 Sat.
Oracle Recovery 04 - How to dump the control file
Oracle
Oracle
dump
controlfile
2018-05-30 Wed.
Oracle Recovery 03 - Recover the delete/truncate/drop action
Oracle
Oracle
flashback
rman
tts
2018-05-23 Wed.
Oracle Problem about UNDO Tablespace - ORA-01548 ORA-01157 ORA-01110
Oracle
Oracle
UNDO
2018-05-23 Wed.
Oracle Recovery 02 - Controlfile
Oracle
Oracle
BBED
controlfile
2018-05-23 Wed.
Oracle Recovery 01 - BBED
Oracle
Oracle
BBED
2018-05-01 Tue.
Oracle UNDO
Oracle
Oracle
UNDO
2018-04-18 Wed.
Oracle 12c - PDBSEED
Oracle
Oracle
12c
PDBSEED
2018-03-16 Fri.
Oracle 12c - Resetlogs
Unix
Oracle
12c
redolog
2018-03-15 Thu.
The VagrantBox list from Oracle
Unix
Box
2018-03-10 Sat.
How to remove file while happening ‘Text file busy’?
Unix
Unix
2018-03-06 Tue.
How to install Redis3.0 in Linux 7?
Redis
Redis
Unix
2018-03-03 Sat.
Oralce 12c SP2-0618 and ORA-01919
Oracle
Oracle
12c
ORA-01919
2018-03-02 Fri.
Oralce 18c New feature
Oracle
Oracle
18c
NewFeatures
2018-03-01 Thu.
Oracle 18c
Oracle
Oracle
18c
vagrant
Box
Linux
2018-02-01 Thu.
How to install GUI in Oracle Linux 7?
Unix
Oracle
Linux7
GUI
yum
2018-01-10 Wed.
Oracle 12c - How to create new service name for PDB?
Oracle
Oracle
12c
Service
name
2018-01-05 Fri.
Oracle 11g - Startup Error #ORA-00119#ORA-00130
Oracle
Oracle
ORA-00130
ORA-00119
11g
2018-01-03 Wed.
Oracle 12c - The control file error#ORA-00205#ORA-00202
Oracle
Oracle
ORA-00202
ORA-00205
12c
2018-01-03 Wed.
Oracle 12c - RMAN-20299
Oracle
Oracle
12c
RMAN-20299
2018-01-02 Tue.
[Original]Oracle 11g Output the result to Excel file via SQL
Oracle
Oracle
Excel
SQL
2018-01-02 Tue.
[Original]Impdp/Expdp Oracle 11g Schema's data to Oracle 12c
Oracle
Oracle
12c
impdp
expdp
2017
2017-12-26 Tue.
[Original]Import Oracle Sample schema and create big test table and Test
Oracle
Oracle
Schema
2017-12-08 Fri.
[原创]Oracle自增序列
Oracle
Oracle
Sequence
2017-12-07 Thu.
APEX Barcode扫描小程序
APEX
APEX
Oracle
2017-12-05 Tue.
[原创]Win10 Python3.6 连接Oracle12c的简单步骤
Python
Python
Oracle
2017-12-01 Fri.
[原创]Linux 删除大量文件报错-[Argument list too long]
Unix
Linux
Python
2017-11-08 Wed.
[原创]Linux更新python版本
Unix
Linux
Python
2017-11-07 Tue.
[原创]PPT瘦身工具
Tools
PPT
Tools
2017-10-15 Sun.
[原创]ipmitool命令
Oracle
Oracle
Exadata
ipmitool
2017-10-14 Sat.
[原创]Oracle 11g之后内存管理
Oracle
Oracle
Memory
2017-10-11 Wed.
[原创] Oracle Autonomous Databas
Oracle
Oracle
Autonomous
Databas
2017-10-10 Tue.
[原创]Oracle DBSAT 简单介绍
Oracle
Oracle
security
Tools
2017-09-15 Fri.
[原创]Oracle12cR2_创建公用用户
Oracle
Oracle
12c
CDB
common_user
2017-09-15 Fri.
[原创]Oracle12cR2_测试在线移动表
Oracle
Oracle
12c
new
features
tablespace
2017-09-15 Fri.
[原创]Oracle12cR2_通过控制文件查看cdb的结构
Oracle
Oracle
12c
CDB
controlfile
2017-09-11 Mon.
[原创]Oracle12cR2_创建PDB
Oracle
Oracle
12c
PDB
2017-09-10 Sun.
[原创]Oracle12cR2_手工创建CDB
Oracle
Oracle
12c
CDB
2017-09-05 Tue.
Oracle开放了开发者的hands-on虚拟环境
Oracle
Oracle
VM
hands-on
2017-09-02 Sat.
[转]为何在查询中索引未被使用 (Doc ID 1549181.1)
Oracle
Oracle
Index
2017-09-01 Fri.
[转]Oracle Trace Level Event Numbers
Oracle
Oracle
Trace
Number
2017-08-23 Wed.
[原创]创建Oracle Database Imange in Docker
Oracle
Oracle
Docker
2017-08-23 Wed.
[原创]Oracle Linux in Docker 测试
Oracle
Oracle
Docker
Linux
2017-08-22 Tue.
[原创]VirtualBox的VMDK进行扩容碰到的问题解决
Linux
VirtualBox
Linux
2017-08-02 Wed.
[原创]Vagrant自动构建Oracle12cR2的DB
Vagrant
Oracle
Vagrant
2017-07-23 Sun.
[原创]Oracle12c-Study001-Draft
Oracle
Oracle
12c
2017-07-22 Sat.
[原创]Exadata Cellcli命令汇总
Oracle
Exadata
cellcli
2017-07-21 Fri.
[原创]DB whoami 脚本
Oracle
whoami
sql
2017-07-17 Mon.
[原创]DB12cR2 Express设置
Oracle
Exadata
Oracle
SmartScan
2017-07-17 Mon.
[原创]DB12cR2系列001_CDB/PDB操作
Oracle
DB12c
系列
CDB
PDB
2017-07-16 Sun.
[原创]sqlplus之rlwrap插件
Oracle
rlwrap
2017-07-15 Sat.
[原创]OCP题解-Q001
Oracle
OCP
2017-07-07 Fri.
[原创]Exadata虚拟机测试SMART SCAN
Oracle
Exadata
Oracle
SmartScan
2017-07-02 Sun.
[原创]Centos7-Python安装
Unix
Linux
Centos
Python
2017-07-02 Sun.
[原创]Centos7-64bit安装
Unix
Linux
Centos
Installation
2017-06-24 Sat.
VI汇总
Other
Unix
VI
2017-04-24 Mon.
五一
Other
Labor
Holiday
2017-04-13 Thu.
[原创]SQL在什么条件下使用索引
Oracle
Index
Oracle
2017-03-02 Thu.
[原创]Linux vim 基本操作
Unix
AIX
Move
2017-03-01 Wed.
[原创]AIX-临时文件的移动注意点
Unix
AIX
Move
2017-02-27 Mon.
[原创]Oracle BBED测试使用
Oracle
Oracle
BBED
2017-02-20 Mon.
PB是最大吗?
Unix
Unix
Size
2017-02-14 Tue.
Oracle 行连接/行迁移实验测试
Oracle
Oracle
RowMigration
RowChain
2017-02-13 Mon.
Oracle Session 阻塞处理
Oracle
Oracle
Redo
2017-02-12 Sun.
Oracle Redo概念
Oracle
Oracle
Redo
2017-02-09 Thu.
[原创]Oracle连接方式02-哈希连接
Oracle
Tuning
Oracle
NL
2017-02-08 Wed.
[原创]Oracle连接方式01-嵌套循环
Oracle
Tuning
Oracle
NL
2017-02-07 Tue.
[转]Using RMAN Incremental Backups to Refresh Standby Database
Oracle
Datagurad
Oracle
2017-02-07 Tue.
梦想plus坚持plus自律
Others
Dreem
2017-02-06 Mon.
Oracle 11g - Guaranteed Restore Points测试
Oracle
Restore
points
2017-02-02 Thu.
Oracle Hint中qb_name使用
Oracle
Oracle
hint
qb_name
2017-01-22 Sun.
dd命令使用
Oracle
Oracle
shutdown
2017-01-22 Sun.
[转]2016年人工智能领域十大标志性事件
Others
AI
2017-01-21 Sat.
Oracle - How to shutdown database
Oracle
Oracle
shutdown
2017-01-20 Fri.
什么是Oracle Block corruption?
Oracle
Oracle
Block
2017-01-19 Thu.
[转]Oracle 热块优化方法小结
Oracle
Oracle
2017-01-18 Wed.
[转]裁员潮?招聘难?
Other
Job
2017-01-09 Mon.
Oracle 体系结构-PGA概念
Oracle
Oracle
PGA
2017-01-08 Sun.
Oracle 12c 大纲
Oracle
Oracle
12c
OCM
2017-01-06 Fri.
[原创] DB2 db2pd收集信息脚本
DB2
DB2
Shell
2016
2016-12-28 Wed.
Oracle SQL优化: 最大值和最小值
Oracle
Oracle
SQL
2016-12-12 Mon.
Oracle SQL优化: 01.统计信息
Oracle
Oracle
2016-12-12 Mon.
Oracle OCM exam schedual
Oracle
Oracle
2016-12-09 Fri.
[原创]Oracle Redo Latch相关测试
Oracle
Oracle
2016-12-09 Fri.
[原创]Oracle控制文件
Oracle
Oracle
2016-12-08 Thu.
[原创]Oracle id和密码忽略大小写连接参数
Oracle
Oracle
2016-12-02 Fri.
Togaf
DB2
DB2
2016-12-01 Thu.
[DB2 LUW] うるう秒が DB2 に与える影響
DB2
DB2
2016-10-08 Sat.
[原创]DB2 Top SQL查询
DB2
DB2
2016-10-03 Mon.
[原创]Oracle数据仓库
Oracle
Oracle
2016-09-28 Wed.
[转]DBA的一天
Oracle
Oracle
2016-09-25 Sun.
DB2 监听端口汇总
DB2
DB2
2016-09-02 Fri.
[原创]DB2 Reorg的SQL2216N问题处理总结
DB2
DB2
2016-09-01 Thu.
DB2 数据架构的一些连接和InfoSphere Data Architect的安装及资料
DB2
DB2
2016-08-22 Mon.
DB2中常用清空大表的方法
DB2
DB2
2016-08-12 Fri.
DB2表空间备份,恢复,回滚日志
DB2
DB2
2016-07-07 Thu.
Git 如何 clone 非 master 分支的代码
GitHub
Git
GitHub
分支
2016-07-02 Sat.
[原创]DB2表空间问题集
Shell
DB2
Unix
Shell
2016-07-01 Fri.
[原创]Steps to rebalance Database tablespaces
Shell
DB2
Unix
Shell
2016-06-22 Wed.
[原创]Unix脚本产生随机数
Shell
DB2
Unix
Shell
2016-06-01 Wed.
[原创]DB2修改数据库名
DB2
DB2
2016-06-01 Wed.
[原创]IBM UCD连接DB2时候碰到的问题
DB2
Unix
DB2
2016-06-01 Wed.
[原创]Linux Red-hat/CentOS下的xMind安装
Unix
Unix
xMind
2016-06-01 Wed.
[汇总]Linux环境的解压方法汇总(包括rpm和deb文件)
Unix
Unix
tar
2016-06-01 Wed.
ssh免密码资料汇总
Unix
Unix
2016-05-31 Tue.
[原创]Chef Cookbook 05.Facebook cookbook之fb_motd学习
Chef
Chef
Cookbook
2016-05-31 Tue.
[原创]CentOS安装db2后启动异常SQL1042C
DB2
DB2
Unix
2016-05-29 Sun.
Osquery 初体验
Unix
Unix
Osquery
2016-05-28 Sat.
[原创]AWK 入门示例学习
Unix
Unix
Commands
awk
Studby
2016-05-27 Fri.
Unix中并发进程的控制
Unix
Unix
Commands
flock
2016-05-25 Wed.
[原创]Chef Cookbook 04.cron 任务
Chef
Chef
Cookbook
2016-05-24 Tue.
[原创]Chef Client 注册client
Chef
Chef
Introduce
2016-05-24 Tue.
[原创]Centos7 下的ifconfig和netstat命令
Unix
Unix
ifconfig
netstat
Centos
2016-05-22 Sun.
[原创]Chef Cookbook 03. chef receipe 学习用例
Chef
Chef
Cookbook
receipe
2016-05-21 Sat.
[原创]db2look生成测试数据库
DB2
DB2
db2look
2016-05-21 Sat.
[原创]关于GET_DBSIZE_INFO的一些事
DB2
DB2
GET_DBSIZE_INFO
2016-05-20 Fri.
[原创]db2pd中lockname对应的详细信息
DB2
DB2
Lockname
db2pd
2016-05-18 Wed.
[原创]Chef Cookbook 02.创建文件
Chef
Chef
Cookbook
2016-05-18 Wed.
[原创]Chef Cookbook 01.Helloworld
Chef
Chef
Cookbook
2016-05-17 Tue.
[原创]Chef 入门介绍-简明手册
Chef
Chef
Introduce
2016-05-17 Tue.
[原创]Chef 入门介绍
Chef
Chef
Introduce
2016-05-09 Mon.
[原创]DB2救命工具-db2dart
DB2
DB2
db2dart
2016-05-08 Sun.
[原创]DB2连接SQL8002N错误
DB2
DB2
SQL8002N
2016-05-07 Sat.
[原创]aix文件系统限制
Unix
DB2
Unix
filesize
2016-05-06 Fri.
[原创]25个酷酷的Linux Shell命令
Unix
Unix
Shell
2016-05-05 Thu.
告别平庸的10种简单方法
Others
2016-05-05 Thu.
[原创]关于系统和数据库ID的一些事
DB2
DB2
Install
Issue
2016-05-04 Wed.
[原创]扩大VM的磁盘容量
DB2
VM
2016-04-20 Wed.
[原创]DB2 V9.7FP11安装错误
DB2
DB2
Install
Issue
2016-04-19 Tue.
[原创]自动发送邮件脚本
Shell
脚本
scripts
mail
2016-04-15 Fri.
DB2 Distributed end of support (EOS) dates
DB2
DB2
EOS
Licence
2016-04-06 Wed.
存储概念:Raidx的介绍
DB2
Storage
Raid
2016-04-06 Wed.
[原创]DB2 参数:DB2_OVERRIDE_BPF
DB2
DB2
参数
DB2_OVERRIDE_BPF
2016-03-28 Mon.
转:基于CDC复制技术实现DB2大版本升级迁移
DB2
DB2
CDC
2016-03-23 Wed.
Oracle性能调优工具-Statpack
Oracle
Oracle,statpack,性能调优
2016-03-22 Tue.
VIM命令图解
Bigdata
bigdata
2016-03-10 Thu.
[原创]DB2 简单入门系列-1.安装
DB2
DB2
原创
2016-03-10 Thu.
[原创]DB2 简单入门序列-0.Introduction
DB2
DB2
原创
2016-03-01 Tue.
[原创]DB2 licence report
DB2
DB2
db2licm
licence
2016-03-01 Tue.
[原创]DB2 v10.5 C2090-311认证
DB2
DB2
认证
2016-02-24 Wed.
[原创]DB2 db2top 介绍和使用
DB2
DB2工具
db2top
原创
2016-02-23 Tue.
[原创]DB2 db2expln/db2advis/db2batch简单介绍和实战
DB2
原创
DB2
db2batch
db2expln
db2advis
2016-02-23 Tue.
[原创]DB2 存储结构(db2dart分析)
DB2
DB2
db2dart
原创
2016-02-22 Mon.
Benchmark-TPC
DB2
DB2
MON_GET
原创
2016-02-22 Mon.
[原创]DB2 监控表的使用
DB2
DB2
MON_GET
原创
2016-02-22 Mon.
[原创]DB2 Information Center PDF资料
DB2
DB2
PDF
2016-02-21 Sun.
Python2.7 Linux安装
Python
安装
python2.7
2016-02-21 Sun.
DB2 with BLU Acceleration:快速应用指南
DB2
DB2
BLU
2016-02-21 Sun.
[热点话题]区块链
Others
BlockChain
2016-02-20 Sat.
[原创]pureScale在线打Fixpack
DB2
DB2
pureScale
原创
2016-02-16 Tue.
[原创]开源监控工具之一 安装
Others
Infuxdb
Grafana
2016-02-16 Tue.
关于大数据-2016
Bigdata
bigdata
2016-02-13 Sat.
[原创]Oracle和DB2的术语映射
DB2
DB2
Oracle
概念
2016-02-13 Sat.
[原创]DB2 INGEST工具
DB2
DB2工具
2016-02-11 Thu.
[原创]DB2 Reorg/Runstat简单脚本
DB2
DB2脚本
原创
reorg
runstat
2016-02-11 Thu.
[原创]DB2 数据库升级碰到的错误-SQL1326N
DB2
DB2错误
原创
SQL1326N
2016-02-11 Thu.
DB2 311 认证题库
DB2
DB2认证
311
2016-02-02 Tue.
如何阅读一本书
Others
阅读
2016-02-01 Mon.
[原创]DB2 数据库的备份和恢复-lab 1
Python
DB2数据库
备份和恢复
原创
2016-02-01 Mon.
Jekyll-tags设置
Jekyll
标签云
2016-01-31 Sun.
[原创]Python学习-01
Python
python学习
原创
2016-01-30 Sat.
[原创]DB2 Runstat 统计信息脚本命令(Linux)
DB2
DB2工具
原创
2016-01-30 Sat.
Github ssh 提交
Jekyll
2016-01-30 Sat.
[原创]DB2 查看执行计划
DB2
DB2工具
原创
2016-01-29 Fri.
[原创]DB2 重要概念点(陆续更新) in 2016/1/30
DB2
DB2概念
原创
2016-01-28 Thu.
M13-Test
Architecture
测试
2016-01-28 Thu.
Docker常用命令操作
Docker
命令使用
2016-01-27 Wed.
Docker 安装
Docker
安装
2016-01-22 Fri.
git使用技巧1-本地建立仓库和提交
Jekyll
命令使用
2016-01-20 Wed.
REORG TABLE命令优化数据库性能
DB2
DB2工具
2016-01-20 Wed.
代码校验工具 SublimeLinter 的安装与使用
Jekyll
安装
2016-01-20 Wed.
数据库飞起来 十大DB2优化技巧
DB2
DB2
SQL优化
2016-01-20 Wed.
Jekyll 搭建静态博客
Jekyll
Jekyll安装
命令
2015
2015-03-26 Thu.
代码校验工具 SublimeLinter 的安装与使用
Sublime
Sublime
jshint
csslint
2015-02-16 Mon.
Jekyll 搭建静态博客
jekyll
jekyll
RubyGems
2015-02-10 Tue.
hello jekyll!
jekyll
jekyll
Content
2024 (5)
2023 (37)
2022 (59)
2021 (35)
2020 (37)
2019 (45)
2018 (57)
2017 (58)
2016 (93)
2015 (3)