| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Can't get dbms_profiler to work
Hi Guys,
Env: 8.1.5 and 8.1.6 on Solaris 2.7
I've been wasting too much time on this so have now decided to ask for help.
The story starts with turning on PL/SQL Profiling in TOAD for my 8.1.6 database. Found that the stats are 0 ie. no runs, nothing. So I went into SQL*Plus and tried to turn on profiling manually:
declare
x number;
begin
x := SYS.dbms_profiler.start_profiler('Leng');
pkg_db_stat.gather_stale;
sys.dbms_profiler.flush_data;
end;
There's nothing in the plsql_profiler tables. Time_statistics is set to true.
So thought I might try it out on 8.1.5. Guess what, no profload.sql and proftab.sql in $ORACLE_HOME/rdbms/admin. Been searching metalink for them but can't find. Have you got a copy of them to send to me? Or an ftp site I can download from? not just ftp.oracle.com, but the full path please. Thanks.
So have you got the profiler working in both 8.1.5 and 8.1.6? How did you do it? Any tips and tricks?
TIA, Leng.
Tel: 9843-8440 Fax: 9843-8590 -----------------------------------------------------------------------This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.
**********************************************************************
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
 |
 |