tags:

views:

38

answers:

3
Q: 

How can we set the profile option from a PL/SQL procedure?

How can we set the profile option from a PL/SQL procedure?

A: 

Have a look at this page. It describes how to set profile options.

henchman  2010-03-12 11:34:34
Question is about profiling a procedure.
P Sharma  2010-03-12 12:35:57
+1  A: 

Check here for Oracle documentation on PL/SQL Hierarchical Profiler.

A very good example article from Oracle-base on PL/SQL profiler. Are you dealing with Oracle 11gR1 ?

Guru  2010-03-12 13:46:27
A: 

Try to use this util

Artic  2010-03-12 13:50:25
Add the reason of you down voting. Be polite.
Artic  2010-03-13 09:32:08
+1. Never know PL/SQL profiler existed in PL/SQL Developer. Gonna try it now.
Guru  2010-03-17 04:02:21
You are welcome.
Artic  2010-03-17 06:55:48

related questions

Using the results of a query in OPENQUERY
Search all tables in Oracle DB
Insufficient privileges when creating a trigger for a table in another schema
rebuild indexes oracle 10G
oracle 10G shrink datafiles
How do I limit the global memory resources of Oracle 10g database
Getting Hourly statistics using SQL
Problems importing SQL script from Oracle 9i to Oracle 10g express
Can someone explain oracle 10G encoding, nls_lang unicode
Is it possible to output a SELECT state from a PL/SQL block?
Null Pointer when populating Grails Domain object with Oracle 10g long field
Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC
Why does Oracle require TO_NCHAR when binding SQL_C_WCHAR text via ODBC
ORACLE SQL: Need to sum two values, but one may not exist... Is this possible?
How do you programatically identify a stored procedure's dependencies?
How do I find out when a stored procedure was last modified or compiled?
ORACLE SQL: Multiple SUMS dependent on CODE in One Statement
How to read the PL/SQL code in an Oracle Forms .FMT file ?
How do I use oracle.jdbc.driver.OracleLog?
Table load via Partition Exchange (Oracle 10g)
"loader constraints violated when linking javax/xml/namespace/QName class" from webapp on Oracle 10g
JAXB 2 in an Oracle 10g Webapp
How do I change the IP address on Oracle 10g
How do I do a manual uninstall of Oracle?
Backup/Restore database for oracle 10g testing using sqlplus or rman