Go to Qiita Advent Calendar 2024 Top
LoginSignup

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

This article is a Private article. Only a writer and users who know the URL can access it.
Please change open range to public in publish setting if you want to share this article with other users.

More than 1 year has passed since last update.

@t_kyn

【DB設計・実装】Oracleアーキテクチャ_補足記事（インスタンス起動時のプロセス状態確認）

Posted at

インスタンス起動時のプロセス状態確認をwhileループで10秒ごとに確認しています。
初期化パラメータの読み込みし、SGAコンポネントの割り当て、バックグラウンドプロセスの実行
ユーザプロセスの起動をしているっぽいです。

[root@oltkyn ~]# while true
> do date
> ps -ef | grep ora_ | grep -v grep
> sleep 10
> done
Sat Sep 17 01:27:42 JST 2022
Sat Sep 17 01:27:52 JST 2022
oracle   10768     1  0 01:27 ?        00:00:00 ora_pmon_orcl
oracle   10770     1  0 01:27 ?        00:00:00 ora_clmn_orcl
oracle   10772     1  1 01:27 ?        00:00:00 ora_psp0_orcl
oracle   10775     1  1 01:27 ?        00:00:00 ora_vktm_orcl
oracle   10779     1  0 01:27 ?        00:00:00 ora_gen0_orcl
oracle   10781     1  0 01:27 ?        00:00:00 ora_mman_orcl
oracle   10785     1  0 01:27 ?        00:00:00 ora_gen1_orcl
oracle   10788     1  0 01:27 ?        00:00:00 ora_diag_orcl
oracle   10790     1  0 01:27 ?        00:00:00 ora_ofsd_orcl
oracle   10793     1  1 01:27 ?        00:00:00 ora_dbrm_orcl
oracle   10795     1  0 01:27 ?        00:00:00 ora_vkrm_orcl
oracle   10797     1  0 01:27 ?        00:00:00 ora_svcb_orcl
oracle   10799     1  0 01:27 ?        00:00:00 ora_pman_orcl
oracle   10801     1  0 01:27 ?        00:00:00 ora_dia0_orcl
oracle   10803     1  0 01:27 ?        00:00:00 ora_dbw0_orcl
oracle   10805     1  0 01:27 ?        00:00:00 ora_lgwr_orcl
oracle   10807     1  0 01:27 ?        00:00:00 ora_ckpt_orcl
oracle   10809     1  0 01:27 ?        00:00:00 ora_lg00_orcl
oracle   10811     1  0 01:27 ?        00:00:00 ora_smon_orcl
oracle   10813     1  0 01:27 ?        00:00:00 ora_lg01_orcl
oracle   10815     1  1 01:27 ?        00:00:00 ora_smco_orcl
oracle   10817     1  0 01:27 ?        00:00:00 ora_reco_orcl
oracle   10819     1  0 01:27 ?        00:00:00 ora_w000_orcl
oracle   10821     1  0 01:27 ?        00:00:00 ora_lreg_orcl
oracle   10824     1  0 01:27 ?        00:00:00 ora_w001_orcl
oracle   10826     1  0 01:27 ?        00:00:00 ora_pxmn_orcl
oracle   10830     1  0 01:27 ?        00:00:00 ora_mmon_orcl
oracle   10832     1  0 01:27 ?        00:00:00 ora_mmnl_orcl
oracle   10834     1  0 01:27 ?        00:00:00 ora_d000_orcl
oracle   10836     1  0 01:27 ?        00:00:00 ora_s000_orcl
oracle   10838     1  0 01:27 ?        00:00:00 ora_tmon_orcl
Sat Sep 17 01:28:02 JST 2022
oracle   10768     1  0 01:27 ?        00:00:00 ora_pmon_orcl
oracle   10770     1  0 01:27 ?        00:00:00 ora_clmn_orcl
oracle   10772     1  0 01:27 ?        00:00:00 ora_psp0_orcl
oracle   10775     1  1 01:27 ?        00:00:00 ora_vktm_orcl
oracle   10779     1  0 01:27 ?        00:00:00 ora_gen0_orcl
oracle   10781     1  0 01:27 ?        00:00:00 ora_mman_orcl
oracle   10785     1  0 01:27 ?        00:00:00 ora_gen1_orcl
oracle   10788     1  0 01:27 ?        00:00:00 ora_diag_orcl
oracle   10790     1  0 01:27 ?        00:00:00 ora_ofsd_orcl
oracle   10793     1  0 01:27 ?        00:00:00 ora_dbrm_orcl
oracle   10795     1  0 01:27 ?        00:00:00 ora_vkrm_orcl
oracle   10797     1  0 01:27 ?        00:00:00 ora_svcb_orcl
oracle   10799     1  0 01:27 ?        00:00:00 ora_pman_orcl
oracle   10801     1  0 01:27 ?        00:00:00 ora_dia0_orcl
oracle   10803     1  0 01:27 ?        00:00:00 ora_dbw0_orcl
oracle   10805     1  0 01:27 ?        00:00:00 ora_lgwr_orcl
oracle   10807     1  0 01:27 ?        00:00:00 ora_ckpt_orcl
oracle   10809     1  0 01:27 ?        00:00:00 ora_lg00_orcl
oracle   10811     1  0 01:27 ?        00:00:00 ora_smon_orcl
oracle   10813     1  0 01:27 ?        00:00:00 ora_lg01_orcl
oracle   10815     1  0 01:27 ?        00:00:00 ora_smco_orcl
oracle   10817     1  0 01:27 ?        00:00:00 ora_reco_orcl
oracle   10819     1  0 01:27 ?        00:00:00 ora_w000_orcl
oracle   10821     1  0 01:27 ?        00:00:00 ora_lreg_orcl
oracle   10824     1  0 01:27 ?        00:00:00 ora_w001_orcl
oracle   10826     1  0 01:27 ?        00:00:00 ora_pxmn_orcl
oracle   10830     1  1 01:27 ?        00:00:00 ora_mmon_orcl
oracle   10832     1  0 01:27 ?        00:00:00 ora_mmnl_orcl
oracle   10834     1  0 01:27 ?        00:00:00 ora_d000_orcl
oracle   10836     1  0 01:27 ?        00:00:00 ora_s000_orcl
oracle   10838     1  0 01:27 ?        00:00:00 ora_tmon_orcl
oracle   10848     1  0 01:27 ?        00:00:00 ora_m000_orcl
oracle   10851     1  0 01:27 ?        00:00:00 ora_m001_orcl
oracle   10858     1  0 01:27 ?        00:00:00 ora_tt00_orcl
oracle   10860     1  0 01:27 ?        00:00:00 ora_arc0_orcl
oracle   10862     1  0 01:27 ?        00:00:00 ora_tt01_orcl
oracle   10864     1  0 01:27 ?        00:00:00 ora_arc1_orcl
oracle   10866     1  0 01:27 ?        00:00:00 ora_arc2_orcl
oracle   10868     1  0 01:27 ?        00:00:00 ora_arc3_orcl
oracle   10870     1  0 01:27 ?        00:00:00 ora_tt02_orcl
oracle   10875     1  0 01:27 ?        00:00:00 ora_w002_orcl
oracle   10879     1  1 01:28 ?        00:00:00 ora_w003_orcl
Sat Sep 17 01:28:12 JST 2022
oracle   10768     1  0 01:27 ?        00:00:00 ora_pmon_orcl
oracle   10770     1  0 01:27 ?        00:00:00 ora_clmn_orcl
oracle   10772     1  0 01:27 ?        00:00:00 ora_psp0_orcl
oracle   10775     1  1 01:27 ?        00:00:00 ora_vktm_orcl
oracle   10779     1  0 01:27 ?        00:00:00 ora_gen0_orcl
oracle   10781     1  0 01:27 ?        00:00:00 ora_mman_orcl
oracle   10785     1  0 01:27 ?        00:00:00 ora_gen1_orcl
oracle   10788     1  0 01:27 ?        00:00:00 ora_diag_orcl
oracle   10790     1  0 01:27 ?        00:00:00 ora_ofsd_orcl
oracle   10793     1  0 01:27 ?        00:00:00 ora_dbrm_orcl
oracle   10795     1  0 01:27 ?        00:00:00 ora_vkrm_orcl
oracle   10797     1  0 01:27 ?        00:00:00 ora_svcb_orcl
oracle   10799     1  0 01:27 ?        00:00:00 ora_pman_orcl
oracle   10801     1  0 01:27 ?        00:00:00 ora_dia0_orcl
oracle   10803     1  0 01:27 ?        00:00:00 ora_dbw0_orcl
oracle   10805     1  0 01:27 ?        00:00:00 ora_lgwr_orcl
oracle   10807     1  0 01:27 ?        00:00:00 ora_ckpt_orcl
oracle   10809     1  0 01:27 ?        00:00:00 ora_lg00_orcl
oracle   10811     1  0 01:27 ?        00:00:00 ora_smon_orcl
oracle   10813     1  0 01:27 ?        00:00:00 ora_lg01_orcl
oracle   10815     1  0 01:27 ?        00:00:00 ora_smco_orcl
oracle   10817     1  0 01:27 ?        00:00:00 ora_reco_orcl
oracle   10819     1  0 01:27 ?        00:00:00 ora_w000_orcl
oracle   10821     1  0 01:27 ?        00:00:00 ora_lreg_orcl
oracle   10824     1  0 01:27 ?        00:00:00 ora_w001_orcl
oracle   10826     1  0 01:27 ?        00:00:00 ora_pxmn_orcl
oracle   10830     1  9 01:27 ?        00:00:02 ora_mmon_orcl
oracle   10832     1  0 01:27 ?        00:00:00 ora_mmnl_orcl
oracle   10834     1  0 01:27 ?        00:00:00 ora_d000_orcl
oracle   10836     1  0 01:27 ?        00:00:00 ora_s000_orcl
oracle   10838     1  0 01:27 ?        00:00:00 ora_tmon_orcl
oracle   10848     1  0 01:27 ?        00:00:00 ora_m000_orcl
oracle   10851     1  0 01:27 ?        00:00:00 ora_m001_orcl
oracle   10858     1  0 01:27 ?        00:00:00 ora_tt00_orcl
oracle   10860     1  0 01:27 ?        00:00:00 ora_arc0_orcl
oracle   10862     1  0 01:27 ?        00:00:00 ora_tt01_orcl
oracle   10864     1  0 01:27 ?        00:00:00 ora_arc1_orcl
oracle   10866     1  0 01:27 ?        00:00:00 ora_arc2_orcl
oracle   10868     1  0 01:27 ?        00:00:00 ora_arc3_orcl
oracle   10870     1  0 01:27 ?        00:00:00 ora_tt02_orcl
oracle   10875     1  0 01:27 ?        00:00:00 ora_w002_orcl
oracle   10879     1  0 01:28 ?        00:00:00 ora_w003_orcl
oracle   10888     1  0 01:28 ?        00:00:00 ora_aqpc_orcl
oracle   10891     1  0 01:28 ?        00:00:00 ora_w004_orcl
oracle   10896     1  0 01:28 ?        00:00:00 ora_p000_orcl
oracle   10898     1  0 01:28 ?        00:00:00 ora_p001_orcl
oracle   10900     1  0 01:28 ?        00:00:00 ora_p002_orcl
oracle   10902     1  0 01:28 ?        00:00:00 ora_p003_orcl
oracle   10904     1  8 01:28 ?        00:00:00 ora_cjq0_orcl
oracle   10909     1  1 01:28 ?        00:00:00 ora_s001_orcl
Sat Sep 17 01:28:22 JST 2022
oracle   10768     1  0 01:27 ?        00:00:00 ora_pmon_orcl
oracle   10770     1  0 01:27 ?        00:00:00 ora_clmn_orcl
oracle   10772     1  0 01:27 ?        00:00:00 ora_psp0_orcl
oracle   10775     1  0 01:27 ?        00:00:00 ora_vktm_orcl
oracle   10779     1  0 01:27 ?        00:00:00 ora_gen0_orcl
oracle   10781     1  0 01:27 ?        00:00:00 ora_mman_orcl
oracle   10785     1  0 01:27 ?        00:00:00 ora_gen1_orcl
oracle   10788     1  0 01:27 ?        00:00:00 ora_diag_orcl
oracle   10790     1  0 01:27 ?        00:00:00 ora_ofsd_orcl
oracle   10793     1  0 01:27 ?        00:00:00 ora_dbrm_orcl
oracle   10795     1  0 01:27 ?        00:00:00 ora_vkrm_orcl
oracle   10797     1  0 01:27 ?        00:00:00 ora_svcb_orcl
oracle   10799     1  0 01:27 ?        00:00:00 ora_pman_orcl
oracle   10801     1  0 01:27 ?        00:00:00 ora_dia0_orcl
oracle   10803     1  0 01:27 ?        00:00:00 ora_dbw0_orcl
oracle   10805     1  0 01:27 ?        00:00:00 ora_lgwr_orcl
oracle   10807     1  0 01:27 ?        00:00:00 ora_ckpt_orcl
oracle   10809     1  0 01:27 ?        00:00:00 ora_lg00_orcl
oracle   10811     1  0 01:27 ?        00:00:00 ora_smon_orcl
oracle   10813     1  0 01:27 ?        00:00:00 ora_lg01_orcl
oracle   10815     1  0 01:27 ?        00:00:00 ora_smco_orcl
oracle   10817     1  0 01:27 ?        00:00:00 ora_reco_orcl
oracle   10819     1  0 01:27 ?        00:00:00 ora_w000_orcl
oracle   10821     1  0 01:27 ?        00:00:00 ora_lreg_orcl
oracle   10824     1  0 01:27 ?        00:00:00 ora_w001_orcl
oracle   10826     1  0 01:27 ?        00:00:00 ora_pxmn_orcl
oracle   10830     1  8 01:27 ?        00:00:02 ora_mmon_orcl
oracle   10832     1  0 01:27 ?        00:00:00 ora_mmnl_orcl
oracle   10834     1  0 01:27 ?        00:00:00 ora_d000_orcl
oracle   10836     1  0 01:27 ?        00:00:00 ora_s000_orcl
oracle   10838     1  0 01:27 ?        00:00:00 ora_tmon_orcl
oracle   10848     1  0 01:27 ?        00:00:00 ora_m000_orcl
oracle   10851     1  0 01:27 ?        00:00:00 ora_m001_orcl
oracle   10858     1  0 01:27 ?        00:00:00 ora_tt00_orcl
oracle   10860     1  0 01:27 ?        00:00:00 ora_arc0_orcl
oracle   10862     1  0 01:27 ?        00:00:00 ora_tt01_orcl
oracle   10864     1  0 01:27 ?        00:00:00 ora_arc1_orcl
oracle   10866     1  0 01:27 ?        00:00:00 ora_arc2_orcl
oracle   10868     1  0 01:27 ?        00:00:00 ora_arc3_orcl
oracle   10870     1  0 01:27 ?        00:00:00 ora_tt02_orcl
oracle   10875     1  0 01:27 ?        00:00:00 ora_w002_orcl
oracle   10879     1  0 01:28 ?        00:00:00 ora_w003_orcl
oracle   10888     1  0 01:28 ?        00:00:00 ora_aqpc_orcl
oracle   10891     1  0 01:28 ?        00:00:00 ora_w004_orcl
oracle   10896     1  0 01:28 ?        00:00:00 ora_p000_orcl
oracle   10898     1  0 01:28 ?        00:00:00 ora_p001_orcl
oracle   10900     1  0 01:28 ?        00:00:00 ora_p002_orcl
oracle   10902     1  0 01:28 ?        00:00:00 ora_p003_orcl
oracle   10904     1  3 01:28 ?        00:00:00 ora_cjq0_orcl
oracle   10909     1  0 01:28 ?        00:00:00 ora_s001_orcl
oracle   11069     1  0 01:28 ?        00:00:00 ora_qm02_orcl
oracle   11071     1  0 01:28 ?        00:00:00 ora_qm03_orcl
oracle   11073     1  3 01:28 ?        00:00:00 ora_q002_orcl
oracle   11075     1  0 01:28 ?        00:00:00 ora_q003_orcl
oracle   11097     1  4 01:28 ?        00:00:00 ora_m002_orcl
oracle   11099     1  2 01:28 ?        00:00:00 ora_m003_orcl
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?