PL/SQL (MOSC)

MOSC Banner

look for plssql code from plsql_object_id and report tuning task

edited Feb 16, 2016 4:07AM in PL/SQL (MOSC) 2 commentsAnswered

Hello,

How do I look for which plsql object/code is running corresponding to this

SQL> select PLSQL_OBJECT_ID,PLSQL_SUBPROGRAM_ID,PLSQL_ENTRY_OBJECT_ID,sid,sql_id ,paddr from v$session  where PLSQL_OBJECT_ID='8065';

PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID PLSQL_ENTRY_OBJECT_ID        SID SQL_ID                                  PADDR

--------------- ------------------- --------------------- ---------- --------------------------------------- ----------------

           8065                 185                              151                                         00000000BF395428

Additionally, when I try to run autotune for plsql it gives error:

SQL>  DECLARE

  2   ret_val VARCHAR2(4000);

  3

  4  BEGIN

  5

  6  ret_val := dbms_sqltune.create_tuning_task(task_name=>'tune1task', sql_id=>'3vnq6r9cm2pcf', time_limit=>&time_limit);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center