RE: What script builds DBA_LOCKS view?

Catblock.sql - dba_lock and dba_blockers Utllockt.sql - show who is blocking who in a tree diagram like this:

• For example, in the following printout session 9 is waiting for
  • session 8, 7 is waiting for 9, and 10 is waiting for 9.
  • =20
  • WAITING_SESSION TYPE MODE REQUESTED MODE HELD LOCK ID1 = LOCK ID2
  • ----------------- ---- ----------------- ----------------- --------

    ---

  • 8 NONE None None 0 = 0
  • 9 TX Share (S) Exclusive (X) 65547 = 16
  • 7 RW Exclusive (X) S/Row-X (SSX) 33554440 = 2
  • 10 RW Exclusive (X) S/Row-X (SSX) 33554440 = 2
  • =20

both are in rdbms/admin

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Cherie_Machler_at_gelco.com [SMTP:Cherie_Machler_at_gelco.com]
	Sent:	Thursday, August 31, 2000 7:36 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	What script builds DBA_LOCKS view?

	I do not have access to DBA_LOCKS view (although I have access to
other DBA_
	views).
	I suspect I need to run a catxxx script.   Anyone know which one?

	TIA,

	Cherie


	--=20
	Author:=20
	  INET: Cherie_Machler_at_gelco.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).