Section 6, OS-related and other [Q] how to generate a date format file [A] On Linux / UNIX, use the `Date % Y% M% D` (` this is the key on the keyboard ~ Or $ (DATE % Y% M% D), such as: Touch Exp_table_name_`date % Y% M% D`.dmpdate = $ (DATE % Y% M% D) or Date = $ (Date % Y % M% D --Date '1 Days Ago') # Get the date of yesterday or more days, using% DATE: ~ 4, 10%, where 4 is the start character, 10 is the extraction length, indicating from DATE During the date, the extraction of the start length is 10 strings of 10. You can change to other numbers you need, such as: Echo% Date: ~ 4, 10% If you want to get more accurate time, Win can also use TIME [q] test disks and array performance [A] Similar methods Test Writing Ability TIME DD IF = / Dev / Zero of = / ORADATA / BIDDB / Testind / TestFile.dbf BS = 1024000 Count = 1000 System IO Use (UNIX): iostat -xnp 2 Show Busy Level [Q] Configure SSH key [A] to prevent "intermediary" offensive mode 1, ssh-keygen or ssh-keygen -d (ssh 2.x) Generate a key 2, then copy a table to the server you want to log in, rename Authorized_Keys If it is 3.0 or less, you need to change to Authorized_Keys23, you can also use the config file to further simplify the operation such as Host * BJHostName machine name or IPuser username with this configuration file, you can use SSH BJ to access the specified machine, You can use SCP to transfer files with SFTP. [Q] How to automatically upload / download in the script / download [A] You can write FTP to the shell script, such as ftp -n -i host ip << Eofuser username passcd target directory PUT Fileget File # Query file LS # Exit Byeeof
