Link to home
Start Free TrialLog in
Avatar of xoxomos
xoxomos

asked on

update undo$ set name=:2, ..Question

I'm seeing this in an AWR.

update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1

What kind of undo activity is that?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Anything performing DML to a base table (most end with a '$') is performed by Oracle.

Hard to tell exactly what that means.  You can open an SR with Oracle Support but I really doubt they will provide specifics about what it is actually doing.
Avatar of xoxomos

ASKER

Thanks.  So you are unable to tell if this is writing to or reading from UNDO?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xoxomos

ASKER

Thank you.