Lin Hong's TECH Blog!

【学习】 2025年阅读清单

Oracle 19c online statistics gathering Tips

2020-02-11

Oracle

Oracle SQLloader Tips

Oracle 19c Online statistics gathering between sqlloader and insert append Tips

This is test with sqlloader/insert append sql.

Read All
Oracle SQL loader Tips

2020-02-10

Oracle

Oracle SQLloader Tips scripts

Oracle SQL loader Tips

Read All
Unix SSH Timeout Tips

2020-02-09

Unix

Unix SSH Tips

Unix SSH Timeout Tips

Read All
Centos 7.6 + Postgresql 10 Install Tips

2020-02-03

Postgresql

Centos Postgres Postgresql Tips

Centos 7.6 + Postgresql 10 Install Tips

实战介绍在 CentOS 7.6 环境下如何源码安装 Postgresql 10

Read All

Ubuntu Change default editor Tips

2019-12-01

Unix

Unix Tips

1. Modify .bashrc
2. Modify OS config editor
3.remove other editors

Ubuntu Change default editor Tips

1. Modify .bashrc

$ echo export EDITOR=/usr/bin/vim >> ~/.bashrc 

2. Modify OS config editor

$ update-alternatives --config editor 
-> 3 (vim.basic)

root@inst-hk01:~# update-alternatives --config editor 
There are 4 choices for the alternative editor (providing /usr/bin/editor).

  Selection    Path                Priority   Status
------------------------------------------------------------
  0            /bin/nano            40        auto mode
  1            /bin/ed             -100       manual mode
  2            /bin/nano            40        manual mode
* 3            /usr/bin/vim.basic   30        manual mode
  4            /usr/bin/vim.tiny    10        manual mode

Press <enter> to keep the current choice[*], or type selection number: 3
root@inst-hk01:~# 

3.remove other editors

$ sudo apt-get remove nano

test

$crontab -e

Read All

Oracle Linux pstack Tips

2019-10-16

Oracle

Oracle Tips 12c pstack trace
- Install pstack in Oracle Linux 7.
Oracle Linux pstack Tips

Install pstack in Oracle Linux 7.

Install gdb by yum and there are pstack and gstack in gdb.
Read All
Oracle Linux yum/wget proxy Tips

2019-10-16

Oracle

Oracle Linux Tips

Oracle Linux yum/wget proxy Tips

Linux Yum/Wget proxy setting

Read All
Oracle 12c PDB LOCKDOWN Profiles Tips

2019-09-04

Oracle

Oracle Tips 12c

Oracle 12c PDB LOCKDOWN Profiles Tips

Oracle Database 12.2 New Feature – PDB Lockdown Profiles

Having fun with PDB LOCKDOWN PROFILES

oracle 12cR2新特性-PDB lockdown profile

Have a good work&life! 2019/09 via LinHong

Read All

Oracle 19c Query the patch Tips

2019-08-23

Oracle

Oracle Scripts SQL 19c

Oracle 19c Query the patch Tips

Query the patch applied on database 19c.

SYS@orcl> !cat patch_list.sql
set line 300
col action form a12
col version  form a40
col comments form a60
col action_date form a20

select comments, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, version from registry$history order by action_date;

set line 300
col action form a12
col version  form a40
col description form a60
col action_date form a20
select description, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version from dba_registry_sqlpatch;

SYS@orcl>

Read All

Oracle 19c Import with disable_archive_logging Tips

2019-08-22

Oracle

Oracle Import disable_archive_logging Tips
Oracle 19c Import with disable_archive_logging Tips

Oracle12c feature is the ability to run in nologging mode in import execution, disabling archive logging during a large import. Only for table and index Not for tablespace.
```
    transform=disable_archive_logging:Y
    transform=disable_archive_logging:Y:tablename
    transform=disable_archive_logging:Y:indexname
```
Read All
Linux 7 enable Autostarting of Oracle Database 19c Tips

2019-08-20

Linux

Oracle autostart Tips

Linux 7 enable Autostarting of Oracle Database 19c Tips

Read All
Linux Visual-dstat Tips

2019-08-05

Linux

Linux dstat Tips
- Visual-dstat
Linux Visual-dstat Tips

Visual-dstat

bigdatalyn/visual_dstat
Read All

16/37

1. Modify .bashrc

2. Modify OS config editor

3.remove other editors

Install pstack in Oracle Linux 7.

Visual-dstat