|
Bunyamin,
Why don't you use v$locked_object ?
"Bunyamin K. Karadeniz" wrote:
I
want to select locked_objects in a view.I
runCREATE OR REPLACE VIEW
V_BUN_LOCKED_OBJECTS AS SELECT
sn.username, m.sid, m.type,
DECODE(m.lmode,
0, 'None'
, 1, 'Null'
, 2, 'Row Share'
, 3, 'Row Excl.'
, 4, 'Share'
, 5, 'S/Row Excl.'
, 6, 'Exclusive'
, lmode, ltrim(to_char(lmode,'990'))) lmode,
DECODE(m.request,
0, 'None'
, 1, 'Null'
, 2, 'Row Share'
, 3, 'Row Excl.'
, 4, 'Share'
, 5, 'S/Row Excl.'
, 6, 'Exclusive'
, request, ltrim(to_char(request,'990'))) request,
obj1.object_name objname, obj2.object_name objname
FROM v$session sn, V$lock m,
dba_objects obj1, dba_objects obj2
WHERE sn.sid = m.sid
AND m.id1 = obj1.object_id (+)
AND m.id2 = obj2.object_id (+)
AND lmode != 4 ; and
gives error or ora-942. Can not find dba_objects .But
with the same user I can query dba_objects table since my user has dba
privilege.The inside of
view runs perfectly.Why
can it be??
--
Web: http://www.unal-bilisim.com
*********
Questions and Answers: http://www.unal-bilisim.com/qa/discus/
*********
itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html
itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.
*********
iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html
iOraBugFinder is a web based tool which scans Oracle's alert log files,
ORA-600 and ORA-7445 trace files; extracts relevant information from
them
and generates URL links to relevant bugs, notes, forums at Metalink.
*********
|
