Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I couln't find dbmshptab.sql script for

973995Nov 26 2012 — edited Nov 26 2012
I would likle to use Hierarchical Profiler. In order to use it, I have to execute below script. However, I couln't find it anywhere. I searched DBMS_HPROF package in all_objects table, it exists in db. Do you have any idea how can I execute this script? If it is not exist in my computer can I download it anywhere?

Note: I use windows 7

@$ORACLE_HOME/rdbms/admin/dbmshptab.sql
select * from all_objects where object_name = 'DBMS_HPROF';

SYS	DBMS_HPROF		10581		PACKAGE BODY	01/11/2007	01/11/2007	2007-11-01:21:00:04	VALID	N
SYS	DBMS_HPROF		7480		PACKAGE	01/11/2007	01/11/2007	2007-11-01:20:55:24	VALID	N
PUBLIC	DBMS_HPROF		7481		SYNONYM	01/11/2007	01/11/2007	2007-11-01:20:55:24	VALID	N


select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE	11.1.0.6.0	Production"
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
Thanks for your help.
This post has been answered by Manik on Nov 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2012
Added on Nov 26 2012
8 comments
1,665 views