OraFAQ Forum: Performance Tuning » get proc and package names

Home » RDBMS Server » Performance Tuning » get proc and package names

Thu, 17 February 2005 21:51

Vinu
Messages: 13
Registered: March 2003

Junior Member

how to get the list of procedrue names and package name in my database.....

Regards,
Vinu

Thu, 17 February 2005 22:14

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

SELECT object_name,object_type FROM dba_objects
WHERE object_type IN ('PROCEDURE','PACKAGE')

Thu, 17 February 2005 22:16

Vinu
Messages: 13
Registered: March 2003

Junior Member

Thanks sreedhar

Previous Topic:	Urgent:How to find long running query in Oracle
Next Topic:	same statement reparsing again.Pl help

Goto Forum:

]

Current Time: Thu Mar 19 13:14:31 CDT 2026