Oracle 9i Unix Manager

When you are forced to terminate the Oracle Process on UNIX, you must do the following: (1) Kill all Oracle processes. Ps-ef|grep $ORACLE _sid|grep-v Grep|awk ' {print $} ' |xargs-i kill-9 {} (2) Use IPCS-PMB to confirm RAM memory segments and then release from UNIX using the IPCRM-M command RAM memory. (3) Use the IPCS-SA command to display the amount of synchronization semaphore and use the ipcrm-s command to release the synchronous semaphore for the instance.

Sometimes, the UNIX process is hard to kill, even if you use kill-9, it is difficult to kill it, you can use the following techniques to achieve:

Cat/dev/null >/dev/ttyname kill-9 $PID;

Display UNIX kernel values on AIX: LSDEV-C Displays the number of CPUs Lsdev-c|grep process|wc-l

View base core values: Lsattr-e1 SYS0

Memory Management commands for UNIX

(1) Displays the total amount of RAM on Unix a. Lsdev-c|grep mem display memory device name B. Lsattr-el mem0

(2) Observe the allocated RAM segment on UNIX (where Oracle, which represents the memory used by the SGA on the Oracle System Global Zone) IPCS-PMB use Sqlplus "/as sysdba" to log in to Oracle > Oradebug i PC >udump view RAM details Cat XXXX.TRC

When Oracle crashes, you must manually clean up RAM memory, Ipcrm-m $PID

Watch the RAM swap page schedule in Unix

Lsps-a View Page Scheduling

Oracle tuning factor that affects disk I/O

(1)  Oracle Instance Settings (Init.ora) Large db_block_size: The larger the block size, the smaller the disk I/O Db_block_buffer: The larger the data cache, the smaller the disk I/O multiple database write process (DBWR):     To write data files more efficiently.     The larger the sort_area_size in the Sort_area_size:ram, the smaller the type of disk that appears in the temporary table space. Large online redo logs: The larger the online log, the lower the frequency of log switching.

(2)     The lower the value of the Oracle Object (table and index) low pctused:pctused, the smaller the I/O appears in subsequent SQL insertions.     Low Pctfree: If you set Pctfree to allow all rows without fragmentation, then less disk I/O will occur in subsequent SQL selections. Reorganize tables by index: disk I/O is significantly reduced if the table is placed in the same physical order as the most commonly used indexes.

(3) Oracle SQL uses table indexes to use hint hints with bitmap indexes

Oracle internal structure and disk I/O (1) db_file_mutltiblock_read_count and disk I/O Db_file_mutltiblock_read_count: This parameter controls the reading when a continuous long block of data is requested According to the speed of the block. This parameter has an important relationship with Db_block_size.      At the UNIX physical layer, Oracle typically reads with 64K as the smallest block. means: db_file_mutltiblock_read_count*db_block_size=64k

Oracle 9i Unix Manager