Some common Oracle knowledge points below are some common small ORACLE knowledge points for your own search and review, to be further supplemented ........ www.2cto.com 1. Open the trace file $ tail-f $ ORACLE_BASE/admin/SID/bdump/alert_SID.log 2. archive the log SQL> alter system archive log current; manually archive the log file SQL> alter system switch logfile; switch logs from one group to another. 3. Oracle data file storage rules: oradataORACLE_BASE product flash_recovery_area adminORACLE_BASE =/u01/app/oracleORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1 4. What does strings do to view the binary file www.2cto.com eg: $ strings control01.ctl | more5, commit, and checkpoint? Commit is used by LGWR to write data to the online redo log file. Checkpoint writes dirty data in the database buffer cache to the data file on the disk. 6. AWR: Automatic Workload Repository Automatic Workload information library 7. How to disable linux boot from loading graphical interface: vi/etc/inittab id: x: initdefault: x = 3: text mode x = 5: graphic mode 8. In Windows, the OEM Web cannot access the entry in: C: \ WINDOWS \ system32 \ drivers \ etc \ hosts, for example, 192.168.92.200 even.oracle.com.