Database Administration (MOSC)

MOSC Banner

QMN0 process generating the archives

edited Dec 28, 2009 3:01AM in Database Administration (MOSC) 2 commentsAnswered
 Hi Team,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center