Database Administration (MOSC)

MOSC Banner

Impact of killing a Qnnn background process

edited Feb 23, 2014 11:47PM in Database Administration (MOSC) 5 commentsAnswered ✓

I recently created a new UNDO TS and after insuring no transactions were left dropped the old one including contents and datafiles.

I cannot see the old file in Linux, but the space is not freed up.

Using lsof I can see that background process Qnnn is still using this file, even though is shows as /...../undotbs1.dbf (deleted)

Is there any danger to killing this Qnnn process?

Will QCMN simply spawn a new one, or should I bounce the database?

Any help is appreciated......

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