Performance Issues on Update OBJ$
Hi,
I was investigating a cause of slow performance in the DB and found that an (#1) UPDATE to OBJ table is causing high CPU wait and I/O in my EM. When I queried into the table, I saw that there are "objects" unusual to me (#2)
Can anyone tell me what is causing #1 and what are the purpose of #2
#1:
update obj$ set obj#=:4, type#=:5,ctime=:6,mtime=:7,stime=:8,status=:9,dataobj#=:10,flags=:11,oid$=:12,spare1=:13, spare2=:14 where owner#=:1 and name=:2 andnamespace=:3 and remoteowner is null and linkname is null and subname is null
#2: 75 of below "objects" found in 2 days
SYSTP79k9Dm0V4yrgQ6wZTBo+vg==
1