0 13:50 00:00:00 ora_reco_ora10g
oracle 3480 1 0 13:50 00:00:01 ora_cjq0_ora10g
oracle 3482 1 0 13:50 00:00:01 ora_mmon_ora10g
oracle 3484 1 0 13:50 00:00:00 ora_mmnl_ora10g
oracle 3486 1 0 13:50 00:00:00 ora_d000_ora10g
oracle 3488 1 0 13:50 00:00:00 ora_s000_ora10g
oracle 3493 1 0 13:50 00:00:00 ora_arc0_ora10g
oracle 3495 1 0 13:50 00:00:00 ora_arc1_ora10g
oracle 3499 1 0 13:51 00:00:00 ora_qmnc_ora10g
oracle 3513 1 0 13:51 00:00:00 ora_q000_ora10g
oracle 3515 1 0 13:51 00:00:00 ora_q001_ora10g
oracle 3565 1 0 14:04 00:00:00 ora_j000_ora10g
oracle 3568 3278 0 14:04 pts/5 00:00:00 /bin/bash -c ps -ef | grep ora_
SQL> !ls -ltr /proc/3472/fd
total 0
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 9 -> /u01/app/oracle/product/10.2.0/db_1/dbs/hc_ora10g.dat
l-wx------ 1 oracle oinstall 64 Aug 25 14:04 8 -> /u01/app/oracle/admin/ora10g/bdump/alert_ora10g.log
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 7 -> /u01/app/oracle/product/10.2.0/db_1/dbs/lkinstora10g (deleted)
l-wx------ 1 oracle oinstall 64 Aug 25 14:04 6 -> /u01/app/oracle/admin/ora10g/bdump/alert_ora10g.log
l-wx------ 1 oracle oinstall 64 Aug 25 14:04 5 -> /u01/app/oracle/admin/ora10g/udump/ora10g_ora_3462.trc
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 4 -> /dev/null
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 3 -> /dev/null
l-wx------ 1 oracle oinstall 64 Aug 25 14:04 2 -> /u01/app/oracle/admin/ora10g/bdump/ora10g_lgwr_3472.trc
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 13 -> /u01/app/oracle/product/10.2.0/db_1/dbs/hc_ora10g.dat
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 12 -> /dev/zero
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 11 -> /dev/zero
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 10 -> /u01/app/oracle/admin/ora10g/adump/ora_3462.aud
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 1 -> /dev/null
lr-x------ 1 oracle oinstall 64 Aug 25 14:04 0 -> /dev/null
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 26 -> /u01/app/oracle/oradata/ora10g/temp01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 25 -> /u01/app/oracle/oradata/ora10g/example01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 24 -> /u01/app/oracle/oradata/ora10g/users01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 23 -> /u01/app/oracle/oradata/ora10g/sysaux01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 22 -> /u01/app/oracle/oradata/ora10g/undotbs01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 21 -> /u01/app/oracle/oradata/ora10g/system01.dbf
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 20 -> /u01/app/oracle/oradata/ora10g/redo03.log
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 19 -> /u01/app/oracle/oradata/ora10g/redo02.log
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 18 -> /u01/app/oracle/oradata/ora10g/redo01.log
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 17 -> /u01/app/oracle/oradata/ora10g/control03.ctl
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 16 -> /u01/app/oracle/oradata/ora10g/control02.ctl
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 15 -> /u01/app/oracle/oradata/ora10g/control01.ctl
lrwx------ 1 oracle oinstall 64 Aug 25 14:04 14 -> /u01/app/oracle/product/10.2.0/db_1/dbs/lkORA10G
SQL>
此时数据文件都已经正常了，每次启动数据库实例后，进程都会再/proc下生成一个相应的以进程号命名的目录，存放操作中涉及到的文件句柄，此时lgwr进程对应的目录已经变为3472，而原来的2914目录已经不存在了
--------------------------------------------------------------------------------------
第2次测试（创建完表并插入2条数据后，不提交，直接删除/u01/app/oracle/oradata/o