Architecture Overview - Expert Oracle Database Architecture

Database Reference

In-Depth Information

ora12cr1 19633 1 0 15:16 ? 00:00:00 ora_lg00_ora12cr1

ora12cr1 19635 1 0 15:16 ? 00:00:00 ora_lg01_ora12cr1

ora12cr1 19637 1 0 15:16 ? 00:00:00 ora_smon_ora12cr1

ora12cr1 19639 1 0 15:16 ? 00:00:00 ora_reco_ora12cr1

ora12cr1 19641 1 0 15:16 ? 00:00:00 ora_lreg_ora12cr1

ora12cr1 19643 1 1 15:16 ? 00:00:00 ora_mmon_ora12cr1

ora12cr1 19645 1 0 15:16 ? 00:00:00 ora_mmnl_ora12cr1

ora12cr1 19647 1 0 15:16 ? 00:00:00 ora_d000_ora12cr1

ora12cr1 19649 1 0 15:16 ? 00:00:00 ora_s000_ora12cr1

ora12cr1 19661 1 0 15:16 ? 00:00:00 ora_tmon_ora12cr1

ora12cr1 19663 1 0 15:16 ? 00:00:00 ora_tt00_ora12cr1

ora12cr1 19665 1 0 15:16 ? 00:00:00 ora_smco_ora12cr1

ora12cr1 19667 1 0 15:16 ? 00:00:00 ora_fbda_ora12cr1

ora12cr1 19671 1 0 15:16 ? 00:00:00 ora_aqpc_ora12cr1

ora12cr1 19675 1 0 15:16 ? 00:00:00 ora_cjq0_ora12cr1

ora12cr1 19705 1 0 15:16 ? 00:00:00 ora_w000_ora12cr1

ora12cr1 19708 1 0 15:16 ? 00:00:00 ora_qm02_ora12cr1

ora12cr1 19710 1 0 15:16 ? 00:00:00 ora_qm03_ora12cr1

ora12cr1 19712 1 0 15:16 ? 00:00:00 ora_q002_ora12cr1

ora12cr1 19714 1 0 15:16 ? 00:00:00 ora_q003_ora12cr1

tkyte 19720 15416 0 15:16 pts/1 00:00:00 grep _ora12cr1

If we were now to log into this database using a dedicated server, we would see a new process (or a thread on

some other operating systems) get created just to service us:

OPS$TKYTE@ORA12CR1> !ps -aef | grep $ORACLE_SID

ora12cr1 19607 1 0 15:16 ? 00:00:00 ora_pmon_ora12cr1

ora12cr1 19609 1 0 15:16 ? 00:00:00 ora_psp0_ora12cr1

ora12cr1 19611 1 0 15:16 ? 00:00:00 ora_vktm_ora12cr1

ora12cr1 19615 1 0 15:16 ? 00:00:00 ora_gen0_ora12cr1

ora12cr1 19617 1 0 15:16 ? 00:00:00 ora_mman_ora12cr1

ora12cr1 19621 1 0 15:16 ? 00:00:00 ora_diag_ora12cr1

ora12cr1 19623 1 0 15:16 ? 00:00:00 ora_dbrm_ora12cr1

ora12cr1 19625 1 0 15:16 ? 00:00:00 ora_dia0_ora12cr1

ora12cr1 19627 1 0 15:16 ? 00:00:00 ora_dbw0_ora12cr1

ora12cr1 19629 1 0 15:16 ? 00:00:00 ora_lgwr_ora12cr1

ora12cr1 19631 1 0 15:16 ? 00:00:00 ora_ckpt_ora12cr1