Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Where is v$locked_object

143 views
Skip to first unread message

Nick Rumble

unread,
Oct 7, 1999, 3:00:00 AM10/7/99
to
Hi

I'm using Toad to trace locked objects within Oracle and it seems to rely on
a view called v$locked_object.

Problem is - I can't find this view within my 7.2.3 or 8.0.5 database - nor
is it defined in any of the .sql files shipped with these releases.

Does anyone know where I can find it ?

Thanks

Nick

Michel Cadot

unread,
Oct 7, 1999, 3:00:00 AM10/7/99
to
I use 7.3.4 and 8.0.5 and in both of it i found the definition
of v$locked_object in catalog.sql in the rdbms/admin directory.

as sys run:
create or replace view v_$locked_object as select * from v$locked_object;
drop public synonym v$locked_object;
create public synonym v$locked_object for v_$locked_object;
grant select on v_$locked_object to select_catalog_role; -- for 8.0.5


--
Regards

Michel


Nick Rumble <rum...@tetraworld.com> a écrit dans le message :
939307149.27223.0...@news.demon.co.uk...

Pascale Marois

unread,
Oct 7, 1999, 3:00:00 AM10/7/99
to
You must run the CATBLOCK.SQL script which creates the v$locked_object view.


Nick Rumble wrote in message
<939307149.27223.0...@news.demon.co.uk>...

Nick Rumble

unread,
Oct 8, 1999, 3:00:00 AM10/8/99
to
Ahh thanks - I've now found this in 8.0.5 but it's not in 7.2.3. But what's
more of a worry
is that 7.2.3 doesn't contain the v_$locked_object view.

How is this built ?

Regards

Nick

Michel Cadot <mic...@netcourrier.com> wrote in message
news:7tiddk$g5m$1...@oceanite.cybercable.fr...


> I use 7.3.4 and 8.0.5 and in both of it i found the definition
> of v$locked_object in catalog.sql in the rdbms/admin directory.
>
> as sys run:
> create or replace view v_$locked_object as select * from v$locked_object;
> drop public synonym v$locked_object;
> create public synonym v$locked_object for v_$locked_object;
> grant select on v_$locked_object to select_catalog_role; -- for 8.0.5
>
>
> --
> Regards
>
> Michel
>
>
> Nick Rumble <rum...@tetraworld.com> a écrit dans le message :
> 939307149.27223.0...@news.demon.co.uk...

Nick Rumble

unread,
Oct 8, 1999, 3:00:00 AM10/8/99
to
Tried to but my 7.2.3 system doesn't contain the v_$locked_object that
CATBLOCK relies upon.

Any ideas where I might find this ?

Thanks

Nick


Pascale Marois <pasc...@total.net> wrote in message
news:0I6L3.36848$Hb3.2...@news.total.net...


> You must run the CATBLOCK.SQL script which creates the v$locked_object
view.
>
>
> Nick Rumble wrote in message
> <939307149.27223.0...@news.demon.co.uk>...

fumi

unread,
Oct 8, 1999, 3:00:00 AM10/8/99
to

Nick Rumble <rum...@tetraworld.com> wrote in message
news:939307149.27223.0...@news.demon.co.uk...

> Hi
>
> I'm using Toad to trace locked objects within Oracle and it seems to rely
on
> a view called v$locked_object.
>
> Problem is - I can't find this view within my 7.2.3 or 8.0.5 database -
nor
> is it defined in any of the .sql files shipped with these releases.
>
> Does anyone know where I can find it ?


v$locked_object is available since Oracle 7.3.

The synonym and view are created using CATALOG.SQL.


Nick Rumble

unread,
Oct 10, 1999, 3:00:00 AM10/10/99
to
That explains it!

Thanks


fumi <fu...@tpts5.seed.net.tw> wrote in message
news:7tl7on$n28$5...@news.seed.net.tw...

0 new messages