look for plssql code from plsql_object_id and report tuning task
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);