Learn the skills that Oracle should prepare

Learn the skills that Oracle should prepare

First, database skills:Database architecture, basic concepts and basic theories, database management, backup, recovery, SQL development, PLSQL development, and use of tools.

Operating System skills:Linux/Unix systems should have a considerable foundation. Understand concepts related to storage such as RAID, RAW, ASM, LVM, and OCFS, install Oracle software, install patches, and upgrade the system, and use common Linux/Unix commands: rpm, cpio, tar, ftp, top, vmstat, iostat, sar, netstat, ifconfig, crontab, chmod, chown, lsof, ntsysv, mv, rm, vi, mkdir and rmdir, etc..

Network:You need to understand basic network models and network protocol working principles.

Tools:You need to know how to use some performance measurement tools.

After preparing the above knowledge, we will begin to optimize the Oracle database.