Database Tuning (MOSC)

MOSC Banner

Performance Issues on Update OBJ$

edited Jun 26, 2014 2:51PM in Database Tuning (MOSC) 6 commentsAnswered
 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==

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