HIRE ORACLE DBA IN ABU DHABI
ORACLE DBA JOBS DUBAI
Wednesday, June 4, 2014
obj_lock script to find in oracle 10g
SELECT a.type,
Substr(a.owner,1,30) owner,
a.sid,
Substr(a.object,1,30) object
FROM v$access a
WHERE a.owner NOT IN ('SYS','PUBLIC')
ORDER BY 1,2,3,4
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment