QMN0 process generating the archives
I am facing archive issue on production database.When i track the information,found QMN0 process generating archives . Below is the information :
system@ETPSP1> SELECT s.sid, s.username, s.program, i.block_changes
2 FROM v$session s, v$sess_io i
3 WHERE i.block_changes!=0 and s.sid = i.sid
4 ORDER BY 4 desc, 1, 2, 3;
SID USERNAME PROGRAM BLOCK_CHANGES
---------- ----------- -------------- -----------------------
9 oracle@tsp51 (QMN0) 19017267
6 oracle@tsp51 (SMON) 2384756
33 TBEBZ 41214
47 oracle@tsp51 (CJQ0) 25126
38 TBEBZ 22973
35 TBEBZ 371
41 DBSNMP emagent@tsp51 (TNS V1-V3) 117
1 oracle@tsp51 (PMON) 19
46 TBEBZ 18
42 TBEBZ 10
39 SYSTEM sqlplus.exe 4
11 rows selected.
system@ETPSP1> select sql_text from v$sql where HASH_VALUE=&HASH_VALUE;